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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

1 of 1 students recommend this class