27
Welcome to the Course!
Before you begin...
Introduction to Financial Modeling
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
Key Performance Indicators
Final Wrap-up
Further Reading
Up Next: Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Next Steps
Before you go...
27
Welcome to the Course!
Before you begin...
Introduction to Financial Modeling
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
Key Performance Indicators
Final Wrap-up
Further Reading
Up Next: Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Next Steps
Before you go...