The Real Estate Development Pro Forma Modeling Master Class

The Complete Guide To Building Real Estate Development Pro Forma Models From Scratch For Smarter Real Estate Investing

Last updated 2022-01-10 | 4.7

- Learn how to build dynamic
- institutional-grade real estate development models from scratch
- Learn how to build out S-Curve construction models
- equity and construction loan draw funding
- and dynamic lease-up modeling for new development deals
- Learn how to create institutional
- professionally formatted models to present development pro forma calculations to investors and partners

What you'll learn

Learn how to build dynamic
institutional-grade real estate development models from scratch
Learn how to build out S-Curve construction models
equity and construction loan draw funding
and dynamic lease-up modeling for new development deals
Learn how to create institutional
professionally formatted models to present development pro forma calculations to investors and partners

* Requirements

* Access to Microsoft Excel for Mac or PC
* Mac Numbers
* or Google Sheets
* A basic understanding of real estate finance terms and calculations is recommended

Description

Want to learn how to build professional, dynamic, institutional-quality 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 and walk away with a fully-functional, dynamic, eight-tab real estate development 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 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 from scratch

  • Learn key Excel shortcuts to double your real estate financial modeling speed

  • Modify and customize existing real estate development models to fit your specific investment scenario and needs

  • Confidently model key investment metrics such as the Stabilized Return on Cost, IRR, and Equity Multiple, and calculate these metrics automatically as you change manual input drivers

  • Build a dynamic construction budget (including S-Curve functionality)

  • Model dynamic lease-up revenue and expenses that change automatically as construction timelines change

  • Build out floating rate construction loan draws, dynamic equity draws, and permanent take-out financing to accurately model any financing structure

  • Build formula "checks" to error-proof your work and feel confident your calculations are correct

This 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 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 development deal 

  • You're an existing real estate professional looking to advance your career, increase your compensation, and break into the real estate development field

  • You've bought rental homes or duplexes, 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

Here's what some of our students have had to say:

★★★★★ "I have taken other RE Development courses and they were over-complicated and hard to follow, this course was just the opposite. As with all his other courses, Justin delivers a clear and easy to follow lesson, making him easily the best Real Estate modeling instructor on the internet. I honestly bought this course within 3 minutes of its release, and it was worth every penny.” 

★★★★★ "I've been in CRE valuation, investment sales brokerage, and realty capital for over 30 years, and I've never taken a class with this much detailed content. Justin not only crushes this course, but more importantly pulls back the curtain on how institutional investors view and model their deals. You'd have to work at an institutional PE or CRE firm for years to learn what he is offering here. It's not an easy walk but if one can master this content, you can size and model anything in the CRE universe. Congrats, Justin - job well done!"

★★★★★ "Another flagship course by Justin! First, it's all about the thoroughness of the course design (takes me step-by-step). Second, and more importantly, Justin keeps the communications going with his students. I am experiencing this myself and you could verify this by how many I post in the Q&A section, and how many got answered. I don't get this treatment often."

★★★★★ "Something that I've been looking for for a long time! I feel like I understand how to approach almost any RE modeling going forward."

★★★★★ "I've taken several real estate financial modeling courses to improve my skill level for my job. This is by far the best I have taken. Everything is taught step by step with clear instruction and explanations of formulas."

★★★★★ "Another great course taught by Justin, this was filled with many in depth excel modeling techniques to implement when forming a development model. Trying to break into CRE finance/ development can be tough and these skills can really give you an upper hand on the competition. Thanks!!"

If you have a basic understanding of real estate finance, and you're looking to apply that knowledge to analyze new real estate development opportunities, enroll now and let's get started building this model together today. Looking forward to having you in the course!

Who this course is for:

  • Real estate investors and professionals who want to learn how to create dynamic, institutional-quality real estate development models from scratch
  • Aspiring real estate investment professionals who want to begin a lucrative career in real estate development
  • Single-family home and duplex investors who want to become real estate developers and have the skill set to confidently analyze return projections on ground-up development deals

Course content

11 sections • 100 lectures

Welcome! Preview 01:13

What We Will Cover - Part 1 Preview 02:52

What We Will Cover - Part 2 Preview 02:43

What We Will Cover - Part 3 Preview 01:46

A Sneak Peek Into What You'll Build Preview 01:05

Setting Expectations Preview 03:12

About The Instructor & Student Success Stories Preview 04:17

Disclaimer Preview 01:23

Real Estate Development Modeling Fundamentals Preview 01:55

Real Estate Pro Forma Modeling 101 Preview 02:47

Monthly vs. Annual CF Modeling & Checks Preview 02:17

Real Estate Financial Modeling Color Coding Preview 02:27

The Development Model Set-Up Preview 03:24

