|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-advanced-real-estate-development-pro-forma-modeling-course/
课程评论：没有评论
课程名称：高级房地产开发建模大师班 课程概述：想要学习如何从零开始在Microsoft Excel中为办公室、零售和工业项目构建专业的动态、机构级商业房地产开发财务模型？本课程将手把手指导您完成构建完整动态的八个标签商业房地产开发财务模型的整个过程，从一个空白的Excel工作簿开始，直到您完成自己的商业房地产开发财务模型。许多学习房地产财务建模的人曾遇到过下载房地产开发模型时感到无从下手的困扰，复杂的函数和公式往往让人感到沮丧。本课程将揭示大多数房地产财务模型背后的“黑箱”。课程结束时，您将能够从零开始构建一个动态、专业级的商业房地产开发财务模型，具备大型和复杂的CRE开发公司评估交易的视角。 课程结束时，您将能够： - 从零开始构建机构级的动态商业房地产开发财务模型（无需昂贵软件） - 模拟复杂的房地产融资结构，如次级建设贷款、基于多种约束的动态长期贷款大小等 - 创建动态资金来源和用途表，准确掌握开发项目的资金需求 - 在Excel中模拟复杂的商业房地产租赁结构，包括NNN、FSG、MG和BYS报销结构、自定义租金递增计划、百分比租金条款等 - 基于续租概率和续租假设创建动态续租情景，自动生成未来预测的租赁现金流 - 在月度、季度和年度基础上模拟投资者分配，并快速切换三种选项 - 创建自定义图表和图形，便于向投资者、贷款人和合作伙伴展示 - 构建公式“检查”，快速修正错误，增强计算的信心 本课程适合以下人群： - 正在寻找进入房地产开发的大学生或研究生，想在求职简历中增加关键技术技能，以在房地产开发领域的实习和全职工作中脱颖而出 - 希望提升职业生涯和增加收入的现有房地产专业人士 - 对房地产金融有基本理解，希望将房地产财务建模技能提升到专家级别，自信地模拟和分析自己的房地产开发交易 学生反馈： ★★★★★ “好课程，内容精彩且相对简单，全靠Justin。感谢您开设这些课程，传播房地产金融建模的知识，非常感激。” ★★★★★ “解释非常清晰！不同示例中的重复使学习更深入。同时指出您在做的快捷方式，让这变成对您的第二天性也很有帮助。” ★★★★★ “精彩课程，与Justin的其他课程一样，内容丰富且注重实用。没有多余的内容，直接进入材料和技巧。虽然课程相对高级，但涵盖了许多不同的技术、方法和概念。” 如果您对房地产金融有基本了解，并希望将这些知识应用于分析土地收购和商业房地产开发机会，我期待您加入这个课程！
Want to learn how to build professional, dynamic, institutional-quality commercial real estate development pro forma models from scratch for office, retail, and industrial projects in Microsoft Excel? This course will take you by the hand and walk you step-by-step through the entire process of building a complete, dynamic, eight-tab commercial real estate development pro forma model, starting with a blank Excel workbook and ending with a complete commercial real estate development pro forma model that you've created (from scratch). When I was first learning real estate financial modeling, I would download real estate development models or "calculators" on the internet, only to feel overwhelmed and frustrated by the complex functions and formulas everywhere in these Excel files. And once I felt like I was finally starting to get used to these, I still was scared to change anything because I didn't want to "break" the model. And in most cases, even I believed the model was working correctly, I still had no idea if I could even trust the calculations in the first place. If you've ever felt any of these things, this course will pull back the curtain and uncover the "Black Box" that most real estate financial models appear to be. By the end of this course, you'll be able to build a dynamic, professional-quality commercial real estate development pro forma model from scratch, and by the time you finish the last lecture, you'll have an institutional-quality model that you've built from start to finish.This course will teach you how to build a commercial real estate development pro forma model the way the largest and most sophisticated CRE development firms look at deals. At the end of this course, you will be able to:Build an institutional-quality, dynamic commercial real estate development pro forma model for office, retail, and industrial projects from scratch (without expensive software)Model advanced real estate financing structures like mezzanine construction debt, dynamic permanent loan sizing based on multiple constraints, and moreCreate a dynamic sources and uses table, so you'll know exactly how much you'll need to fund a development projectModel complex commercial real estate lease structures in Excel including NNN, FSG, MG, and BYS reimbursement structures, custom rent escalation schedules, percentage rent clauses, and moreCreate dynamic re-leasing scenarios based on renewal probability and re-leasing assumptions to create future projected lease cash flows automaticallyModel investor distributions on a monthly, quarterly, and annual basis and switch between the three options (quickly and easily)Create custom charts and graphs that automatically populate in your model, that you can use to present to investors, lenders, and partnersBuild formula "checks" to quickly correct errors and feel confident in your calculationsThis course is perfect for you if:You're a college student or graduate student looking to break into real estate development after graduation, and you're looking to add the key technical skills to your resume that will put you head and shoulders above the competition and allow you to land internships and full-time jobs in the CRE development fieldYou're an existing real estate professional looking to advance your career and increase your compensation.You have a basic understanding of real estate finance and you're looking to take your real estate financial modeling skill set to an expert level to more confidently model and analyze your own real estate development dealsHere's what some of our students have had to say about the class:★★★★★ "Great course, amazing content made relatively simple, all thanks to Justin. Thank you for making these courses and spreading the knowledge of Real Estate Financial Modeling. Really Grateful."★★★★★ "Very clear explanations! I like the repetition through the different examples to embed learning. It's also helpful to say which shortcuts you are doing so that this becomes second nature."★★★★★ "Fantastic course, and just like with Justin's other courses: crammed with great content and hands-on application. No fluff. Just into the materials and the mechanics. This course is rather advanced, but it covers a lot of different techniques, methods, and concepts."If you have a basic understanding of real estate finance and you're looking to apply that knowledge to analyze land acquisition and ground-up commercial real estate development opportunities, I'd love to have you in the class!
