image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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 more
Create a
dynamic sources and uses table
, so you'll know exactly how much you'll need to fund a development project
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 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 field
You'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 deals
Here'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!
Who this course is for:
Real estate investors and professionals who want to learn how to create dynamic, institutional-quality commercial real estate development pro forma models from scratch for office, industrial, and retail properties
Current real estate professionals who want to become an expert in real estate financial modeling to advance their career and make more money
Aspiring commercial real estate development professionals who want to begin a career in commercial real estate development

What you'll learn

Learn how to build dynamic, institutional-grade commercial real estate development pro forma models from scratch for office, industrial, and retail properties

Learn how to create institutional, professionally formatted commercial real estate development pro forma models to present to investors and partners

Learn how to model commercial lease structures and reimbursements all in Excel (without expensive software)

Learn how to build a "Circuit Breaker" to "reset" errors in your model quickly and easily

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
4
1.1-Welcome & What We Will Cover
1.2-Who This Course Is For
1.3-About The Instructor & Student Success
1.4-Disclaimer
2-Real Estate Development Modeling Fundamentals
2
2.1-Real Estate Development Modeling Fundamentals
2.2-Setting Expectations
3-Building Out The Summary Dashboard
13
3.1-Setting Up The Model
3.2-Property Details
3.3-Land Acquisition Information
3.4-Sale Information & Distribution Frequency
3.5-Project-Level Fees & Lease-Up Information
3.6-Summary Details
3.7-Development Capital Budget
3.8-Construction Financing Details
3.9-Permanent Financing Details
3.10-Sale Details
3.11-Levered & Unlevered Return Metrics
3.12-Sources & Uses
3.13-Additional Equity Required & The Circuit Breaker
4-Part 2 - CRE Lease Modeling
26
4.1-CRE Leases Tab Setup
4.2-Operating Expense Reimbursement Structures
4.3-Rent Escalation Schedules
4.4-Re-Leasing Assumptions
4.5-Re-Leasing Costs
4.6-Percentage Rent
4.7-Building The Tenant Cash Flow Timeline
4.8-Dynamic Re-Leasing Month & Tenant Name
4.9-Tenant Identifiers & Lease-Up Base Rent
4.10-Lease-Up Reimbursements - Part 1
4.11-Lease-Up Reimbursements - Part 2
4.12-Total Percentage Rent
4.13-Up-Front Free Rent
4.14-Re-Leasing Base Rent
4.15-Re-Leasing Free Rent
4.16-Re-Leasing Reimbursements
4.17-Up-Front Tenant Improvements
4.18-Up-Front Leasing Commissions
4.19-Re-Leasing Tenant Improvements
4.20-Re-Leasing Leasing Commissions
4.21-CF Codes & Totals
4.22-Creating Additional Suites
4.23-Occupancy Calculations - Part 1
4.24-Occupancy Calculations - Part 2
4.25-Finalizing The Pro Rata Share & Health Ratios
4.26-Finalizing The CRE Leases Tab
5-Part 3 - Expense Modeling
7
5.1-Expenses Tab Setup
5.2-Expense Assumptions & Fixed vs. Variable
5.3-Other Assumptions & Property Tax Information
5.4-Credit Loss & Property Assessment Growth Rates
5.5-Hold Period Property Taxes
5.6-Stabilized Operating Expenses
5.7-Actual Operating Expenses
6-Part 4 - Construction Budget Modeling
6
6.1-Construction Budget Tab Setup
6.2-Hard Costs Build-Out
6.3-S-Curve & Straight-Line Cost Modeling
6.4-Checks & Subtotals
6.5-Soft Costs Build-Out
6.6-Contingency Modeling
7-Part 5 - Monthly & Annual Cash Flow Modeling
14
7.1-Monthly CF Tab Setup
7.2-Net Rental Income
7.3-Other Income & EGR
7.4-Property Taxes
7.5-Operating Expenses & NOI
7.6-Construction Costs, TIs, & LCs
7.7-Capital Reserves, AM Fee, & CM Fee
7.8-Debt Service, CF After DS, & Acquisition & Sale Information
7.9-Loan Information & Total Levered CF
7.10-Investor-Level CF - Part 1
7.11-Investor-Level CF - Part 2
7.12-Modeling Monthly CF Totals
7.13-Annual CF Tab Build-Out - Part 1
7.14-Annual CF Tab Build-Out - Part 2
8-Part 6 - Debt Modeling
15
8.1-Financing Tab Setup
8.2-Modeling Operating Metrics
8.3-Total Land, Construction, & Financing Costs
8.4-Operating Shortfalls & Positive Operating CF
8.5-Equity Financing
8.6-Mezzanine Construction Financing - Part 1
8.7-Sources & Uses Build-Out
8.8-Modeling Forward Rate Curves
8.9-Mezzanine Construction Financing - Part 2
8.10-Senior Construction Financing
8.11-Permanent Financing - Part 1
8.12-Permanent Financing - Part 2
8.13-Permanent Financing - Part 3
8.14-Permanent Financing - Part 4
8.15-Percentage of Funding Checks
9-Part 7 - Model Finalization
18
9.1-Finalizing The Monthly CF Tab
9.2-Finalizing The Expenses Tab
9.3-Consolidated Rent Roll Build-Out - Part 1
9.4-Consolidated Rent Roll Build-Out - Part 2
9.5-Consolidated Rent Roll Build-Out - Part 3
9.6-Stabilized Yield on Cost & DSCR
9.7-Stabilized Debt Yield & LTV
9.8-Unlevered & Levered IRR, Equity Multiple, & Profit
9.9-Unlevered Cash-on-Cash Return
9.10-Levered Cash-on-Cash Return - Part 1
9.11-Levered Cash-on-Cash Return - Part 2
9.12-2-Metric Data Table Build-Out - Part 1
9.13-2-Metric Data Table Build-Out - Part 2
9.14-Dynamic Charts Build-Out - Part 1
9.15-Dynamic Charts Build-Out - Part 2
9.16-Dynamic Charts Build-Out - Part 3
9.17-Building Out Checks
9.18-How To Use What You've Built
10-Wrapping Up
1
10.1-Where To Go From Here
11-Bonus Lecture
1
11.1-Bonus Lecture - The Next Step