The Advanced Real Estate Pro Forma Modeling Master Class

Download Now


Files Included :

1 - Introduction.mp4 (14.35 MB)
MP4
2 - A Sneak Peek Into What Youll Build.mp4 (24.37 MB)
MP4
3 - Who This Course Is For.mp4 (30.66 MB)
MP4
4 - About This Course Student Success Stories.mp4 (52.13 MB)
MP4
139 - Modeling Management Fees Construction Expenses.mp4 (41.27 MB)
MP4
140 - Partnership Expense Modeling AcquisitionRefinance Loan Proceed Funding.mp4 (69.73 MB)
MP4
141 - How To Use SUMIF To Model Additional Loan Proceeds.mp4 (45.29 MB)
MP4
142 - Building In Debt Service Modeling The Loan Payoff.mp4 (33.78 MB)
MP4
143 - Modeling Loan Fees.mp4 (74.87 MB)
MP4
144 - Creating Dynamic Working Capital Funding.mp4 (80.6 MB)
MP4
145 - Investor Distribution Modeling Part 1.mp4 (63.72 MB)
MP4
146 - Investor Distribution Modeling Part 2.mp4 (43.91 MB)
MP4
147 - Investor Distribution Modeling Part 3.mp4 (73.62 MB)
MP4
148 - Cash Flow SUM Formatting Finalization.mp4 (79.82 MB)
MP4
150 - Introduction To The Annual CF Tab.mp4 (64.61 MB)
MP4
151 - The Annual Cash Flow AllInOne Formula.mp4 (99.71 MB)
MP4
152 - Modeling Unlevered CashonCash Returns.mp4 (72.68 MB)
MP4
153 - Modeling Levered CashonCash Returns.mp4 (47.5 MB)
MP4
155 - Modeling Asset Management Fees.mp4 (84.41 MB)
MP4
156 - Property Tax Finalization Dynamic Assessed Value Modeling.mp4 (95.22 MB)
MP4
157 - Modeling Tenant Health Ratio.mp4 (34.06 MB)
MP4
158 - Modeling DSCR Debt Yield Total Cost.mp4 (112.28 MB)
MP4
159 - Capital Budget Modeling.mp4 (32.59 MB)
MP4
160 - Sources Uses Finalization.mp4 (79.36 MB)
MP4
161 - Modeling Levered Return Metrics IRR Equity Multiple CashonCash Return.mp4 (82.03 MB)
MP4
162 - Modeling Unlevered Return Metrics IRR Equity Multiple CashonCash Return.mp4 (56.97 MB)
MP4
163 - Building Out The Property Sale Details.mp4 (48.54 MB)
MP4
164 - Building Out The Consolidated Rent Roll.mp4 (47.58 MB)
MP4
165 - Modeling InPlace Rent.mp4 (30.43 MB)
MP4
166 - Reimbursements Lease Expirations.mp4 (33.34 MB)
MP4
167 - Partitioning The IRR Part 1.mp4 (68.6 MB)
MP4
168 - Partitioning The IRR Part 2.mp4 (66.64 MB)
MP4
170 - Creating The IRR Partitioning Chart.mp4 (24.59 MB)
MP4
171 - Creating The Base Rent Makeup Chart.mp4 (58.82 MB)
MP4
172 - Creating The Dynamic Operating Metrics Over Time Chart.mp4 (74.3 MB)
MP4
173 - Dynamic Operating Metric Cash Flow BuildOut Part 1.mp4 (54.63 MB)
MP4
174 - Dynamic Operating Metric Cash Flow BuildOut Part 2.mp4 (85.06 MB)
MP4
175 - The Dynamic Operating Metric Chart BuildOut.mp4 (51.72 MB)
MP4
176 - Creating The DSCR Over Time Chart Part 1.mp4 (46.52 MB)
MP4
177 - Creating The DSCR Over Time Chart Part 2.mp4 (30.14 MB)
MP4
178 - Running The Sensitivity Analysis.mp4 (31.65 MB)
MP4
179 - Creating The Checks Tab.mp4 (21.12 MB)
MP4
180 - Building Out The Model Checks Conditional Formatting.mp4 (70.91 MB)
MP4
181 - How To Use What Youve Built.mp4 (73.39 MB)
MP4
182 - Operating Shortfalls IRR Partitioning Finalization.mp4 (105.28 MB)
MP4
185 - Where To Go From Here.mp4 (41.17 MB)
MP4
186 - A Final Word.mp4 (25.46 MB)
MP4
10 - Modeling Dynamic Commercial Real Estate Leases.mp4 (29.9 MB)
MP4
11 - Modeling CRE Operating Expenses.mp4 (20.9 MB)
MP4
12 - Building Out The Monthly Cash Flow Statement.mp4 (37.7 MB)
MP4
13 - Modeling The Annual Cash Flow RollUp.mp4 (27.6 MB)
MP4
14 - Building Out The Financing Tab.mp4 (30.63 MB)
MP4
15 - Construction Budget Modeling Automatic Checks.mp4 (30.47 MB)
MP4
8 - The 8 CRE Pro Forma Model Tabs.mp4 (32.91 MB)
MP4
9 - Building Out The Summary Dashboard.mp4 (37.4 MB)
MP4
16 - How To Get The Most Out Of This Course.mp4 (32.5 MB)
MP4
17 - Excel Financial Modeling Best Practices Color Coding.mp4 (46.21 MB)
MP4
18 - Removing Gridlines.mp4 (12.53 MB)
MP4
19 - The Entire Sheet Formatting Trick.mp4 (8.83 MB)
MP4
20 - Workbook Iterative Calculations.mp4 (26.79 MB)
MP4
21 - Advanced Excel Settings.mp4 (14.4 MB)
MP4
23 - Building Out The Property Details.mp4 (20.15 MB)
MP4
24 - Formatting The Property Details.mp4 (30.81 MB)
MP4
25 - Building Out Parking Information.mp4 (17.47 MB)
MP4
26 - Modeling Key Acquisition Inputs.mp4 (27.12 MB)
MP4
27 - Modeling Sale Information.mp4 (31.15 MB)
MP4
28 - Investor Distribution Frequency ProjectLevel Fees.mp4 (28.08 MB)
MP4
29 - Building Out The Summary Details.mp4 (44.66 MB)
MP4
30 - The Capital Budget Breakdown.mp4 (56.2 MB)
MP4
31 - Sources Uses Part 1.mp4 (23.25 MB)
MP4
32 - Sources Uses Part 2.mp4 (39.11 MB)
MP4
33 - Building Out Unlevered Levered Return Metrics.mp4 (59.35 MB)
MP4
34 - Modeling Sale Details The Formula BuildOut.mp4 (88.04 MB)
MP4
35 - IRR Partitioning.mp4 (22.09 MB)
MP4
36 - Sensitivity Analysis BuildOut.mp4 (37.46 MB)
MP4
37 - Combining Dynamic Text Values.mp4 (36.92 MB)
MP4
38 - Creating Dynamic Hold Period Intervals.mp4 (33.39 MB)
MP4
39 - Sensitivity Analysis Finalization.mp4 (27.55 MB)
MP4
40 - The Consolidated Rent Roll.mp4 (27.73 MB)
MP4
41 - Modeling The Weighted Average Lease Term WALT.mp4 (60.67 MB)
MP4
43 - Building Out The CRE Leases Tab.mp4 (10.98 MB)
MP4
44 - InPlace Tenant Details.mp4 (26.49 MB)
MP4
45 - Formatting The InPlace Tenant Details.mp4 (14.51 MB)
MP4
46 - Building Out The Expense Reimbursement Structure.mp4 (46.98 MB)
MP4
47 - Modeling The Rent Escalation Schedule.mp4 (56.8 MB)
MP4
48 - ReLeasing Assumptions.mp4 (68.2 MB)
MP4
49 - ReLeasing Costs.mp4 (41.62 MB)
MP4
50 - Modeling Percentage Rent.mp4 (36.41 MB)
MP4
51 - Tenant Cash Flow Timeline BuildOut.mp4 (52.15 MB)
MP4
52 - Timeline Formatting Tenant SetUp.mp4 (33.78 MB)
MP4
53 - Modeling InPlace Base Rent.mp4 (96.84 MB)
MP4
54 - The InPlace Operating Expense BuildOut.mp4 (25.75 MB)
MP4
55 - Modeling InPlace Reimbursements.mp4 (147.13 MB)
MP4
56 - Modeling Percentage Rent.mp4 (74.38 MB)
MP4
58 - Modeling UpFront Free Rent.mp4 (30.63 MB)
MP4
59 - Modeling ReLeasing Base Rent.mp4 (117.23 MB)
MP4
60 - Modeling ReLeasing Free Rent.mp4 (44.76 MB)
MP4
61 - Modeling ReLeasing Reimbursements.mp4 (79.81 MB)
MP4
62 - Modeling UpFront Tenant Improvements.mp4 (100.77 MB)
MP4
63 - Modeling UpFront Leasing Commissions.mp4 (93.97 MB)
MP4
64 - Modeling ReLeasing Tenant Improvements.mp4 (71.64 MB)
MP4
65 - Modeling ReLeasing Leasing Commissions.mp4 (109.39 MB)
MP4
66 - Total Suite Cash Flow Finalization.mp4 (68.65 MB)
MP4
67 - Creating Additional Leases.mp4 (59.23 MB)
MP4
68 - Creating Additional Lease Cash Flows.mp4 (71.71 MB)
MP4
69 - Formatting Pro Rata Share Calculations.mp4 (50.84 MB)
MP4
70 - Grouping Tenants.mp4 (45.13 MB)
MP4
72 - Building Out The Expenses Tab.mp4 (12.35 MB)
MP4
73 - T12 Hold Period Operating Expense Modeling.mp4 (42.41 MB)
MP4
74 - Modeling Operating Expense Assumptions.mp4 (28.14 MB)
MP4
75 - Property Tax Information Inputs.mp4 (49.87 MB)
MP4
76 - Modeling Credit Loss Property Tax Growth Rates.mp4 (32.71 MB)
MP4
77 - Property Tax Modeling.mp4 (60.58 MB)
MP4
78 - Monthly Expense Modeling Formatting.mp4 (55.69 MB)
MP4
79 - Modeling Monthly Property Tax Cash Flows.mp4 (64.72 MB)
MP4
80 - Modeling Insurance.mp4 (35.25 MB)
MP4
81 - Modeling CAM Other Expenses.mp4 (64.56 MB)
MP4
83 - Introduction To The Monthly Cash Flow Tab.mp4 (71.68 MB)
MP4
84 - Building Out The Monthly Cash Flow Timeline.mp4 (49.84 MB)
MP4
85 - Modeling Revenue Free Rent.mp4 (75.28 MB)
MP4
86 - Modeling Credit Loss Net Rental Income.mp4 (32.31 MB)
MP4
87 - Modeling CAM Reimbursements Percentage Rent.mp4 (33.9 MB)
MP4
88 - Modeling Operating Expenses.mp4 (68.98 MB)
MP4
89 - Modeling TIs LCs.mp4 (74.97 MB)
MP4
90 - Modeling Capital Reserves.mp4 (100.33 MB)
MP4
91 - Modeling Acquisition Information.mp4 (28.11 MB)
MP4
92 - Modeling Sale Information.mp4 (55.3 MB)
MP4
93 - Building Out The Loan Information Section.mp4 (43.82 MB)
MP4
100 - Sizing The Acquisition Loan LTV LTC.mp4 (25.72 MB)
MP4
101 - Sizing The Acquisition Loan DSCR.mp4 (36.34 MB)
MP4
102 - Sizing The Acquisition Loan Debt Yield.mp4 (16.18 MB)
MP4
103 - Sizing The Mezzanine Loan LTV LTC.mp4 (27.83 MB)
MP4
104 - Sizing The Mezzanine Loan DSCR Debt Yield.mp4 (36.24 MB)
MP4
105 - Sizing The Refinance LTV LTC.mp4 (46.29 MB)
MP4
106 - Sizing The Refinance DSCR Debt Yield.mp4 (43.4 MB)
MP4
107 - The Acquisition Financing BuildOut.mp4 (46.05 MB)
MP4
108 - Dynamic Acquisition Loan Balance Modeling.mp4 (36.68 MB)
MP4
109 - Modeling Additional Loan Proceeds.mp4 (32.93 MB)
MP4
110 - Naming Cells For Faster Modeling.mp4 (23.48 MB)
MP4
112 - Chatham Forward Curves.mp4 (33.19 MB)
MP4
113 - Building In The Floating Interest Rate Index.mp4 (69.49 MB)
MP4
114 - Creating Dynamic Fixed Floating Interest Rates.mp4 (53.26 MB)
MP4
115 - Building Out The Total Loan Payment.mp4 (39.82 MB)
MP4
117 - Modeling Principal Interest Payments.mp4 (26.11 MB)
MP4
118 - Modeling The Acquisition Loan Payoff Prepayment Penalty.mp4 (59.49 MB)
MP4
119 - Creating Acquisition Financing Checks.mp4 (65.66 MB)
MP4
120 - Mezzanine Financing BuildOut.mp4 (60.28 MB)
MP4
121 - Modeling Mezzanine Debt Payments.mp4 (88.04 MB)
MP4
122 - Refinance BuildOut.mp4 (76.7 MB)
MP4
123 - Modeling Additional Refinance Loan Proceeds.mp4 (24.51 MB)
MP4
124 - Modeling Total Refinance Loan Payments.mp4 (55.17 MB)
MP4
125 - Modeling Refinance Principal Interest Payments.mp4 (37.52 MB)
MP4
126 - Modeling The Refinance Loan Payoff Prepayment Penalty.mp4 (73.49 MB)
MP4
128 - Total Payment Formula Update.mp4 (70.49 MB)
MP4
129 - SUMIF Trigger BuildOut.mp4 (39.95 MB)
MP4
95 - Introduction To The Financing Tab.mp4 (20 MB)
MP4
96 - Creating The Loan Information Table.mp4 (38.72 MB)
MP4
97 - Building Out The Loan Metrics.mp4 (43.6 MB)
MP4
98 - Interest Rate Modeling.mp4 (33.9 MB)
MP4
99 - Loan Periods Prepayment.mp4 (26.98 MB)
MP4
131 - Introduction To The Construction Budget Tab.mp4 (38.55 MB)
MP4
132 - Building Out The Construction Budget Line Items.mp4 (24.64 MB)
MP4
133 - Construction Budget Costs Timing.mp4 (40.07 MB)
MP4
134 - StraightLine Construction Cost Modeling.mp4 (43.42 MB)
MP4
135 - Construction Budget Checks Formatting.mp4 (55.67 MB)
MP4
136 - Construction Subtotals MAX and MIN IF.mp4 (79.77 MB)
MP4
137 - Modeling Contingencies.mp4 (76.16 MB)
MP4