What does the Real Estate Modeling Program Cover

The program equips delegates with the necessary knowledge and tools so that starting from scratch, they can develop a full-scale financial model for valuation of real estate investments.

Learning Objectives

icon

Learn to apply advanced excel tools in real estate modeling

icon

Understand fundamentals of real estate investments

icon

Learn nuances for developing financial models for different types of real estate investments such as residential, commercial and hospitality

icon

Modeling of debt structure for real estate investments

icon

Model and calculate real estate investment KPIs

icon

Perform scenario and sensitivity analysis

Program Agenda

Introduction to the Real Estate Model

Model design and structure for the case study real estate asset

Introduction to Real Estate Cash Flows

Understanding real estate investment concepts: Rental rates, ADR, Occupancy, RevPAR, GOP, NOI, cap rate

Develop the model

Projecting rental rates, rental revenue and non-rental revenues
Projecting occupancy rates and vacancy losses and key operating expenses
Calculating terminal value : Replacement cost Vs exit cap rate methods

Modeling the Debt Structure

Flexible debt repayment & interest payment schedule

Model output and dashboard

Calculating outputs such as payback period and levered and unlevered IIR
Preparing Dashboards to present key sections of the model

Modeling for Key Model outputs

Understanding the role of Asset Management post acquisition
Preparing an asset management dashboard for performance monitoring
Analysing post acquisition fair value and analysing the impact of potential impairment

Our Expert Trainers

Upcoming Dates

Course Title Level Term Location Course Date Duration / Days Price*
5 Level I CFA® Program – Complime... Level I June 18, 2021 Dubai June 25, 2021 34 days (Sun,Tue,Fri) AED 1
6CMA – Complimentary Info session Level 1 July 8, 2021 Dubai June 23, 2021 34 days (Sun,Tue,Fri) AED 1200
7CMA – Part 2 – Revision Pro Level 1 June 28, 2021 Ajman June 30, 2021 34 days (Sun,Tue,Fri) AED 1500

Request a Call Back

The answer to your doubts is just a click away! Simply fill in your details in the form, and we will get in touch with you shortly.