Whether you are a social or commercial investor on MYC4, or perhaps something in-between, one of the thrilling – and at times frustrating – things about investing on the platform is to follow the performance of your own loan portfolio. Which of my loans have been fully repaid? Are any of my loans at risk of defaulting? What is the net result of my investments?
We are often contacted by investors who are trying to find the answer to the last question. They are rarely looking for fancy ratios or complicated calculations, yet they do not feel that their MYC4 account supplies the simple information they need. If you are one of those investors, this basic tutorial should help you solve the problem.
You will find the data you need on your Profit and Loss page. Log on to www.myc4.com, click on My Account, and go to Profit and Loss in the left hand menu. Here you will see your profit and loss for 2011. Select All Years.
There are a number of figures here which may be of interest to you, but to calculate your result you only need the following:
- Earned interest after tax and currency
- Defaulted principal
- Recovered principal
- Currency gain/loss on principal
As the text indicates, the figure for earned interest is already accounting for withholding tax and currency, however there is almost always a currency effect on the loan principal as well. An important parameter to remember is therefore currency gain/loss on principal.
The actual calculation should be done as follows: Earned interest after tax and currency minus Defaulted principal plus Recovered principal plus Currency gain on principal OR minus currency loss on principal.
Here are a couple of examples with data from two MYC4 investor accounts:
Example 1
- Earned interest after tax and currency: 4,009.27
- Defaulted principal: 353.77
- Recovered principal: 0.00
- Currency gain/loss on principal: -1,718.80
Net result: 4,009.27 – 353.77 – 1,718.80 = 1,936.70 euro.
Example 2
- Earned interest after tax and currency: 994.52
- Defaulted principal: 3,426.99
- Recovered principal: 98.87
- Currency gain/loss on principal: -83.82
Net result: 994.52 – 3,426.99 + 98.87 – 83.82 = -2,417.42 euro.
Note that if you are an investor with defaulted loans in Côte d’Ivoire, it may be necessary to make an additional calculation. The MISCOCI coverage from MYC4 came into your account as a money upload, not a recovery. You will therefore need to adjust the Recovered principal figure by adding the MISCOCI amounts (look under Transfers on your account statement for 2009). In the second example above, the investor received 1,906.50 euro back through this coverage, making the net result -510.92 euro instead of -2,417.42.
Let me know if you have a good idea for another aspect of investing on MYC4 that you would like to have explained or clarified here on the blog. Remember that you are also always welcome to write to us at info@myc4.com with any questions you may have.
Hi Githa,
While I greatly appreciate your advice, there is one specific key measurement that I feel is missing:
Namely, what the annualized percentage of returns has been on my portfolio (for the selected time period).
The reason why this would be useful is that if you’ve uploaded different amounts at different times, it is very difficult to calculate it manually using the method you described.
Also, for me, this is the key figure I am looking for, since it is what you use to compare different investment options.
Keep up the good work!
Hi Bukszi,
Thanks a lot for your constructive feedback. I’ve added your request to the list of features that we would like to develop to improve Investor reporting.
All the best,
Githa
I agree with Bukszi. Annualized percentage is THE key measurement.
In fact I it ougth to be mandatory. Like Å.O.P (I don’t know the english term).
Reading the result of your investment in a single, easy understandably figure
would stimulate the urge to invest.
vh
Jakob
Hi Githa,
I am simply adding the earnings/loss on fully repaid loans to get an overview for compring to other investment options.
For the time being, this results in an average interest of 3.9%.
It should however be noticed that it has lately been mainly losses. I hope that currency will change soon!
Kind regards
Hanne
Hi Hanne,
Thanks for your input. It is correct that an alternative method is to look at the fully repaid loans. However, for investors who have recently joined or invested in loans with long payback periods, this approach may not be possible.
Yes, let’s hope that the currency will improve soon.
Best Regards,
Githa
Why does it state “Earned interest after tax and currency” when it is actually BEFORE currency adjustments on principal?
Kind regards,
Hanne
It states “Earned interest after tax and currency” because it does not show the full interest earned. It only shows the earned interest after withholding tax has been paid and after accounting for currency gains/losses, i.e. net interest earned. It is not related to the principal.
I realise that it may not be the best way to express this and we do hope to improve the communication side of the profit & loss page at some point.
I hope this answers your question.
Best,
Githa