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 →
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.
| Per unit | 5 Mar | 12 Mar | 19 Mar | 26 Mar |
|---|---|---|---|---|
| Opening NAV per unit | 104.1667 | 104.2299 | 104.8943 | 104.9594 |
| Income | +0.0871 | +0.0853 | +0.0892 | +0.0862 |
| Revaluation | 0.0000 | +0.6032 | 0.0000 | -0.1243 |
| Management fee | -0.0239 | -0.0241 | -0.0241 | -0.0241 |
| Residual (dealing, rounding) | 0.0000 | 0.0000 | 0.0000 | 0.0000 |
| Closing NAV per unit | 104.2299 | 104.8943 | 104.9594 | 104.8972 |
| Published price | 104.23 | 104.89 | 104.96 | 104.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.
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.
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.
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."
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.
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.
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).
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.
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 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.
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