The Real Estate Financial Modeling Bootcamp
4.6 (2,777 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,355 students enrolled

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
4.6 (2,777 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,355 students enrolled
Created by Justin Kivel
Last updated 5/2020
English
English [Auto-generated], Indonesian [Auto-generated], 4 more
  • Italian [Auto-generated]
  • Polish [Auto-generated]
  • Romanian [Auto-generated]
  • Thai [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 5 articles
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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 the most essential investment metrics evaluated by large institutions and private equity groups.
  • 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 complex commercial real estate transactions.
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 2018 median total compensation for an acquisitions associate in retail, office/industrial, and multifamily was $130K, $137K, and $115K, 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 backgound 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
Expand all 122 lectures 07:08:57
+ Introduction
6 lectures 10:13

This lecture will talk about what we're going to cover in this course. Real estate financial modeling is a major key to becoming a better, more savvy real estate investor and taking your real estate investing ability to the next level. This lesson will go over what we're going to cover to take you there.

Preview 02:19

Real estate financial modeling is a hands-on skill to learn - this lesson will go over how you can get the most out of this course.

Preview 01:22
Master Excel File - DOWNLOAD FIRST
00:14
Disclaimer
01:18
+ Real Estate Financial Modeling Best Practices
3 lectures 07:47
Excel Financial Modeling Best Practices + A Quick Primer
04:30
Saving in A1 (The Steak Sauce Cell)
01:17
Gridlines
02:00
+ Property Cash Flow Statement Modeling
15 lectures 28:21
Revenue
01:51
GPR, General Vacancy, & Credit Loss
01:30
GPR, General Vacancy, & Credit Loss Excel Exercise
02:34
Free Rent
00:58
Percentage Rent, Storage Income, & Other Income
00:36
Expenses
01:27
NOI & The Property Cash Flow Statement (So Far)
03:06
Below-The-Line Expenses
02:38
Tenant Improvement Allowances
01:57
Leasing Commissions
01:03
Capital Reserves
01:20
TIs, LCs, & Capital Reserves Excel Exercise
02:56
CF Before Debt Service + The Property Cash Flow Statement (So Far)
01:35
Debt Service, Before Tax & After Tax Cash Flow
03:06
The Property Cash Flow Statement (Complete!)
01:44
+ Modeling Key Real Estate Investment Metrics
7 lectures 21:44
Real Estate Investment Analysis Metrics
02:51
DCF Analysis
01:52
DCF Excel Exercise
02:49
Internal Rate of Return (IRR) & Excel Exercise
03:35
Capitalization (Cap) Rate
03:51
Cash-on-Cash Return
03:36
Equity Multiple & Excel Exercise
03:10
+ Real Estate Debt Modeling
6 lectures 21:54
Loan-to-Value (LTV)
03:11
Loan-to-Cost (LTC)
02:34
Debt Service Coverage Ratio (DSCR)
02:27
Debt Yield
01:59
Expense Ratio + Breakeven Ratio
04:06
+ Excel Hotkeys + Shortcuts for Real Estate Financial Modeling
11 lectures 39:39
A Quick Note For Mac Users
00:46
Controlling Columns & Rows
04:58
Function Shortcuts
02:49
The "ALT + E" SUM Shortcut
01:18
Navigating Throughout The Sheet & Workbook
04:13
Text Formatting
04:05
Text & Font Styles
02:41
All About Borders
02:32
Alignment
06:15
Format Finalization
09:54
Excel For Mac Hotkeys & Shortcuts
00:08
+ Essential Real Estate Financial Analysis Excel Functions
12 lectures 34:06
Key Real Estate Financial Analysis Excel Functions
01:12
Present Value (PV) Exercise
04:17
Future Value (FV) Exercise
02:21
Number of Periods (NPER) Exercise
01:54
Rate (RATE) Exercise
02:01
Payment (PMT) Exercise
02:41
Loan Functions & IPMT
06:44
PPMT Excel Example
01:32
Cumulative Interest Payment (CUMIPMT) Excel Example
01:40
NPV + IRR Dynamic Modeling
03:43
XNPV + XIRR Dynamic Modeling
03:23
+ Data Manipulation + Scenario Analysis
15 lectures 50:13
VLOOKUP Excel Example
03:32
HLOOKUP Excel Example
01:22
INDEX Example
01:19
INDEX(MATCH) Example
01:56
IF Statement Functions
03:55
SUMIF Excel Example
02:10
SUMIFS Excel Example
02:54
COUNTIF & COUNTIFS
03:48
AVERAGEIF & AVERAGEIFS
04:06
AND Statements
04:51
OR Statements
02:49
SUMPRODUCT Excel Example
04:33
CAGR Excel Example
03:50
ROUND Excel Example
04:29
DATEDIF Excel Example
04:39
+ Data Analysis Tools for Real Estate Financial Modeling
6 lectures 27:47
Goal Seek
03:29
1-Variable Data Table
07:51
2-Variable Data Table
03:22
Conditional Formatting
04:59
Toggle Triggers
02:55
Scenario Analysis
05:11
+ Advanced Debt Modeling
8 lectures 33:48
Loan Sizing
01:40
LTV Sizing
03:27
LTC Sizing
02:31
Loan Sizing by DSCR
05:05
Loan Sizing by Debt Yield
01:30
Loan Sizing With Multiple Constraints (MIN)
05:05
Building a Loan Amortization Table - Part I
06:04
Building a Loan Amortization Table - Part II
08:26