Overview
-
Discover how to use Excel for essential tasks required in corporate finance. Learn how to pick investments, determine your cost of capital, and perform operational budgeting.
Syllabus
-
Introduction
- Welcome
- Corporate finance and modern business
- Project selection in finance
- Weighted average cost of capital and capital structure
- Cash flows in budgeting
- Capital budgeting in Excel
- Capital budgeting scenarios
- NPV tests in Excel
- IRR tests in Excel
- PBP and MIRR tests
- Unexpected events and capital budgeting
- NPV and scenario analysis
- Capital structure in Excel
- Using Excel and WACC
- Capital structure options in Excel
- Changes in capital structure
- Estimating WACC in Excel
- Sensitivity of WACC to capital structure
- Optimal WACC
- Operational budgeting in Excel
- Building a budget in Excel
- CAGRs and long-term assumptions
- Cash flow budgeting
- The power of price
- Stress test tools for budget in Excel
- Next steps
