种子简介

种子名称： [FreeCourseSite.com] Udemy - The Advanced Real Estate Pro Forma Modeling Master Class
文件类型： 视频
文件数目： 167个文件
文件大小： 8.11 GB
收录时间： 2024-10-14 13:30
已经下载： 3次
资源热度： 23
最近下载： 2024-10-20 15:42

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:e448d3379ef763caf6b98d95fccfe34642b864e6&dn=[FreeCourseSite.com] Udemy - The Advanced Real Estate Pro Forma Modeling Master Class 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - The Advanced Real Estate Pro Forma Modeling Master Class.torrent

1 - Introduction/1 - Introduction.mp414.35MB

1 - Introduction/2 - A Sneak Peek Into What Youll Build.mp424.37MB

1 - Introduction/3 - Who This Course Is For.mp430.66MB

1 - Introduction/4 - About This Course Student Success Stories.mp452.13MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/139 - Modeling Management Fees Construction Expenses.mp441.27MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/140 - Partnership Expense Modeling AcquisitionRefinance Loan Proceed Funding.mp469.73MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/141 - How To Use SUMIF To Model Additional Loan Proceeds.mp445.29MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/142 - Building In Debt Service Modeling The Loan Payoff.mp433.78MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/143 - Modeling Loan Fees.mp474.87MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/144 - Creating Dynamic Working Capital Funding.mp480.6MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/145 - Investor Distribution Modeling Part 1.mp463.72MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/146 - Investor Distribution Modeling Part 2.mp443.91MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/147 - Investor Distribution Modeling Part 3.mp473.62MB

10 - Part 7 Building Out The Monthly Cash Flow Tab Part 2/148 - Cash Flow SUM Formatting Finalization.mp479.82MB

11 - Part 8 Creating The Annual Cash Flow RollUp/150 - Introduction To The Annual CF Tab.mp464.61MB

11 - Part 8 Creating The Annual Cash Flow RollUp/151 - The Annual Cash Flow AllInOne Formula.mp499.71MB

11 - Part 8 Creating The Annual Cash Flow RollUp/152 - Modeling Unlevered CashonCash Returns.mp472.68MB

11 - Part 8 Creating The Annual Cash Flow RollUp/153 - Modeling Levered CashonCash Returns.mp447.5MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/155 - Modeling Asset Management Fees.mp484.41MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/156 - Property Tax Finalization Dynamic Assessed Value Modeling.mp495.22MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/157 - Modeling Tenant Health Ratio.mp434.06MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/158 - Modeling DSCR Debt Yield Total Cost.mp4112.28MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/159 - Capital Budget Modeling.mp432.59MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/160 - Sources Uses Finalization.mp479.36MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/161 - Modeling Levered Return Metrics IRR Equity Multiple CashonCash Return.mp482.03MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/162 - Modeling Unlevered Return Metrics IRR Equity Multiple CashonCash Return.mp456.97MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/163 - Building Out The Property Sale Details.mp448.54MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/164 - Building Out The Consolidated Rent Roll.mp447.58MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/165 - Modeling InPlace Rent.mp430.43MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/166 - Reimbursements Lease Expirations.mp433.34MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/167 - Partitioning The IRR Part 1.mp468.6MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/168 - Partitioning The IRR Part 2.mp466.64MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/170 - Creating The IRR Partitioning Chart.mp424.59MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/171 - Creating The Base Rent Makeup Chart.mp458.82MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/172 - Creating The Dynamic Operating Metrics Over Time Chart.mp474.3MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/173 - Dynamic Operating Metric Cash Flow BuildOut Part 1.mp454.63MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/174 - Dynamic Operating Metric Cash Flow BuildOut Part 2.mp485.06MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/175 - The Dynamic Operating Metric Chart BuildOut.mp451.72MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/176 - Creating The DSCR Over Time Chart Part 1.mp446.52MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/177 - Creating The DSCR Over Time Chart Part 2.mp430.14MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/178 - Running The Sensitivity Analysis.mp431.65MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/179 - Creating The Checks Tab.mp421.12MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/180 - Building Out The Model Checks Conditional Formatting.mp470.91MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/181 - How To Use What Youve Built.mp473.39MB

12 - Part 9 Dynamic Chart Creation Finalizing The Advanced Pro Forma Model/182 - Operating Shortfalls IRR Partitioning Finalization.mp4105.28MB

13 - Wrapping Up/185 - Where To Go From Here.mp441.17MB

13 - Wrapping Up/186 - A Final Word.mp425.46MB

