Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Value- Add Residential cash flow modelling: Retrofitting Stranded Assets
Bayfield Training | Executive Education
Learn more about us
Bayfield 2025 Course Brochure
Course Outline
Faculty
Excel Key Boards Shortcuts
Useful Terminology
Community Forum
Useful Excel videos
Disclaimer
Introduction to the Case Study
Case Study and Modelling Exercise
Case Study & Model Overview (23:33)
Introduction to Excel formulas, shortcuts and key concepts (30:42)
The importance of Formatting (15:00)
Build the Cash flow - Unlevered Cash flow
Acquisition Cost Inputs & Cash flow (16:35)
Development Inputs and Cash flow (48:41)
Investment/Reversion Cash flow: Exit/Sales Proceeds (15:03)
Operating Cash flow I: Passing Rental Income (22:59)
Operating Cash flow II: Post-refurbishment Model (44:19)
Operating Cash flow III: Vacancy, Net Rental Income & NOI (27:22)
Unlevered CF and Performance Return Metrics (11:11)
Build the Cash flow - Adding Debt to the Model
Financing : Acquisition, Development and Refinance Loan (69:06)
Interest Only Periods (11:14)
Visual Cash flow Review: Error Checking the Model (11:51)
Levered Model & Performance Return Metrics (13:10)
Converting the Monthly to Annual Cash flow
Formatting & Building the Annual Cash flow model (36:43)
Cashflow Analysis and Dashboard
Executive Summary - Dashboard (53:57)
Sensitivity Analysis (29:59)
Case Study Wrap-Up with Completed Model (13:01)
Wrap up
Course feedback
What's next
Unlevered CF and Performance Return Metrics
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock