I am facing problems while preparing an Excel sheet.
In actuality, investments are made and redemptions effected at NAV. Then, at the close of the reporting period (maybe a quarter/month), the statement shows either realized or unrealized gain/loss.
Investments are basically grouped into 3 categories:
a) Held to maturity - reported at amortized cost
b) Trading securities - reported at fair value with unrealized gains and losses included in profit/loss
c) Available for sale (securities) - reported at fair value with unrealized gains/losses excluded from profit/loss and reported in a separate component of shareholders' equity.
My dilemma is how do I budget for these.
Can anybody illustrate this with an example, preferably in Excel.
In actuality, investments are made and redemptions effected at NAV. Then, at the close of the reporting period (maybe a quarter/month), the statement shows either realized or unrealized gain/loss.
Investments are basically grouped into 3 categories:
a) Held to maturity - reported at amortized cost
b) Trading securities - reported at fair value with unrealized gains and losses included in profit/loss
c) Available for sale (securities) - reported at fair value with unrealized gains/losses excluded from profit/loss and reported in a separate component of shareholders' equity.
My dilemma is how do I budget for these.
Can anybody illustrate this with an example, preferably in Excel.