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