589689.xyz

[] Udemy - The Advanced Real Estate Pro Forma Modeling Master Class

  • 收录时间:2023-09-11 10:28:03
  • 文件大小:8GB
  • 下载次数:1
  • 最近下载:2023-09-11 10:28:03
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/55 - Modeling InPlace Reimbursements.mp4 147MB
  2. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/59 - Modeling ReLeasing Base Rent.mp4 117MB
  3. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/158 - Modeling DSCR Debt Yield Total Cost.mp4 112MB
  4. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/65 - Modeling ReLeasing Leasing Commissions.mp4 109MB
  5. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/182 - Operating Shortfalls IRR Partitioning Finalization.mp4 105MB
  6. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/62 - Modeling UpFront Tenant Improvements.mp4 101MB
  7. 7 - Part 4 Building Out The Monthly Cash Flows/90 - Modeling Capital Reserves.mp4 100MB
  8. 11 - Part 8 Creating The Annual Cash Flow RollUp/151 - The Annual Cash Flow AllInOne Formula.mp4 100MB
  9. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/53 - Modeling InPlace Base Rent.mp4 97MB
  10. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/156 - Property Tax Finalization Dynamic Assessed Value Modeling.mp4 95MB
  11. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/63 - Modeling UpFront Leasing Commissions.mp4 94MB
  12. 4 - Part 1 Building Out The Summary Dashboard/34 - Modeling Sale Details The Formula BuildOut.mp4 88MB
  13. 8 - Part 5 Modeling Advanced Financing Structures/121 - Modeling Mezzanine Debt Payments.mp4 88MB
  14. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/174 - Dynamic Operating Metric Cash Flow BuildOut Part 2.mp4 85MB
  15. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/155 - Modeling Asset Management Fees.mp4 84MB
  16. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/161 - Modeling Levered Return Metrics IRR Equity Multiple CashonCash Return.mp4 82MB
  17. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/144 - Creating Dynamic Working Capital Funding.mp4 81MB
  18. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/148 - Cash Flow SUM Formatting Finalization.mp4 80MB
  19. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/61 - Modeling ReLeasing Reimbursements.mp4 80MB
  20. 9 - Part 6 Creating A Dynamic Construction Budget/136 - Construction Subtotals MAX and MIN IF.mp4 80MB
  21. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/160 - Sources Uses Finalization.mp4 79MB
  22. 8 - Part 5 Modeling Advanced Financing Structures/122 - Refinance BuildOut.mp4 77MB
  23. 9 - Part 6 Creating A Dynamic Construction Budget/137 - Modeling Contingencies.mp4 76MB
  24. 7 - Part 4 Building Out The Monthly Cash Flows/85 - Modeling Revenue Free Rent.mp4 75MB
  25. 7 - Part 4 Building Out The Monthly Cash Flows/89 - Modeling TIs LCs.mp4 75MB
  26. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/143 - Modeling Loan Fees.mp4 75MB
  27. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/56 - Modeling Percentage Rent.mp4 74MB
  28. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/172 - Creating The Dynamic Operating Metrics Over Time Chart.mp4 74MB
  29. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/147 - Investor Distribution Modeling Part 3.mp4 74MB
  30. 8 - Part 5 Modeling Advanced Financing Structures/126 - Modeling The Refinance Loan Payoff Prepayment Penalty.mp4 73MB
  31. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/181 - How To Use What Youve Built.mp4 73MB
  32. 11 - Part 8 Creating The Annual Cash Flow RollUp/152 - Modeling Unlevered CashonCash Returns.mp4 73MB
  33. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/68 - Creating Additional Lease Cash Flows.mp4 72MB
  34. 7 - Part 4 Building Out The Monthly Cash Flows/83 - Introduction To The Monthly Cash Flow Tab.mp4 72MB
  35. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/64 - Modeling ReLeasing Tenant Improvements.mp4 72MB
  36. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/180 - Building Out The Model Checks Conditional Formatting.mp4 71MB
  37. 8 - Part 5 Modeling Advanced Financing Structures/128 - Total Payment Formula Update.mp4 70MB
  38. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/140 - Partnership Expense Modeling AcquisitionRefinance Loan Proceed Funding.mp4 70MB
  39. 8 - Part 5 Modeling Advanced Financing Structures/113 - Building In The Floating Interest Rate Index.mp4 69MB
  40. 7 - Part 4 Building Out The Monthly Cash Flows/88 - Modeling Operating Expenses.mp4 69MB
  41. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/66 - Total Suite Cash Flow Finalization.mp4 69MB
  42. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/167 - Partitioning The IRR Part 1.mp4 69MB
  43. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/48 - ReLeasing Assumptions.mp4 68MB
  44. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/168 - Partitioning The IRR Part 2.mp4 67MB
  45. 8 - Part 5 Modeling Advanced Financing Structures/119 - Creating Acquisition Financing Checks.mp4 66MB
  46. 6 - Part 3 CRE Expense Modeling/79 - Modeling Monthly Property Tax Cash Flows.mp4 65MB
  47. 11 - Part 8 Creating The Annual Cash Flow RollUp/150 - Introduction To The Annual CF Tab.mp4 65MB
  48. 6 - Part 3 CRE Expense Modeling/81 - Modeling CAM Other Expenses.mp4 65MB
  49. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/145 - Investor Distribution Modeling Part 1.mp4 64MB
  50. 4 - Part 1 Building Out The Summary Dashboard/41 - Modeling The Weighted Average Lease Term WALT.mp4 61MB
  51. 6 - Part 3 CRE Expense Modeling/77 - Property Tax Modeling.mp4 61MB
  52. 8 - Part 5 Modeling Advanced Financing Structures/120 - Mezzanine Financing BuildOut.mp4 60MB
  53. 8 - Part 5 Modeling Advanced Financing Structures/118 - Modeling The Acquisition Loan Payoff Prepayment Penalty.mp4 59MB
  54. 4 - Part 1 Building Out The Summary Dashboard/33 - Building Out Unlevered Levered Return Metrics.mp4 59MB
  55. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/67 - Creating Additional Leases.mp4 59MB
  56. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/171 - Creating The Base Rent Makeup Chart.mp4 59MB
  57. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/162 - Modeling Unlevered Return Metrics IRR Equity Multiple CashonCash Return.mp4 57MB
  58. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/47 - Modeling The Rent Escalation Schedule.mp4 57MB
  59. 4 - Part 1 Building Out The Summary Dashboard/30 - The Capital Budget Breakdown.mp4 56MB
  60. 6 - Part 3 CRE Expense Modeling/78 - Monthly Expense Modeling Formatting.mp4 56MB
  61. 9 - Part 6 Creating A Dynamic Construction Budget/135 - Construction Budget Checks Formatting.mp4 56MB
  62. 7 - Part 4 Building Out The Monthly Cash Flows/92 - Modeling Sale Information.mp4 55MB
  63. 8 - Part 5 Modeling Advanced Financing Structures/124 - Modeling Total Refinance Loan Payments.mp4 55MB
  64. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/173 - Dynamic Operating Metric Cash Flow BuildOut Part 1.mp4 55MB
  65. 8 - Part 5 Modeling Advanced Financing Structures/114 - Creating Dynamic Fixed Floating Interest Rates.mp4 53MB
  66. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/51 - Tenant Cash Flow Timeline BuildOut.mp4 52MB
  67. 1 - Introduction/4 - About This Course Student Success Stories.mp4 52MB
  68. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/175 - The Dynamic Operating Metric Chart BuildOut.mp4 52MB
  69. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/69 - Formatting Pro Rata Share Calculations.mp4 51MB
  70. 6 - Part 3 CRE Expense Modeling/75 - Property Tax Information Inputs.mp4 50MB
  71. 7 - Part 4 Building Out The Monthly Cash Flows/84 - Building Out The Monthly Cash Flow Timeline.mp4 50MB
  72. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/163 - Building Out The Property Sale Details.mp4 49MB
  73. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/164 - Building Out The Consolidated Rent Roll.mp4 48MB
  74. 11 - Part 8 Creating The Annual Cash Flow RollUp/153 - Modeling Levered CashonCash Returns.mp4 47MB
  75. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/46 - Building Out The Expense Reimbursement Structure.mp4 47MB
  76. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/176 - Creating The DSCR Over Time Chart Part 1.mp4 47MB
  77. 8 - Part 5 Modeling Advanced Financing Structures/105 - Sizing The Refinance LTV LTC.mp4 46MB
  78. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/17 - Excel Financial Modeling Best Practices Color Coding.mp4 46MB
  79. 8 - Part 5 Modeling Advanced Financing Structures/107 - The Acquisition Financing BuildOut.mp4 46MB
  80. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/141 - How To Use SUMIF To Model Additional Loan Proceeds.mp4 45MB
  81. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/70 - Grouping Tenants.mp4 45MB
  82. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/60 - Modeling ReLeasing Free Rent.mp4 45MB
  83. 4 - Part 1 Building Out The Summary Dashboard/29 - Building Out The Summary Details.mp4 45MB
  84. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/146 - Investor Distribution Modeling Part 2.mp4 44MB
  85. 7 - Part 4 Building Out The Monthly Cash Flows/93 - Building Out The Loan Information Section.mp4 44MB
  86. 8 - Part 5 Modeling Advanced Financing Structures/97 - Building Out The Loan Metrics.mp4 44MB
  87. 9 - Part 6 Creating A Dynamic Construction Budget/134 - StraightLine Construction Cost Modeling.mp4 43MB
  88. 8 - Part 5 Modeling Advanced Financing Structures/106 - Sizing The Refinance DSCR Debt Yield.mp4 43MB
  89. 6 - Part 3 CRE Expense Modeling/73 - T12 Hold Period Operating Expense Modeling.mp4 42MB
  90. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/49 - ReLeasing Costs.mp4 42MB
  91. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/139 - Modeling Management Fees Construction Expenses.mp4 41MB
  92. 13 - Wrapping Up/185 - Where To Go From Here.mp4 41MB
  93. 9 - Part 6 Creating A Dynamic Construction Budget/133 - Construction Budget Costs Timing.mp4 40MB
  94. 8 - Part 5 Modeling Advanced Financing Structures/129 - SUMIF Trigger BuildOut.mp4 40MB
  95. 8 - Part 5 Modeling Advanced Financing Structures/115 - Building Out The Total Loan Payment.mp4 40MB
  96. 4 - Part 1 Building Out The Summary Dashboard/32 - Sources Uses Part 2.mp4 39MB
  97. 8 - Part 5 Modeling Advanced Financing Structures/96 - Creating The Loan Information Table.mp4 39MB
  98. 9 - Part 6 Creating A Dynamic Construction Budget/131 - Introduction To The Construction Budget Tab.mp4 39MB
  99. 2 - The Advanced Real Estate Pro Forma Model/12 - Building Out The Monthly Cash Flow Statement.mp4 38MB
  100. 8 - Part 5 Modeling Advanced Financing Structures/125 - Modeling Refinance Principal Interest Payments.mp4 38MB
  101. 4 - Part 1 Building Out The Summary Dashboard/36 - Sensitivity Analysis BuildOut.mp4 37MB
  102. 2 - The Advanced Real Estate Pro Forma Model/9 - Building Out The Summary Dashboard.mp4 37MB
  103. 4 - Part 1 Building Out The Summary Dashboard/37 - Combining Dynamic Text Values.mp4 37MB
  104. 8 - Part 5 Modeling Advanced Financing Structures/108 - Dynamic Acquisition Loan Balance Modeling.mp4 37MB
  105. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/50 - Modeling Percentage Rent.mp4 36MB
  106. 8 - Part 5 Modeling Advanced Financing Structures/101 - Sizing The Acquisition Loan DSCR.mp4 36MB
  107. 8 - Part 5 Modeling Advanced Financing Structures/104 - Sizing The Mezzanine Loan DSCR Debt Yield.mp4 36MB
  108. 6 - Part 3 CRE Expense Modeling/80 - Modeling Insurance.mp4 35MB
  109. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/157 - Modeling Tenant Health Ratio.mp4 34MB
  110. 8 - Part 5 Modeling Advanced Financing Structures/98 - Interest Rate Modeling.mp4 34MB
  111. 7 - Part 4 Building Out The Monthly Cash Flows/87 - Modeling CAM Reimbursements Percentage Rent.mp4 34MB
  112. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/142 - Building In Debt Service Modeling The Loan Payoff.mp4 34MB
  113. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/52 - Timeline Formatting Tenant SetUp.mp4 34MB
  114. 4 - Part 1 Building Out The Summary Dashboard/38 - Creating Dynamic Hold Period Intervals.mp4 33MB
  115. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/166 - Reimbursements Lease Expirations.mp4 33MB
  116. 8 - Part 5 Modeling Advanced Financing Structures/112 - Chatham Forward Curves.mp4 33MB
  117. 8 - Part 5 Modeling Advanced Financing Structures/109 - Modeling Additional Loan Proceeds.mp4 33MB
  118. 2 - The Advanced Real Estate Pro Forma Model/8 - The 8 CRE Pro Forma Model Tabs.mp4 33MB
  119. 6 - Part 3 CRE Expense Modeling/76 - Modeling Credit Loss Property Tax Growth Rates.mp4 33MB
  120. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/159 - Capital Budget Modeling.mp4 33MB
  121. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/16 - How To Get The Most Out Of This Course.mp4 32MB
  122. 7 - Part 4 Building Out The Monthly Cash Flows/86 - Modeling Credit Loss Net Rental Income.mp4 32MB
  123. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/178 - Running The Sensitivity Analysis.mp4 32MB
  124. 4 - Part 1 Building Out The Summary Dashboard/27 - Modeling Sale Information.mp4 31MB
  125. 4 - Part 1 Building Out The Summary Dashboard/24 - Formatting The Property Details.mp4 31MB
  126. 1 - Introduction/3 - Who This Course Is For.mp4 31MB
  127. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/58 - Modeling UpFront Free Rent.mp4 31MB
  128. 2 - The Advanced Real Estate Pro Forma Model/14 - Building Out The Financing Tab.mp4 31MB
  129. 2 - The Advanced Real Estate Pro Forma Model/15 - Construction Budget Modeling Automatic Checks.mp4 30MB
  130. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/165 - Modeling InPlace Rent.mp4 30MB
  131. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/177 - Creating The DSCR Over Time Chart Part 2.mp4 30MB
  132. 2 - The Advanced Real Estate Pro Forma Model/10 - Modeling Dynamic Commercial Real Estate Leases.mp4 30MB
  133. 6 - Part 3 CRE Expense Modeling/74 - Modeling Operating Expense Assumptions.mp4 28MB
  134. 7 - Part 4 Building Out The Monthly Cash Flows/91 - Modeling Acquisition Information.mp4 28MB
  135. 4 - Part 1 Building Out The Summary Dashboard/28 - Investor Distribution Frequency ProjectLevel Fees.mp4 28MB
  136. 8 - Part 5 Modeling Advanced Financing Structures/103 - Sizing The Mezzanine Loan LTV LTC.mp4 28MB
  137. 4 - Part 1 Building Out The Summary Dashboard/40 - The Consolidated Rent Roll.mp4 28MB
  138. 2 - The Advanced Real Estate Pro Forma Model/13 - Modeling The Annual Cash Flow RollUp.mp4 28MB
  139. 4 - Part 1 Building Out The Summary Dashboard/39 - Sensitivity Analysis Finalization.mp4 28MB
  140. 4 - Part 1 Building Out The Summary Dashboard/26 - Modeling Key Acquisition Inputs.mp4 27MB
  141. 8 - Part 5 Modeling Advanced Financing Structures/99 - Loan Periods Prepayment.mp4 27MB
  142. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/20 - Workbook Iterative Calculations.mp4 27MB
  143. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/44 - InPlace Tenant Details.mp4 26MB
  144. 8 - Part 5 Modeling Advanced Financing Structures/117 - Modeling Principal Interest Payments.mp4 26MB
  145. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/54 - The InPlace Operating Expense BuildOut.mp4 26MB
  146. 8 - Part 5 Modeling Advanced Financing Structures/100 - Sizing The Acquisition Loan LTV LTC.mp4 26MB
  147. 13 - Wrapping Up/186 - A Final Word.mp4 25MB
  148. 9 - Part 6 Creating A Dynamic Construction Budget/132 - Building Out The Construction Budget Line Items.mp4 25MB
  149. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/170 - Creating The IRR Partitioning Chart.mp4 25MB
  150. 8 - Part 5 Modeling Advanced Financing Structures/123 - Modeling Additional Refinance Loan Proceeds.mp4 25MB
  151. 1 - Introduction/2 - A Sneak Peek Into What Youll Build.mp4 24MB
  152. 8 - Part 5 Modeling Advanced Financing Structures/110 - Naming Cells For Faster Modeling.mp4 23MB
  153. 4 - Part 1 Building Out The Summary Dashboard/31 - Sources Uses Part 1.mp4 23MB
  154. 4 - Part 1 Building Out The Summary Dashboard/35 - IRR Partitioning.mp4 22MB
  155. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/179 - Creating The Checks Tab.mp4 21MB
  156. 2 - The Advanced Real Estate Pro Forma Model/11 - Modeling CRE Operating Expenses.mp4 21MB
  157. 4 - Part 1 Building Out The Summary Dashboard/23 - Building Out The Property Details.mp4 20MB
  158. 8 - Part 5 Modeling Advanced Financing Structures/95 - Introduction To The Financing Tab.mp4 20MB
  159. 4 - Part 1 Building Out The Summary Dashboard/25 - Building Out Parking Information.mp4 17MB
  160. 8 - Part 5 Modeling Advanced Financing Structures/102 - Sizing The Acquisition Loan Debt Yield.mp4 16MB
  161. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/45 - Formatting The InPlace Tenant Details.mp4 15MB
  162. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/21 - Advanced Excel Settings.mp4 14MB
  163. 1 - Introduction/1 - Introduction.mp4 14MB
  164. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/18 - Removing Gridlines.mp4 13MB
  165. 6 - Part 3 CRE Expense Modeling/72 - Building Out The Expenses Tab.mp4 12MB
  166. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/43 - Building Out The CRE Leases Tab.mp4 11MB
  167. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/19 - The Entire Sheet Formatting Trick.mp4 9MB
  168. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/184 - Advanced-Real-Estate-Pro-Forma-Model-Final.xlsx 1MB
  169. 11 - Part 8 Creating The Annual Cash Flow RollUp/154 - Advanced-Real-Estate-Pro-Forma-Model-Annual-CF.xlsx 1MB
  170. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/149 - Advanced-Real-Estate-Pro-Forma-Model-Monthly-CF-Part-2.xlsx 1MB
  171. 9 - Part 6 Creating A Dynamic Construction Budget/138 - Advanced-Real-Estate-Pro-Forma-Model-Construction-Budget.xlsx 1MB
  172. 8 - Part 5 Modeling Advanced Financing Structures/130 - Advanced-Real-Estate-Pro-Forma-Model-Financing.xlsx 1MB
  173. 7 - Part 4 Building Out The Monthly Cash Flows/94 - Advanced-Real-Estate-Pro-Forma-Model-Monthly-CF.xlsx 1MB
  174. 6 - Part 3 CRE Expense Modeling/82 - Advanced-Real-Estate-Pro-Forma-Model-Expenses.xlsx 921KB
  175. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/71 - Advanced-Real-Estate-Pro-Forma-Model-CRE-Leases.xlsx 641KB
  176. 1 - Introduction/6 - Advanced-Pro-Forma-Excel-Hotkeys-and-Shortcuts.pdf 431KB
  177. 1 - Introduction/5 - Advanced-Pro-Forma-Model-Key-Definitions.pdf 191KB
  178. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/55 - Modeling InPlace Reimbursements English.vtt 19KB
  179. 4 - Part 1 Building Out The Summary Dashboard/42 - Advanced-Real-Estate-Pro-Forma-Model-Summary.xlsx 17KB
  180. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/59 - Modeling ReLeasing Base Rent English.vtt 15KB
  181. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/65 - Modeling ReLeasing Leasing Commissions English.vtt 13KB
  182. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/53 - Modeling InPlace Base Rent English.vtt 13KB
  183. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/62 - Modeling UpFront Tenant Improvements English.vtt 13KB
  184. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/158 - Modeling DSCR Debt Yield Total Cost English.vtt 12KB
  185. 8 - Part 5 Modeling Advanced Financing Structures/113 - Building In The Floating Interest Rate Index English.vtt 12KB
  186. 7 - Part 4 Building Out The Monthly Cash Flows/85 - Modeling Revenue Free Rent English.vtt 12KB
  187. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/144 - Creating Dynamic Working Capital Funding English.vtt 12KB
  188. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/63 - Modeling UpFront Leasing Commissions English.vtt 12KB
  189. 4 - Part 1 Building Out The Summary Dashboard/34 - Modeling Sale Details The Formula BuildOut English.vtt 11KB
  190. 9 - Part 6 Creating A Dynamic Construction Budget/136 - Construction Subtotals MAX and MIN IF English.vtt 11KB
  191. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/182 - Operating Shortfalls IRR Partitioning Finalization English.vtt 11KB
  192. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/46 - Building Out The Expense Reimbursement Structure English.vtt 11KB
  193. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/47 - Modeling The Rent Escalation Schedule English.vtt 11KB
  194. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/48 - ReLeasing Assumptions English.vtt 11KB
  195. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/51 - Tenant Cash Flow Timeline BuildOut English.vtt 11KB
  196. 7 - Part 4 Building Out The Monthly Cash Flows/90 - Modeling Capital Reserves English.vtt 11KB
  197. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/156 - Property Tax Finalization Dynamic Assessed Value Modeling English.vtt 11KB
  198. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/180 - Building Out The Model Checks Conditional Formatting English.vtt 11KB
  199. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/183 - Final Model Updates.html 11KB
  200. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/174 - Dynamic Operating Metric Cash Flow BuildOut Part 2 English.vtt 11KB
  201. 8 - Part 5 Modeling Advanced Financing Structures/96 - Creating The Loan Information Table English.vtt 10KB
  202. 11 - Part 8 Creating The Annual Cash Flow RollUp/151 - The Annual Cash Flow AllInOne Formula English.vtt 10KB
  203. 6 - Part 3 CRE Expense Modeling/77 - Property Tax Modeling English.vtt 10KB
  204. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/160 - Sources Uses Finalization English.vtt 10KB
  205. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/172 - Creating The Dynamic Operating Metrics Over Time Chart English.vtt 10KB
  206. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/56 - Modeling Percentage Rent English.vtt 10KB
  207. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/171 - Creating The Base Rent Makeup Chart English.vtt 10KB
  208. 7 - Part 4 Building Out The Monthly Cash Flows/84 - Building Out The Monthly Cash Flow Timeline English.vtt 10KB
  209. 9 - Part 6 Creating A Dynamic Construction Budget/137 - Modeling Contingencies English.vtt 9KB
  210. 4 - Part 1 Building Out The Summary Dashboard/41 - Modeling The Weighted Average Lease Term WALT English.vtt 9KB
  211. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/161 - Modeling Levered Return Metrics IRR Equity Multiple CashonCash Return English.vtt 9KB
  212. 6 - Part 3 CRE Expense Modeling/75 - Property Tax Information Inputs English.vtt 9KB
  213. 8 - Part 5 Modeling Advanced Financing Structures/97 - Building Out The Loan Metrics English.vtt 9KB
  214. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/64 - Modeling ReLeasing Tenant Improvements English.vtt 9KB
  215. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/61 - Modeling ReLeasing Reimbursements English.vtt 9KB
  216. 6 - Part 3 CRE Expense Modeling/73 - T12 Hold Period Operating Expense Modeling English.vtt 9KB
  217. 4 - Part 1 Building Out The Summary Dashboard/30 - The Capital Budget Breakdown English.vtt 9KB
  218. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/147 - Investor Distribution Modeling Part 3 English.vtt 9KB
  219. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/49 - ReLeasing Costs English.vtt 9KB
  220. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/66 - Total Suite Cash Flow Finalization English.vtt 9KB
  221. 11 - Part 8 Creating The Annual Cash Flow RollUp/152 - Modeling Unlevered CashonCash Returns English.vtt 9KB
  222. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/143 - Modeling Loan Fees English.vtt 9KB
  223. 8 - Part 5 Modeling Advanced Financing Structures/121 - Modeling Mezzanine Debt Payments English.vtt 8KB
  224. 6 - Part 3 CRE Expense Modeling/81 - Modeling CAM Other Expenses English.vtt 8KB
  225. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/155 - Modeling Asset Management Fees English.vtt 8KB
  226. 9 - Part 6 Creating A Dynamic Construction Budget/135 - Construction Budget Checks Formatting English.vtt 8KB
  227. 4 - Part 1 Building Out The Summary Dashboard/29 - Building Out The Summary Details English.vtt 8KB
  228. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/181 - How To Use What Youve Built English.vtt 8KB
  229. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/148 - Cash Flow SUM Formatting Finalization English.vtt 8KB
  230. 4 - Part 1 Building Out The Summary Dashboard/33 - Building Out Unlevered Levered Return Metrics English.vtt 8KB
  231. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/140 - Partnership Expense Modeling AcquisitionRefinance Loan Proceed Funding English.vtt 8KB
  232. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/50 - Modeling Percentage Rent English.vtt 8KB
  233. 9 - Part 6 Creating A Dynamic Construction Budget/133 - Construction Budget Costs Timing English.vtt 8KB
  234. 9 - Part 6 Creating A Dynamic Construction Budget/134 - StraightLine Construction Cost Modeling English.vtt 8KB
  235. 6 - Part 3 CRE Expense Modeling/79 - Modeling Monthly Property Tax Cash Flows English.vtt 8KB
  236. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/167 - Partitioning The IRR Part 1 English.vtt 8KB
  237. 7 - Part 4 Building Out The Monthly Cash Flows/88 - Modeling Operating Expenses English.vtt 8KB
  238. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/145 - Investor Distribution Modeling Part 1 English.vtt 8KB
  239. 8 - Part 5 Modeling Advanced Financing Structures/107 - The Acquisition Financing BuildOut English.vtt 8KB
  240. 7 - Part 4 Building Out The Monthly Cash Flows/92 - Modeling Sale Information English.vtt 8KB
  241. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/68 - Creating Additional Lease Cash Flows English.vtt 7KB
  242. 8 - Part 5 Modeling Advanced Financing Structures/119 - Creating Acquisition Financing Checks English.vtt 7KB
  243. 4 - Part 1 Building Out The Summary Dashboard/24 - Formatting The Property Details English.vtt 7KB
  244. 7 - Part 4 Building Out The Monthly Cash Flows/93 - Building Out The Loan Information Section English.vtt 7KB
  245. 8 - Part 5 Modeling Advanced Financing Structures/122 - Refinance BuildOut English.vtt 7KB
  246. 7 - Part 4 Building Out The Monthly Cash Flows/89 - Modeling TIs LCs English.vtt 7KB
  247. 8 - Part 5 Modeling Advanced Financing Structures/126 - Modeling The Refinance Loan Payoff Prepayment Penalty English.vtt 7KB
  248. 7 - Part 4 Building Out The Monthly Cash Flows/83 - Introduction To The Monthly Cash Flow Tab English.vtt 7KB
  249. 8 - Part 5 Modeling Advanced Financing Structures/118 - Modeling The Acquisition Loan Payoff Prepayment Penalty English.vtt 7KB
  250. 9 - Part 6 Creating A Dynamic Construction Budget/131 - Introduction To The Construction Budget Tab English.vtt 7KB
  251. 6 - Part 3 CRE Expense Modeling/78 - Monthly Expense Modeling Formatting English.vtt 7KB
  252. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/168 - Partitioning The IRR Part 2 English.vtt 7KB
  253. 8 - Part 5 Modeling Advanced Financing Structures/114 - Creating Dynamic Fixed Floating Interest Rates English.vtt 7KB
  254. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/173 - Dynamic Operating Metric Cash Flow BuildOut Part 1 English.vtt 7KB
  255. 8 - Part 5 Modeling Advanced Financing Structures/105 - Sizing The Refinance LTV LTC English.vtt 7KB
  256. 11 - Part 8 Creating The Annual Cash Flow RollUp/150 - Introduction To The Annual CF Tab English.vtt 7KB
  257. 8 - Part 5 Modeling Advanced Financing Structures/98 - Interest Rate Modeling English.vtt 7KB
  258. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/44 - InPlace Tenant Details English.vtt 7KB
  259. 8 - Part 5 Modeling Advanced Financing Structures/128 - Total Payment Formula Update English.vtt 7KB
  260. 8 - Part 5 Modeling Advanced Financing Structures/106 - Sizing The Refinance DSCR Debt Yield English.vtt 7KB
  261. 4 - Part 1 Building Out The Summary Dashboard/26 - Modeling Key Acquisition Inputs English.vtt 7KB
  262. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/164 - Building Out The Consolidated Rent Roll English.vtt 6KB
  263. 8 - Part 5 Modeling Advanced Financing Structures/120 - Mezzanine Financing BuildOut English.vtt 6KB
  264. 6 - Part 3 CRE Expense Modeling/74 - Modeling Operating Expense Assumptions English.vtt 6KB
  265. 8 - Part 5 Modeling Advanced Financing Structures/104 - Sizing The Mezzanine Loan DSCR Debt Yield English.vtt 6KB
  266. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/67 - Creating Additional Leases English.vtt 6KB
  267. 4 - Part 1 Building Out The Summary Dashboard/28 - Investor Distribution Frequency ProjectLevel Fees English.vtt 6KB
  268. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/175 - The Dynamic Operating Metric Chart BuildOut English.vtt 6KB
  269. 4 - Part 1 Building Out The Summary Dashboard/27 - Modeling Sale Information English.vtt 6KB
  270. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/162 - Modeling Unlevered Return Metrics IRR Equity Multiple CashonCash Return English.vtt 6KB
  271. 8 - Part 5 Modeling Advanced Financing Structures/101 - Sizing The Acquisition Loan DSCR English.vtt 6KB
  272. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/69 - Formatting Pro Rata Share Calculations English.vtt 6KB
  273. 6 - Part 3 CRE Expense Modeling/76 - Modeling Credit Loss Property Tax Growth Rates English.vtt 6KB
  274. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/146 - Investor Distribution Modeling Part 2 English.vtt 6KB
  275. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/176 - Creating The DSCR Over Time Chart Part 1 English.vtt 6KB
  276. 4 - Part 1 Building Out The Summary Dashboard/32 - Sources Uses Part 2 English.vtt 6KB
  277. 11 - Part 8 Creating The Annual Cash Flow RollUp/153 - Modeling Levered CashonCash Returns English.vtt 6KB
  278. 7 - Part 4 Building Out The Monthly Cash Flows/86 - Modeling Credit Loss Net Rental Income English.vtt 6KB
  279. 8 - Part 5 Modeling Advanced Financing Structures/124 - Modeling Total Refinance Loan Payments English.vtt 6KB
  280. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/52 - Timeline Formatting Tenant SetUp English.vtt 5KB
  281. 4 - Part 1 Building Out The Summary Dashboard/38 - Creating Dynamic Hold Period Intervals English.vtt 5KB
  282. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/163 - Building Out The Property Sale Details English.vtt 5KB
  283. 8 - Part 5 Modeling Advanced Financing Structures/108 - Dynamic Acquisition Loan Balance Modeling English.vtt 5KB
  284. 9 - Part 6 Creating A Dynamic Construction Budget/132 - Building Out The Construction Budget Line Items English.vtt 5KB
  285. 4 - Part 1 Building Out The Summary Dashboard/40 - The Consolidated Rent Roll English.vtt 5KB
  286. 1 - Introduction/4 - About This Course Student Success Stories English.vtt 5KB
  287. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/60 - Modeling ReLeasing Free Rent English.vtt 5KB
  288. 8 - Part 5 Modeling Advanced Financing Structures/115 - Building Out The Total Loan Payment English.vtt 5KB
  289. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/70 - Grouping Tenants English.vtt 5KB
  290. 8 - Part 5 Modeling Advanced Financing Structures/103 - Sizing The Mezzanine Loan LTV LTC English.vtt 5KB
  291. 4 - Part 1 Building Out The Summary Dashboard/37 - Combining Dynamic Text Values English.vtt 5KB
  292. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/141 - How To Use SUMIF To Model Additional Loan Proceeds English.vtt 5KB
  293. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/17 - Excel Financial Modeling Best Practices Color Coding English.vtt 5KB
  294. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/166 - Reimbursements Lease Expirations English.vtt 5KB
  295. 4 - Part 1 Building Out The Summary Dashboard/39 - Sensitivity Analysis Finalization English.vtt 5KB
  296. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/139 - Modeling Management Fees Construction Expenses English.vtt 5KB
  297. 4 - Part 1 Building Out The Summary Dashboard/36 - Sensitivity Analysis BuildOut English.vtt 5KB
  298. 7 - Part 4 Building Out The Monthly Cash Flows/87 - Modeling CAM Reimbursements Percentage Rent English.vtt 5KB
  299. 8 - Part 5 Modeling Advanced Financing Structures/109 - Modeling Additional Loan Proceeds English.vtt 5KB
  300. 8 - Part 5 Modeling Advanced Financing Structures/99 - Loan Periods Prepayment English.vtt 5KB
  301. 8 - Part 5 Modeling Advanced Financing Structures/112 - Chatham Forward Curves English.vtt 5KB
  302. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/179 - Creating The Checks Tab English.vtt 4KB
  303. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/142 - Building In Debt Service Modeling The Loan Payoff English.vtt 4KB
  304. 4 - Part 1 Building Out The Summary Dashboard/25 - Building Out Parking Information English.vtt 4KB
  305. 8 - Part 5 Modeling Advanced Financing Structures/129 - SUMIF Trigger BuildOut English.vtt 4KB
  306. 4 - Part 1 Building Out The Summary Dashboard/23 - Building Out The Property Details English.vtt 4KB
  307. 6 - Part 3 CRE Expense Modeling/80 - Modeling Insurance English.vtt 4KB
  308. 7 - Part 4 Building Out The Monthly Cash Flows/91 - Modeling Acquisition Information English.vtt 4KB
  309. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/54 - The InPlace Operating Expense BuildOut English.vtt 4KB
  310. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/45 - Formatting The InPlace Tenant Details English.vtt 4KB
  311. 8 - Part 5 Modeling Advanced Financing Structures/100 - Sizing The Acquisition Loan LTV LTC English.vtt 4KB
  312. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/58 - Modeling UpFront Free Rent English.vtt 4KB
  313. 8 - Part 5 Modeling Advanced Financing Structures/125 - Modeling Refinance Principal Interest Payments English.vtt 4KB
  314. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/170 - Creating The IRR Partitioning Chart English.vtt 4KB
  315. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/165 - Modeling InPlace Rent English.vtt 4KB
  316. 13 - Wrapping Up/185 - Where To Go From Here English.vtt 4KB
  317. 8 - Part 5 Modeling Advanced Financing Structures/117 - Modeling Principal Interest Payments English.vtt 4KB
  318. 4 - Part 1 Building Out The Summary Dashboard/31 - Sources Uses Part 1 English.vtt 4KB
  319. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/178 - Running The Sensitivity Analysis English.vtt 4KB
  320. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/159 - Capital Budget Modeling English.vtt 4KB
  321. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/157 - Modeling Tenant Health Ratio English.vtt 4KB
  322. 2 - The Advanced Real Estate Pro Forma Model/12 - Building Out The Monthly Cash Flow Statement English.vtt 4KB
  323. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/20 - Workbook Iterative Calculations English.vtt 3KB
  324. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/177 - Creating The DSCR Over Time Chart Part 2 English.vtt 3KB
  325. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/16 - How To Get The Most Out Of This Course English.vtt 3KB
  326. 2 - The Advanced Real Estate Pro Forma Model/9 - Building Out The Summary Dashboard English.vtt 3KB
  327. 2 - The Advanced Real Estate Pro Forma Model/15 - Construction Budget Modeling Automatic Checks English.vtt 3KB
  328. 2 - The Advanced Real Estate Pro Forma Model/8 - The 8 CRE Pro Forma Model Tabs English.vtt 3KB
  329. 2 - The Advanced Real Estate Pro Forma Model/14 - Building Out The Financing Tab English.vtt 3KB
  330. 1 - Introduction/3 - Who This Course Is For English.vtt 3KB
  331. 2 - The Advanced Real Estate Pro Forma Model/10 - Modeling Dynamic Commercial Real Estate Leases English.vtt 3KB
  332. 8 - Part 5 Modeling Advanced Financing Structures/102 - Sizing The Acquisition Loan Debt Yield English.vtt 3KB
  333. 1 - Introduction/2 - A Sneak Peek Into What Youll Build English.vtt 3KB
  334. 8 - Part 5 Modeling Advanced Financing Structures/123 - Modeling Additional Refinance Loan Proceeds English.vtt 3KB
  335. 8 - Part 5 Modeling Advanced Financing Structures/110 - Naming Cells For Faster Modeling English.vtt 3KB
  336. 4 - Part 1 Building Out The Summary Dashboard/35 - IRR Partitioning English.vtt 3KB
  337. 2 - The Advanced Real Estate Pro Forma Model/13 - Modeling The Annual Cash Flow RollUp English.vtt 3KB
  338. 13 - Wrapping Up/186 - A Final Word English.vtt 2KB
  339. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/21 - Advanced Excel Settings English.vtt 2KB
  340. 1 - Introduction/7 - Disclaimer.html 2KB
  341. 2 - The Advanced Real Estate Pro Forma Model/11 - Modeling CRE Operating Expenses English.vtt 2KB
  342. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/19 - The Entire Sheet Formatting Trick English.vtt 2KB
  343. 6 - Part 3 CRE Expense Modeling/72 - Building Out The Expenses Tab English.vtt 2KB
  344. 14 - Bonus Lecture/187 - Bonus Lecture The Next Step.html 2KB
  345. 8 - Part 5 Modeling Advanced Financing Structures/95 - Introduction To The Financing Tab English.vtt 2KB
  346. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/18 - Removing Gridlines English.vtt 2KB
  347. 8 - Part 5 Modeling Advanced Financing Structures/116 - Total Loan Payment Formula Update.html 1KB
  348. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/22 - Downloading Macros Optional.html 1KB
  349. 1 - Introduction/1 - Introduction English.vtt 1KB
  350. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/169 - XNPV Formula Update.html 1KB
  351. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/57 - Percentage Rent Update.html 1009B
  352. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/43 - Building Out The CRE Leases Tab English.vtt 952B
  353. 8 - Part 5 Modeling Advanced Financing Structures/127 - Refinancing Prepayment Penalty Formula Update.html 823B
  354. 12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/184 - Model Download Review Were Done.html 623B
  355. 8 - Part 5 Modeling Advanced Financing Structures/130 - Model Download Review.html 542B
  356. 7 - Part 4 Building Out The Monthly Cash Flows/94 - Model Download Review.html 518B
  357. 9 - Part 6 Creating A Dynamic Construction Budget/138 - Model Download Review.html 492B
  358. 6 - Part 3 CRE Expense Modeling/82 - Model Download Review.html 476B
  359. 11 - Part 8 Creating The Annual Cash Flow RollUp/154 - Model Download Review.html 475B
  360. 4 - Part 1 Building Out The Summary Dashboard/42 - Model Download Review.html 463B
  361. 5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/71 - Model Download Review.html 448B
  362. 10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/149 - Model Download Review.html 427B
  363. 8 - Part 5 Modeling Advanced Financing Structures/111 - Chatham Forward Curves Link.html 387B
  364. 1 - Introduction/5 - Key Terms Definitions Cheat Sheet.html 224B
  365. 1 - Introduction/6 - Excel Shortcuts Hotkeys Cheat Sheet.html 141B
  366. 0. Websites you may like/[FreeCourseSite.com].url 127B
  367. 11 - Part 8 Creating The Annual Cash Flow RollUp/0. Websites you may like/[FreeCourseSite.com].url 127B
  368. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/0. Websites you may like/[FreeCourseSite.com].url 127B
  369. 0. Websites you may like/[CourseClub.Me].url 122B
  370. 11 - Part 8 Creating The Annual Cash Flow RollUp/0. Websites you may like/[CourseClub.Me].url 122B
  371. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/0. Websites you may like/[CourseClub.Me].url 122B
  372. 0. Websites you may like/[GigaCourse.Com].url 49B
  373. 11 - Part 8 Creating The Annual Cash Flow RollUp/0. Websites you may like/[GigaCourse.Com].url 49B
  374. 3 - Advanced Real Estate Pro Forma Modeling Fundamentals/0. Websites you may like/[GigaCourse.Com].url 49B