Mastering The Modelling Test
Mastering The Modelling Test
Mastering The Modelling Test
Mastering The Modelling Test
Mastering The Modelling Test
Screen Shot 2016-05-04 at 16.41.01.png
Mastering The Modelling Test
Mastering The Modelling Test
Mastering The Modelling Test
Mastering The Modelling Test
Mastering The Modelling Test
Screen Shot 2016-05-04 at 16.41.01.png



This scenario based training programme will be invaluable to those candidates applying for an Analyst position, as well as real estate professionals wishing to understand the concepts of real estate financial modelling.

Written by a highly experienced team of real estate modelling experts, Mastering The Modelling Test program provides candidates with the essential skills needed to understand and conduct professional real estate financial analysis and will enable them to successfully pass the modelling test. 

The Mastering the Modelling Test training program is meticulously designed to teach and guide users through a logical step-by-step process of how to create complex and flexible real estate financial models. The digital download training program interlinks the theoretical nature of real estate and the specialised Excel modelling skills needed to construct financial appraisals within a modelling test and workplace surrounding.

Learn the following fundamentals of building Excel real estate financial models; data presentation; rental income assembly; multiple lease analysis, incl. rent reviews, lease renewals and expiries; rent-free and void period forecasting; CAPEX assembly; disposal values; debt finance; unlevered and levered performance metrics (IRR, equity multiple and NPV); risk and sensitivity analysis.

Add To Cart


  • Undergraduate and postgraduate students studying real estate and finance cognitive degrees
  • Candidates performing real estate modelling tests
  • Real estate investment analysts, associates and investors that use Excel on a daily basis
  • Senior real estate professionals wishing to grasp a deeper understanding of Excel-based real estate modelling
  • Professionals switching industries to real estate investments 
  • APC candidates
  • Investment agents, research analysts, fund managers and fund accounts


  • Digital download containing;
    • 82 page step-by-step PDF training guidebook
    • Corresponding password protected and unlocked Excel workbook following a modelling test case study scenario
    • PDF and Excel PASSWORD received with the order confirmation email
  • Training program requirement - Essential
  • Training program type - Course attendance not required. Able to study from the comfort of your own home.
  • Basic knowledge of Excel and finance is assumed
  • Access to Microsoft Excel and a PC is required. Compatible with Macintosh and Macintosh Excel. However, Macintosh Excel shortcuts not provided (all financial models and modelling test will be performed on PC's).
  • Refunds not available (Terms and Conditions)


Mastering The Modelling Test training program will provide users a greater understanding of the following;

  • Learn modelling structures, modelling techniques and real estate theory
    • Introduction to real estate
    • Introduction to Excel and best practice techniques
    • Power modelling and Excel shortcuts
    • Design and model presentation
  • Transaction inputs and specifications
    • Hold periods
    • Target rates, incl. risk-free rates and risk premiums
    • Rental rates
    • Growth rates
    • Investment yields, e.g. initial and exit yields
  • Creation and presentation of transaction business plans
    • Current and future tenant lease events
    • Prospective void and rent-free periods
    • Current and future rental rates
    • Projected property values and equivalent yield calculations
    • Void cost and CAPEX budgeting
  • Modelling rent functions and multi-let cash flows for current and future business plans
    • Dates and time intervals
    • Modelling lease expires, break clauses, lease renewals and upward only rent reviews
    • Incorporating void and rent-free periods
    • Rent function concept using logic functions, incl. IF and AND
    • Distribution of CAPEX, void and letting costs
  • Analysis of unlevered performance metrics
    • Profit margins
    • Cash on cash equity multiples
    • Internal Rate of Return (IRR)
    • Net Present Value (NPV)
  • Debt financing
    • Introduction to real estate debt financing, incl. Loan to Value, arrangement fees, loan repayment types (non-amortisation)
    • Construction of levered cash flows
    • Analysis of levered IRR, NPV, equity multiple and margin
  • Scenario analysis
    • Sensitivity analysis
    • Conditional formatting
    • Maximum property price analysis (goal seek)
  • Modelling test case study