The Real Estate Gap Financing Modeling Master Class
Learn how to build a dynamic real estate financial model with senior and subordinate debt and promote structure in Excel
The Real Estate Gap Financing Modeling Master Class free download
Learn how to build a dynamic real estate financial model with senior and subordinate debt and promote structure in Excel
This course delves into the complexities of financial modelling specific to the real estate industry, with a focus on recapitalising the capital stack by providing subordinate debt to address financing gap. Ideal for experienced real estate investors, advisers, and people who would like to start a career in real estate investment related roles, this course equips participants with the capability to build a fully dynamic real estate financial model in Microsoft Excel.
The curriculum begins with why there is a financing gap challenge in the real estate market today followed by reviewing a case study where the sponsor is seeking a preferred equity solution for an office building in London which, alongside further equity injection will unlock value-accretive asset management initiatives and right-size the in-place senior loan.
Students will learn how to model rental income under various UK’s rent review structure, property and corporate level expenses. Furthermore, this course will explore the concept of renewal probability and apply it in financial modelling.
A significant portion of the course is dedicated to modelling senior and preferred equity financing arrangements. Student will learn to model reserve and cash trap accounts, debt covenants, cash / payment in kind interest, understanding their implications on cashflow and risk.
Participants will explore the intricacies of real estate co-investment, including modelling fees and promote structure. Specifically, the course will cover the concept of invested capital and GP catch-up clause and learn how to calculate profit share between General Partners and Limited Partners.
Lastly, the course will introduce the use of macros and VBA to financial modelling. Student will be equipped with the skill to create sensitivity analysis and overcome circular reference by using VBA.
By the end of the course, students will be proficient in creating advanced real estate financial models. They will be equipped with the analytical tools to make informed investment decisions and present comprehensive investment proposals to investment committee and clients. This course is designed for those seeking to deepen their expertise in real estate finance. Prior experience with Excel is recommended.
