|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/real-estate-financial-analysis-and-modeling/
课程评论：没有评论
Coursera 上的“房地产金融分析与建模”课程，旨在教授您如何在 Excel 中分析房地产投资，并基于分析结果提出投资建议。 本课程提供四种案例实践，帮助您打造完全自动化、动态的 Excel 模型，以便进行假设测试和关键投资假设的敏感性分析。课程内容紧密结合了实际招聘过程中的建模练习，特别适合准备房地产投资和资产管理岗位面试的学员，助您顺利通过 Excel 测试这一关键环节。 **先修要求：** * **Excel 基础：** 熟悉常用的 Excel 公式，如 EDATE、SUMIF、INDEX、MATCH 等。 * **金融基础：** 理解房地产投资相关的收入、成本、盈利能力和回报概念，例如内部收益率 (IRR)、股权倍数 (Equity Multiple)、现金回报率 (Cash on Cash Returns) 以及总初始收益率 (Gross Initial Yield) 和净初始收益率 (Net Initial Yield)。 * **债务融资知识（加分项）：** 了解贷款价值比 (Loan to Value)、融资 ratio 以及财务偿债能力指标，如债务收益率 (Debt Yield)、债务覆盖率 (Debt Service Coverage Ratio) 和利息覆盖率 (Interest Coverage Ratio)。 通过本课程的学习，您将成为一名熟练的 Excel 建模师，能够进行深入的房地产投资分析，并做出明智的投资决策。
Learn how to analyze real estate investments in Excel and how to make investment recommendations based on your analysis. On this course you will have the opportunity to practice and become a true excel modelling wiz with the four cases included in the course materials.The models you build will be completely automated and dynamic and will allow you to test your assumptions and run sensitivity analysis on your main investment assumptions.If you are preparing for an interview for both real estate investment and asset management roles, this course will help you pass the Excel test that is the first stage on the interview process, because it is based on modeling exercises that I have done as part of recruiting processes.To get the most out of this course you need previous knowledge of Excel and finance, including among other the use of formulas such as EDATE, SUMIF, INDEX, MATCH, and finance concepts related to revenue, costs, profitability and returns, such as the IRR, equity multiple, cash on cash returns and gross and net initial yields.It's also good to have some knowledge on debt financing such as loan to value, ratios and financial solvency such as debt yield, debt service coverage ratio and interest coverage ratio.
