The Advanced Real Estate Pro Forma Modeling Master Class

About 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

and 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 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 pro forma model from scratch in Excel, 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 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 acquisition 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_

_, 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_

_and prevent unexpected equity capital calls to investors_

_Model_

_complex commercial real estate lease structures in Excel_

_including NNN, FSG, MG, and BYS reimbursement structures, custom rent escalation schedules, percentage rent clauses, and more_

_Create_

_dynamic re-leasing scenarios based on renewal probability and re-leasing assumptions_

_to create future projected lease cash flows automatically_

_Model_

_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 partners_

_Build formula "checks" to_

_quickly correct errors_

_and feel confident in your calculations_

This course is perfect for you if:

_You're a college student or graduate student looking to break into real estate investment 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 an existing real estate professional looking to_

_advance your career, increase your compensation, and break into the real estate investment industry_

_You've 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 land a better job, make more money, and/or more confidently model and analyze your own 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 basic understanding of real estate finance and you're looking to apply that knowledge to analyze commercial real estate investment opportunities, I'd love to have you in the class!