3 Day Masterclass in Real Estate Modelling | Terrapinn Training
3 day Masterclass

Real Estate Modelling


Get to grips with the latest developments in real estate modelling.

This three-day intensive course will enable you to develop your own spreadsheets for different property types, allowing you to model any real estate investment scenario quickly and effectively.

Learn bulb

gain strategic advantage

Back up your international real estate investment strategy with understanding sound financial models

Learn bulb

get practical

Use stressed asset cash flows to support a variety of financing structures

Learn bulb

expand your knowledge

Build and understand accurate and robust models for your complex property development deals


Does your job require you to analyse and develop complex real estate models? If so, don’t miss this 3 Day Masterclass in Real Estate Modelling. In just three days, you’ll learn how to use Excel for powerful analysis of real estate investments, developments and partnerships.

This course will benefit Real Estate Professionals looking to take their financial modelling skills to the next level. It's is intended for the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

In just 3 days you will:

  • Examine the case for real estate investment, and explore the target criteria and property types
  • Get to grips with cash flow analysis for real estate and learn to use the core Excel Functions for Real Estate
  • Use advanced tools in Excel and apply them immediately to their own Excel models
  • Building construction loan and development models
  • Using statistical skills to better model real estate investments
  • Developing reusable models and auditing existing models
  • Examine the structure of REIT's, UPREIT's, REMIC's, and CMBSs; and the roles of the rating agency, the investment house, conduits, servicer, and underwriter
  • Spreadsheets that show how these structures work are also explored

Organisations that will benefit:

  • Investment banks
  • Hotel Groups
  • Real Estate Developers
  • Property Developers
  • Private Equity
  • Property Consultants
  • Investors
  • Banks
  • Hedge Funds

Who will attend:

  • C-Level Executives
  • Project Managers
  • Real Estate Analysts
  • Financial Managers
  • Risks Managers
  • Investment Managers

Course Agenda

  • Big Picture
  • Speed Networking
  • Why invest in real estate?
  • Development vs. Investment
  • Target Criteria
  • Property Types
  • Sources for Property
  • Cash Flow Analysis using Excel
  • Partnerships
  • “Wall Street” – IRR Hurdles
  • Advanced IRR Hurdles and Equity Multiples
  • “Claw backs”
  • Construction and Development
  • Build and Hold – Construction and Permanent Financing
  • Advanced Scheduling
  • Single Family Suburban and Condominium Development
  • General introduction to capital markets
  • Introduction to the Real Estate Investment Trust (REIT)
  • What sources of private debt are available to the investor?
  • How do Commercial Mortgage Backed Securities (CMBS) fit into the history of securitization
  • Wrap Up

For further information please call: +44 (0)207 092 1045

You might also be interested in:

Three-day training course in real estate modelling for property investors, developers, owners, lenders and advisors
  • “Milena knows the materials well and blends in real life experiences with theory to demostrate with applications to real life situation. Very hands on.”

    - Past attendee,Land Lease Japan

  • “Milena knowledge and detailed spreadsheets are useful”

    - Past attendee,Glickfield Nominees P/L

  • “Understanding assumption of building models is useful”

    - Past attendee, Khazanah Nasional Berhad

  • “The Trainer's knowledge of the materials well and blends in real life experiences with theory to demonstrate with applications to real situation. Very hands on.”

    - Past attendee,Land Lease Japan

  • “The Trainer's knowledge and detailed spreadsheets are useful”

    - Past attendee,Glickfield Nominees P/L


We can come to you too! If you have a team of six or more, why not hold a private course? Our experts come to you and the course is tailored to your requirements.

Call +44 (0)20 7092 1045 (United Kingdom)
or +65 6322 2333 (Asia Pacific)
for more details