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


What you'll learn
Understand UK's rent review structures and how to model them in Excel.
Understand property and corporate level expenses and how to incoporate them into analysis.
Learn how to model cash, payment in Kind (PIK) interest, commitment fee and make-whole fee in Excel.
Understand the use of debt covenants and reserve accounts and how to model them in Excel.
Learn how to model co-investor's return after fees and promote.
Understand the concept of invested capital and learn how to model management fees based on invested capital.
Calculate promote and profit share structures under a GP catch-up clause.
Learn how to create sensitivity analysis and overcome circular reference by using VBA.

Requirements
General knowlegde of MS Excel and basic financial modelling experience is recommended
No previous VBA knowledge is required, you will learn what you need during the course

Description
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.
Who this course is for:
Real estate debt / equity investors
Asset managers
People looking to start a career in real estate investment related roles

More Info