The objective of the program 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
Learn and apply advanced excel tools used in real estate financial modeling
Develop EPC, capex and funding schedule using timing flags
Build project's repayment schedule for various sources of financing
Analyze the financial implications for construction, sales and lease phases of real estate projects
Assess project’s financial feasibility from both lender and investor’s perspective
Calculate NPV, IRR, NOI and other metrics to evaluate 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 Introducion
Input Sheet and assumptions
Forecasting timing sheets and the concept of timing flags
Developing EPC and Capex 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
Financial analysis and Valuation of the project Calculating project’s cost of equity, cost of capital NPV and IRR analysis for project and investors DSCR analysis Free cash flow analysis NOI analysis
Cash Flow waterfall analysis for different levels of investors
Sensitivity analysis of the project changing key inputs
Trainers
Karan Sharma, CFA
Trainer
Over 8 years of experience in M&A advisory, financial modelling, buy side equity research, advanced excel and financial statement analysis.
Upcoming dates
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.
Discounts
Get 15% discount, if you are a Current Student who is currently attending an Executive Education, CMA, Claritas, or CISI course with us.
Get 15% discount, if you are a Past Student who has completed a course with us.
Get 15% discount, when three or more individuals from the same organization register.
Get 10% discount, when you register 2 weeks prior to the course start date.
