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.
KPME Real Estate Modeling
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
Learn to apply advanced excel tools in real estate modeling
Understand fundamentals of real estate investments
Learn nuances for developing financial models for different types of real estate investments such as residential, commercial and hospitality
Modeling of debt structure for real estate investments
Model and calculate real estate investment KPIs
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
Rahul Sonthalia
AFM, CFA, CMA
Rahul has more than 13 years of experience in the area of investment banking, equity research, macro-economic research, and training. He has been teaching financial modeling and investment banking courses in UK, Singapore, and the MENA region.
He has delivered advanced financial modeling related programs for Sovereign wealth funds and banks in the GCC and for large asset management companies in the UK and Singapore. He was a guest speaker on “Best Practices in Financial Modeling” at the Modeloff Global World Financial Modeling championship in London.
Shanin Thomas
CFA
Shanin has over 10 years of work experience in equity research, portfolio management, investment banking, and financial modeling. He was a partner at Esta Capital, a boutique investment research and advisory firm. He also previously worked in JPMorgan’s Investment Banking Division in Mumbai and New York offices covering North American banks and asset management companies.
He has over 6 years of experience in CFA training and corporate training on programs such as Financial modeling, finance for non-finance, business valuation, equity research, value investing, and derivatives.
Upcoming Dates
| Course Title | Term | Location | Start Date | End Date | Price* | |
|---|---|---|---|---|---|---|