Wong Seafood, I just finished my UT worksheet yesterday...thanks for intro me to this magic XIRR fungsi

you're welcomed.
i also buta buta stumbled on it several donkey years ago when looking for an easier way to count all the donkey transactions' total combined CAGR.
being effectively lazy, need to automate mar  

The spirit is willing but the flesh is weak... didn't make the time to study & analyze what to sell (PM) and buy (FSM) - had my monthly financial tracking last weekend & Raya holidays enjoying the company of my loved ones

I suspect i'd need 2 solid days' focus - to reconstruct my plans (programmatic + opportunity investing for cash & EPF with overall Asset Allocation arcing controls) ..
AND LOTS OF COFFEE (oo reminds me.. i'm running out of tongkat Ali coffee )

Yes, KLCI is peaking, but there's always bond funds...mind u, the bond funds under my portfolio delivers IRR of 8%++

High or not, depends on the underlying stockholdings of the fund, the fund NAV price alone tells no story.

With XIRR, just need to lay all the cash flows on the same column with the dates side-by-side, then the current NAV at bottom...voila! IRR keluar

Well said.

But now a bit skeptical with AmDynamic returns. Used XIRR to calculate, and it's still a bit low as compared to the past trend. We shall see.

8.6% is the IRR I'm getting from my holdings in AmDynamic, consider mid-range of its historical returns lar...6% only is low

I'm getting below 5% for now. My investment in this fund this year only has been slightly over half a year. Not sure if XIRR annualize my returns for me. It should I believe.

Pls PM me or Wong Seafood for guidance on how to do XIRR correctly

I roughly remember Master Wong say correct wor.

1/2/2012 cash inflow
1/5/2012 cash inflow
.
.
.
27/8/2012 latest investment value

I did not include any distributions like you suggested. Do you think it makes a different that my investment this year alone is less than 12 months?

I maintained 2 work sheets. One is total investment, another one is investment each year (to be include into total investment the following year).

E.g.

A B C
1 Date - Cash Flow - Transaction
2 01/01/12 -1000 Buy
3 01/02/12 -1000 Buy
4 30/06/12 0 Dividend
5 27/08/12 2200 Valuation

=XIRR(C2:C5,B2:B5)

Oh, we need include the 30/06/12 too (althou with no value)? I remembered Master Wong asking one of the guy to slash off the whole line.

If u want to maintain record of dividends in your transactions listing, u can do it but maintain ZERO in the amounts field cos its a non-cash flow. Put a zero there and totally deleting the line makes no difference.

Exactly. Let me relook at my worksheet tonight. I have a feeling it's cause my investment for this year is less than 12 months. The other worksheet is fine. Cause it includes my past years of investment in this fund.

I roughly remember Master Wong say correct wor.

1/2/2012 cash inflow
1/5/2012 cash inflow
.
.
.
27/8/2012 latest investment value

I did not include any distributions like you suggested. Do you think it makes a different that my investment this year alone is less than 12 months?

I maintained 2 work sheets. One is total investment, another one is investment each year (to be include into total investment the following year).

Boss, cash OUTFLOW lar (outflow coz yr $ go out to buy fund units)
...
...
...
Then right - total value of investment (ASSUMING didn't take out cash dividends but reinvested)
er.. i think i'll upload a demo snapshot later tomorrow (kinda tied up today) 

http://www.fundsupermart.com.my/main/fundi...nouncement.svdo

For your infomation from Funds Dividend Announcement

u FSM staff?

Why you say so?