• views: 147
• date: 4 July 2024
• posted by: voska89

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
Homepage

https://www.udemy.com/course/the-real-estate-gap-financing-modelling-master-class/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.