Courses · Video course

NAV & Investor Reporting: the quarterly close of a private markets fund

How the NAV of a closed-ended fund is really produced and reported: the cash roll, fair value and the valuation bridge, fees and accruals, the accrued carried interest, each partner's capital account, DPI, TVPI and net IRR, and the report investors expect. You build the whole close in Excel along the way.

$149, or included in All Access

28 short video lessons (about 60 minutes of video), 14 of them built live in Excel, the Case Workbook of a $500.0m fund, a start file and a solution file for every build lesson, an Exercise Workbook that checks your answers, a 48-question quiz app, a Course Summary, and the certificate exam online. Download right after payment.

Get the course, $149 →

Secure checkout by Stripe. 14-day money-back guarantee. Not sure yet? Watch module 1 and a build lesson free, read the summary of module 1 and try ten questions below.

Most material on fund accounting stops at definitions. This course closes one fund four times in a row, from the bank statement to the page a pension fund reads, and makes you compute every number on the way: the NAV, the carried interest that is accrued before anyone is paid, and the capital account of each partner.

What you will be able to do

The program

Six modules. Concept lessons explain on animated slides; build lessons fill the workbook on screen, cell by cell, with the formula shown, while you build the same cells in the start file.

Try it free

All of module 1 and one build lesson. The four lessons of module 1, and lesson 3.5, where you build the waterfall that accrues the carried interest of each quarter.

Lesson 1.1, What a NAV is in a closed-ended fund: free.
Lesson 1.2, The close calendar and who does what: free.
Lesson 1.3, Build the cash roll (build lesson): free.
Lesson 1.4, From the accounts to the NAV: free.
Lesson 3.5, Build the carry accrual (build lesson): free.

The summary of module 1. Download the free sample of the Course Summary (PDF).

Ten quiz questions. Click an answer: it turns green or red and the explanation appears. The questions use the running case:

Northmoor Capital Partners III (fictional): $500.0m of commitments from six partners, of which $490.0m pay a 2% management fee and 20% carried interest above an 8% preferred return. At 31 Dec 2028: four companies carried at $209.00m for a cost of $170.00m, NAV $215.21m.

Module 1

1. In a closed-ended private equity fund, what is the quarterly NAV mainly used for?

Answer: Reporting the value of each partner's interest; nobody subscribes or redeems at it. Partners commit once and cannot redeem: the NAV is a reporting figure, used in their own accounts, in performance and in the carry accrual.

Module 1

2. Who is responsible for the fair values in the NAV?

Answer: The general partner (the manager), even when an administrator keeps the books. Valuation is the manager's responsibility; the administrator records it and the auditor tests it once a year.

Module 1

3. The NAV of a fund is...

Answer: Assets at fair value less liabilities. It is a balance sheet figure: investments at fair value, cash and receivables, less accruals and borrowings.

Module 1

4. A capital call received from the partners...

Answer: Increases cash and the NAV by the same amount. Contributions are equity: cash rises and so does net asset value. They are not income.

Module 1

5. A draw on the subscription line used to buy a company...

Answer: Leaves the NAV unchanged: an asset and a liability rise together. Borrowing adds an investment and a debt of the same size. The NAV moves later, with interest and the value of the company.

Module 1

6. Q1 2028: opening cash $2.90m, capital called $4.00m, management fee paid $2.45m, expenses paid $0.20m. Closing cash?

Answer: $4.25m. 2.90 + 4.00 - 2.45 - 0.20 = 4.25.

Module 2

7. Fair value is...

Answer: The price that would be received to sell the asset in an orderly transaction between market participants at the measurement date. Same exit-price definition in IFRS 13 and ASC 820. It is today's price, not the planned exit.

Module 3

8. During the investment period, Northmoor's management fee is charged on...

Answer: The commitments of the fee-paying partners. 2% of $490m a year; the GP commitment pays no fee. After the investment period the base usually steps down to invested capital.

Module 4

9. A partner's capital account is...

Answer: Its share of the NAV: contributions less distributions plus its share of results. The accounts add up to the NAV at every date.

Module 5

10. DPI measures...

Answer: Cash distributed to the LPs relative to the capital they paid in. Distributions / paid-in: the realized part of the multiple.

Inside the course

