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