|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/real-estate-development-in-excel/
课程评论：没有评论
**课程名称：** Excel in Real Estate Development (附带模板) **课程概述：** 本课程旨在教授学员如何利用Excel对多单元房地产开发项目进行财务建模。课程提供一个完整的、即插即用的Excel模型，只需少量调整即可适用于任何多单元房地产开发项目。学员将学习如何使用该模型，掌握房地产开发行业常用的术语、指标和估值技术。 **模型亮点：** * **动态计算指标：** 模型可动态计算内部收益率 (IRR)、偿债覆盖率 (DSCR)、成本收益率 (Yield to Cost)、贷款成本比 (LTC) 和项目估值，直观展示各个变量变化对项目的影响。 * **行业标准应用：** 该模型在实际房地产项目中得到广泛应用。 * **股权投资者建模：** 专为辛迪加化项目中的股权投资者设计，展示股权IRR和投资者回报。 * **债务建模：** 涵盖建设贷款、永久贷款、一次性还款以及所有期间的债务偿还。模型包含集成的摊销表，方便快速分析貸款。 * **易于适应性：** 模型设计旨在轻松适应任何类型多单元项目，视频内容将详细指导如何调整模型以处理不同的单元组合、稳定期、租金、贷款和退出日期。 **课程内容示例：** 课程将以一个36个单元的公寓项目为例，从股本投入到项目出售，演示整个财务建模过程。 **总之，本课程将为您提供一套强大的Excel工具和实用的房地产开发知识，助您在实际工作中得心应手。**
This course will teach you how to financially model a multi-family real estate development project and comes with a downloadable, complete Excel model. The model that comes with this course is plug and play with minimal work necessary to adapt it to any kind of multi-family development project. This course will teach you how to use the model, the industry standard terms, metrics and valuation techniques which developers use on a daily basis. Here are some strengths of the model: The model dynamically calculates various metrics, including IRR, Debt Service Coverage, Yield to Cost, Loan to Cost and Project Valuation so you can see how every variable you change affects the project. This model is used in industry for actual real estate projectsDesigned to model equity investors for syndicated projects. The model will show equity IRRs and investor returns.Designed to model a construction loan, a take-out permanent loan, a balloon payment and all of the debt service payments along the way. The model comes with integrated amortization tables for quick analysis of loans. The model is specifically designed to be easy to adapt to any kind of multi-family project. The video content of the course will show you everything you need to know to re-tool the model to handle any variety of unit mix, stabilization period, rent, loan, and exit date. This course will demonstrate how to financially model the development of a 36 unit apartment complex, from equity contribution up through the sale of the project. Welcome to Real Estate Development in Excel.