2 - The Advanced Real Estate Pro Forma Model/10 - Modeling Dynamic Commercial Real Estate Leases.mp429.9MB

2 - The Advanced Real Estate Pro Forma Model/11 - Modeling CRE Operating Expenses.mp420.9MB

2 - The Advanced Real Estate Pro Forma Model/12 - Building Out The Monthly Cash Flow Statement.mp437.7MB

2 - The Advanced Real Estate Pro Forma Model/13 - Modeling The Annual Cash Flow RollUp.mp427.6MB

2 - The Advanced Real Estate Pro Forma Model/14 - Building Out The Financing Tab.mp430.63MB

2 - The Advanced Real Estate Pro Forma Model/15 - Construction Budget Modeling Automatic Checks.mp430.47MB

2 - The Advanced Real Estate Pro Forma Model/8 - The 8 CRE Pro Forma Model Tabs.mp432.91MB

2 - The Advanced Real Estate Pro Forma Model/9 - Building Out The Summary Dashboard.mp437.4MB

3 - Advanced Real Estate Pro Forma Modeling Fundamentals/16 - How To Get The Most Out Of This Course.mp432.5MB

3 - Advanced Real Estate Pro Forma Modeling Fundamentals/17 - Excel Financial Modeling Best Practices Color Coding.mp446.21MB

3 - Advanced Real Estate Pro Forma Modeling Fundamentals/18 - Removing Gridlines.mp412.53MB

3 - Advanced Real Estate Pro Forma Modeling Fundamentals/19 - The Entire Sheet Formatting Trick.mp48.83MB

3 - Advanced Real Estate Pro Forma Modeling Fundamentals/20 - Workbook Iterative Calculations.mp426.79MB

3 - Advanced Real Estate Pro Forma Modeling Fundamentals/21 - Advanced Excel Settings.mp414.4MB

4 - Part 1 Building Out The Summary Dashboard/23 - Building Out The Property Details.mp420.15MB

4 - Part 1 Building Out The Summary Dashboard/24 - Formatting The Property Details.mp430.81MB

4 - Part 1 Building Out The Summary Dashboard/25 - Building Out Parking Information.mp417.47MB

4 - Part 1 Building Out The Summary Dashboard/26 - Modeling Key Acquisition Inputs.mp427.12MB

4 - Part 1 Building Out The Summary Dashboard/27 - Modeling Sale Information.mp431.15MB

4 - Part 1 Building Out The Summary Dashboard/28 - Investor Distribution Frequency ProjectLevel Fees.mp428.08MB

4 - Part 1 Building Out The Summary Dashboard/29 - Building Out The Summary Details.mp444.66MB

4 - Part 1 Building Out The Summary Dashboard/30 - The Capital Budget Breakdown.mp456.2MB

4 - Part 1 Building Out The Summary Dashboard/31 - Sources Uses Part 1.mp423.25MB

4 - Part 1 Building Out The Summary Dashboard/32 - Sources Uses Part 2.mp439.11MB

4 - Part 1 Building Out The Summary Dashboard/33 - Building Out Unlevered Levered Return Metrics.mp459.35MB

4 - Part 1 Building Out The Summary Dashboard/34 - Modeling Sale Details The Formula BuildOut.mp488.04MB

4 - Part 1 Building Out The Summary Dashboard/35 - IRR Partitioning.mp422.09MB

4 - Part 1 Building Out The Summary Dashboard/36 - Sensitivity Analysis BuildOut.mp437.46MB

4 - Part 1 Building Out The Summary Dashboard/37 - Combining Dynamic Text Values.mp436.92MB

4 - Part 1 Building Out The Summary Dashboard/38 - Creating Dynamic Hold Period Intervals.mp433.39MB

4 - Part 1 Building Out The Summary Dashboard/39 - Sensitivity Analysis Finalization.mp427.55MB

4 - Part 1 Building Out The Summary Dashboard/40 - The Consolidated Rent Roll.mp427.73MB

