QUOTE(HJebat @ May 19 2011, 11:34 AM)
I can't get the bolded part...
Current closing price + Dividends : RM2.25
Less costs : RM1.55
Bought in 2008 & assume that i sell in 2011.
How do i do the math when i reach the bolded part?

To be clearer, i'll use the example below. Your data needs to be more specific in terms of Dividend amount, date bought (2008 isn't a date, it's a year), date sold
Eg.
Bought: 1/1/2008
Bought at $1
Units: 3,000
Dividends: $0.10 single tier
Sold: 30/06/2009
Sold at $1.20
Units: 3,000
a. Cost of Purchase = ($1 * 3,000) +brokerage +stamp duty
I'll assume here that Cost of Purchase = $3,043
b. BEP = Cost of purchase - Net Dividend received, say $3,043 - $300 = $2,743
c. Net Profit = Sales - (brokerage + stamp duty) - BEP,
say $3,600 -$21 -$2,743 = $836
Thus the pa% returns calculation based on the above (in Excel formula) would be:
((BEP +Net Profit) / BEP) ^(1 / (Date Sold -Date Purchased) /364.25) -1
where: (BEP +Net Profit) / BEP = simple Profit % (er.. minus 1 please from here)
where: (Date Sold -Date Purchased) = days held. Dividing this by 364.25 days will get U years
where: ^(1 / blah blah). The basic formula is derived from S = P * (1+%)^n
Anyone

yet? heheh - it looks simple in Excel. Any maths genius can check the above? I just translated it from my Excel spreadsheet from interpretation of the cells' data - did my spreadsheet (finalized) several years ago
This post has been edited by wongmunkeong: May 19 2011, 01:07 PM