The programme
Real Estate Modelling Programme
We build these Excel models from scratch, line by line. Every single piece of the model is built on-screen, nothing comes pre-packaged: you witness the entire creation of the model as we intuitively explain why each cash flow item matters.
£1,500With Coaching, £2,000
| A | B | C | D | |
|---|---|---|---|---|
| 4 | Asset cash flow | Year 1 | Year 2 | Year 3 |
| 5 | Gross Rental Income | 1,250,000 | 1,281,250 | 1,313,281 |
| 6 | Operating Costs | (150,000) | (153,750) | (157,594) |
| 8 | Net Operating Income | 1,100,000 | 1,127,500 | 1,155,687 |
| 10 | Debt Service | (846,022) | (846,022) | (846,022) |
| 12 | Cash Flow to Equity | 253,978 | 281,478 | 309,665 |
Rent covers the loan 1.30 times. Change the rent and see what the loan does to the equity.
Our alumni now work at 100+ firms, including some of the world’s leading names in commercial real estate. A few of them, by the kind of firm:
average increase in salary after the programme£24k before, £53k after
From your first cash flow to a full equity waterfall
Small bite-size material in Microsoft Excel and video format. You build every line yourself, in order, with mini-tests throughout based on real modelling tests, with full solutions.
- Start here
Building an Asset Cash Flow
Present value, NPV and IRR, then an annual and a quarterly discounted cash flow for a single asset.
- Then
Incorporating Debt and Leverage
Interest-only and amortising loans, and what leverage does to the sponsor’s cash flow.
- Then
Waterfall Modelling and Promote Structures
How profit is split between investors and sponsor: a three-tier equity waterfall and a partnership model.
- Then the real thing
10 practice modelling tests from real Private Equity firms, Debt Funds and Investment Banks
Sit each one against the clock, then open the finished Excel and watch it built on video. One of the ten is free: sit it before you buy.
Enrol now to elevate your career to the next level
One programme, with or without Coaching. See what Coaching adds.
Modelling Programme
£1,500For you if the modelling is the gap
- The full recorded course, from first principles to a fund waterfall
- 10 real modelling tests from UK and European funds and banks, each with a video walkthrough and the finished Excel
- The course Excel workbook
- At your own pace, with lifetime access: go back over any part as often as you like
Modelling Programme + Coaching
£2,000For you if the interview is the harder part
- Everything in the Modelling Programme
- Three one-hour one-to-one sessions, used however you find most useful: a mock interview, job-search strategy, or anything else you need
- Your CV edited and re-checked, your LinkedIn profile reviewed, and a written plan built around your test or interview date
Led by Anita MeliceBlackstone, Cerberus and Goldman Sachs before CRE ModellingNot sure yet? Sit the free test or book a free call first.Employer paying? Book a free call and we’ll arrange it with them.
Who will benefit
- 01Undergraduate and postgraduate students studying real estate and finance based degrees
- 02Young professionals with limited work experience and Excel training looking to break into the industry
- 03Real estate investment analysts, associates, investors and research analysts
- 04Professionals with limited Excel skills looking to enhance their skillset in a meaningful way to improve their technical real estate modelling skills
- 05Senior real estate professionals, debt and lending professionals and surveyors
- 06Professionals switching industries to real estate investments
Not covered: hotels and hospitality. There is a hotel underwriting model in the free materials, but it is not part of the programme.
Programme Highlights
Progressive difficulty, from beginner to pro-level.
- 01
Industry-best practices
You will gain insights into how the world’s top institutional investors analyse real estate opportunities and construct sophisticated financial models.
- 02
At your own pace, with lifetime access
Go through the course at your own speed, from anywhere, and go back over any part as often as you like. The course is regularly updated to reflect the latest industry-best practices.
- 03
Value for money
A fraction of the cost of traditional online university classes and other providers. The content prioritises commercially relevant material, so you learn what matters without spending a fortune or studying for weeks.