4 - Part 1 Building Out The Summary Dashboard/41 - Modeling The Weighted Average Lease Term WALT.mp460.67MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/43 - Building Out The CRE Leases Tab.mp410.98MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/44 - InPlace Tenant Details.mp426.49MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/45 - Formatting The InPlace Tenant Details.mp414.51MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/46 - Building Out The Expense Reimbursement Structure.mp446.98MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/47 - Modeling The Rent Escalation Schedule.mp456.8MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/48 - ReLeasing Assumptions.mp468.2MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/49 - ReLeasing Costs.mp441.62MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/50 - Modeling Percentage Rent.mp436.41MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/51 - Tenant Cash Flow Timeline BuildOut.mp452.15MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/52 - Timeline Formatting Tenant SetUp.mp433.78MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/53 - Modeling InPlace Base Rent.mp496.84MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/54 - The InPlace Operating Expense BuildOut.mp425.75MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/55 - Modeling InPlace Reimbursements.mp4147.13MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/56 - Modeling Percentage Rent.mp474.38MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/58 - Modeling UpFront Free Rent.mp430.63MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/59 - Modeling ReLeasing Base Rent.mp4117.23MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/60 - Modeling ReLeasing Free Rent.mp444.76MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/61 - Modeling ReLeasing Reimbursements.mp479.81MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/62 - Modeling UpFront Tenant Improvements.mp4100.77MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/63 - Modeling UpFront Leasing Commissions.mp493.97MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/64 - Modeling ReLeasing Tenant Improvements.mp471.64MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/65 - Modeling ReLeasing Leasing Commissions.mp4109.39MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/66 - Total Suite Cash Flow Finalization.mp468.65MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/67 - Creating Additional Leases.mp459.23MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/68 - Creating Additional Lease Cash Flows.mp471.71MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/69 - Formatting Pro Rata Share Calculations.mp450.84MB

5 - Part 2 Dynamic Commercial Real Estate Lease Modeling/70 - Grouping Tenants.mp445.13MB

6 - Part 3 CRE Expense Modeling/72 - Building Out The Expenses Tab.mp412.35MB

6 - Part 3 CRE Expense Modeling/73 - T12 Hold Period Operating Expense Modeling.mp442.41MB

6 - Part 3 CRE Expense Modeling/74 - Modeling Operating Expense Assumptions.mp428.14MB

6 - Part 3 CRE Expense Modeling/75 - Property Tax Information Inputs.mp449.87MB

6 - Part 3 CRE Expense Modeling/76 - Modeling Credit Loss Property Tax Growth Rates.mp432.71MB

6 - Part 3 CRE Expense Modeling/77 - Property Tax Modeling.mp460.58MB

6 - Part 3 CRE Expense Modeling/78 - Monthly Expense Modeling Formatting.mp455.69MB

6 - Part 3 CRE Expense Modeling/79 - Modeling Monthly Property Tax Cash Flows.mp464.72MB

6 - Part 3 CRE Expense Modeling/80 - Modeling Insurance.mp435.25MB

6 - Part 3 CRE Expense Modeling/81 - Modeling CAM Other Expenses.mp464.56MB

7 - Part 4 Building Out The Monthly Cash Flows/83 - Introduction To The Monthly Cash Flow Tab.mp471.68MB

7 - Part 4 Building Out The Monthly Cash Flows/84 - Building Out The Monthly Cash Flow Timeline.mp449.84MB

7 - Part 4 Building Out The Monthly Cash Flows/85 - Modeling Revenue Free Rent.mp475.28MB

7 - Part 4 Building Out The Monthly Cash Flows/86 - Modeling Credit Loss Net Rental Income.mp432.31MB

7 - Part 4 Building Out The Monthly Cash Flows/87 - Modeling CAM Reimbursements Percentage Rent.mp433.9MB

7 - Part 4 Building Out The Monthly Cash Flows/88 - Modeling Operating Expenses.mp468.98MB

7 - Part 4 Building Out The Monthly Cash Flows/89 - Modeling TIs LCs.mp474.97MB

7 - Part 4 Building Out The Monthly Cash Flows/90 - Modeling Capital Reserves.mp4100.33MB

7 - Part 4 Building Out The Monthly Cash Flows/91 - Modeling Acquisition Information.mp428.11MB

7 - Part 4 Building Out The Monthly Cash Flows/92 - Modeling Sale Information.mp455.3MB

7 - Part 4 Building Out The Monthly Cash Flows/93 - Building Out The Loan Information Section.mp443.82MB

8 - Part 5 Modeling Advanced Financing Structures/100 - Sizing The Acquisition Loan LTV LTC.mp425.72MB

8 - Part 5 Modeling Advanced Financing Structures/101 - Sizing The Acquisition Loan DSCR.mp436.34MB

8 - Part 5 Modeling Advanced Financing Structures/102 - Sizing The Acquisition Loan Debt Yield.mp416.18MB

8 - Part 5 Modeling Advanced Financing Structures/103 - Sizing The Mezzanine Loan LTV LTC.mp427.83MB

