50% discount for limited time to celebrate the launch of REIA

Launch Discount: Intermediate Real Estate Financial Model

Take advantage of a 50% discount. Available for a limited time to celebrate the launch of the Real Estate Investment Academy.

Buy for £28 (50% off)
  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Real-life Case Study

This course course covers a case study of a core investment opportunity with a single tenant on a long lease (Project Magellan). In this case study, you are an Analyst at a real estate private equity firm called Thanos Capital and your job is to make an investment recommendation. You can only make this investment recommendation by building a financial model.

Course Curriculum

    1. Course Content & Navigation

      FREE PREVIEW

    2. Intermediate Financial Model - Master Excel File

    3. Course Overview

    4. Jargon Buster

    5. Excel Power Shortcuts

    6. Portugal Real Estate Market Report

    1. Case Study Overview

      FREE PREVIEW

    2. Lesson 1: Model Setup

      FREE PREVIEW

    3. Lesson 2: Rental Income

      FREE PREVIEW

    4. Lesson 3: Opex & NOI

    5. Lesson 4: Net Asset Cash-Flows

    6. Interim Assessment 1

    7. Lesson 5: Unlevered Cash-Flows

    8. Lesson 6: Exit Valuation

    9. Lesson 7: Unlevered Returns

    10. Lesson 8: Debt Repayment Schedule

    11. Lesson 9: Levered Cash-Flows

    12. Lesson 10: Levered Returns

    13. Lesson 11: Income Taxes

    14. Interim Assessment 2

    15. Lesson 12: Capital Gains Taxes

    16. Lesson 13: Post-Tax Cash-Flows

    17. Lesson 14: Promote Mechanisms

    18. Interim Assessment 3

    19. Lesson 15: Annual Cash-Flows

    20. Lesson 16: Formatting

    21. Conclusions & Next Steps

    22. Final Exam

About this course

  • £28.00
  • 3 hours of video content

Course Highlights

This is a case study based financial modelling course in which you will learn how the most prestigious investment firms analyse real estate investment opportunities and build financial models.

  • Immersive case study: based on a real transaction and delivered via over 3 hours of video lessons.

  • Excel backup: gain access to the final financial model and the excel back-up for each of the 16 steps.

  • Best practices: the financial model is identical to the financial models you would build as an Analyst at top private equity firms.

  • Excel shortcuts: see exactly each keyboard entry so that you can learn how to apply excel shortcuts when building financial models.

  • Jargon buster: includes a section with key terminology so that you can familiarize yourself wit the industry jargon.

  • Market report: real estate market reports are included in this course so you can better contextualize the transaction.

  • Exams: test your knowledge via four assessments that are included in this course.

  • Taught by industry expert: instructed by Steffen Kluners, a seasoned professional with extensive private equity experience.

  • No-questions-asked refund policy: students are entitled to a full refund within the first 72 hours of signing up for this course.

  • Certificate of completion: receive a course completion certificate for job applications or social media sharing.

Your Instructor

Steffen Kluners

Founder of the Real Estate Investment Academy

The course is taught by Steffen Kluners, industry expert with over 12 years of private equity experience, including at Blackstone. Steffen has worked on transactions with an aggregate volume of over $3.0bn. Before launching the Real Estate Investment Academy, he worked as an Investment Director at a private equity firm in London. In the REIA courses, he shares valuable insights on how the most prestigious private equity firms analyse real estate transactions.

Course Completion Certificate

You will receive a course completion certificate at the end of this course, which you can use for your applications, and you can also share the certificate on any social media platform such as LinkedIn, Facebook, and Instagram.

The REIA Mobile App

The course content can be accessed via our REIA mobile app so that you can access our courses on-the-go, providing for a more user-friendly experience.

Course Overview

Who is this course for?

This financial modelling course is designed for:

  • Students preparing for job interviews in the real estate industry, aiming to gain a competitive edge by mastering financial modelling techniques.
  • Investment professionals looking to refine their core financial modelling skills.
  • Anyone who wants to learn how to set up real estate cash-flow models.


Course Format

  • The course is delivered via immersive video lessons and is structured to offer an engaging and interactive learning experience. 
  • It includes over 3 hours of video content, divided into easily manageable segments, allowing you to progress at your own pace.
  • The content is organized into 16 individual financial modelling lessons that are easy to follow and that provide a seamless learning journey. 
  • Each lesson is accompanied by a support excel file so that you can learn how to build an intermediate financial model from scratch.
  • We have incorporated practice tests and included support such as a Jargon Buster with the key industry terminology and an excel cheat sheet with the most important shortcuts.
  • The course has real hands-on applications, making it an ideal preparation resource for assessment centers and financial modelling tests.


Recommended Prerequisites

The course is suitable for beginner to intermediate level and learners are strongly encouraged to complete the Applied Financial Modelling course beforehand.


Refund Policy

You will be entitled to a full refund within the first 72 hours of signing up this course. Just send an e-email to admin@reia-edu.com.


Industry Expert Opinion

“The case study is ideal for anyone who wants to learn how the best investment firms set up cash-flow models. I really liked how the model progressively builds up from zero so that anyone can learn how to build sophisticated models from scratch. I have taken this course in preparation for a financial modelling test at a real estate investment firm in London. The modelling techniques taught in this course have been invaluable not only for the financial modelling test but also for my day-to-day job as an Investment Associate, which requires extensive financial modelling. ”

James Graham (Investment Associate at MARCOL Real Estate)

Other Courses