Courses · Video course
How open-ended property funds really work, from the inside: SCPI, OPCI, German open-ended funds and ELTIF; subscriptions and redemptions, fees, the NAV and the reconstitution value, gates and the AIFMD II liquidity tools, Annex IV and investor reporting. You build a complete fund in Excel along the way.
33 short video lessons (about 80 minutes of video), 18 of them built live in Excel, the Case Workbook of a €1,200.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.
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 courses on real estate funds stop at definitions. This one follows a single fund for six quarters, through a fall in values and a run of redemptions that triggers its gate, and makes you compute every number the managers, the depositary and the investors look at.
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 five lessons of module 1, and lesson 5.2, where you build the gate that decided how much each investor was paid in the stress quarter.
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:
Meridian Europa Property Fund (fictional): 28 buildings worth €1,200.0m at 31 Dec 2024 in five countries, €264.0m of loans (22.0% LTV), NAV €980.0m, 9.8 million shares at €100.00. Quarterly dealing at NAV, entry fees 2.5% to the fund and 2.0% to distributors, a 5% gate.
Module 1
1. What makes a fund open-ended?
Answer: Investors subscribe and redeem at the fund's own price on regular dealing dates. Open-ended funds issue and cancel shares at their own NAV-based price; closed-ended funds call capital once and return it at the end.
Module 1
2. Which French vehicle sets its price on the reconstitution value, within a 10% corridor?
Answer: SCPI. Art. L214-94 of the Code monetaire et financier ties the SCPI price to the reconstitution value; a gap above 10% is justified and notified to the AMF.
Module 1
3. Who must verify that the fund really owns its buildings?
Answer: The depositary. For real assets the depositary cannot hold them in custody; it verifies ownership and monitors cash flows.
Module 1
4. German open-ended real estate funds bought today impose which redemption terms?
Answer: 24 months minimum holding and 12 months notice. KAGB section 255 since 2013.
Module 1
5. Meridian owns €1,200.0m of buildings, €70.0m of cash, other net liabilities of €26.0m and €264.0m of loans. What is its NAV?
Answer: €980.0m. 1,200.0 + 70.0 - 26.0 - 264.0 = €980.0m.
Module 1
6. What is Meridian's loan-to-value at 31 Dec 2024 (€264.0m of loans, €1,200.0m of property)?
Answer: 22.0%. 264.0 / 1,200.0 = 22.0%. LTV divides by the property value, not by NAV.
Module 2
7. Under forward pricing, an order received before the cut-off is dealt at...
Answer: The next NAV, computed after the cut-off. Nobody can deal at a price already known.
Module 3
8. TER divides fund operating costs by...
Answer: The average NAV of the year. Management fees and other fund costs over average NAV.
Module 4
9. Market value is the price...
Answer: A willing buyer would pay a willing seller at the valuation date. Red Book / European valuation standards definition.
Module 5
10. The first-mover advantage in an open-ended property fund means...
Answer: Early leavers get the full NAV while stayers bear the cost of later sales. It is what drives runs.



| File | What it is |
|---|---|
| Videos, one zip per module | 33 lessons in 1080p, about 80 minutes of video, with English subtitles (.srt) and chapters. |
| Case_Workbook.xlsx | The Meridian Europa Property Fund: assets, valuations, rent, NAV, dealing, liquidity, returns, reporting and checks. |
| Step_Files | 36 workbooks: a start file and a solution file for each of the 18 build lessons. |
| Exercise_Workbook.xlsx | Six exercise tabs, 42 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: 40 questions from a private bank, 60 minutes, 80% to pass, verifiable certificate. |
The Meridian Europa Property Fund, fictional, owns 28 buildings in France, Germany, the Netherlands, Ireland and Poland. Over six quarters its office values fall, a tenant leaves, and in the first quarter of 2026 investors ask for €82.0m back:
| Measure | Value |
|---|---|
| Property / loans / NAV at 31 Dec 2024 | €1,200.0m / €264.0m / €980.0m |
| NAV per share: 31 Dec 2024 / 30 Jun 2026 | €100.00 / €91.60 |
| 2025: distribution rate / total return / TER | 3.08% / 0.04% / 1.16% |
| Q1 2026: net redemptions / share of each request paid | 8.3% of NAV / 64.0% |
| Credit line drawn at 31 Mar 2026 | €41.7m |
| SCPI lens: price above reconstitution value, Q1 2026 | 10.4% |
This course is the third building block of the ERFA, European Real Estate Fund Analyst, with Real Estate Modeling and Private Fund Finance & Controllership. See certifications.
Analysts and controllers of real estate funds, auditors, depositary and compliance teams, distribution teams and fund selectors in private banks and wealth management. It suits anyone who must explain or check how an open-ended property fund prices, deals, pays and reports. You need basic Excel.
33 video lessons of two to five minutes, about 80 minutes of video, in six modules. With the build lessons, the exercises and the quizzes, most learners need six to eight hours.
No. The running case is a pan-European fund with buildings in France, Germany, the Netherlands, Ireland and Poland. SCPIs and OPCIs are covered in detail because they are the largest retail market, alongside German open-ended funds, Luxembourg RAIFs, ELTIF 2.0 and the AIFMD II rules that apply to all.
Right after payment: the course zip (Course Summary, Case Workbook with 1,833 live formulas, 36 step files, Exercise Workbook, Quiz App) and one video zip per module, with subtitles and chapters. The certificate exam opens from your order page.
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.
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.
The liquidity rules of AIFMD II, applicable from 16 April 2026, are covered, and every regulatory figure carries its source and the date it was checked. Rules that vary by country or fund, such as transfer taxes or the gate threshold, are stated as assumptions of the case.
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 buildings and its investors are fictional. The course teaches how these funds work and how to model them.
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.