In this course, you will :
- Describe financial modeling basics.
- Review the three financial statements used in financial modeling.
- Explain how to create corporate financing models.
- Explore the valuation process in financial models.
- Apply complex modeling features in Excel to a scenario.
- Identify the key components in a buyout model.
1. Financial Modeling Basics
- What is financial modeling?
- Why is financial modeling important?
- Business questions and financial models
- Data for a model
- Sources of data
- Gathering data from FRED for Excel
- Getting started with the project
- Excel tips for financial modeling
2. Corporate Financial Modeling: Three-Statement Financial Model
- Foundations of the model
- Linking financial statements
- Three-statement financial model
- Setting source parameters
- Assumptions in financial statements
- Forecasting in financial statements
- Putting it all together
- Improving model quality
3. Evaluating Corporate Financial Models: Three-Statement Model
- Financial modeling strategies
- Sensitivity analysis and financial models
- Adding visuals to a financial model
4. Investment Models: DCF Model
- Financial valuation models
- Cash flows in the valuation model
- Terminal value in a valuation model
- Interpreting a DCF model
5. Banking Models
- Beyond the basics in financial models
- Corkscrews and models
- Waterfalls and models
- Adding toggles to a financial model
- Model outputs
- Hiding tabs and making models readable
- Stress testing models
6. Buyout Models
- Interest rate assumptions in models
- Discount rates in models
- Top-down financial models
- Bottom-up financial models
- IRR decisions in financial models
- NPV decisions in financial models
- Limits of financial models
7. Financial Modeling across Industries
- Characteristics of financial models
- Modeling in banking
- Modeling in corporate finance
- Modeling in investments
8. Building and Maintaining Models
- Applications of financial models
- Bitcoin and cryptocurrency valuation modeling
- Updating financial models
- Maintaining ongoing financial models