Real Estate Sector Modeling

What you will learn

• The ability to build a functional, dynamic real estate financial model from scratch.
• The skill set to model real estate transactions for multiple different asset types and solve for key investment metrics evaluated by real estate firms.
• Mastery of the foundational analytical and financial modeling tools necessary to break into the real estate private equity industry and model deals.
• How to create best practice macros and Excel VBA codes to break circularities;
• Learn how to create institutional, professionally formatted models to present development pro forma calculations to investors and partners
• A mastery of real estate financial modeling formulas, functions, and processes.
• Calculation for returns from project and returns to equity holders
• Sensitivity Analysis

Requirement

• A laptop with a good internet connection and Microsoft Excel.
• General knowledge of MS Excel and essential financial modeling experience is recommended
• Basic Knowledge of financial statements  is recommended

Description

Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project. The project’s debt capacity, valuation, and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this. In this Project Finance Modeling course, we will model complex real estate project finance transactions from scratch in excel.