QUOTE(j.passing.by @ Jul 29 2016, 04:01 PM)
If the 760 payment is for 12 months on an investment of 4200, that's a IRR of 416%.
Everyone will be abandoning their UT units... fund houses will go empty... fund managers out of jobs...
===========
Everyone will be abandoning their UT units... fund houses will go empty... fund managers out of jobs...
===========
QUOTE(em0kia @ Jul 31 2016, 02:53 AM)
hey, feeling curious, how did you get the IRR value?
My way of calculation is:
RM760 * 12 = RM9120
If invest RM4200,
9120/4200 = 2.17.
416% is like doubling twice right?
okay, simple maths should be adequately clarified, otherwise IRR could be taken as dubious maths doing manipulative accounting.My way of calculation is:
RM760 * 12 = RM9120
If invest RM4200,
9120/4200 = 2.17.
416% is like doubling twice right?
1. The returns are 9120 - 4200 = 4920. This RM4920 is the ROI (returns on investment).
2. This ROI can also be expressed in percentage. 4920/4200 x 100% = 117%.
3. If the payment is in one lump sum at the end of 12 months, then this percentage of 117% is also the effective rate, meaning it is based on annual basis. The effective rate is to have an apple-to-apple comparision.
4. If the payment is in 2 payments, RM4560 in June and another RM4560 in Dec, then the effective rate, using the Excel XIRR function to quickly calculate it, is 196%.
5. This shows that getting 2 payments is better than getting one lump sum payment, 196% vs 117%.
6. If the payment is every month, then the IRR increases further to 416%. Showing that it is giving a much higher effective returns, 416% vs 117%.
Of course, if we sit down and think which one is better - one payment at the end of 12 months or getting payments every month, we could also come to the right answer using common sense.
The simple maths, using IRR to show the effective returns, shows the answer in more precise numbers to show how lucrative the returns are.
=========
PS. There is no easy formula to calculate the IRR. The quick and easy way is using Excel function XIRR.
Within this XIRR function, it has a recursive looping algorithm making a 'guess' each time it goes through the loop until it gets closer and closer to the answer.
The 3rd number in the function helps to start the guesswork... otherwise the function could fail to give any answer if it was looping too many times...
This post has been edited by j.passing.by: Aug 1 2016, 03:56 PM
Aug 1 2016, 03:53 PM

Quote
0.0699sec
0.35
7 queries
GZIP Disabled