What is Wall Street Prep Real Estate Financial Modeling for Cheap?
This real estate financial modeling course is delivered at the world’s leading real estate private equity firms and academic institutions.
Get 20+ Hours of Video Content + Reusable Real Estate Excel Model Templates
- Get lifetime access to step by step online video training as well as industry-grade reusable real estate excel templates for modeling acquisitions and developments for multifamily, office, retail, industrial properties, including JV & Waterfall Modeling.
Learn from Real Estate practitioners
- Led by real estate private equity expert Aaron Hancock, you’ll not only learn modeling best practices across the different real estate property types, you’ll learn how real estate investors actually evaluate opportunities.
Enhance your Real Estate credentials
- Designed for professionals and students pursuing careers in real estate private equity as well as operators, developers, lenders, individual investors. Enrollment includes the option of sitting for the Real Estate Financial Modeling Certification. Those who successfully pass the exam can present their achievement on their resumes and LinkedIn (see below).
A Comprehensive Real Estate Financial Modeling Program
This course begins with the foundations of real estate finance and excel best practices, adding complexity piece by piece. By the end of the program, learners will build complete, industrial grade multifamily, office, retail and industrial models, including in depth treatment of the modeling of revenues, operating expenses, capital improvements, debt, and joint venture waterfalls
- Real estate financial modeling best practices
- Real estate investment and development theory
- How to utilize historical financials to build a multifamily acquisition model
- How to utilize Argus outputs to build a commercial acquisition model
- How to build a real estate development model
- How to model a debt schedule
- How to model a joint venture waterfall
SAMPLE:
SAMPLE:
What will you learn in Real Estate Financial Modeling?
Introduction to Real Estate Modeling
- Section 1 of our Real Estate Financial Modeling Program. This course provides an introduction to the function of real estate financial models, the challenges presented by bespoke approaches, and Wall Street Prep’s approach to teaching Real Estate Financial Modeling. We will begin with a review of efficiency and formatting fundamentals that will be employed throughout the course. From there, we’ll begin to develop an understanding of the different types of real estate models.
Operating Cash Flow
-
Section 2 of our Real Estate Financial Modeling Program. Real estate is all about cash flow. This module will cover cash flow builds for multifamily and commercial property types. We will build the foundations of revenues and expenses and finish with a discussion on the importance of net operating income. Each section will begin with the characteristics underpinning the cash flow for the property type at hand. After detailed discussions of various revenue and expense methodologies, concepts will be crystalized with step-by-step modeling walkthroughs in Excel.
Non-Operating Cash Flow
- Section 3 of our Real Estate Financial Modeling Program. Although real estate is valued based on operating cash flow, non-operating cash flows are integral to business plans. This module will cover leasing costs for commercial properties, capital improvements and costs associated with buying and selling a property. After detailed discussions of the various cost items within non-operating cash flow, the concepts will be reinforced with step-by-step modeling walkthroughs in Excel.
Debt & Levered Cash Flow
-
Section 4 of our Real Estate Financial Modeling Program. Real estate is a highly levered asset class and an understanding of leverage is critical for any real estate investor. This module will serve as a primer on real estate debt, covering everything from different ways to finance an acquisition, to key terms in loan documents and how to model an amortization schedule. A significant portion of this module is dedicated to understanding the applications of leverage, reviewing key terminology and introducing debt-specific calculations. The module concludes with a step-by-step modeling walkthrough in Excel.
Joint Ventures & Waterfalls
- Section 5 of our Real Estate Financial Modeling Program. The waterfall is infamously part of most real estate interview modeling tests. This module introduces joint ventures and the theory behind waterfalls. After introducing key terminology and reinforcing the underlying theory, considerable time will be spent on a step-by-step walkthrough of how to model a waterfall.
Summarizing & Analyzing the Model
-
Section 6 of our Real Estate Financial Modeling Program. Real estate financial models are tools for projecting the cash flows of a potential investment. The cash flow projections alone are not enough to analyze a potential investment. This module will cover how to summarize the outputs of a model to form the basis of an analysis by discussing key metrics and how to put these metrics into perspective.
Development Modeling
- Section 7 of our Real Estate Financial Modeling Program. Real estate can be bought or built. Up to this point, the course has been focused on buying property. This module will unpack the differences and similarities in modeling a development and an acquisition. Development specific topics such as construction budgets and lease-up will be covered as well as the nuances of development financing. Armed with the real estate financial modeling fundamentals previously discussed, this module will also go into detail on how to model a development step-by-step.
Office Building Acquisition Case Study
- Section 8 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a potential investor. But, many situations – whether a modeling test or first pass at a potential personal investment – necessitate building a model quickly from a blank Excel sheet. This acquisition case study is an opportunity to test everything you’ve learned utilizing the key pieces of information you would have in the real world. After attempting the case study independently, follow along to see how best to stay organized and which “corners to cut” when under time constraints.
Multifamily Building Development Case Study
- Section 9 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a potential investor. But, many situations – whether a modeling test or first pass at a potential personal investment – necessitate building a model quickly from a blank Excel sheet. This development case study is an opportunity to test everything you’ve learned utilizing the key pieces of information as you would in the real world. After attempting the case study independently, follow along to see how best to stay organized and which “corners to cut” when under time constraints.
Wall Street Prep Real Estate Financial Modeling Index:
🖿 1. Real Estate Modeling 1 Introduction
- 📄 #Screenshot.pdf (318.76 KB)
- 📄 RE Introduction to Real Estate Financial Modeling_61ab46d073335.pdf (944.78 KB)
- 🖿 1. COURSE INTRODUCTION
- 📄 1. Course Introduction (1).mp4 (19.95 MB)
- 📄 1. Course Introduction.mp4 (24.81 MB)
- 🖿 2. MODELING BEST PRACTICES
- 📄 2. Formatting Conventions.mp4 (11.73 MB)
- 📄 3. Working with Dates & Timelines.mp4 (65.59 MB)
- 📄 4. Modeling Best Practices Rules of Thumb.mp4 (13.74 MB)
- 📄 5. Modeling Best Practices Key Takeaways.mp4 (2.16 MB)
- 🖿 3. REAL ESTATE MODELING BASICS
- 📄 6. Real Estate Model Structure.mp4 (111.87 MB)
- 📄 7. Real Estate Model Types.mp4 (10.47 MB)
- 📄 8. Argus.mp4 (19.23 MB)
- 🖿 4. QUIZ COURSE REVIEW
- 📄 9. Introduction to Real Estate Financial Modeling Quiz.pdf (37.36 KB)
- 🖿 5. APPENDIX EXCEL SETTINGS FOR MODELING
- 📄 10. Excel Settings for Modeling.mp4 (7.13 MB)
- 📄 11. Excel for Mac Quick Setup.mp4 (23.09 MB)
- 📄 12. Keyboard Shortcuts.mp4 (31.14 MB)
- 🖿 RE Introduction Course Materials
- 📄 Excel-shortcuts-Windows-Mac.pdf (139.67 KB)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
- 📄 excel_2010_shortcuts.pdf (57.64 KB)
- 📄 excel_2013_shortcuts.pdf (58.50 KB)
- 📄 excel_mac_settings.pdf (329.29 KB)
- 📄 excel_mac_shortcuts.pdf (66.14 KB)
🖿 2. Real Estate Modeling 2 Operating Cash Flow
- 📄 #Screenshot.pdf (774.42 KB)
- 📄 RE Real Estate Operating Cash Flow_61ad84340d51a.pdf (1.19 MB)
- 🖿 1. REAL ESTATE FINANCE 101
- 📄 1. Operating Cash Flow Introduction.mp4 (2.49 MB)
- 📄 2. Tenants, Income, Expenses & Cash Flow.mp4 (10.58 MB)
- 📄 3. Property Types.mp4 (18.42 MB)
- 📄 4. Commercial Leases.mp4 (25.16 MB)
- 🖿 2. MODELING REVENUES MULTIFAMILY
- 📄 10. Multifamily Revenue Build – Method 1 – Model Layout.mp4 (21.19 MB)
- 📄 11. Multifamily Revenue Build – Method 1 – Historical Financials.mp4 (98.81 MB)
- 📄 12. Multifamily Revenue Build – Method 1 -Trailing Performance.mp4 (37.34 MB)
- 📄 13. Multifamily Revenue Build – Method 1 – In-Place Income.mp4 (15.41 MB)
- 📄 14. Multifamily Revenue Build – Method 1 – Revenue Assumptions.mp4 (18.71 MB)
- 📄 15. Multifamily Revenue Build – Method 1 – Offensive Capital Expenditures.mp4 (23.97 MB)
- 📄 16. Multifamily Revenue Build – Method 1 – Tracking Units.mp4 (55.28 MB)
- 📄 17. Multifamily Revenue Build – Method 1 – Rental Income.mp4 (16.54 MB)
- 📄 18. Multifamily Revenue Build – Method 1 – Other Revenue.mp4 (19.73 MB)
- 📄 19. Multifamily Revenue Build – Method 1 – Total Income.mp4 (29.25 MB)
- 📄 20. Multifamily Revenue Build – Method 2 – Model Layout.mp4 (26.49 MB)
- 📄 21. Multifamily Revenue Build – Method 2 – Historical Financials.mp4 (19.35 MB)
- 📄 22. Multifamily Revenue Build – Method 2 -Trailing Performance.mp4 (10.50 MB)
- 📄 23. Multifamily Revenue Build – Method 2 – In-Place Income.mp4 (7.33 MB)
- 📄 24. Multifamily Revenue Build – Method 2 – Revenue Assumptions.mp4 (11.60 MB)
- 📄 25. Multifamily Revenue Build – Method 2 – Revenue Build Review.mp4 (2.52 MB)
- 📄 26. Multifamily Revenue Build – Method 2 – Tracking Units.mp4 (17.63 MB)
- 📄 27. Multifamily Revenue Build – Method 2 – Rental Income.mp4 (17.16 MB)
- 📄 28. Multifamily Revenue Build – Method 2 – Other Revenue.mp4 (9.87 MB)
- 📄 29. Multifamily Revenue Build – Method 2 – Total Income.mp4 (9.48 MB)
- 📄 30. Multifamily Revenues Key Takeaways.mp4 (3.75 MB)
- 📄 5. Multifamily Property Characteristics.mp4 (12.06 MB)
- 📄 6. Multifamily Revenue Build – Method 1.mp4 (35.91 MB)
- 📄 7. Multifamily Revenue Build – Method 2.mp4 (19.49 MB)
- 📄 8. Multifamily Revenue Build Comparison.mp4 (6.24 MB)
- 📄 9. Multifamily Revenue – Model Flow.mp4 (6.12 MB)
- 🖿 3. MODELING REVENUES COMMERCIAL
- 📄 31. Commercial Property Introduction.mp4 (614.58 KB)
- 📄 32. Commercial Property Characteristics.mp4 (10.25 MB)
- 📄 33. Commercial Revenue Build.mp4 (41.82 MB)
- 📄 34. Commercial Revenue – Model Flow.mp4 (9.74 MB)
- 📄 35. Commercial Revenue – Model Layout.mp4 (39.14 MB)
- 📄 36. Argus Output Fundamentals.mp4 (60.42 MB)
- 📄 37. Commercial Revenues – Toggling & Combining Argus Outputs.mp4 (51.93 MB)
- 📄 38. Commercial Revenues – Populating the Model Tab.mp4 (13.84 MB)
- 📄 39. Occupancy & Rent Per Square Foot.mp4 (20.16 MB)
- 📄 40. Retail Percentage Rent.mp4 (40.68 MB)
- 📄 41. Commercial Revenues Key Takeaways.mp4 (7.84 MB)
- 🖿 4. MODELING EXPENSES MULTIFAMILY
- 📄 .getxfer.45640.182.mega (0.00 B)
- 📄 42. Modeling Expenses Introduction.mp4 (1.46 MB)
- 📄 43. Multifamily Expense Build.mp4 (5.96 MB)
- 📄 44. Expense Line Items.mp4 (13.16 MB)
- 📄 45. Multifamily Expenses – Model Flow.mp4 (1.25 MB)
- 📄 46. Multifamily Expenses – Model Layout.mp4 (12.71 MB)
- 📄 47. Historical Financials.mp4 (32.68 MB)
- 📄 48. Trailing Performance.mp4 (4.76 MB)
- 📄 49. In-Place Operating Expenses.mp4 (23.56 MB)
- 📄 50. Expense Assumptions.mp4 (2.28 MB)
- 📄 51. Proforma Operating Expenses.mp4 (14.76 MB)
- 📄 52. Multifamily Expenses Key Takeaways.mp4 (2.31 MB)
- 🖿 5. MODELING EXPENSES COMMERCIAL
- 📄 53. Introduction to Commercial Expenses.mp4 (2.05 MB)
- 📄 54. Commercial Expense Build.mp4 (8.67 MB)
- 📄 55. Industrial Expense Build.mp4 (2.57 MB)
- 📄 56. Commercial Expenses – Model Flow.mp4 (1.31 MB)
- 📄 57. Commercial Expenses – Model Layout.mp4 (9.60 MB)
- 📄 58. Commercial Expenses – Argus Output Tagging.mp4 (28.69 MB)
- 📄 59. Commercial Expenses – Toggling & Combining Argus Outputs.mp4 (3.99 MB)
- 📄 60. Commercial Expenses – Populating the Model Tab.mp4 (15.10 MB)
- 📄 61. Commercial Expenses Key Takeaways.mp4 (1.52 MB)
- 🖿 6. NET OPERATING INCOME
- 📄 62. Net Operating Income Introduction.mp4 (560.87 KB)
- 📄 63. Defining Net Operating Income.mp4 (3.93 MB)
- 📄 64. Net Operating Income & Cap Rates.mp4 (19.70 MB)
- 📄 65. Net Operating Income Takeaways.mp4 (1.58 MB)
- 🖿 7. QUIZ COURSE REVIEW
- 📄 Real Estate Operating Cash Flow Quiz.pdf (132.35 KB)
- 🖿 RE Operating Cash Flow
- 📄 .getxfer.37452.127.mega (0.00 B)
- 📄 .getxfer.37452.128.mega (0.00 B)
- 📄 Module 2 Instructions.txt (658.00 B)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
- 🖿 Commercial
- 📄 .DS_Store (6.00 KB)
- 📄 .getxfer.37452.136.mega (0.00 B)
- 🖿 Commercial Expenses
- 📄 Commercial Expenses_Solution.xlsx (224.88 KB)
- 📄 Commercial Expenses_Worksheet.xlsx (190.07 KB)
- 🖿 Commercial Revenues
- 📄 .getxfer.37452.137.mega (0.00 B)
- 📄 Commercial Revenues_Solution.xlsx (143.13 KB)
- 📄 Commercial Revenues_Worksheet.xlsx (103.58 KB)
- 🖿 Support Files
- 📄 .getxfer.37452.138.mega (0.00 B)
- 📄 Commercial Argus Output.xlsx (75.11 KB)
- 🖿 Include Crash Course As Well
- 📄 .getxfer.37452.139.mega (0.00 B)
- 📄 Real Estate Crash Course Exercises.xlsx (110.73 KB)
- 🖿 Multifamily
- 📄 .DS_Store (6.00 KB)
- 📄 .getxfer.37452.129.mega (0.00 B)
- 🖿 Multifamily Expenses
- 📄 .getxfer.37452.134.mega (0.00 B)
- 📄 .getxfer.37452.135.mega (0.00 B)
- 📄 Multifamily Expenses_Solution.xlsx (93.45 KB)
- 📄 Multifamily Expenses_Worksheet.xlsx (86.76 KB)
- 🖿 Multifamily Revenues – Method 1
- 📄 .getxfer.37452.132.mega (0.00 B)
- 📄 .getxfer.37452.133.mega (0.00 B)
- 📄 Multifamily Revenues_Method 1_Solution.xlsx (64.08 KB)
- 📄 Multifamily Revenues_Method 1_Worksheet.xlsx (53.97 KB)
- 🖿 Multifamily Revenues – Method 2
- 📄 .getxfer.37452.130.mega (0.00 B)
- 📄 .getxfer.37452.131.mega (0.00 B)
- 📄 Multifamily Revenues_Method 2_Solution.xlsx (68.10 KB)
- 📄 Multifamily Revenues_Method 2_Worksheet.xlsx (55.37 KB)
- 🖿 Support Files
- 📄 Multifamily Property Historicals.pdf (198.54 KB)
🖿 3. Real Estate Modeling 3 Non-Operating Cash Flow
- 📄 #Screenshot.pdf (398.65 KB)
- 📄 .getxfer.45640.204.mega (0.00 B)
- 📄 .getxfer.45640.205.mega (0.00 B)
- 📄 RE Real Estate Non-Operating Cash Flow_61ad80741a081.pdf (724.23 KB)
- 🖿 1. LEASING COSTS
- 📄 1. Tenant Improvements.mp4 (22.43 MB)
- 📄 2. Leasing Commissions.mp4 (10.24 MB)
- 📄 3. Modeling Leasing Costs.mp4 (9.75 MB)
- 📄 4. A Note on Argus.mp4 (4.00 MB)
- 📄 5. Leasing Costs Key Takeaways.mp4 (5.72 MB)
- 🖿 2. CAPITAL COSTS
- 📄 .getxfer.45640.206.mega (0.00 B)
- 📄 .getxfer.45640.208.mega (0.00 B)
- 📄 10. Modeling Capital Expenditures.mp4 (64.44 MB)
- 📄 11. Capital Costs Key Takeaways.mp4 (7.74 MB)
- 📄 6. Capital Expenditures.mp4 (17.20 MB)
- 📄 7. Capital Reserves.mp4 (6.19 MB)
- 📄 8. Capital Costs – Model Flow.mp4 (5.05 MB)
- 📄 9. Capital Costs – Model Layout.mp4 (16.57 MB)
- 🖿 3. ACQUISITION & SALE
- 📄 12. Capital Costs Assumptions.mp4 (2.46 MB)
- 📄 13. Frictional Costs.mp4 (10.03 MB)
- 📄 14. Acquisition & Sale – Model Flow.mp4 (1.37 MB)
- 📄 15. Acquisition & Sale – Model Layout.mp4 (5.80 MB)
- 📄 16. Modeling Acquisition & Sale.mp4 (35.90 MB)
- 📄 17. Reversion.mp4 (29.54 MB)
- 📄 18. Modeling Reversion.mp4 (36.08 MB)
- 📄 19. Acquisition & Sale Key Takeaways.mp4 (1.99 MB)
- 🖿 4. UNLEVERED CASH FLOW
- 📄 20. Defining Unlevered Cash Flow.mp4 (4.85 MB)
- 📄 21. Importance of Unlevered Cash Flow.mp4 (776.11 KB)
- 🖿 5. QUIZ COURSE REVIEW
- 📄 Real Estate Non-Operating Cash Flow Quiz.pdf (124.71 KB)
- 🖿 RE Non Operating Cash Flow
- 📄 Module 3 Instructions.txt (322.00 B)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
- 🖿 Acquisition & Sale
- 📄 Acquisition & Sale_Solution.xlsx (157.62 KB)
- 📄 Acquisition & Sale_Worksheet.xlsx (99.46 KB)
- 🖿 Capital Costs
- 📄 Capital Costs_Solution.xlsx (93.02 KB)
- 📄 Capital Costs_Worksheet.xlsx (92.48 KB)
- 🖿 Include Crash Course As Well
- 📄 Real Estate Crash Course Exercises.xlsx (110.64 KB)
- 🖿 Reversion
- 📄 Reversion_Solution.xlsx (321.88 KB)
- 📄 Reversion_Worksheet.xlsx (319.41 KB)
🖿 4. Real Estate Modeling 4 Debt & Levered Cash Flow
- 📄 #Screenshot.pdf (488.07 KB)
- 📄 RE Real Estate Debt Levered Cash Flow_61ad7d9f60dfc.pdf (1.07 MB)
- 🖿 1. THE CAPITAL STACK
- 📄 1. Why use Leverage-.mp4 (24.18 MB)
- 📄 2. Methods of Financing.mp4 (3.23 MB)
- 🖿 2. KEY FINANCING TERMS
- 📄 10. Prepayment Penalties.mp4 (12.20 MB)
- 📄 3. Key Financing Terms.mp4 (1.76 MB)
- 📄 4. Loan Amount.mp4 (4.39 MB)
- 📄 5. Interest Rate.mp4 (19.08 MB)
- 📄 6. Loan Term.mp4 (925.18 KB)
- 📄 7. Amortization.mp4 (4.02 MB)
- 📄 8. Fees.mp4 (2.43 MB)
- 📄 9. Recourse.mp4 (2.91 MB)
- 🖿 3. LENDER CONSIDERATIONS
- 📄 11. Lender Consideration Introduction.mp4 (399.11 KB)
- 📄 12. Lender Universe.mp4 (15.22 MB)
- 📄 13. Loan Types.mp4 (4.49 MB)
- 📄 14. Loan Sizing.mp4 (36.46 MB)
- 📄 15. Additional Funding Mechanisms.mp4 (10.87 MB)
- 🖿 4. AMORTIZATION SCHEDULE
- 📄 16. Loan Cash Flows.mp4 (5.34 MB)
- 📄 17. The PMT Function.mp4 (2.06 MB)
- 📄 18. Amortization Schedule to Proforma.mp4 (1.48 MB)
- 📄 19. Debt Financing – Model Flow.mp4 (717.25 KB)
- 📄 20. Amortization Table Practice.mp4 (23.47 MB)
- 📄 21. Debt Financing – Model Layout.mp4 (8.22 MB)
- 📄 22. Debt Financing Assumptions.mp4 (9.44 MB)
- 📄 23. Modeling Debt Financing.mp4 (47.72 MB)
- 📄 24. Calculating Levered Cash Flow.mp4 (4.09 MB)
- 🖿 5. LEVERED CASH FLOW
- 📄 25. Defining Levered Cash Flow.mp4 (1.36 MB)
- 📄 26. Importance of Levered Cash Flow.mp4 (578.55 KB)
- 🖿 6. QUIZ COURSE REVIEW
- 📄 Real Estate Debt & Levered Cash Flow Quiz.pdf (167.62 KB)
- 🖿 RE Debt & Levered Cash Flow
- 📄 Debt & Levered Cash Flows_Solution.xlsx (198.68 KB)
- 📄 Debt & Levered Cash Flows_Worksheet.xlsx (168.18 KB)
- 📄 Module 4 Instructions.txt (291.00 B)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
- 🖿 Include Crash Course As Well
- 📄 Real Estate Crash Course Exercises.xlsx (110.73 KB)
- 🖿 Support Files
- 📄 Chatham_USForwardCurves.xlsx (28.87 KB)
🖿 5. Real Estate Modeling 5 Joint Ventures & Waterfalls
- 📄 #Screenshot.pdf (362.64 KB)
- 📄 RE Real Estate Joint Ventures Waterfalls_61ad7bc47e95a.pdf (595.90 KB)
- 🖿 1. WATERFALL FUNDAMENTALS
- 📄 1. Joint Venture Fundamentals.mp4 (7.44 MB)
- 📄 2. Waterfall Fundamentals.mp4 (4.52 MB)
- 📄 3. Joint Venture & Waterfall Key Terms.mp4 (903.18 KB)
- 📄 4. Joint Venture Example.mp4 (4.63 MB)
- 🖿 2. CONCEPTUALIZING A WATERFALL
- 📄 5. Waterfall Core Concepts.mp4 (9.40 MB)
- 🖿 3. MODELING A WATERFALL
- 📄 10. Building the First Hurdle.mp4 (32.97 MB)
- 📄 11. Building the Second Hurdle.mp4 (34.23 MB)
- 📄 12. Building the Third Hurdle.mp4 (21.58 MB)
- 📄 13. Building the Last Hurdle.mp4 (22.99 MB)
- 📄 14. Understanding Post-Waterfall Returns.mp4 (12.15 MB)
- 📄 15. Joint Venture & Waterfall – Model Layout.mp4 (5.50 MB)
- 📄 16. Modeling Joint Venture Assumptions.mp4 (5.24 MB)
- 📄 17. Modeling a Waterfall Part 1.mp4 (22.86 MB)
- 📄 18. Modeling a Waterfall Part 2.mp4 (26.91 MB)
- 📄 19. Modeling a Waterfall Part 3.mp4 (19.18 MB)
- 📄 20. Modeling a Waterfall Part 4.mp4 (12.89 MB)
- 📄 21. Summarizing Waterfall Outputs.mp4 (9.79 MB)
- 📄 6. Hurdle Mechanics.mp4 (9.90 MB)
- 📄 7. Joint Venture & Waterfall – Model Flow.mp4 (1.41 MB)
- 📄 8. Hurdle Schedules Explained.mp4 (21.61 MB)
- 📄 9. Calculating Levered Returns.mp4 (3.48 MB)
- 🖿 4. QUIZ COURSE REVIEW
- 📄 Real Estate Joint Ventures & Waterfalls Quiz.pdf (168.08 KB)
- 🖿 RE Joint Ventures & Waterfalls
- 📄 Joint Ventures & Waterfalls_Solution.xlsx (300.60 KB)
- 📄 Joint Ventures & Waterfalls_Worksheet.xlsx (215.16 KB)
- 📄 Module 5 Instructions.txt (222.00 B)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
- 🖿 Include Crash Course As Well
- 📄 Real Estate Crash Course Exercises.xlsx (110.73 KB)
🖿 6. Real Estate Modeling 6 Summarizing & Analyzing the Model
- 📄 #Screenshot.pdf (410.69 KB)
- 📄 RE Summarizing Analyzing a Real Estate Model_61ad787537e26.pdf (589.37 KB)
- 🖿 1. RETURNS & KEY METRICS
- 📄 1. Analyzing a Real Estate Model Introduction.mp4 (1.86 MB)
- 📄 10. Completing Modeling Return Metrics.mp4 (12.84 MB)
- 📄 2. Return Metrics.mp4 (20.01 MB)
- 📄 3. Modeling Return Metrics.mp4 (15.68 MB)
- 📄 4. Debt Metrics.mp4 (1.73 MB)
- 📄 5. Modeling Debt Metrics.mp4 (8.32 MB)
- 📄 6. Other Metrics.mp4 (5.45 MB)
- 📄 7. Modeling Other Metrics.mp4 (13.70 MB)
- 📄 8. Sources & Uses.mp4 (2.49 MB)
- 📄 9. Modeling Sources & Uses.mp4 (22.66 MB)
- 🖿 2. MAKING A MODEL USEFUL
- 📄 11. Review of Formatting and Layout.mp4 (1.81 MB)
- 📄 12. Summarizing Model into Annual Cash Flows.mp4 (66.30 MB)
- 📄 13. Checks.mp4 (1.43 MB)
- 📄 14. Transaction Summary.mp4 (1.50 MB)
- 📄 15. Transaction Summary – Model Flow.mp4 (2.42 MB)
- 📄 16. Transaction Summary – Model Layout.mp4 (4.95 MB)
- 📄 17. Modeling the Transaction Summary, Part 1.mp4 (77.21 MB)
- 📄 18. Modeling the Transaction Summary, Part 2.mp4 (57.73 MB)
- 📄 19. Modeling Checks Part 1.mp4 (25.06 MB)
- 📄 20. Modeling Checks Part 2.mp4 (45.43 MB)
- 🖿 3. TAKING A STEP BACK
- 📄 21. What are we looking for-.mp4 (2.60 MB)
- 📄 22. Risk-Return Spectrum.mp4 (11.30 MB)
- 📄 23. Tweaking the Model.mp4 (3.29 MB)
- 📄 24. Modeling Sensitivity Tables Part 1.mp4 (36.04 MB)
- 📄 25. Modeling Sensitivity Tables Part 2.mp4 (43.32 MB)
- 🖿 4. QUIZ COURSE REVIEW
- 📄 Summarizing & Analyzing a Real Estate Model Quiz.pdf (162.86 KB)
- 🖿 RE Summarizing & Analyzing RE Model
- 📄 .getxfer.37452.125.mega (0.00 B)
- 📄 .getxfer.37452.126.mega (0.00 B)
- 📄 Module 6 Instructions.txt (226.00 B)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
- 📄 Summarizing & Analyzing a Model_Solution.xlsx (343.27 KB)
- 📄 Summarizing & Analyzing a Model_Worksheet.xlsx (303.39 KB)
🖿 7. Real Estate Modeling 7 Development Modeling
- 📄 #Screenshot.pdf (513.79 KB)
- 📄 RE Real Estate Development Modeling_61ad78183fbfd.pdf (764.73 KB)
- 🖿 1. MAJOR DIFFERENCES IN DEVELOPMENT
- 📄 1. Introduction to Development Modeling.mp4 (2.73 MB)
- 📄 2. Project Timeline.mp4 (7.79 MB)
- 📄 3. Modeling Dynamics.mp4 (5.10 MB)
- 📄 4. Development – Model Flow.mp4 (1.45 MB)
- 📄 5. Why a Multifamily Example.mp4 (1.05 MB)
- 🖿 2. UNDERSTANDING A DEVELOPMENT BUDGET
- 📄 10. Development Fees.mp4 (7.71 MB)
- 📄 6. Development Cost Categories.mp4 (6.25 MB)
- 📄 7. Review of Unlevered Cash Flow.mp4 (2.47 MB)
- 📄 8. Unlevered vs. Levered Development Costs.mp4 (1.09 MB)
- 📄 9. Development Budget Contingency.mp4 (2.28 MB)
- 🖿 3. LEASING-UP A DEVELOPMENT
- 📄 11. Lease-up Key Terms.mp4 (3.35 MB)
- 📄 12. Review of Multifamily Revenue Builds.mp4 (2.57 MB)
- 📄 13. Projecting Revenues & Expenses.mp4 (2.34 MB)
- 📄 14. Lease-up Timing.mp4 (2.70 MB)
- 🖿 4. DEVELOPMENT FINANCING
- 📄 15. Introduction to Development Financing.mp4 (936.25 KB)
- 📄 16. Reserves & Shortfalls.mp4 (4.04 MB)
- 📄 17. Funding a Development Loan.mp4 (6.36 MB)
- 🖿 5. DEVELOPMENT KEY METRICS
- 📄 18. Development Return Metrics.mp4 (5.71 MB)
- 📄 19. Other Development Metrics.mp4 (1.78 MB)
- 🖿 6. MODELING A DEVELOPMENT
- 📄 20. Development – Model Layout.mp4 (22.72 MB)
- 📄 21. Modeling the Development Budget.mp4 (23.67 MB)
- 📄 22. Lease-up & Timing Assumptions.mp4 (24.02 MB)
- 📄 23. Modeling Timeline Trackers.mp4 (26.88 MB)
- 📄 24. Modeling the Development Timeline.mp4 (17.26 MB)
- 📄 25. Modeling the Lease-up Timeline.mp4 (14.64 MB)
- 📄 26. Trending Revenues & Expenses.mp4 (35.97 MB)
- 📄 27. Modeling Proforma Revenues & Expenses.mp4 (39.41 MB)
- 📄 28. Modeling Development Costs.mp4 (13.78 MB)
- 📄 29. Review of What We_ve Done to This Point.mp4 (3.97 MB)
- 📄 30. Modeling Development Financing.mp4 (3.61 MB)
- 📄 31. Circularity in Development Financing.mp4 (6.43 MB)
- 📄 32. Modeling the Funding Timeline.mp4 (14.39 MB)
- 📄 33. Modeling Financing Reserves.mp4 (31.05 MB)
- 📄 34. Reviewing the Debt Schedule.mp4 (4.68 MB)
- 📄 35. Reviewing the S&U and Waterfall.mp4 (2.62 MB)
- 📄 36. Summarizing the Development Model.mp4 (15.90 MB)
- 📄 37. Transaction Summary Overview.mp4 (8.77 MB)
- 📄 38. Revenue & Expense Summary.mp4 (80.59 MB)
- 📄 39. Modeling Checks.mp4 (30.28 MB)
- 📄 40. Development Modeling Wrap-up.mp4 (12.69 MB)
- 🖿 7. QUIZ COURSE REVIEW
- 📄 Real Estate Development Modeling Quiz.pdf (122.34 KB)
- 🖿 RE Development Modeling
- 📄 Development_Solution.xlsx (415.76 KB)
- 📄 Development_Worksheet.xlsx (266.34 KB)
- 📄 Module 7 Instructions.txt (206.00 B)
- 📄 Real Estate Modeling Exercises.xlsx (110.64 KB)
🖿 8. Real Estate Modeling 8 Office Building Acquisition Case Study
- 📄 #Screenshot.pdf (317.20 KB)
- 📄 1. Office Building Acquisition Case Study Introduction.mp4 (41.49 MB)
- 📄 10. Revisiting Our Assumptions.mp4 (12.24 MB)
- 📄 11. Waterfall.mp4 (3.91 MB)
- 📄 12. Summarizing the Model.mp4 (37.01 MB)
- 📄 13. Tying it All Together.mp4 (10.88 MB)
- 📄 2. Creating the Inputs Tab.mp4 (35.78 MB)
- 📄 3. Revenues.mp4 (18.29 MB)
- 📄 4. OpEx and NOI.mp4 (10.07 MB)
- 📄 5. Leasing and Capital Costs.mp4 (17.54 MB)
- 📄 6. Acquisition and Sale.mp4 (14.57 MB)
- 📄 7. Unlevered Cash Flow and Returns.mp4 (9.22 MB)
- 📄 8. Debt Schedule.mp4 (25.41 MB)
- 📄 9. Debt and Levered Cash Flow.mp4 (54.24 MB)
- 🖿 Case Study #1_Ministry of Magic Building
- 📄 Chatham_USForwardCurves.xlsx (28.87 KB)
- 📄 Ministry of Magic Building_Argus Output.xlsx (45.81 KB)
- 📄 Ministry of Magic Building_Debt Term Sheet.pdf (79.10 KB)
- 📄 Ministry of Magic Building_Instructions.pdf (107.62 KB)
- 📄 Ministry of Magic Building_Offering Memorandum.pdf (293.20 KB)
- 📄 Ministry of Magic Building_Quick Solution.xlsx (240.83 KB)
- 📄 Ministry of Magic Building_Solution.xlsx (463.88 KB)
- 📄 Ministry of Magic Building_Worksheet.xlsx (237.72 KB)
- 📄 Module 8 Instructions.txt (421.00 B)
🖿 9. Real Estate Modeling 9 Multifamily Building Development Case Study
- 📄 #Screenshot.pdf (350.19 KB)
- 📄 .getxfer.45640.186.mega (0.00 B)
- 📄 .getxfer.45640.189.mega (0.00 B)
- 📄 .getxfer.45640.195.mega (0.00 B)
- 📄 .getxfer.45640.196.mega (0.00 B)
- 📄 .getxfer.45640.197.mega (0.00 B)
- 📄 .getxfer.45640.198.mega (0.00 B)
- 📄 1. Multifamily Building Development Case Study Overview.mp4 (38.24 MB)
- 📄 10. Debt and Levered Cash Flow Part 2.mp4 (69.24 MB)
- 📄 11. Revisiting our Assumptions.mp4 (20.30 MB)
- 📄 12. Waterfall.mp4 (4.81 MB)
- 📄 13. Summarizing the Model.mp4 (57.64 MB)
- 📄 14. Tying it All Together.mp4 (13.68 MB)
- 📄 2. Creating the Inputs Tab Part 1.mp4 (49.20 MB)
- 📄 3. Creating the Inputs Tab Part 2.mp4 (67.61 MB)
- 📄 4. Timelines.mp4 (45.23 MB)
- 📄 5. Revenues.mp4 (27.44 MB)
- 📄 6. OpEx and NOI.mp4 (20.94 MB)
- 📄 7. Development and Sale.mp4 (21.12 MB)
- 📄 8. Unlevered Cash Flow and Returns.mp4 (9.05 MB)
- 📄 9. Debt and Levered Cash Flow Part 1.mp4 (25.23 MB)
- 🖿 RE Grimmauld Place Development
- 📄 .getxfer.37452.140.mega (0.00 B)
- 📄 .getxfer.37452.141.mega (0.00 B)
- 📄 .getxfer.37452.142.mega (0.00 B)
- 📄 .getxfer.37452.143.mega (0.00 B)
- 📄 .getxfer.45640.199.mega (0.00 B)
- 📄 .getxfer.45640.200.mega (0.00 B)
- 📄 .getxfer.45640.201.mega (0.00 B)
- 📄 .getxfer.45640.202.mega (0.00 B)
- 📄 .getxfer.45640.203.mega (0.00 B)
- 📄 Chatham_USForwardCurves.xlsx (28.87 KB)
- 📄 Grimmauld Place Development_Debt Term Sheet.pdf (76.88 KB)
- 📄 Grimmauld Place Development_Instructions.pdf (77.33 KB)
- 📄 Grimmauld Place Development_Offering Memorandum.pdf (186.33 KB)
- 📄 Grimmauld Place Development_Quick Solution.xlsx (224.16 KB)
- 📄 Grimmauld Place Development_Solution.xlsx (418.32 KB)
- 📄 Grimmauld Place Development_Summary Construction Costs.pdf (421.58 KB)
- 📄 Grimmauld Place Development_Worksheet.xlsx (134.50 KB)
- 📄 Module 9 Instructions.txt (487.00 B)
Feel free to reach out to our CHAT support for personalized assistance and detailed information tailored to your needs. We’re here to help!
Reviews
There are no reviews yet.