The Real Estate Financial Modeling Bootcamp

The Complete A to Z Guide to Modeling Real Estate Transactions in Microsoft Excel For Smarter Real Estate Investing

Last updated 2022-01-10 | 4.8

- The ability to build a functional
- dynamic real estate financial model from scratch.
- The skill set to model real estate transactions for multiple different asset types and solve for key investment metrics evaluated by real estate firms.
- A substantial increase in speed and efficiency in Microsoft Excel by learning powerful tools and functions.

What you'll learn

The ability to build a functional
dynamic real estate financial model from scratch.
The skill set to model real estate transactions for multiple different asset types and solve for key investment metrics evaluated by real estate firms.
A substantial increase in speed and efficiency in Microsoft Excel by learning powerful tools and functions.
A mastery of the foundational analytical and financial modeling tools necessary to break into the real estate private equity industry and model deals.

* Requirements

* Access to Microsoft Excel software for Mac or PC.
* A basic working knowledge of Microsoft Excel is recommended.

Description

Learn real estate financial modeling. Advance your career. Make more money. Built by an instructor with over eight years of real estate private equity finance experience modeling over $1.5 billion of closed commercial real estate transactions, this course was designed to take you from complete beginner with no knowledge of real estate financial modeling to a real estate financial modeling pro. The skills and concepts you will learn in this course can be used to help you break into the real estate private equity industry, increase your compensation at your existing real estate job, or confidently analyze and model a commercial real estate investment on your own.

This course was created to help our students:

  • Begin a lucrative career in the commercial real estate private equity industry - According to CEL & Associates, Inc., the 2020 median total compensation for an acquisitions associate in retail, office/industrial, and multifamily was $137K, $143K, and $121K, respectively. This course will teach you the core fundamental Excel financial modeling skills necessary to land one of these jobs and succeed in your first commercial real estate investing role.

  • Increase overall compensation and career opportunities in their current real estate role - Real estate agents, property managers, construction managers, and architects all have extremely valuable skills that are highly desirable in the commercial real estate finance industry. Whether you want to earn more money in your current role or make a transition into commercial real estate acquisitions, this course will give you the foundational knowledge to take your real estate investing career to the next level.

  • Confidently model large real estate transactions - For property acquisitions larger than single-family homes, having the ability to confidently create a financial model projecting real estate investment returns is essential to buying profitable deals and garnering the confidence of your investors. Whether you are modeling a real estate investment you are looking to buy with your own money or leading a real estate syndication, strong financial modeling skills are an essential component of the real estate investment process.

This course will teach you the key fundamentals necessary in order for you to be able to model real estate investment transactions accurately, quickly, and efficiently.

Here's what some of our students have said about the course:

★★★★★ "Excellent course that teaches you financial modeling in Excel for CRE. I purchased the course after starting a new job as valuation analyst for a RE asset manager and it has helped me immensely. I have a background in PE funds and my excel skills are fairly advanced so for me the added value was understanding the specificities of CRE. I now look forward to completing the advanced RE modelling course. This instructor is great: no fluff, clear explanations, top notch material and step-by-step directions. Justin is also very responsive with answering your queries. I highly recommend the course!"

★★★★★ "This course is great. I learned everything I needed to build a model for an interview for a Financial Analyst role at a Real Estate Private Equity Fund. And I got the job. I have since gotten other courses by Justin, as they are what I need to get me up to speed at my new job. Also, Justin is great at answering questions when I get stuck and pointing me in the right direction."

★★★★★ "Excellent Course! Thank you for all your hard work in transforming a complex concept into an easy to understand format. This course has multiplied my understanding of financial modeling and the use of Excel. I learned more through this platform than the traditional institutional setting. A great resource and educator."

★★★★★ "Overall, this course was such an awesome experience! As a CRE investor as well, I took this course with the goal of it helping to rebuild my financial model and, what can I say, mission accomplished! From the structure, to the pace, the exercises, Justin's CRE knowledge and Excel tips/tricks - it was exactly what I was looking for and more!"

★★★★★ "Cannot believe the value in this course!! Best deal in real estate education. Thank you Justin, can't wait to take the next course. I could not recommend it more."

★★★★★ "This is a top notch course. The self-pace is perfect for me and it helped refresh all of the concepts that I learned in my grad school real estate courses. Just follow along and practice the examples and you'll extract tremendous value from a modeling perspective!!"

★★★★★ "Justin is awesome! His teaching style makes learning very intuitive. I would recommend this class for anyone that is trying to break into CRE or expand their current foundation of CRE. I was recommended by a friend who spent $600 on a course but found this one to be more helpful and easier to follow/understand."

★★★★★ "Superb course that teaches you the fundamentals of CRE modelling you need to know. Justin is a really good lecturer and he is very responsive with answering your queries, not just about the course material but even things related to your career in CRE. I would recommend the course to anyone looking to understand the fundamentals of CRE modelling."

★★★★★ "Wow! This course and Justin's other courses are the equivalent of an MBA level curriculum. If you are willing to put in the time and effort you will benefit."

If you're looking to learn to model commercial real estate investments to jump-start your career, make more money in your current job, or do your own big deals, you're in the right place.

Join us!

Who this course is for:

  • College students or career switchers who want to begin a career in private equity real estate finance.
  • Current real estate professionals who want to boost their compensation by adding valuable financial modeling skills to their existing skill set.
  • Current real estate investors who want to feel confident moving from purchasing 1-4 unit rental properties to larger properties involving more complex financial metrics and data.

Course content

13 sections • 113 lectures

Welcome & What We Will Cover Preview 04:46

