The Real Estate Financial Modeling Bootcamp

Justin Kivel

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
121 Videos (7h)
    • Introduction

      2:05
    • What We Will Cover

      7:53
    • How To Take This Course

      3:17
    • About The Instructor

      1:58
    • Revenue

      2:02
    • GPR

      2:01
    • General Vacancy Factor

      2:38
    • Credit Loss Factor

      2:42
    • Free Rent

      1:26
    • Other Income

      1:50
    • Expenses

      1:33
    • NOI + The Financial Statement (So Far)

      3:30
    • Below The Line Expenses

      1:50
    • Tenant Improvement Allowance

      1:35
    • Leasing Commissions

      2:50
    • Capital Reserves

      2:18
    • Cash Flow Before Debt Service

      1:48
    • Debt Service

      1:35
    • Before Tax + After Tax CF

      2:41
    • The Property Cash Flow Statement (Complete)

      1:32
    • Real Estate Investment Analysis Metrics

      2:29
    • DCF Analysis

      6:03
    • Internal Rate of Return (IRR)

      4:59
    • Capitalization (Cap) Rate

      3:42
    • Cash on Cash Return

      3:11
    • Equity Multiple

      4:16
    • Debt Analysis Overview + Loan Sizing Explained

      1:46
    • LTV

      1:59
    • LTC

      1:47
    • Debt Service Coverage Ratio (DSCR)

      2:28
    • Debt Yield

      2:31
    • Loan Constant

      2:55
    • Expense + Breakeven Ratio

      2:19
    • Excel Financial Modeling Best Practices

      0:42
    • Cell Color Coding

      3:15
    • The Steak Sauce Cell

      1:19
    • Gridlines

      1:12
    • Time Value of Money Functions

      1:26
    • PV Exercise

      7:08
    • FV Exercise

      2:58
    • NPER Exercise

      2:57
    • Rate Exercise

      3:33
    • PMT Exercise

      5:33
    • Loan Functions

      1:19
    • IPMT

      5:18
    • PPMT

      2:22
    • CUMIPMT

      4:13
    • CUMPRINC

      4:08
    • Return Metric Functions Part II

      1:18
    • NPV + IRR Dynamic Modeling

      6:18
    • XIRR + XNPV Dynamic Modeling

      8:32
    • Data Manipulation + Scenario Analysis

      1:42
    • Lookup Functions

      1:26
    • VLOOKUP Example

      3:53
    • HLOOKUP Example

      2:34
    • INDEX Example

      1:00
    • INDEX(MATCH)

      3:16
    • Excel Hotkeys + Shortcuts Intro + Columns and Rows

      5:11
    • Function Shortcuts

      3:08
    • Navigating Throughout The Sheet and Workbook

      4:59
    • Special Pasting

      8:27
    • 60 IF Statements

      1:30
    • 61 IF Statements Excel Example

      4:14
    • 62 SUMIF

      2:42
    • 63 SUMIFS Excel Example

      4:13
    • 64 COUNTIF Excel Example

      2:47
    • 65 COUNTIFS Excel Example

      4:20
    • 66 AVERAGEIF Excel Example

      2:13
    • 67 AVERAGEIFS Excel Example

      3:13
    • 68 AND Excel Example

      3:34
    • 69 OR Excel Example

      3:32
    • 70 Other Helpful Formula

      1:26
    • 71 SUMPRODUCT Excel Example

      2:20
    • 72 CAGR Excel Example

      3:37
    • 73 ROUND

      3:12
    • 74 ROUNDUP + ROUNDDOWN

      3:50
    • 75 DATEDIF

      3:59
    • 76 Goal Seek

      5:01
    • 77 1 Variable Data Table

      3:59
    • 78 2 Variable Data Table

      5:37
    • 79 Conditional Formatting

      3:30
    • 80 Toggle

      4:52
    • 81 Scenario Analysis

      5:38
    • 82 Debt Modeling Part II

      1:30
    • 83 Loan Sizing

      3:11
    • 84 Loan Sizing by LTV + LTC

      4:29
    • 85 Loan Sizing by DSCR

      4:10
    • 86 Loan Sizing by Debt Yield

      2:55
    • 87 Building a Loan Amortization Table Part I

      2:24
    • 88 Building a Loan Amortization Part II

      8:42
    • 89 How to Model Commercial Leases

      1:56
    • 90 Pro Rata Share Modeling

      2:56
    • 91 NNN Lease Modeling

      2:36
    • 92 FSG Leases

      1:59
    • 93 Base Year Stop

      3:33
    • 94 Percentage Rent

      5:10
    • 95 Leasing Commissions

      6:29
    • 96 Tenant Improvement Allowance

      3:18
    • 97 Modeling Renewal Probability (ADVANCED)

      9:53
    • 98 Excel Modeling Walkthrough

      1:05
    • 98 Modeling Net Operating Income

      8:03
    • 99 NOI Modeling Walkthrough

      6:47
    • 100 Modeling CF Before Debt Service

      3:27
    • 101 Modeling Interest Expense

      5:29
    • 102 Modeling Amortization

      3:38
    • 103 Modeling Acquisition Metrics

      1:52
    • 104 Modeling Disposition Metrics

      4:30
    • 105 Modeling Return Metrics

      4:49
    • 106 Manipulating Manual Inputs

      3:50
    • 106 The Set Up

      1:06
    • 107 How To Take Exam Get Started

      2:19
    • 108 Building Out The Investment Timeline

      2:50
    • 109 Revenue + Vacancy Modeling

      5:47
    • 110 Modeling Expenses

      2:27
    • 111 Modeling NOI

      1:30
    • 112 Modeling Debt Service

      4:46
    • 113 Modeling Purchase + Sale Proceeds

      7:01
    • 114 Formatting Clean Up

      2:18
    • 115 Investment Metric Solutions

      5:50
    • 116 Loan Metric Solutions

      4:22
    • 117 Putting It All Together

      3:51

About This Class

Learn how to build a real estate financial model like the pros. Built by an instructor with over seven years of real estate private equity finance experience modeling complex 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 deal 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 2017 median total compensation for an acquisitions associate in retail, office/industrial, and multifamily was $127K, $133K, and $111K, 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 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 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 investment returns is essential to buying profitable deals and garnering the confidence of your investors. Whether you are modeling a deal 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 transactions accurately, quickly, and efficiently.

If you're looking to learn to model commercial real estate transactions 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!

Credit to Bensound for the Intro Music!

22

Students

--

Projects

0

Reviews (0)

Business Finance Financial Modeling