...above is not crap talk and trust you?

It is the last mile that can pull the average to above average. Exclude the 10% in MM or bond, and consider it as part of your total asset in FD and cash. Maybe then you could see the reason of having money in equities instead of having it lingering in lesser risk MM and bond funds; and having every dollar set aside for investment in UT to work harder.

===========

The culcalation in IRR needs only 3 pieces of info: the date and value of the capital outlay (including any service charges/commissions), and the total current value of the portfolio.

One can make switches and trade as often as he likes, and not affect the IRR. (As mentioned above, the IRR needs only 3 pieces of info.) The switches can only affect the IRR if the switches can change the total value of the portfolio.

The million dollar question is how to time the switches. And if the timing is right, how bold one must be to make HUGE switches such that the total value of the portfolio will be GREATLY affected.

Get the timing wrong, the total value of the portfolio (and the IRR) will be negatively affected. When switches are done over a long term, maybe sometimes getting it right, sometimes getting it wrong... which is same as not doing any swithces.

So it all goes back to the basic of regular investments and putting money that was set aside, for the purpose of UT investment, into Equity (not MM or Bond) funds...

(Getting the first several steps correct is important... if one begins on a wrong footing, the next money/purchase will need to work extra hard to craw back and pull the IRR up and above average.)

BTW the numbers are still 'alive'. This is akin to the old phrase "never count chickens before they are hatched."

Enjoy the moments when the markets are up. Don't get too dismay when they are down.

Just keep on investing....

This is a general reply, and not specific to how the worksheet was structured...

1. Date and value of the fund "sold" should be there to be included into the IRR calculation; if you want to know the IRR of all investments since day 1. Otherwise, the IRR is only on the current portfolio of funds.

2. The whole portfolio was already assumed to be "sold off" at its latest current value in calculating the IRR.

3. Above "sold" means that. Don't confuse it with switching from one fund to another. These swithcing transations - one transaction in, and another transaction out nullified each other and nullified the cash flow. So don't have to keep track of switching transactions in IRR. The real "buys" and "sells" values and dates are needed...

This post has been edited by j.passing.by: Nov 19 2015, 05:03 PM