Who This Course Is For Preview 02:05

About The Instructor & Student Success Stories Preview 05:18

Download Me First! Preview 00:15

Disclaimer Preview 01:23

The Property Cash Flow Statement Overview Preview 02:51

Effective Gross Revenue - Part 1 Preview 02:34

Effective Gross Revenue - Part 2 Preview 02:48

Operating Expenses Preview 02:37

Net Operating Income (NOI) Preview 01:24

Capital Expenses Preview 04:09

Debt Service Preview 02:57

Purchase, Sale, & Financing Metrics Preview 02:53

Unlevered & Levered Cash Flow Preview 04:12

A Note About Income Taxes Preview 01:32

Setting Expectations Preview 03:12

Real Estate Financial Modeling 101 & Dynamic Modeling Preview 02:20

Absolute & Mixed References Preview 08:02

Custom Formatting Preview 04:12

Drop-Down Lists Preview 04:28

Real Estate Financial Modeling Color Codes Preview 02:52

Gridlines & The "Steak Sauce" Cell Preview 02:06

Navigating Worksheets & Workbooks Preview 05:12

Controlling Columns & Rows Preview 05:58

Text Formatting Preview 05:26

Font Style Preview 04:57

Borders Preview 04:11

Alignment Preview 06:01

Excel Function Shortcuts Preview 04:10

Copy, Paste, & Paste Special Preview 06:12

IF Statements Preview 04:15

AND & OR Preview 05:23

SUMIF & SUMIFS Preview 06:27

COUNTIF & COUNTIFS Preview 05:25

AVERAGEIF & AVERAGEIFS Preview 04:14

VLOOKUP & HLOOKUP Preview 07:39

INDEX & MATCH Preview 06:32

Weighted Averages (Using SUMPRODUCT) Preview 06:23

CAGR (Using RATE) Preview 04:45

ROUND, ROUNDUP, & ROUNDDOWN Preview 06:05

DATEDIF Preview 04:51

YEARFRAC & EOMONTH Preview 04:20

PV Preview 05:03

FV Preview 03:04

NPER Preview 02:45

RATE Preview 03:31

PMT Preview 05:41

GPR, Vacancy, & Credit Loss Preview 06:19

Percentage Rent Preview 05:01

The Pro Rata Share Preview 03:46

NNN Reimbursements Preview 02:44

FSG Reimbursements Preview 01:51

MG Reimbursements Preview 03:11

BYS Reimbursements Preview 04:41

The Operating Expense Ratio Preview 05:33

Renewal Probability Modeling Preview 06:23

Cash Flow Modeling With Renewal Probability Preview 06:50

Leasing Commissions Preview 05:38

Tenant Improvement (TI) Allowances Preview 02:20

Loan Terms & Amortization vs. Term Preview 03:54

Loan Functions & PMT Preview 05:12

IPMT & PPMT Preview 04:17

CUMIPMT & CUMPRINC Preview 05:42

Building a Loan Amortization Schedule Preview 15:20

Loan-To-Value (LTV) Preview 02:19

Loan-To-Cost (LTC) Preview 02:07

Debt Service Coverage Ratio (DSCR) Preview 01:50

Debt Yield Preview 02:10

The Loan Constant Preview 03:05

Loan Sizing (LTV & LTC) Preview 03:25

Loan Sizing (DSCR & Debt Yield) Preview 04:21

Dynamic Loan Sizing Build-Out Preview 04:32

Key Real Estate Investment Analysis Metrics Preview 01:56

Capitalization (Cap) Rates Preview 08:40

Net Present Value (NPV) Preview 08:29

Internal Rate of Return (IRR) Preview 06:34

Equity Multiple Preview 06:09

Cash-on-Cash Return Preview 08:05

Positive vs. Negative Leverage Preview 05:02

XNPV vs. XIRR Preview 06:57

Real Estate Pro Forma Modeling Overview Preview 02:41

Monthly Cash Flow Modeling Preview 11:07

Monthly Growth & Toggle Triggers Preview 04:23

Modeling NOI Preview 09:24

Modeling Capital Expenses Preview 05:37

Modeling Principal & Interest Payments Preview 05:47

Modeling Purchase & Sale Metrics Preview 09:06

Modeling Loan Proceeds & Loan Payoffs Preview 06:23

Modeling Return Metrics Preview 05:34

1-Variable Data Tables Preview 06:54

2-Variable Data Tables Preview 02:50

Conditional Formatting Preview 04:00

Goal Seek Preview 04:07

Scenario Analysis Preview 07:56

PERE Exam Introduction Preview 03:00

PERE Exam Instructions Preview 03:31

Building The Pro Forma Timeline Preview 11:35

Modeling GPR Preview 05:15

Modeling Vacancy & Net Rental Revenue Preview 03:22

Modeling Other Income & EGR Preview 04:02

Modeling Operating Expenses & NOI Preview 03:05

Modeling Capital Improvements, Reserves, & Cash Flow Before Debt Service Preview 10:52

Modeling Principal & Interest Payments Preview 07:04

Modeling Purchase & Sale Metrics Preview 10:09

Modeling Loan Proceeds & Loan Payoff Preview 11:26

Going-In Cap Rate & Loan Constant Preview 02:42

Unlevered & Levered IRR Preview 02:23

Unlevered & Levered Cash-on-Cash Preview 15:55

Unlevered & Levered Equity Multiple Preview 04:08

DSCR, Debt Yield, Exit LTV, & Expense Ratio Preview 05:01

Running The Sensitivity Analysis Preview 07:38

Bonus Lecture - The Next Step Preview 00:34