Courses · Video course

AIFMD & Annex IV Reporting: leverage, liquidity and the regulatory report of an alternative fund

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.

$149, or included in All Access

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.

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 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.

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.2, where you compute the leverage of the fund under the gross method.

Lesson 1.1, What AIFMD regulates: free.
Lesson 1.2, AIFMD II: what changed in April 2026: free.
Lesson 1.3, The Annex IV report in three blocks: free.
Lesson 1.4, Who reports, and how often (build lesson): free.
Lesson 3.2, The gross method (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:

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.

Inside the course

Build lesson 3.2: the Leverage sheet of the Case Workbook fills row by row with the gross method
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 Leverage sheet with the gross method and the commitment method
The Case Workbook: the whole report in 9 sheets, 250 live formulas, 8 checks and a master check.
Quiz App: a question on leverage 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 module26 lessons in 1080p, about 65 minutes of video, with English subtitles (.srt) and chapters.
Case_Workbook.xlsxHalden European Property Fund at 31 Dec 2026: scope, NAV, positions, leverage, liquidity, gate, stress tests, report figures and checks.
Step_Files22 workbooks: a start file and a solution file for each of the 11 build lessons.
Exercise_Workbook.xlsxSix exercise tabs, 36 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

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:

MeasureValue
NAV / assets under management€520.0m / €835.0m
Leverage: gross method / commitment method151.9% / 141.3%
Portfolio liquid within 90 days / investors able to redeem, with the gate15.6% / 5.0%
Redemption stress test: coverage at 15% / 25% of the NAV1.25x / 0.75x
Loan to value: today / after a fall of 20% in values33.9% / 42.3%
Fall in values that breaches the 45% covenant24.7%

Part of the fund controller track

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.

Questions people ask

Who is the course for?

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.

How long is it?

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.

Is it up to date with AIFMD II?

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.

Does it replace my regulator's filing manual?

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.

What do I get exactly?

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.

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 texts does it follow?

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.

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 legal or regulatory advice?

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.

AIFMD & Annex IV 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