28
Welcome to the Course!
Before you begin...
Before your first live class... (PLEASE READ)
January 26, 2023 from 12-1pm ET Live Session
January 31, 2023 from 12-1pm ET Live Session
February 2, 2023 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
Calculating IRR with Monthly Cash Flows
Further Reading
Up Next: Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Next Steps
Before you go...
28
Welcome to the Course!
Before you begin...
Before your first live class... (PLEASE READ)
January 26, 2023 from 12-1pm ET Live Session
January 31, 2023 from 12-1pm ET Live Session
February 2, 2023 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
Calculating IRR with Monthly Cash Flows
Further Reading
Up Next: Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Next Steps
Before you go...