UNDERSTANDING IRR (Internal Rate of Return)Another dollar, another day... been quite some time since my last post...
As mentioned previously, I'm keeping track of the portfolios using Excel... in 2 tabs, the main tab showing the current funds, and the 2nd tab on those funds that were switched out (including those that were repurchased.)
So the main tab has the YTD figures, and the CAGR (compounded annual growth rate or in simpler term, the annualised growth) on each line of the fund purchased. If the fund was purchased in several dates, also did a IRR on the fund.
Wiki has IRR as follows:
The internal rate of return (IRR) or economic rate of return (ERR) is a rate of return used in capital budgeting to measure and compare the profitability of investments. It is also called the discounted cash flow rate of return (DCFROR).[1] In the context of savings and loans, the IRR is also called the effective interest rate.
In the 2nd tab (the switched out funds), I also did a IRR on them... it's not on each individual fund, by rather grouping all the switches (and repurchases) by year. The data is not really useful... since they are 'history' and gone. Just something to browse back and review how many switches I'd done, and how profitable were they. (I guessed I picked some pointers over the years since there is hardly any negative switches in the past year.

)
Now, with all the transactions in 2 tabs, what is the IRR of my portfolios (or investments) since day 1?
Simple, create another tab.

Before you shake and smack your head on the workload that needed to copy and combine the current and historic data in the 2 tabs into the 3rd tab, I have to say that it is much easier than I had initially thought.
1. All those switches, all those funds that were bought and dumped are "history" and has no bearing on the IRR of the portfolio/investment.
2. Only those purchase transactions that are cash out of wallet, or out of EPF, are relevant.
3. Only those "repurchases", that were truly cashed out into bank accounts or direct to wallet via cash cheque.
(Those funds that were switched out into money market funds, are still inside and part of the portfolio and investment... they don't count.)
For example, I have only several withdrawals out of EPF over the past years, buying into a bond fund first and then over a regular period of time (or when ever there is a market dip) switched bit by bit into equities. I also did many switching back and fro from equities to bond/money market funds.
The calculation of the IRR of the investment is only on those withdrawal dates and money withdrawn, and the current size of the portfolio/investment.
So in this example, the data is only 4 lines.
1st withdrawal: 1/7/2011 (10,000.00)
2nd withdrawal: 1/3/2012 (15,000.00)
3rd withdrawal: 1/10/2013 (15,000.00)
Current Value of Portfolio: 31/1/2015 46,000.00
IRR of Portfolio = 5.71%
Cheers. Stay invested.