Advanced Excel Settings Preview 03:51

Excel Shortcuts Cheat Sheet Preview 00:07

Building Out The Summary Tab Preview 11:07

Modeling Land Acquisition Assumptions Preview 06:02

Modeling Lease-Up Assumptions Preview 06:44

Construction Financing Assumptions Preview 08:12

Permanent Financing Assumptions - Part 1 Preview 07:08

Permanent Financing Assumptions - Part 2 Preview 06:55

Modeling Total Project Costs Preview 06:27

Modeling Sale Details Preview 05:58

Building Out The Circuit Breaker Preview 04:03

Modeling Sources & Uses Preview 08:01

Post-Construction Equity & Return Metrics Build-Out Preview 05:53

Building Out The Rent Roll Preview 08:25

Weighted Average Rents Preview 06:10

Modeling Other Income Preview 07:56

Vacancy, Bad Debt, & Rent Growth Assumptions Preview 07:40

Modeling The Lease-Up Preview 05:11

Modeling Stabilized Rents Preview 09:31

Calculating Percentage of Lease-Up Complete Preview 05:46

Net Rental Revenue Preview 03:17

Modeling Stabilized Other Income Preview 07:40

Modeling Actual Other Income Preview 03:37

Building Out The Expenses Tab Preview 07:18

Stabilized, Fixed, & Variable Expenses Preview 04:38

PM Fees & Reserves Preview 04:11

Building Out The Property Tax Information Table Preview 04:14

Annual Property Tax Growth Modeling Preview 10:30

Modeling Stabilized Operating Expenses Preview 11:36

Modeling Actual Operating Expenses Preview 08:34

Building Out The Construction Budget Tab Preview 04:41

Building Out The Hard Costs Table Preview 06:12

Total Costs & Timing Preview 05:52

Building Out The Construction Timeline Preview 05:20

S-Curve Construction Cost Modeling Preview 16:21

Construction Funding Checks Preview 07:41

Modeling Soft Costs - Part 1 Preview 04:38

Modeling Soft Costs - Part 2 Preview 07:23

Modeling Soft Costs - Part 3 Preview 07:33

Building In The Contingency Preview 08:15

Building Out The Monthly CF Tab Preview 07:52

Modeling Revenue Preview 07:38

Dynamic Physical Vacancy Modeling Preview 07:14

Bad Debt, Concessions, & Other Loss Preview 06:01

Modeling Other Income Preview 04:36

Modeling Operating Expenses Preview 05:47

Property Taxes & PM Fees Preview 05:54

Capital Reserves & NOI Preview 06:14

Capital Expenses & Cash Flow Before Debt Service Preview 08:54

Modeling Acquisition & Sale Information Preview 09:33

Loan Information Section Build-Out Preview 04:39

Cash Flow Line Item Totals & Formatting Clean-Up Preview 06:06

Property Taxes Finalization Preview 09:46

Building Out The Financing Tab Preview 05:25

Modeling Operating Metrics Preview 07:33

Total Land & Construction Costs Preview 06:33

Modeling Equity Financing Preview 05:51

Modeling Equity Draws Preview 08:24

Construction Financing Table Build-Out Preview 04:11

Modeling Construction Loan Draws Preview 05:31

Up-Front Financing Costs Preview 04:07

Interest Rate Projections (Forward Curves) Preview 05:37

Modeling Floating Interest Rates Preview 09:30

Modeling Interest Expense & Capitalized Interest Preview 05:23

Construction Loan Payoff & Ending Balance Preview 08:37

Building Out The Permanent Financing Table Preview 05:10

Timing The Permanent Loan Funding Preview 05:56

Modeling The Total Loan Payment Preview 07:38

Modeling Principal & Interest Payments Preview 04:39

Permanent Loan Payoff & Ending Balance Preview 07:49

Equity & Debt Funding Checks Preview 06:15

Finalizing The Sources & Uses Table Preview 07:29

Monthly CF Tab Financing Finalization - Part 1 Preview 03:55

Monthly CF Tab Financing Finalization - Part 2 Preview 08:23

Building Out The Annual CF Tab Preview 05:31

Modeling Annual Cash Flows Preview 08:46

Building Out The Cash-on-Cash Return Preview 08:03

Dynamic Refinance Loan Sizing Preview 06:55

Modeling DSCR & Debt Yield Preview 05:51

Modeling Stabilized Return on Cost Preview 04:05

Finalizing Sale Details & Additional Equity Required Preview 05:05

Modeling The IRR & Equity Multiple Preview 06:07

Modeling The Average Stabilized Cash-on-Cash Return Preview 04:45

Building Out The Checks Tab Preview 10:55

How To Use What You've Built Preview 07:14

Bonus Lecture - The Next Step Preview 00:34