Build lesson 3.5: the Carry sheet of the Case Workbook fills row by row with the formulas of the waterfall
A build lesson: the workbook fills on screen, cell by cell, with the formula shown. You build the same cells in the start file.
Case Workbook: the NAV sheet with the statement of operations, the balance sheet and the NAV roll-forward
The Case Workbook: the whole close in 10 sheets, 600 live formulas, 11 checks and a master check.
Quiz App: a question on the accrued carried interest with the explanation after the answer
The Quiz App: 48 questions with explanations, practice by module. It runs offline, and the same quizzes are in your learner account.

What you receive

FileWhat it is
Videos, one zip per module28 lessons in 1080p, about 60 minutes of video, with English subtitles (.srt) and chapters.
Case_Workbook.xlsxNorthmoor Capital Partners III in 2028: cash, valuation, NAV, carried interest, capital accounts, partner statement, performance, reporting and checks.
Step_Files28 workbooks: a start file and a solution file for each of the 14 build lessons.
Exercise_Workbook.xlsxSix exercise tabs, 42 answers checked automatically, hidden solution tabs.
Quiz_App.html48 questions, eight per module, with explanations.
Course_Summary.pdfTwo pages per module: key ideas, the case in numbers, the mistakes to avoid; glossary and dated sources.
Certificate examOnline from your order page or your account: 40 questions from a private bank, 60 minutes, 80% to pass, verifiable certificate.

The running case

Northmoor Capital Partners III, fictional, is a $500.0m private equity fund in its second year. In 2028 it buys two companies, bridges one purchase with its subscription line, receives a dividend recapitalization, and crosses its preferred return hurdle:

MeasureValue
NAV: 31 Dec 2027 / 31 Dec 2028$92.20m / $215.21m
Investments at 31 Dec 2028: cost / fair value$170.00m / $209.00m
Accrued carried interest: 30 Jun / 30 Sep / 31 Dec 2028$0.00m / $2.98m / $5.26m
Capital account of the largest investor, after carry$62.95m
Limited partners: DPI / RVPI / TVPI0.06x / 1.05x / 1.11x
IRR: gross / before carry / net34.2% / 16.2% / 13.0%

Part of the fund controller track

This course builds on Private Fund Finance & Controllership, which models the whole life of the same fund, and will be followed by a course on AIFMD and Annex IV reporting. Together they form our fund controller track. See certifications.

Questions people ask

Who is the course for?

Fund accountants and controllers, fund administrators, auditors, investor relations and finance teams of private equity, private credit, infrastructure and real estate managers, and the investors who read their reports. It suits anyone who must produce, check or explain the NAV and the statements of a closed-ended fund. You need basic Excel.

How long is it?

28 video lessons of two to four minutes, about 60 minutes of video, in six modules. With the build lessons, the exercises and the quizzes, most learners need five to seven hours.

Do I need the Fund Finance course first?

No. The fund is the one of Private Fund Finance & Controllership, for continuity, but this course stands on its own: the history of the fund is given, and the waterfall is rebuilt from scratch for the carried interest accrual. The two courses complement each other: that one models the life of the fund, this one closes and reports a quarter.

What do I get exactly?

Right after payment: the course zip (Course Summary, Case Workbook with 600 live formulas, 28 step files, Exercise Workbook, Quiz App) and one video zip per module, with subtitles and chapters. The certificate exam opens from your order page or your learner account.

How does the certificate exam work?

40 questions drawn at random from a private bank, 60 minutes, graded on the server, 80% to pass, retake as often as you need. You receive a certificate with a public verification page. How certificates work.

Which standards does it follow?

Fair value as defined by IFRS 13 and ASC 820, the IPEV valuation guidelines (December 2022 edition) and the ILPA reporting templates, including the Reporting Template updated in January 2025 and used from the first quarter of 2026. Fee terms and the waterfall are those of the fictional fund: real agreements differ.

Who is the narrator?

Lessons use AI-generated narration. The scripts, the case and every figure on screen were written and computed for this course and checked by script against the workbook.

Can I get a refund?

Yes. Every course has a 14-day money-back guarantee: write to [email protected] within 14 days of your purchase and you get a full refund, no reason needed. Details in the terms of sale.

Is it accounting or investment advice?

No. The fund, its companies and its investors are fictional. The course teaches how a close works and how to model it.

NAV & Investor Reporting: $149

The videos, the Case Workbook, the step files, the exercises, the quiz app, the Course Summary and the certificate exam. Download right after payment.

Get the course, $149 →

Want every course? All Access opens all of them, with their certificate exams, for $299 a year.

Related