Real Estate modeling course in Dubai and Abu Dhabi (UAE)

This Real Estate modeling course is to equip the participants with knowledge and tools so that they can analyze a green-field real estate project's financial feasibility. Starting from scratch the participants will develop a detailed and flexible real estate financial model using advanced excel tools and global best practices.

Learning objectives

Apply advanced excel tools in project feasibility modeling
Project financial statements for a greenfield project
Forecast Revenue for lease or sale type real estate project
Develop EPC (Engineering, Procurement, and Construction), CapEx (Capital Expenditures) and funding schedule using timing flags
Build a project's repayment schedule for various sources of financing
Analyze the financial implications for construction, sales and lease phases of real estate projects
Assess a project’s financial feasibility from both the lender and the investor’s perspective
Calculate NPV (Net Present Value), IRR (Internal Rate of Return), NOI (Return on investment), and other metrics to evaluate the financial feasibility
Perform scenario analysis

Who should attend

Corporate Finance Managers
CFOs
Management Accountants
Corporate Finance Professionals working in construction, real estate development and real estate operating companies
Investment Bankers
Consulting Professionals
Credit Analysts and Corporate Bankers advising on real estate transactions
Private equity funds and family offices making real estate investments

Agenda

Day One

Advanced Excel Tools Used in Real Estate Modeling
FAST standards of Financial Modeling
Real Estate Modeling: An Introduction
Input Sheet and assumptions
Forecasting timing sheets and the concept of timing flags
Developing EPC and Capex (Capital Expenditures) schedule
Forecasting debt repayment and interest schedule (For different types of debt structure)
Interest during construction & controlling circular referencing

Day Two

Forecasting Revenue:

Lease type project
Sale type project
Mixed revenue structure

Projecting other core schedules like Depreciation, Working Capital and Equity
Projecting Income Statement, Balance Sheet & Cash Flow Statements

Calculating project’s cost of equity, cost of capital
NPV (Net Present Value) and IRR (Internal Rate of Return) analysis for project and investors
DSCR (Debt Coverage Ratio) analysis
Free cash flow analysis
NOI (Net Operating Income) analysis

Cash Flow waterfall analysis for different levels of investors
Sensitivity analysis of the project changing key inputs

Trainers

Karan Sharma, CFA

Trainer

Over 10 years of experience in M&A advisory, financial modelling, buy side equity research, advanced excel and financial statement analysis.

Rahul Sonthalia, CFA

Trainer

Over 12 years of experience in the area of macro-economic research, equity research, investment banking, with specialization in financial analysis, equity valuation, and Financial Modeling.

Upcoming dates

Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.

+97145546184

Real Estate Modeling & Valuation