FreeCourseSite com Udemy The Advanced Real Estate Pro Forma Modeling Master Class

FreeCourseSite com Udemy The Advanced Real Estate Pro Forma Modeling Master Class

Name	[FreeCourseSite.com] Udemy - The Advanced Real Estate Pro Forma Modeling Master Class	DOWNLOAD Copy Link
Total Size	8.7 GB
Total Files	374
Last Seen	2024-12-23 23:34
Hash	E448D3379EF763CAF6B98D95FCCFE34642B864E6

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1 - Introduction/
1 - Introduction English.vtt	1.2 KB
1 - Introduction.mp4	15.1 MB
2 - A Sneak Peek Into What Youll Build English.vtt	2.7 KB
2 - A Sneak Peek Into What Youll Build.mp4	25.6 MB
3 - Who This Course Is For English.vtt	3.0 KB
3 - Who This Course Is For.mp4	32.1 MB
4 - About This Course Student Success Stories English.vtt	5.3 KB
4 - About This Course Student Success Stories.mp4	54.7 MB
5 - Advanced-Pro-Forma-Model-Key-Definitions.pdf	195.9 KB
5 - Key Terms Definitions Cheat Sheet.html	0.2 KB
6 - Advanced-Pro-Forma-Excel-Hotkeys-and-Shortcuts.pdf	441.2 KB
6 - Excel Shortcuts Hotkeys Cheat Sheet.html	0.1 KB
7 - Disclaimer.html	2.2 KB
/10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/
139 - Modeling Management Fees Construction Expenses English.vtt	4.8 KB
139 - Modeling Management Fees Construction Expenses.mp4	43.3 MB
140 - Partnership Expense Modeling AcquisitionRefinance Loan Proceed Funding English.vtt	8.1 KB
140 - Partnership Expense Modeling AcquisitionRefinance Loan Proceed Funding.mp4	73.1 MB
141 - How To Use SUMIF To Model Additional Loan Proceeds English.vtt	5.1 KB
141 - How To Use SUMIF To Model Additional Loan Proceeds.mp4	47.5 MB
142 - Building In Debt Service Modeling The Loan Payoff English.vtt	4.4 KB
142 - Building In Debt Service Modeling The Loan Payoff.mp4	35.4 MB
143 - Modeling Loan Fees English.vtt	8.7 KB
143 - Modeling Loan Fees.mp4	78.5 MB
144 - Creating Dynamic Working Capital Funding English.vtt	11.9 KB
144 - Creating Dynamic Working Capital Funding.mp4	84.5 MB
145 - Investor Distribution Modeling Part 1 English.vtt	7.9 KB
145 - Investor Distribution Modeling Part 1.mp4	66.8 MB
146 - Investor Distribution Modeling Part 2 English.vtt	6.1 KB
146 - Investor Distribution Modeling Part 2.mp4	46.0 MB
147 - Investor Distribution Modeling Part 3 English.vtt	8.8 KB
147 - Investor Distribution Modeling Part 3.mp4	77.2 MB
148 - Cash Flow SUM Formatting Finalization English.vtt	8.3 KB
148 - Cash Flow SUM Formatting Finalization.mp4	83.7 MB
149 - Advanced-Real-Estate-Pro-Forma-Model-Monthly-CF-Part-2.xlsx	1.2 MB
149 - Model Download Review.html	0.4 KB
/.../0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/11 - Part 8 Creating The Annual Cash Flow RollUp/
150 - Introduction To The Annual CF Tab English.vtt	6.9 KB
150 - Introduction To The Annual CF Tab.mp4	67.8 MB
151 - The Annual Cash Flow AllInOne Formula English.vtt	10.5 KB
151 - The Annual Cash Flow AllInOne Formula.mp4	104.6 MB
152 - Modeling Unlevered CashonCash Returns English.vtt	8.7 KB
152 - Modeling Unlevered CashonCash Returns.mp4	76.2 MB
153 - Modeling Levered CashonCash Returns English.vtt	5.8 KB
153 - Modeling Levered CashonCash Returns.mp4	49.8 MB
154 - Advanced-Real-Estate-Pro-Forma-Model-Annual-CF.xlsx	1.2 MB
154 - Model Download Review.html	0.5 KB
/12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/
155 - Modeling Asset Management Fees English.vtt	8.6 KB
155 - Modeling Asset Management Fees.mp4	88.5 MB
156 - Property Tax Finalization Dynamic Assessed Value Modeling English.vtt	10.9 KB
156 - Property Tax Finalization Dynamic Assessed Value Modeling.mp4	99.8 MB
157 - Modeling Tenant Health Ratio English.vtt	3.6 KB
157 - Modeling Tenant Health Ratio.mp4	35.7 MB
158 - Modeling DSCR Debt Yield Total Cost English.vtt	12.5 KB
158 - Modeling DSCR Debt Yield Total Cost.mp4	117.7 MB
159 - Capital Budget Modeling English.vtt	3.7 KB
159 - Capital Budget Modeling.mp4	34.2 MB
160 - Sources Uses Finalization English.vtt	10.1 KB
160 - Sources Uses Finalization.mp4	83.2 MB
161 - Modeling Levered Return Metrics IRR Equity Multiple CashonCash Return English.vtt	9.5 KB
161 - Modeling Levered Return Metrics IRR Equity Multiple CashonCash Return.mp4	86.0 MB
162 - Modeling Unlevered Return Metrics IRR Equity Multiple CashonCash Return English.vtt	6.2 KB
162 - Modeling Unlevered Return Metrics IRR Equity Multiple CashonCash Return.mp4	59.7 MB
163 - Building Out The Property Sale Details English.vtt	5.4 KB
163 - Building Out The Property Sale Details.mp4	50.9 MB
164 - Building Out The Consolidated Rent Roll English.vtt	6.6 KB
164 - Building Out The Consolidated Rent Roll.mp4	49.9 MB
165 - Modeling InPlace Rent English.vtt	3.8 KB
165 - Modeling InPlace Rent.mp4	31.9 MB
166 - Reimbursements Lease Expirations English.vtt	4.9 KB
166 - Reimbursements Lease Expirations.mp4	35.0 MB
167 - Partitioning The IRR Part 1 English.vtt	7.9 KB
167 - Partitioning The IRR Part 1.mp4	71.9 MB
168 - Partitioning The IRR Part 2 English.vtt	7.3 KB
168 - Partitioning The IRR Part 2.mp4	69.9 MB
169 - XNPV Formula Update.html	1.1 KB
170 - Creating The IRR Partitioning Chart English.vtt	3.8 KB
170 - Creating The IRR Partitioning Chart.mp4	25.8 MB
171 - Creating The Base Rent Makeup Chart English.vtt	9.9 KB
171 - Creating The Base Rent Makeup Chart.mp4	61.7 MB
172 - Creating The Dynamic Operating Metrics Over Time Chart English.vtt	10.1 KB
172 - Creating The Dynamic Operating Metrics Over Time Chart.mp4	77.9 MB
173 - Dynamic Operating Metric Cash Flow BuildOut Part 1 English.vtt	7.1 KB
173 - Dynamic Operating Metric Cash Flow BuildOut Part 1.mp4	57.3 MB
174 - Dynamic Operating Metric Cash Flow BuildOut Part 2 English.vtt	10.8 KB
174 - Dynamic Operating Metric Cash Flow BuildOut Part 2.mp4	89.2 MB
175 - The Dynamic Operating Metric Chart BuildOut English.vtt	6.2 KB
175 - The Dynamic Operating Metric Chart BuildOut.mp4	54.2 MB
176 - Creating The DSCR Over Time Chart Part 1 English.vtt	6.0 KB
176 - Creating The DSCR Over Time Chart Part 1.mp4	48.8 MB
177 - Creating The DSCR Over Time Chart Part 2 English.vtt	3.5 KB
177 - Creating The DSCR Over Time Chart Part 2.mp4	31.6 MB
178 - Running The Sensitivity Analysis English.vtt	3.7 KB
178 - Running The Sensitivity Analysis.mp4	33.2 MB
179 - Creating The Checks Tab English.vtt	4.6 KB
179 - Creating The Checks Tab.mp4	22.2 MB
180 - Building Out The Model Checks Conditional Formatting English.vtt	10.9 KB
180 - Building Out The Model Checks Conditional Formatting.mp4	74.4 MB
181 - How To Use What Youve Built English.vtt	8.4 KB
181 - How To Use What Youve Built.mp4	77.0 MB
182 - Operating Shortfalls IRR Partitioning Finalization English.vtt	11.5 KB
182 - Operating Shortfalls IRR Partitioning Finalization.mp4	110.4 MB
183 - Final Model Updates.html	10.8 KB
184 - Advanced-Real-Estate-Pro-Forma-Model-Final.xlsx	1.2 MB
184 - Model Download Review Were Done.html	0.6 KB
/13 - Wrapping Up/
185 - Where To Go From Here English.vtt	3.7 KB
185 - Where To Go From Here.mp4	43.2 MB
186 - A Final Word English.vtt	2.6 KB
186 - A Final Word.mp4	26.7 MB
/14 - Bonus Lecture/
187 - Bonus Lecture The Next Step.html	1.9 KB
/2 - The Advanced Real Estate Pro Forma Model/
10 - Modeling Dynamic Commercial Real Estate Leases English.vtt	3.0 KB
10 - Modeling Dynamic Commercial Real Estate Leases.mp4	31.4 MB
11 - Modeling CRE Operating Expenses English.vtt	2.1 KB
11 - Modeling CRE Operating Expenses.mp4	21.9 MB
12 - Building Out The Monthly Cash Flow Statement English.vtt	3.6 KB
12 - Building Out The Monthly Cash Flow Statement.mp4	39.5 MB
13 - Modeling The Annual Cash Flow RollUp English.vtt	2.6 KB
13 - Modeling The Annual Cash Flow RollUp.mp4	28.9 MB
14 - Building Out The Financing Tab English.vtt	3.0 KB
14 - Building Out The Financing Tab.mp4	32.1 MB
15 - Construction Budget Modeling Automatic Checks English.vtt	3.3 KB
15 - Construction Budget Modeling Automatic Checks.mp4	31.9 MB
8 - The 8 CRE Pro Forma Model Tabs English.vtt	3.2 KB
8 - The 8 CRE Pro Forma Model Tabs.mp4	34.5 MB
9 - Building Out The Summary Dashboard English.vtt	3.4 KB
9 - Building Out The Summary Dashboard.mp4	39.2 MB
/.../0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/3 - Advanced Real Estate Pro Forma Modeling Fundamentals/
16 - How To Get The Most Out Of This Course English.vtt	3.5 KB
16 - How To Get The Most Out Of This Course.mp4	34.1 MB
17 - Excel Financial Modeling Best Practices Color Coding English.vtt	5.0 KB
17 - Excel Financial Modeling Best Practices Color Coding.mp4	48.5 MB
18 - Removing Gridlines English.vtt	1.8 KB
18 - Removing Gridlines.mp4	13.1 MB
19 - The Entire Sheet Formatting Trick English.vtt	2.0 KB
19 - The Entire Sheet Formatting Trick.mp4	9.3 MB
20 - Workbook Iterative Calculations English.vtt	3.5 KB
20 - Workbook Iterative Calculations.mp4	28.1 MB
21 - Advanced Excel Settings English.vtt	2.5 KB
21 - Advanced Excel Settings.mp4	15.1 MB
22 - Downloading Macros Optional.html	1.4 KB
/4 - Part 1 Building Out The Summary Dashboard/
23 - Building Out The Property Details English.vtt	4.4 KB
23 - Building Out The Property Details.mp4	21.1 MB
24 - Formatting The Property Details English.vtt	7.6 KB
24 - Formatting The Property Details.mp4	32.3 MB
25 - Building Out Parking Information English.vtt	4.4 KB
25 - Building Out Parking Information.mp4	18.3 MB
26 - Modeling Key Acquisition Inputs English.vtt	6.9 KB
26 - Modeling Key Acquisition Inputs.mp4	28.4 MB
27 - Modeling Sale Information English.vtt	6.2 KB
27 - Modeling Sale Information.mp4	32.7 MB
28 - Investor Distribution Frequency ProjectLevel Fees English.vtt	6.3 KB
28 - Investor Distribution Frequency ProjectLevel Fees.mp4	29.4 MB
29 - Building Out The Summary Details English.vtt	8.5 KB
29 - Building Out The Summary Details.mp4	46.8 MB
30 - The Capital Budget Breakdown English.vtt	9.1 KB
30 - The Capital Budget Breakdown.mp4	58.9 MB
31 - Sources Uses Part 1 English.vtt	3.7 KB
31 - Sources Uses Part 1.mp4	24.4 MB
32 - Sources Uses Part 2 English.vtt	5.9 KB
32 - Sources Uses Part 2.mp4	41.0 MB
33 - Building Out Unlevered Levered Return Metrics English.vtt	8.2 KB
33 - Building Out Unlevered Levered Return Metrics.mp4	62.2 MB
34 - Modeling Sale Details The Formula BuildOut English.vtt	11.7 KB
34 - Modeling Sale Details The Formula BuildOut.mp4	92.3 MB
35 - IRR Partitioning English.vtt	2.7 KB
35 - IRR Partitioning.mp4	23.2 MB
36 - Sensitivity Analysis BuildOut English.vtt	4.7 KB
36 - Sensitivity Analysis BuildOut.mp4	39.3 MB
37 - Combining Dynamic Text Values English.vtt	5.1 KB
37 - Combining Dynamic Text Values.mp4	38.7 MB
38 - Creating Dynamic Hold Period Intervals English.vtt	5.5 KB
38 - Creating Dynamic Hold Period Intervals.mp4	35.0 MB
39 - Sensitivity Analysis Finalization English.vtt	4.8 KB
39 - Sensitivity Analysis Finalization.mp4	28.9 MB
40 - The Consolidated Rent Roll English.vtt	5.3 KB
40 - The Consolidated Rent Roll.mp4	29.1 MB
41 - Modeling The Weighted Average Lease Term WALT English.vtt	9.6 KB
41 - Modeling The Weighted Average Lease Term WALT.mp4	63.6 MB
42 - Advanced-Real-Estate-Pro-Forma-Model-Summary.xlsx	17.6 KB
42 - Model Download Review.html	0.5 KB
/5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/
43 - Building Out The CRE Leases Tab English.vtt	1.0 KB
43 - Building Out The CRE Leases Tab.mp4	11.5 MB
44 - InPlace Tenant Details English.vtt	6.9 KB
44 - InPlace Tenant Details.mp4	27.8 MB
45 - Formatting The InPlace Tenant Details English.vtt	4.2 KB
45 - Formatting The InPlace Tenant Details.mp4	15.2 MB
46 - Building Out The Expense Reimbursement Structure English.vtt	11.3 KB
46 - Building Out The Expense Reimbursement Structure.mp4	49.3 MB
47 - Modeling The Rent Escalation Schedule English.vtt	11.2 KB
47 - Modeling The Rent Escalation Schedule.mp4	59.6 MB
48 - ReLeasing Assumptions English.vtt	11.2 KB
48 - ReLeasing Assumptions.mp4	71.5 MB
49 - ReLeasing Costs English.vtt	8.7 KB
49 - ReLeasing Costs.mp4	43.6 MB
50 - Modeling Percentage Rent English.vtt	8.1 KB
50 - Modeling Percentage Rent.mp4	38.2 MB
51 - Tenant Cash Flow Timeline BuildOut English.vtt	11.0 KB
51 - Tenant Cash Flow Timeline BuildOut.mp4	54.7 MB
52 - Timeline Formatting Tenant SetUp English.vtt	5.5 KB
52 - Timeline Formatting Tenant SetUp.mp4	35.4 MB
53 - Modeling InPlace Base Rent English.vtt	13.7 KB
53 - Modeling InPlace Base Rent.mp4	101.5 MB
54 - The InPlace Operating Expense BuildOut English.vtt	4.2 KB
54 - The InPlace Operating Expense BuildOut.mp4	27.0 MB
55 - Modeling InPlace Reimbursements English.vtt	19.2 KB
55 - Modeling InPlace Reimbursements.mp4	154.3 MB
56 - Modeling Percentage Rent English.vtt	10.0 KB
56 - Modeling Percentage Rent.mp4	78.0 MB
57 - Percentage Rent Update.html	1.0 KB
58 - Modeling UpFront Free Rent English.vtt	4.0 KB
58 - Modeling UpFront Free Rent.mp4	32.1 MB
59 - Modeling ReLeasing Base Rent English.vtt	14.9 KB
59 - Modeling ReLeasing Base Rent.mp4	122.9 MB
60 - Modeling ReLeasing Free Rent English.vtt	5.3 KB
60 - Modeling ReLeasing Free Rent.mp4	46.9 MB
61 - Modeling ReLeasing Reimbursements English.vtt	9.3 KB
61 - Modeling ReLeasing Reimbursements.mp4	83.7 MB
62 - Modeling UpFront Tenant Improvements English.vtt	13.3 KB
62 - Modeling UpFront Tenant Improvements.mp4	105.7 MB
63 - Modeling UpFront Leasing Commissions English.vtt	11.8 KB
63 - Modeling UpFront Leasing Commissions.mp4	98.5 MB
64 - Modeling ReLeasing Tenant Improvements English.vtt	9.3 KB
64 - Modeling ReLeasing Tenant Improvements.mp4	75.1 MB
65 - Modeling ReLeasing Leasing Commissions English.vtt	13.8 KB
65 - Modeling ReLeasing Leasing Commissions.mp4	114.7 MB
66 - Total Suite Cash Flow Finalization English.vtt	8.7 KB
66 - Total Suite Cash Flow Finalization.mp4	72.0 MB
67 - Creating Additional Leases English.vtt	6.3 KB
67 - Creating Additional Leases.mp4	62.1 MB
68 - Creating Additional Lease Cash Flows English.vtt	7.7 KB
68 - Creating Additional Lease Cash Flows.mp4	75.2 MB
69 - Formatting Pro Rata Share Calculations English.vtt	6.1 KB
69 - Formatting Pro Rata Share Calculations.mp4	53.3 MB
70 - Grouping Tenants English.vtt	5.2 KB
70 - Grouping Tenants.mp4	47.3 MB
71 - Advanced-Real-Estate-Pro-Forma-Model-CRE-Leases.xlsx	656.1 KB
71 - Model Download Review.html	0.4 KB
/6 - Part 3 CRE Expense Modeling/
72 - Building Out The Expenses Tab English.vtt	2.0 KB
72 - Building Out The Expenses Tab.mp4	12.9 MB
73 - T12 Hold Period Operating Expense Modeling English.vtt	9.2 KB
73 - T12 Hold Period Operating Expense Modeling.mp4	44.5 MB
74 - Modeling Operating Expense Assumptions English.vtt	6.4 KB
74 - Modeling Operating Expense Assumptions.mp4	29.5 MB
75 - Property Tax Information Inputs English.vtt	9.4 KB
75 - Property Tax Information Inputs.mp4	52.3 MB
76 - Modeling Credit Loss Property Tax Growth Rates English.vtt	6.1 KB
76 - Modeling Credit Loss Property Tax Growth Rates.mp4	34.3 MB
77 - Property Tax Modeling English.vtt	10.3 KB
77 - Property Tax Modeling.mp4	63.5 MB
78 - Monthly Expense Modeling Formatting English.vtt	7.3 KB
78 - Monthly Expense Modeling Formatting.mp4	58.4 MB
79 - Modeling Monthly Property Tax Cash Flows English.vtt	8.0 KB
79 - Modeling Monthly Property Tax Cash Flows.mp4	67.9 MB
80 - Modeling Insurance English.vtt	4.3 KB
80 - Modeling Insurance.mp4	37.0 MB
81 - Modeling CAM Other Expenses English.vtt	8.6 KB
81 - Modeling CAM Other Expenses.mp4	67.7 MB
82 - Advanced-Real-Estate-Pro-Forma-Model-Expenses.xlsx	942.8 KB
82 - Model Download Review.html	0.5 KB
/7 - Part 4 Building Out The Monthly Cash Flows/
83 - Introduction To The Monthly Cash Flow Tab English.vtt	7.4 KB
83 - Introduction To The Monthly Cash Flow Tab.mp4	75.2 MB
84 - Building Out The Monthly Cash Flow Timeline English.vtt	9.8 KB
84 - Building Out The Monthly Cash Flow Timeline.mp4	52.3 MB
85 - Modeling Revenue Free Rent English.vtt	12.1 KB
85 - Modeling Revenue Free Rent.mp4	78.9 MB
86 - Modeling Credit Loss Net Rental Income English.vtt	5.7 KB
86 - Modeling Credit Loss Net Rental Income.mp4	33.9 MB
87 - Modeling CAM Reimbursements Percentage Rent English.vtt	4.7 KB
87 - Modeling CAM Reimbursements Percentage Rent.mp4	35.5 MB
88 - Modeling Operating Expenses English.vtt	7.9 KB
88 - Modeling Operating Expenses.mp4	72.3 MB
89 - Modeling TIs LCs English.vtt	7.5 KB
89 - Modeling TIs LCs.mp4	78.6 MB
90 - Modeling Capital Reserves English.vtt	11.0 KB
90 - Modeling Capital Reserves.mp4	105.2 MB
91 - Modeling Acquisition Information English.vtt	4.2 KB
91 - Modeling Acquisition Information.mp4	29.5 MB
92 - Modeling Sale Information English.vtt	7.7 KB
92 - Modeling Sale Information.mp4	58.0 MB
93 - Building Out The Loan Information Section English.vtt	7.6 KB
93 - Building Out The Loan Information Section.mp4	46.0 MB
94 - Advanced-Real-Estate-Pro-Forma-Model-Monthly-CF.xlsx	1.1 MB
94 - Model Download Review.html	0.5 KB
/8 - Part 5 Modeling Advanced Financing Structures/
100 - Sizing The Acquisition Loan LTV LTC English.vtt	4.1 KB
100 - Sizing The Acquisition Loan LTV LTC.mp4	27.0 MB
101 - Sizing The Acquisition Loan DSCR English.vtt	6.2 KB
101 - Sizing The Acquisition Loan DSCR.mp4	38.1 MB
102 - Sizing The Acquisition Loan Debt Yield English.vtt	2.9 KB
102 - Sizing The Acquisition Loan Debt Yield.mp4	17.0 MB
103 - Sizing The Mezzanine Loan LTV LTC English.vtt	5.2 KB
103 - Sizing The Mezzanine Loan LTV LTC.mp4	29.2 MB
104 - Sizing The Mezzanine Loan DSCR Debt Yield English.vtt	6.3 KB
104 - Sizing The Mezzanine Loan DSCR Debt Yield.mp4	38.0 MB
105 - Sizing The Refinance LTV LTC English.vtt	7.1 KB
105 - Sizing The Refinance LTV LTC.mp4	48.5 MB
106 - Sizing The Refinance DSCR Debt Yield English.vtt	6.9 KB
106 - Sizing The Refinance DSCR Debt Yield.mp4	45.5 MB
107 - The Acquisition Financing BuildOut English.vtt	7.8 KB
107 - The Acquisition Financing BuildOut.mp4	48.3 MB
108 - Dynamic Acquisition Loan Balance Modeling English.vtt	5.4 KB
108 - Dynamic Acquisition Loan Balance Modeling.mp4	38.5 MB
109 - Modeling Additional Loan Proceeds English.vtt	4.7 KB
109 - Modeling Additional Loan Proceeds.mp4	34.5 MB
110 - Naming Cells For Faster Modeling English.vtt	2.7 KB
110 - Naming Cells For Faster Modeling.mp4	24.6 MB
111 - Chatham Forward Curves Link.html	0.4 KB
112 - Chatham Forward Curves English.vtt	4.6 KB
112 - Chatham Forward Curves.mp4	34.8 MB
113 - Building In The Floating Interest Rate Index English.vtt	12.2 KB
113 - Building In The Floating Interest Rate Index.mp4	72.9 MB
114 - Creating Dynamic Fixed Floating Interest Rates English.vtt	7.2 KB
114 - Creating Dynamic Fixed Floating Interest Rates.mp4	55.8 MB
115 - Building Out The Total Loan Payment English.vtt	5.2 KB
115 - Building Out The Total Loan Payment.mp4	41.8 MB
116 - Total Loan Payment Formula Update.html	1.5 KB
117 - Modeling Principal Interest Payments English.vtt	3.7 KB
117 - Modeling Principal Interest Payments.mp4	27.4 MB
118 - Modeling The Acquisition Loan Payoff Prepayment Penalty English.vtt	7.4 KB
118 - Modeling The Acquisition Loan Payoff Prepayment Penalty.mp4	62.4 MB
119 - Creating Acquisition Financing Checks English.vtt	7.6 KB
119 - Creating Acquisition Financing Checks.mp4	68.8 MB
120 - Mezzanine Financing BuildOut English.vtt	6.4 KB
120 - Mezzanine Financing BuildOut.mp4	63.2 MB
121 - Modeling Mezzanine Debt Payments English.vtt	8.7 KB
121 - Modeling Mezzanine Debt Payments.mp4	92.3 MB
122 - Refinance BuildOut English.vtt	7.6 KB
122 - Refinance BuildOut.mp4	80.4 MB
123 - Modeling Additional Refinance Loan Proceeds English.vtt	2.7 KB
123 - Modeling Additional Refinance Loan Proceeds.mp4	25.7 MB
124 - Modeling Total Refinance Loan Payments English.vtt	5.7 KB
124 - Modeling Total Refinance Loan Payments.mp4	57.9 MB
125 - Modeling Refinance Principal Interest Payments English.vtt	3.9 KB
125 - Modeling Refinance Principal Interest Payments.mp4	39.3 MB
126 - Modeling The Refinance Loan Payoff Prepayment Penalty English.vtt	7.5 KB
126 - Modeling The Refinance Loan Payoff Prepayment Penalty.mp4	77.1 MB
127 - Refinancing Prepayment Penalty Formula Update.html	0.8 KB
128 - Total Payment Formula Update English.vtt	6.9 KB
128 - Total Payment Formula Update.mp4	73.9 MB
129 - SUMIF Trigger BuildOut English.vtt	4.4 KB
129 - SUMIF Trigger BuildOut.mp4	41.9 MB
130 - Advanced-Real-Estate-Pro-Forma-Model-Financing.xlsx	1.1 MB
130 - Model Download Review.html	0.5 KB
95 - Introduction To The Financing Tab English.vtt	1.8 KB
95 - Introduction To The Financing Tab.mp4	21.0 MB
96 - Creating The Loan Information Table English.vtt	10.6 KB
96 - Creating The Loan Information Table.mp4	40.6 MB
97 - Building Out The Loan Metrics English.vtt	9.3 KB
97 - Building Out The Loan Metrics.mp4	45.7 MB
98 - Interest Rate Modeling English.vtt	6.9 KB
98 - Interest Rate Modeling.mp4	35.6 MB
99 - Loan Periods Prepayment English.vtt	4.7 KB
99 - Loan Periods Prepayment.mp4	28.3 MB
/9 - Part 6 Creating A Dynamic Construction Budget/
131 - Introduction To The Construction Budget Tab English.vtt	7.3 KB
131 - Introduction To The Construction Budget Tab.mp4	40.4 MB
132 - Building Out The Construction Budget Line Items English.vtt	5.4 KB
132 - Building Out The Construction Budget Line Items.mp4	25.8 MB
133 - Construction Budget Costs Timing English.vtt	8.1 KB
133 - Construction Budget Costs Timing.mp4	42.0 MB
134 - StraightLine Construction Cost Modeling English.vtt	8.1 KB
134 - StraightLine Construction Cost Modeling.mp4	45.5 MB
135 - Construction Budget Checks Formatting English.vtt	8.5 KB
135 - Construction Budget Checks Formatting.mp4	58.4 MB
136 - Construction Subtotals MAX and MIN IF English.vtt	11.7 KB
136 - Construction Subtotals MAX and MIN IF.mp4	83.6 MB
137 - Modeling Contingencies English.vtt	9.6 KB
137 - Modeling Contingencies.mp4	79.9 MB
138 - Advanced-Real-Estate-Pro-Forma-Model-Construction-Budget.xlsx	1.2 MB
138 - Model Download Review.html	0.5 KB
Total files 374