I am facing problems while preparing an excel sheet.
In actuality, investments are made and redemptions effected at NAV and then at the close of the reporting period(maybe a quarter/month), the statement shows either relaized/unrealized gain/(loss).
Investments are basically grouped into 3 :
a) Held to maturity - reported at amortized cost
b) Trading securities - reported at FV with UR gains and losses included in P/L
c) Available for sale(securities) - reported at FV with UR gains/(losses) excluded from P/L and reported in a sep. 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
In actuality, investments are made and redemptions effected at NAV and then at the close of the reporting period(maybe a quarter/month), the statement shows either relaized/unrealized gain/(loss).
Investments are basically grouped into 3 :
a) Held to maturity - reported at amortized cost
b) Trading securities - reported at FV with UR gains and losses included in P/L
c) Available for sale(securities) - reported at FV with UR gains/(losses) excluded from P/L and reported in a sep. 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
5Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
PF Calculation & Challan Excel.xls