The Advanced Real Estate Pro Forma Modeling Master Class
Want to learn how to build professional, dynamic, institutional-quality commercial real estate pro forma models from scratch for office, retail, and industrial properties 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 pro forma model, starting with a blank Excel workbook ending with a complete commercial real estate pro forma acquisition model that YOU'VE created, from scratch.
When I was first learning real estate financial modeling, I would download real estate investment models or real estate investment calculators on the internet, only to feel overwhelmed and frustrated by the complex functions and formulas everywhere in the Excel file. And once I felt like I was getting used to one of these things, I still was petrified to touch or change anything because I didn't want to "break" the model. And honestly, even if I understood 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 commercial real estate 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 pro forma investment 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 commercial real estate pro forma investment model for office, retail, and industrial properties from scratch (without expensive software)
Model advanced real estate financing structures like mezzanine debt, future funding for renovation projects, prepayment penalties, dynamic loan sizing based on multiple constraints, and more.
Create a dynamic sources and uses table that tracks equity investments throughout the project, so you'll know exactly how much you'll need to fund a deal up-front
Build dynamic working capital accounts to automatically fund operating shortfalls to prevent unexpected equity "capital calls" to investors
Model complex commercial real estate lease structures in Excel including
You've have a basic understanding of real estate finance and financial modeling, and you're looking to take your real estate financial modeling skill set to an expert level to land a better job, make more money, or do more profitable real estate deals.
Here's what our students have had to say:
"This course really has it all. I model deals for experienced private equity real estate investors, and the principals I work for had never used a proforma as dynamic, versatile, and visually appealing as this model. If you need to analyze a commercial deal you should absolutely take the time to work through this course. Thanks, Justin. Already looking forward to the next course."
"Best class I've taken, truly builds a phenomenal model with institutional quality complexity. Take this class. "
"Amazing, above expectations. "
If you have a solid understanding of real estate finance, and you're looking to apply that knowledge to analyze commercial real estate investment opportunities, enroll now and let's get started building this model together today. Looking forward to having you in the course.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 14.5 total hours |
Starts | On Demand (Start anytime) |
Cost | $18 |
From | Udemy |
Instructor | Justin Kivel |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Business |
Tags | Business Real Estate |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Real Estate Agent/Real Estate Investing $39k
Real Estate Negotiator and Real Estate Appraiser $40k
Real Estate Translator $60k
Sales/Real Estate $64k
Real Estate Accountat $68k
Shareholder (Real Estate) $71k
Real Estate Aquisitions $74k
Investment Real Estate $78k
Real Estate and Insurance $85k
Real Estate Law $94k
Associate Real Estate & Real Estate Litigation $137k
Partner- Real Estate $260k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 14.5 total hours |
Starts | On Demand (Start anytime) |
Cost | $18 |
From | Udemy |
Instructor | Justin Kivel |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Business |
Tags | Business Real Estate |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course