8 - Part 5 Modeling Advanced Financing Structures/104 - Sizing The Mezzanine Loan DSCR Debt Yield.mp436.24MB

8 - Part 5 Modeling Advanced Financing Structures/105 - Sizing The Refinance LTV LTC.mp446.29MB

8 - Part 5 Modeling Advanced Financing Structures/106 - Sizing The Refinance DSCR Debt Yield.mp443.4MB

8 - Part 5 Modeling Advanced Financing Structures/107 - The Acquisition Financing BuildOut.mp446.05MB

8 - Part 5 Modeling Advanced Financing Structures/108 - Dynamic Acquisition Loan Balance Modeling.mp436.68MB

8 - Part 5 Modeling Advanced Financing Structures/109 - Modeling Additional Loan Proceeds.mp432.93MB

8 - Part 5 Modeling Advanced Financing Structures/110 - Naming Cells For Faster Modeling.mp423.48MB

8 - Part 5 Modeling Advanced Financing Structures/112 - Chatham Forward Curves.mp433.19MB

8 - Part 5 Modeling Advanced Financing Structures/113 - Building In The Floating Interest Rate Index.mp469.49MB

8 - Part 5 Modeling Advanced Financing Structures/114 - Creating Dynamic Fixed Floating Interest Rates.mp453.26MB

8 - Part 5 Modeling Advanced Financing Structures/115 - Building Out The Total Loan Payment.mp439.82MB

8 - Part 5 Modeling Advanced Financing Structures/117 - Modeling Principal Interest Payments.mp426.11MB

8 - Part 5 Modeling Advanced Financing Structures/118 - Modeling The Acquisition Loan Payoff Prepayment Penalty.mp459.49MB

8 - Part 5 Modeling Advanced Financing Structures/119 - Creating Acquisition Financing Checks.mp465.66MB

8 - Part 5 Modeling Advanced Financing Structures/120 - Mezzanine Financing BuildOut.mp460.28MB

8 - Part 5 Modeling Advanced Financing Structures/121 - Modeling Mezzanine Debt Payments.mp488.04MB

8 - Part 5 Modeling Advanced Financing Structures/122 - Refinance BuildOut.mp476.7MB

8 - Part 5 Modeling Advanced Financing Structures/123 - Modeling Additional Refinance Loan Proceeds.mp424.51MB

8 - Part 5 Modeling Advanced Financing Structures/124 - Modeling Total Refinance Loan Payments.mp455.17MB

8 - Part 5 Modeling Advanced Financing Structures/125 - Modeling Refinance Principal Interest Payments.mp437.52MB

8 - Part 5 Modeling Advanced Financing Structures/126 - Modeling The Refinance Loan Payoff Prepayment Penalty.mp473.49MB

8 - Part 5 Modeling Advanced Financing Structures/128 - Total Payment Formula Update.mp470.49MB

8 - Part 5 Modeling Advanced Financing Structures/129 - SUMIF Trigger BuildOut.mp439.95MB

8 - Part 5 Modeling Advanced Financing Structures/95 - Introduction To The Financing Tab.mp420MB

8 - Part 5 Modeling Advanced Financing Structures/96 - Creating The Loan Information Table.mp438.72MB

8 - Part 5 Modeling Advanced Financing Structures/97 - Building Out The Loan Metrics.mp443.6MB

8 - Part 5 Modeling Advanced Financing Structures/98 - Interest Rate Modeling.mp433.9MB

8 - Part 5 Modeling Advanced Financing Structures/99 - Loan Periods Prepayment.mp426.98MB

9 - Part 6 Creating A Dynamic Construction Budget/131 - Introduction To The Construction Budget Tab.mp438.55MB

9 - Part 6 Creating A Dynamic Construction Budget/132 - Building Out The Construction Budget Line Items.mp424.64MB

9 - Part 6 Creating A Dynamic Construction Budget/133 - Construction Budget Costs Timing.mp440.07MB

9 - Part 6 Creating A Dynamic Construction Budget/134 - StraightLine Construction Cost Modeling.mp443.42MB

9 - Part 6 Creating A Dynamic Construction Budget/135 - Construction Budget Checks Formatting.mp455.67MB

9 - Part 6 Creating A Dynamic Construction Budget/136 - Construction Subtotals MAX and MIN IF.mp479.77MB

9 - Part 6 Creating A Dynamic Construction Budget/137 - Modeling Contingencies.mp476.16MB