QUOTE(idyllrain @ Sep 26 2015, 12:24 AM)
That's basically ROI after averaging out the cost/unit.
XIRR and IRR are both Excel functions that calculate IRR. The main difference is that XIRR can deal with random dates, while IRR assumes the values you give it to be periodic. The XIRR function gives you an annualized rate though, so if your data is less than year it'll give you big numbers:

Here are some examples of the different return rate formulas used:

Note that ROI and CAGR (a.k.a Annualized return) calculated the same values for all scenarios, these two measures are not time-sensitive: ROI measures the absolute return over cost of investment irrespective of how long it will take to get that rate, CAGR gives you the average return per year that your investment is compounding at.
IRR on the other hand takes into account the time-value of money, i.e. RM10 today is worth more than RM10 next year. To understand IRR more, you'll need to learn about NPV (Net Present Value, i.e what's the current value of a particular sum of money that you will get in the future).
I'm having a headache.XIRR and IRR are both Excel functions that calculate IRR. The main difference is that XIRR can deal with random dates, while IRR assumes the values you give it to be periodic. The XIRR function gives you an annualized rate though, so if your data is less than year it'll give you big numbers:

Here are some examples of the different return rate formulas used:

Note that ROI and CAGR (a.k.a Annualized return) calculated the same values for all scenarios, these two measures are not time-sensitive: ROI measures the absolute return over cost of investment irrespective of how long it will take to get that rate, CAGR gives you the average return per year that your investment is compounding at.
IRR on the other hand takes into account the time-value of money, i.e. RM10 today is worth more than RM10 next year. To understand IRR more, you'll need to learn about NPV (Net Present Value, i.e what's the current value of a particular sum of money that you will get in the future).
Sep 26 2015, 09:09 AM

Quote
0.0478sec
0.40
7 queries
GZIP Disabled