Articles

How do you explain a change in NAV per unit?

Divide each source of profit by the units in issue, add them to the opening price, and watch the residual. If it is not close to zero, something is missing.

To explain a change in NAV per unit, split it into its sources: income received, change in value of the investments, fees, and a residual. Each source is its amount divided by the units in issue at the NAV date. The residual is what dealing and rounding leave; it should stay within a tolerance set in advance. In our case, the largest weekly move, 0.63% on 12 Mar 2027, is explained almost entirely by one revaluation.

The case comes from the Automate a Fund Reporting with AI course by Julian R. Sterling, author of The Private Equity Fund Controller Playbook.Get the DRM-free PDF, $19.99 →

The method

Closing NAV per unit = opening NAV per unit + income per unit + revaluation per unit + fees per unit + residual. The first three effects use the same divisor, the units in issue at the closing date. The residual is computed last, as the closing price less everything else: it is a check, not an explanation.

Four weeks

Lindenmoor Property Income Fund (fictional), NAV per unit in EUR, March 2027.
Per unit5 Mar12 Mar19 Mar26 Mar
Opening NAV per unit104.1667104.2299104.8943104.9594
Income+0.0871+0.0853+0.0892+0.0862
Revaluation0.0000+0.60320.0000-0.1243
Management fee-0.0239-0.0241-0.0241-0.0241
Residual (dealing, rounding)0.00000.00000.00000.0000
Closing NAV per unit104.2299104.8943104.9594104.8972
Published price104.23104.89104.96104.90
Change in the published price+0.06%+0.63%+0.07%-0.06%

Income adds about 0.09 a week and the fee takes back about 0.02. In a week without a revaluation the price moves by a few cents. On 12 Mar 2027, a revaluation of €1.45m adds 0.6032 per unit.

Why subscriptions do not appear

Units are issued and redeemed at the last published price. A subscription raises the NAV and the number of units in the same proportion, so it does not move the price, apart from the rounding of the dealing price and the fact that income of the week is shared with the new units. That is the residual. In the case it stays below a hundredth of a cent, against a tolerance of half a cent.

When the residual is large

An attribution explains a NAV that is right. Run the controls on the file first; a large residual is one more reason to return it.

From the table to the commentary

Set a threshold for a written comment: in the case, a change of more than 0.5% in the published price. One week out of four crosses it. The comment says what moved, by how much, and where the evidence is: "The price rose 0.63% to EUR 104.89. A revaluation of €1.45m accounts for 0.60 per unit; income and fees for +0.06."

What an AI assistant can draft

Give it the attribution table and the threshold, and ask for the comment in two sentences, using only the figures of the table. The table comes from formulas you tested; the assistant turns it into words. It should not compute the attribution itself, and the reviewer still reads the comment against the table before signing.

Sources

  1. Julian R. Sterling, Automate a Fund Reporting with AI (video course, 2026): running case Lindenmoor Property Income Fund
  2. Directive 2011/61/EU (AIFMD), article 19 on valuation; Commission Delegated Regulation (EU) No 231/2013, articles 67 to 74
  3. Time, cost and frequency figures are assumptions of the worked case, not measurements

Every figure is computed by script from the course's running case, Lindenmoor Property Income Fund, a fictional fund, and checked on 19 November 2026. Tolerances, thresholds, times and costs are assumptions of the case, and the errors in the files are planted for the course. For education, not legal or regulatory advice.

Build the whole control pack, step by step

26 short video lessons on handing a recurring fund report to an AI assistant without losing control: expected NAV, six controls with tolerances, attribution, sign-off and minutes, a reporting data pack, the written procedure and the tests. You build the control pack of a weekly NAV in Excel, with step files, exercises, a prompt kit and a certificate exam ($149).

Watch module 1 free →

Questions readers ask

What is NAV attribution?

The split of a change in NAV, or in NAV per unit, between its sources: income, changes in the value of the investments, fees and expenses, and a residual that should be close to zero.

Why do subscriptions not change the NAV per unit?

Because units are issued at the current price: the NAV and the number of units rise in the same proportion. Only rounding and timing effects remain.

When should a NAV movement be commented in writing?

When it exceeds a threshold set in advance, for example half a percent in a week for a property fund. The comment states the cause, the amount and the evidence.

Read the whole case

This article is one calculation from The Private Equity Fund Controller Playbook. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

See the course →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99

Also on this site

All 2221 articles →