31
Course Overview and Objectives
Meet Your Instructor
What is Included?
Course Materials
Getting Around
Before You Begin...
Before Your First Zoom Class (Please read)
Monday, January 27, 2025 from 12-1pm ET Live Session
Wednesday, January 29, 2025 from 12-1pm ET Live Session
Monday, February 3, 2025 from 12-1pm ET Live Session
How This Course Fits In
Excel Setup
Uses and Sources of Funds
Building the Pro Forma
Incorporating Financial Leverage
Reversion Information
Total Cashflow and Return
Adding Flexibility to the Pro Forma
Additional Analysis for Debt Financing
Calculating an Amortization Schedule
Connecting the Pro Forma to Debt Financing
Building the Pro Forma Tab
Building the Pro Forma Tab (Continued)
Monthly Future Cashflows
Projecting Monthly Future Operating Expenses
Summarizing Annual Cash Flows
Further Reading
Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Your Thoughts
Thank You
31
Course Overview and Objectives
Meet Your Instructor
What is Included?
Course Materials
Getting Around
Before You Begin...
Before Your First Zoom Class (Please read)
Monday, January 27, 2025 from 12-1pm ET Live Session
Wednesday, January 29, 2025 from 12-1pm ET Live Session
Monday, February 3, 2025 from 12-1pm ET Live Session
How This Course Fits In
Excel Setup
Uses and Sources of Funds
Building the Pro Forma
Incorporating Financial Leverage
Reversion Information
Total Cashflow and Return
Adding Flexibility to the Pro Forma
Additional Analysis for Debt Financing
Calculating an Amortization Schedule
Connecting the Pro Forma to Debt Financing
Building the Pro Forma Tab
Building the Pro Forma Tab (Continued)
Monthly Future Cashflows
Projecting Monthly Future Operating Expenses
Summarizing Annual Cash Flows
Further Reading
Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Your Thoughts
Thank You