Nav Calculation And Reporting

NAV CALCULATION AND REPORTING Read more Aastha Kumari A .What is NAV? NAV means Net Asset Value. It is the value of one unit or one share of a fund eg. a mutual fund or private equity fund. Total Assets: What the fund owns (cash, stocks, properties, etc.) Highlights NAV= Number of UnitsTotal Assets−Total Liabilities​ / no.of unit Aastha Kumari Total Liabilities: What the fund owes (debts, expenses) Number of Units: How many units investors have in total Why is NAV Important? How much each investor’s share is worth It is used to calculate how much to pay or receive when someone buys or sells units of the fund It shows the fund is making profit or loss When is NAV Calculated? Aastha Kumari Mutual Funds: Usually every day (end of the day) Private Equity / Real Estate Funds: Quarterly or yearly (not daily) What Affects NAV? a)NAV goes when Fund makes profit Value of investments increases b) NAV goes when - Fund makes loss Value of investments decreases Aastha Kumari Fund pays out money to investors B .Inputs Needed to Calculate NAV a) Valuation (Total Assets) Investments (like stocks, bonds, real estate) Cash in hand or bank Profits not yet taken (unrealized gains) Income to receive (like rent, dividends) b) Total Liabilities Aastha Kumari Loans the fund has taken Unpaid fees (management fee, admin fee) Accrued expenses (not yet paid but due) Taxes payable or other obligations c ) Number of Units or Shares This is the total number of fund units (or shares) that have been given to investors. C.Valuation of Investments: Cost vs Fair Value Aastha Kumari Cost ValueMeaning - original price the fund paid when it bought the investment. Example: If a fund buys a property for ₹1,00,00,000,The cost value is ₹1,00,00,000. Fair Value Meaning current market value- what the investment is worth today. Aastha Kumari Example If the market says the same property is now worth ₹1,20,00,000, The fair value is ₹1,20,00,000. Why This Important? In fund accounting, we usually use Fair Value, not Cost. This gives a more realistic picture of the fund’s actual worth today. Aastha Kumari D. Monthly / Quarterly NAV Reporting What Is NAV Reporting? Meaning - NAV reporting means calculating and showing the Net Asset Value of a fund at regular time periods. It shows investors how much their investment is worth. It helps fund managers and investors track performance. It's like giving a regular report card for the fund. When NAV Reported? Aastha Kumari a ) Mutual Funds - Daily (sometimes weekly) b )Private Equity Funds - Quarterly (every 3 months) c) Real Estate Funds- Quarterly or Monthly d) Hedge Funds - Monthly or Quarterly To prepare the NAV report, the fund team must: a) Valuate Investments Check the fair market value of properties, shares, or private companies May use expert valuations or market data. Aastha Kumari b) Calculate Total AssetsAdd all investments, cash, and other assets c) Deduct LiabilitiesSubtract loans, unpaid fees, and other debts. d) Determine NAVNAV= Total Assets - Liabilities/no. of unit e) Prepare NAV StatementInclude the NAV per unit Show major changes since last report Sometimes includes commentary or investor updates. Aastha Kumari E. NAV pack components 1. NAV Summary SheetIt shows final NAV calculation NAV=Total Assets−Total Liabilities 2. Balance Sheet (Statement of Assets & Liabilities) It shows fund owns (assets) and owes (liabilities) 3. Profit and Loss Statement (P&L or Income Statement) Aastha Kumari Shows income earned and expenses incurred. Example Rent, interest, dividends (income) Management fees, legal fees (expenses) 4. Investment Valuation Schedule Lists all investments with: Cost (original purchase price) Fair Value (current market value) Unrealized Gain/Loss Aastha Kumari 5. Capital Account Statements (Investor Statements) Shows details for each investor: Opening balance Contributions (capital calls) Distributions (payouts) Ending balance Share of NAV 6. Cash Reconciliation Matches cash in fund records vs. cash in bank Ensures there are no missing or extra transactions Aastha Kumari 7. Expense Accrual Schedule Lists all expenses that are due but not paid yet Eg.- audit fees, fund admin fees, legal bills 8. Capital Activity Schedule Shows all capital movements during the period: Capital calls (money taken from investors) Distributions (money returned to investors) Aastha Kumari 9. Fee Calculation Summary Details of fees charged: Management fees Performance fees (carried interest) 10. Supporting Documents (Optional) Valuation reports (by third-party valuers) Bank statements Invoices and fee agreements Notes or commentary from the fund manager Aastha Kumari F. NAV Review Checklist General Information Fund name and ID verified Valuation date is accurate Currency of NAV is correctly stated Assets Review Marketable securities priced using correct market data (e.g., Bloomberg, Reuters) Illiquid/Level 3 assets priced according to valuation policy Aastha Kumari Corporate actions (splits, dividends, mergers) reflected accurately FX rates used are from reliable sources and match policy (e.g., 4 PM LDN) Accrued interest and dividends included Unrealized gains/losses correctly calculated Liabilities Review Accrued expenses (audit, admin, legal, etc.) included Fees (management, performance, custody) correctly calculated and accrued Payables and other liabilities reconciled Aastha Kumari Income & Expense Review Dividend income recorded correctly Interest income matches coupon schedule Performance and management fees calculated per the fund’s governing documents Expense cap or reimbursement applied, if applicable Reconciliation Checks Cash reconciled to bank statements Holdings reconciled with custodian Trades (buys/sells) reconciled with brokers and accounting system Corporate action reconciliation Aastha Kumari NAV Calculation Verification Total assets – total liabilities = net assets Number of shares/units verified NAV per share/unit correctly calculated NAV compared to prior periods and variance explained Compliance Checks Valuation policy followed Pricing committee approvals (if required) Threshold breaches reviewed and documented Regulatory reporting requirements met. Aastha Kumari Sign-offs & Documentation Internal sign-off from fund accountant or NAV preparer Reviewed and signed by supervisor or fund controller Supporting documentation attached (pricing sources, reconciliations, fee calcs) Exception reports reviewed and cleared G. common NAV errors Aastha Kumari a) Incorrect Pricing of SecuritiesError: Using stale or wrong prices (e.g., wrong close, wrong exchange). Tip: Always source prices from approved vendors and cross-check with Bloomberg/Re -uters. Automate price feeds where possible. Flag large price movements. b) Missed or Incorrect Corporate Actions Error: Not accounting for dividends, stock splits, mergers, etc. Aastha Kumari Tip: Maintain a corporate actions calendar. Review custodian notifications daily. Check positions against expected entitlements. c) Wrong FX Rates Error: Using wrong cutoff time or outdated FX rates. Tip: Ensure FX source and time match fund policy. Aastha Kumari d) Incorrect Fee Calculations Error: Miscalculated management or performance fees. Tip: Automate calculations. Review fee terms in the fund docs. Peer-review the logic and rate inputs regularly. e) Unreconciled Cash or Positions Error: NAV includes incorrect cash balances or unconfirmed trades. Aastha Kumari Tip: Perform daily cash and position reconciliations. Investigate breaks immediately. f) Improper Accruals Error: Missing or misapplied expense/income accruals. Tip: Maintain an accrual schedule. Update monthly based on historical averages and vendor notices. Compare accruals to budget or prior month. Aastha Kumari g) Not Reviewing Large Variances Error: Ignoring significant swings in NAV or P&L without explanation. Tip: Require sign-off from a senior reviewer for unusual movements. h ) Manual Entry Errors Error: Typos or incorrect data during manual entry. Tip: Reduce manual inputs with automation. Implement maker-checker control. Use input validation (e.g., formatting, dropdowns). Aastha Kumari i) Incorrect Unit/Shs in Issue Error: NAV per share wrong due to inaccurate share count. Tip: Reconcile subscriptions/redemptions daily. Verify with transfer agent. Crosscheck share register. j) Lack of Documentation Error: No backup for pricing, fees, or assumptions used. Tip: Attach all supporting docs (PDFs, reports, screenshots). Require documentation before NAV approval.