Vanessa Severino
This course reviews real estate project finance concepts and focuses on the skills required to design and create a model to help finance professionals evaluate a real estate development investment.
In the course we review a case study for a mixed-use development project and examine concepts including model design, logic, project timing and various phases and various financing structures.
Various intermediate and advanced Excel tools along with helpful keyboard shortcuts will also be covered throughout the course.
Skills / Knowledge
- Design a clear and logical financial model
- Lay out all necessary assumptions
- Model various project phases
- Use date functions and binary flags to manipulate model cash flows and flexibly manage timing in the model
- Design a powerful scenario manager
- Construct financial statements and necessary schedules
- Calculate important metrics including Net Operating Income, Cash Flow for Debt Service, Levered and Unlevered Free Cash Flow
- Layer in financing structure that includes a construction loan, revolving credit facility, mortgage, mezzanine debt and equity
- Explore model optimization and self-auditing techniques
- Set-up financing sensitivity analysis – revenue reductions, cost overruns, interest rate risk, etc.
- Incorporate and control model circularity
- Incorporate a schedule to evaluate the project’s returns
- Build a strong summary page to display the results
Issued on
March 25, 2021
Expires on
Does not expire