Type the Excel formula for a fund’s NAV per unit, with total assets in B1, total liabilities in B2 and units outstanding in B3.
Type the Excel formula for a fund’s NAV per unit, with total assets in B1, total liabilities in B2 and units outstanding in B3.
Answer
=(B1-B2)/B3
(482,000,000 − 6,000,000) ÷ 19,000,000 = 25.0526. Struck once a day after the close; orders are filled at the NAV nobody knows yet.
OpenStax, Introduction to Business (CC BY 4.0) §16.6 — fund shapes; OpenStax Principles of Finance §12.1 — reference only; CSA news release — OEO trailing-commission ban effective 1 June 2022 under NI 81-105 (verified-facts §2.10 K12, CONFIRMED/CORRECTED 2026-09-17); NI 81-101 Fund Facts and NI 81-102 as register; segregated-fund guarantees (K14, CONFIRMED); original fund and figures