|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-real-estate-gap-financing-modelling-master-class/
课程评论：没有评论
**课程名称：** 房地产夹层融资建模大师班 **课程概述：** 本课程深入探讨房地产行业特有的金融建模复杂性，重点关注通过提供劣后债务来填补融资缺口，从而进行资本结构再融资。该课程非常适合经验丰富的房地产投资者、顾问以及希望在房地产投资相关领域开启职业生涯的人士。课程将帮助学员掌握在Microsoft Excel中构建全动态房地产金融模型的能力。 **课程内容：** * **第一部分：** 探讨当前房地产市场融资缺口的挑战，并通过案例研究，分析一家伦敦写字楼项目，其发起方寻求优先股权解决方案，以配合进一步的股权注入，从而释放价值增长的资产管理计划，并调整现有优先贷款的规模。 * **第二部分：** — 学习如何在金融模型中模拟英国不同租金审查结构下的租金收入，以及物业和公司层面的费用。此外，课程还将探索续约概率的概念并将其应用于金融建模。 * **第三部分：** 重点讲解优先债务和优先股权融资安排的建模。学员将学习如何模拟准备金账户和现金锁定账户、债务契约、现金/实物计息，并理解它们对现金流和风险的影响。 * **第四部分：** 探讨房地产共同投资的复杂性，包括费用和分润结构的建模。具体而言，课程将涵盖投入资本的概念和普通合伙人（GP）的追赶条款，并教授如何计算普通合伙人与有限合伙人（LP）之间的利润分配。 * **第五部分：** 介绍宏（Macros）和VBA在金融建模中的应用。学员将掌握创建敏感性分析和利用VBA解决循环引用的技能。 **课程成果：** 完成本课程后，学员将能够熟练创建高级房地产金融模型。他们将掌握分析工具，能够做出明智的投资决策，并向投资委员会和客户提交全面的投资提案。本课程旨在帮助学员深化在房地产金融领域的专业知识。建议具备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.
