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.
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
Corporate Finance Professionals working in construction, real estate development and real estate operating companies
Credit Analysts and Corporate Bankers advising on real estate transactions
Private equity funds and family offices making real estate investments
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
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
Karan Sharma, CFA
Over 8 years of experience in M&A advisory, financial modelling, buy side equity research, advanced excel and financial statement analysis.
Rahul Sonthalia, CFA
Over 11 years of experience in the area of macro-economic research, equity research, investment banking, with specialization in financial analysis, equity valuation, and Financial Modeling.
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.
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.
The teacher was very knowledgeable and experienced in the subject matter. It definitely shines through in his teaching approach!
Wagih Mansour, Financial Modeling Masterclass program
Very useful session. The practical applications will make life easier in the future
Jay R. Makad, Excel for Accounting and Finance Professionals program
The course is very helpful. It eased the pain in doing data analysis and monthly reports manually!
Glenn Luthrania, Financial Modeling and Valuation program
An easy to follow course to comprehend difficult concepts and content in Financial Modeling
Saad Almahroos, Financial Modeling Masterclass program
An excellent training session; very relevant to my daily job description and also had the opportunity to learn new terms and concepts
Zubin George, Financial Modeling and Valuation program
A well run course. Good materials, presentation and interaction
Stephanie Holland, Financial Modeling Masterclass program
The trainer did a great job to ensure everyone understood the material. The concepts were explained in a patient and relatable manner. Overall the session was excellent!
Heather Harrington, Financial Modeling program
The trainer encouraged interactions and promptly answered queries raised by students. Very knowledgeable and experienced in the field
Ahmad Yassine, Financial Modeling and Valuation program
Very interactive session encouraging the involvement of the participants; enriching our knowledge base in excel
Ananth V. Patel, Excel for Accounting and Finance Professionals program
As a fresher, the course was beneficial and the trainer was patient and well-informed
Nachiket Pandya, Three Statement Modeling and Valuation program
Financial Modeling & Valuation was very relevant to my work. Very knowledgeable faculty here. I will definitely recommend them
Hassan Ali, Financial Modeling and Valuation prorgam
Very useful session to get acquainted with excel shortcuts and data management techniques which can be applied to daily tasks
Somakumar, Excel for Accounting and Finance Professionals program
A very insightful class. Touching upon "just the right" elements used in corporate finance and valuations
Shehbaz Hussain, Financial Modeling and Valuation program
Very well managed session in aspects of time and content. Never knew excel could do so much
Lata Phophalia, Excel for Accounting and Finance Professionals program
The session covered important concepts in excel in detail; taking into consideration basic tools
Vinithra Parthasarathy, Excel for Accounting and Finance Professionals program