How To Pass Real Estate Modelling Tests & Interviews

Build better models. Land better roles. Stand out in real estate interviews.

What you'll learn

Build a fully functional real estate cash flow model from scratch in under two hours

Apply best-practice modelling techniques to create flexible, dynamic models that adapt to changes

Structure and present a compelling investment paper suitable for credit or investment committees

Avoid common mistakes in modelling tests and stand out with clean, professional outputs

Requirements

A basic understanding of real estate investment principles (e.g. leases, yields, capex)

Confidence using Microsoft Excel, including basic formulas and navigation

Access to Microsoft Excel (ideally Excel 365) on a Windows PC

Familiarity with real estate cash flow concepts is helpful but not essential

Description

If you're applying for real estate roles, there's a good chance you’ll be asked to complete a modelling test – often with little instruction and a tight deadline. This course shows you exactly how to approach them with clarity, confidence, and commercial awareness.Whether you're applying for an analyst role at a fund, a graduate position at a developer, or a mid-level job in asset management, this training gives you the structure, tips, and hands-on practice to improve your performance. You’ll learn how to build a flexible investment model from scratch – in under two hours – and how to present your findings clearly to stakeholders, interviewers, or investment committees.We'll cover every stage of the test process, from planning your time and interpreting the brief, to structuring your model and building the cash flow. You'll learn how to avoid common mistakes, how to format and check your work, and how to prepare a compelling summary paper that shows off your analysis skills.The course also includes an unassessed mock test with downloadable files, plus the option to upgrade for personalised feedback and coaching.If you’ve ever been caught off guard by a modelling test – or want to avoid making the mistakes that could cost you the job – this course is for you.You’ll walk away with a practical model you can use again and again, a clear structure for approaching any test, and the confidence to tackle your next opportunity head-on.

Overview

Section 1: Preparation & Strategy

Lecture 1 Modelling Test & Assessment Overview

Lecture 2 Time & task planning

Lecture 3 Mock Test Upgrade: Feedback & Coaching

Section 2: Building the Model

Lecture 4 Introduction & Inputs

Lecture 5 Tenancy Schedule

Lecture 6 Cash Flow

Lecture 7 Review & Audit

Section 3: Presenting the Deal

Lecture 8 Writing the IC paper

Section 4: Tips & Examples

Lecture 9 Modelling Test Examples (what not to do…)

Lecture 10 10 tips to pass a modelling test

Section 5: Mock Tests + Review

Lecture 11 INVESTMENT - Andrews House (1 hour test)

Lecture 12 INVESTMENT - 26 Whitehall Road

Aspiring real estate analysts preparing for technical interviews or modelling tests,Professionals looking to improve the speed, flexibility, and clarity of their investment models,Students or graduates pursuing careers in real estate investment, lending, or advisory,Recruiters and hiring managers who want to understand what ‘good’ looks like in a modelling test