Courses · Video course
How the regulatory report of an alternative investment fund is really computed: assets under management and reporting frequency, leverage under the gross and commitment methods, the two liquidity profiles, the liquidity management tools of AIFMD II, stress tests and controls. You build every figure in Excel on one open-ended property fund.
26 short video lessons (about 65 minutes of video), 11 of them built live in Excel, the Case Workbook of a fund with a NAV of €520.0m, 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.
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 AIFMD is written by lawyers for lawyers. This course is written for the people who produce the numbers. It takes one fund, €620.0m of property, a bank loan, a currency hedge and quarterly redemptions, and computes its report line by line: why its leverage is 151.9% under one method and 141.3% under the other, and what its investors can really redeem in ninety days.
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.
All of module 1 and one build lesson. The four lessons of module 1, and lesson 3.2, where you compute the leverage of the fund under the gross method.
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:
Halden European Property Fund (fictional): an open-ended real estate fund with five properties worth €620.0m, listed securities of €70.0m, cash of €45.0m, a bank loan of €210.0m and a currency forward of €100.0m. NAV at 31 Dec 2026: €520.0m. Its manager runs €955.0m in total.
Module 1
1. What does AIFMD primarily regulate?
Answer: The managers of alternative investment funds. The directive regulates the manager (AIFM); the fund keeps its national legal form.
Module 1
2. Which of these is an alternative investment fund (AIF)?
Answer: A fund that raises capital from a number of investors under a defined policy and is not a UCITS. AIF: collective investment undertaking, not a UCITS.
Module 1
3. Most rules of AIFMD II (Directive (EU) 2024/927) apply from...
Answer: 16 April 2026. In force since 15 April 2024, applied from 16 April 2026; the reporting changes from 16 April 2027.
Module 1
4. Which article of the directive sets the reporting obligation to regulators?
Answer: Article 24. Article 24; Article 23 covers disclosure to investors.
Module 1
5. What is the deadline to file an Annex IV report?
Answer: One month after the end of the reporting period, 45 days for a fund of funds. Article 110 of Regulation 231/2013.
Module 1
6. A registered (sub-threshold) manager reports to its regulator...
Answer: Once a year. Registered managers file a lighter report, annually.
Module 2
7. Which of these is NOT a macro asset type of the report?
Answer: Leverage. Securities, derivatives, physical assets, collective investment undertakings, other.
Module 3
8. For AIFMD, leverage is...
Answer: Any method by which the manager increases the exposure of the fund. Borrowing, derivatives or any other means.
Module 4
9. How many periods do the liquidity profiles of the report use?
Answer: Seven. From 1 day or less to more than 365 days.
Module 5
10. Which article of the directive requires regular liquidity stress tests?
Answer: Article 16. Article 16: liquidity management; Article 15: risk management.



| File | What it is |
|---|---|
| Videos, one zip per module | 26 lessons in 1080p, about 65 minutes of video, with English subtitles (.srt) and chapters. |
| Case_Workbook.xlsx | Halden European Property Fund at 31 Dec 2026: scope, NAV, positions, leverage, liquidity, gate, stress tests, report figures and checks. |
| Step_Files | 22 workbooks: a start file and a solution file for each of the 11 build lessons. |
| Exercise_Workbook.xlsx | Six exercise tabs, 36 answers checked automatically, hidden solution tabs. |
| Quiz_App.html | 48 questions, eight per module, with explanations. |
| Course_Summary.pdf | Two pages per module: key ideas, the case in numbers, the mistakes to avoid; glossary and dated sources. |
| Certificate exam | Online from your order page or your account: 40 questions from a private bank, 60 minutes, 80% to pass, verifiable certificate. |
Halden European Property Fund, fictional, is an open-ended real estate fund in euros with quarterly redemptions and a gate of 5% of the NAV. At 31 December 2026:
| Measure | Value |
|---|---|
| NAV / assets under management | €520.0m / €835.0m |
| Leverage: gross method / commitment method | 151.9% / 141.3% |
| Portfolio liquid within 90 days / investors able to redeem, with the gate | 15.6% / 5.0% |
| Redemption stress test: coverage at 15% / 25% of the NAV | 1.25x / 0.75x |
| Loan to value: today / after a fall of 20% in values | 33.9% / 42.3% |
| Fall in values that breaches the 45% covenant | 24.7% |
This course completes Private Fund Finance & Controllership, which models the life of a closed-ended fund, and NAV & Investor Reporting, which closes and reports a quarter. Together they form our fund controller track. For the product side of European property funds, see European Real Estate Funds. See certifications.
Fund controllers and fund managers, risk and compliance officers, fund administrators, auditors and consultants who produce, review or explain the regulatory report of an alternative investment fund: real estate, private equity, private debt, infrastructure. You need basic Excel. No legal background is assumed.
26 video lessons of two to four minutes, about 65 minutes of video, in six modules. With the build lessons, the exercises and the quizzes, most learners need five to seven hours.
Yes, as of November 2026. The course covers what applies since 16 April 2026 (liquidity management tools, loan-originating funds, delegation), explains that the reporting changes apply from 16 April 2027, and states clearly that the current Annex IV template is still the one to file until ESMA's new standards apply. The methods taught (exposure over NAV, liquidity profiles, stress tests, controls) carry over to the new template.
No. The course teaches the calculations and the logic of the report on one complete case. Each national regulator has its own portal, naming rules and sometimes extra fields: always read the local manual before you file.
Right after payment: the course zip (Course Summary, Case Workbook with 250 live formulas, 22 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.
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.
Directive 2011/61/EU as amended by Directive (EU) 2024/927, Delegated Regulation (EU) No 231/2013 (Articles 2, 6 to 11, 110 and 111, and Annex IV), ESMA's guidelines on reporting obligations and on liquidity stress testing, and the 2026 standards and guidelines on liquidity management tools. Texts are paraphrased, with dated sources in the Course Summary.
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.
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.
No. The fund, its manager and its investors are fictional. The course teaches how the report works and how to compute it; it does not replace legal advice or your regulator's instructions.
The videos, the Case Workbook, the step files, the exercises, the quiz app, the Course Summary and the certificate exam. Download right after payment.
Want every course? All Access opens all of them, with their certificate exams, for $299 a year.