The Real Estate Financial Modeling Bootcamp

Justin Kivel

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
118 Lessons (7h 13m)
    • 1. The Real Estate Financial Modeling Bootcamp

      1:54
    • 2. What We Will Cover - Part 1

      2:19
    • 3. What We Will Cover - Part 2

      3:15
    • 4. What We Will Cover - Part 3

      3:21
    • 5. How To Take This Course

      1:22
    • 6. About The Instructor

      1:45
    • 7. Real Estate Financial Modeling Best Practices - Color Coding

      4:30
    • 8. Steak Sauce Cell

      1:17
    • 9. Turning Off Gridlines

      2:00
    • 10. Revenue

      1:51
    • 11. GPR, General Vacancy, and Credit Loss

      1:30
    • 12. GPR, Vacancy, & Credit Loss Excel Exercise

      2:33
    • 13. The Free Rent Period

      0:58
    • 14. Percentage Rent, Storage Income, and Other Income

      0:36
    • 15. Expenses

      1:27
    • 16. Net Operating Income and The Cash Flow Statement (So Far)

      3:06
    • 17. Below The Line Expenses

      2:38
    • 18. Tenant Improvement Allowances

      1:57
    • 19. Leasing Commissions

      1:03
    • 20. Capital Reserves

      1:20
    • 21. TIs, LCs, and Capital Reserves Excel Exercise

      2:56
    • 22. Cash Flow Before Debt Service and The Cash Flow Statement

      1:35
    • 23. Debt Service, Before Tax, and After Tax Cash Flow

      3:06
    • 24. The Cash Flow Statement (Complete)

      1:44
    • 25. Investment Analysis Metrics

      2:51
    • 26. The Discounted Cash Flow (DCF) Analysis

      1:52
    • 27. DCF Excel Exercise & Solution

      2:49
    • 28. Internal Rate of Return (IRR) Excel Exercise & Solution

      3:35
    • 29. Cap Rate Exercise & Solution

      3:51
    • 30. Cash-on-Cash Return and Excel Exercise

      3:36
    • 31. Equity Multiple and Excel Exercise

      3:10
    • 32. LTV and Excel Exercise

      3:11
    • 33. LTC and Excel Exercise

      2:34
    • 34. DSCR and Excel Exercise

      2:27
    • 35. Debt Yield and Excel Exercise

      1:59
    • 36. Loan Constant and Positive and Negative Leverage

      7:37
    • 37. Expense Ratio and Breakeven Ratio

      4:06
    • 38. Excel Hotkeys - Controlling Columns and Rows

      4:58
    • 39. Function Shortcuts

      2:49
    • 40. The ALT+E SUM Shortcut

      1:18
    • 41. Navigating Throughout The Sheet and Workbook

      4:13
    • 42. Text Formatting

      4:05
    • 43. Text and Font Styles

      2:41
    • 44. All About Borders

      2:32
    • 45. Alignment

      6:15
    • 46. Format Finalization

      9:54
    • 47. Key RE Analysis Excel Functions

      1:12
    • 48. PV Calculations

      4:17
    • 49. FV Calculations

      2:21
    • 50. NPER Calculations

      1:54
    • 51. RATE Calculations

      2:01
    • 52. PMT Calculations

      2:41
    • 53. Loan Functions and IPMT

      6:44
    • 54. PPMT Function

      1:32
    • 55. CUMIPMT

      1:40
    • 56. CUMPRINC

      2:38
    • 57. NPV and IRR

      4:37
    • 58. XNPV and XIRR

      3:20
    • 59. Data Manipulation - VLOOKUP

      3:32
    • 60. HLOOKUP

      1:22
    • 61. INDEX

      1:19
    • 62. MATCH

      1:56
    • 63. IF Statements

      3:55
    • 64. SUMIF

      2:10
    • 65. SUMIFS

      2:54
    • 66. COUNTIF & COUNTIFS

      3:48
    • 67. ]AVERAGEIF & AVERAGEIFS

      4:06
    • 68. AND & OR

      4:51
    • 69. SUMPRODUCT

      4:33
    • 70. CAGR

      3:50
    • 71. ROUND

      4:29
    • 72. DATEDIF

      4:39
    • 73. Goal Seek

      3:29
    • 74. One Variable Data Tables

      7:51
    • 75. Two Variable Data Tables

      3:22
    • 76. Conditional Formatting

      4:59
    • 77. Toggle Triggers

      2:55
    • 78. Scenario Analysis with VLOOKUP

      5:11
    • 79. Loan Sizing

      1:40
    • 80. LTV Sizing

      3:27
    • 81. LTC Sizing

      2:31
    • 82. DSCR Loan Sizing

      5:05
    • 83. Debt Yield Sizing

      1:30
    • 84. Loan Sizing With Multiple Constraints (MIN)

      5:05
    • 85. Loan Amortization Table Part I

      6:04
    • 86. Loan Amortization Table Part II

      8:26
    • 87. Modeling Commercial Leases - Introduction

      0:55
    • 88. Pro Rata Share and NLA vs. GLA

      3:46
    • 89. NNN Leases

      2:33
    • 90. FSG Leases

      1:33
    • 91. Base Year Stop

      2:45
    • 92. Percentage Rent

      4:08
    • 93. Leasing Commissions

      5:34
    • 94. TI Allowances

      2:17
    • 95. Modeling Renewal Probability

      13:50
    • 96. Modeling Walkthrough - NOI

      5:15
    • 97. Cash Flow Before Debt Service

      2:24
    • 98. Interest Expense, Amortization, and CF After DS

      7:33
    • 99. Purchase Price, Closing Costs, and Loan Proceeds

      1:44
    • 100. Sale Proceeds, Costs of Sale, and Loan Payoff

      3:28
    • 101. IRR, Cash on Cash, Equity Multiple Walkthrough

      3:51
    • 102. PERE Exam Intro

      6:21
    • 103. Building Out The Investment Timeline

      8:49
    • 104. Building Out The EGR

      8:23
    • 105. Modeling Expenses and NOI

      2:53
    • 106. Modeling Capital Reserves

      1:40
    • 107. Purchase Price, Sale Proceeds, and CF Before DS

      8:14
    • 108. Interest, Amortization, and CF After DS

      7:12
    • 109. Loan Proceeds, Loan Payoff, and Total Levered Cash Flows

      5:39
    • 110. Month of Sale Cash Flow Triggers

      4:05
    • 111. Model Formatting and Checks

      8:34
    • 112. Going In Cap Rate, Unlevered and Levered IRR

      3:20
    • 113. Cash-on-Cash Return Calculations Part I

      9:08
    • 114. Cash-on-Cash Returns Part II

      7:36
    • 115. Levered and Unlevered Equity Multiple

      1:43
    • 116. DSCR, Debt Yield, and Exit LTV

      4:01
    • 117. Operating Expense and Break Even Ratios

      4:44
    • 118. Where To Go From Here

      3:01
13 students are watching this class

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!