QUOTE(WhitE LighteR @ May 29 2018, 08:51 PM)
[attachmentid=9830146]
[attachmentid=9830147]
Here is the screenshot. Thanks
I don't use this excel template... so can't say where it went wrong. But here's a clarification on how they are calculated...
Invested cost = RM 28,215.00
Total units bought = 45,464.07
Units sold = 4,335.74
Invested cost in the 4,335.74 units sold = 4,335.74 / 45,464.07 x RM 28,215.00 = RM 2,690.76
After the 2nd transaction:
Balance units = 45,464.07 - 4,335.74 = 41,128.33
New Invested cost = RM 28,215.00 - RM 2,690.76 = RM 25,524.24
Note: With the balance units and current NAV price, the current value can be calculated. And the current value together with the "new" invested cost, the ROI or total returns will match the returns given in any charts or reported returns on the fund in percentage.
========
In the 2nd transaction, the units were sold at a lost... bought at 0.6206, sold at 0.6204.
Profit = RM 2,689.89 - RM 2,690.76 = (0.87)
Current Profit of remaining units of 41,128.33, @ 0.6205 = 25,520.13 - 25,524.24 = (4.11) or -0.02%.
(IRR = -0.13%.)
This post has been edited by j.passing.by: May 30 2018, 07:04 AM