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.
From Kuwait, Kuwait
Acknowledge(0)
Amend(0)
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.
From Kuwait, Kuwait
Acknowledge(0)Amend(0)
5CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
CTC Calculation Excel.xls
Advanced Excel 2003.pdf