3 Day Masterclass in Real Estate Modelling | Terrapinn Training

Singapore, 4-6 Dec 2017

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.


book today saving SGD $540

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

Meet your instructor

Jon Armour teaching Real Estate Modelling for Terrapinn Training

Jon Armour is currently a Partner with Dividend Realty Group, where he provides financial, due diligence and deal structuring consultation to private real-estate equity firms and brokerage houses focused on selling, acquiring and managing commercial real estate.

Over his tenure with Dividend Realty Group, Jon has consulted on over $1 Billion in real estate transactions.

Prior to this Jon worked for Griffis/Blessing, Inc., a private real-estate investment and management firm where he underwrote the acquisition and co-investment of more than $200 million of commercial real-estate property, including opportunities in multi-family, office, industrial, retail, development and redevelopment investment.

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

The earlier you book, the more you save…

Additionally, VAT may be applicable depending on course location.
Before 27 Oct 2017Before 17 Nov 2017After 17 Nov 2017
SGD $5,400
Save SGD $540
SGD $5,670
Save SGD $270
SGD $5,940
  • “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