Want to learn how to build professional, dynamic, institutional-quality for-sale residential real estate development models in Microsoft Excel?This course will take you by the hand and walk you step-by-step through the entire process. This is a project-based course, meaning you'll start with a blank Excel workbook andwalk away with a fully-functional, dynamic, eight-tabreal estate development model for condos, townhomes, and for-sale single family homes that YOU'VEcreated -from scratch.
When I was first learning real estate financial modeling, I would downloadreal estate investment modelsor real estate investment calculatorson the internet, only to feeloverwhelmed and frustratedbythe complexfunctions and formulas everywhereinthe Excel file. And once I felt like I was getting used to one of these things, I still was petrified to touch or change anythingbecause I didn'twant to"break" the model.And honestly, even if Iunderstood it and 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 real estate development model from scratch, and your first one will be done by the time you finish the last lecture.
This course will teach you how to build a real estate development model the way the largest and most sophisticated private equity real estate firms look at deals. At the end of this course, you will be able to:
Build an institutional-quality, dynamic real estate development model to analyze land acquisitions and development projects building condos, townhomes, or for-sale single family homes, all from scratch in Excel
Learn key Excel shortcuts to double your real estate financial modeling speed
Modify and customize existing residential for-sale real estate development models to fit your specific investment scenario and needs
Confidently modelkey investment metrics such as the IRR, Equity Multiple, and Total Profit, and calculate these metricsautomatically as you change manual input drivers
Build a dynamic construction budget (including S-Curve and straight-line modeling functionality)
Model pre-sales and deposits that change automatically as construction timelines change
Model deposit holdbacks and build in functionality to use deposits as equity to fund the project
Build out floating rate construction loan draws, dynamic equity draws, and incremental loan payoffs to accurately model the financing and payoff as individual units are sold
Build formula "checks" to error-proof your work and feel confident your calculations arecorrect
This course is perfect for you if:
You're a college studentor graduate studentlooking to break into real estate development after graduation, and you're looking to add the key technical skill sets to your arsenal that will put you head and shoulders above the competition and allow you to land a lucrative career opportunity in the field
You're a professional in a different field, but looking to become a real real estate developer on the side and want to be able to confidently analyze a ground-up for-sale residential development deal
You're an existing real estate professional looking to advance your career, increase your compensation,andbreak into thereal estate development field
You've boughtrental homes orduplexes,and now you're looking to become a real estate developer and want to feel confident in your ability to analyze new ground-up construction projects
If you have a basic understanding of real estate finance, and you're looking to apply that knowledge to analyze new for-sale residential real estate development opportunities, enroll now and let's get started building this model together today. Looking forward to having you in the course!