Discover how to use Excel for essential tasks required in corporate finance. Learn investments selection, determine your cost of capital, and perform operational budgeting.
Overview
Syllabus
Introduction
- Excel's tools for corporate finance
- Describe corporate finance and its purpose
- Explore project selection in finance
- Explain the weighted average cost of capital and capital structure
- Estimate cash flows in budgeting
- Financial ratios and Excel
- Valuation tools and Excel
- Build scenarios and stress tests in Excel
- Define a capital budgeting scenario in Excel
- Build out a series of capital budgeting scenarios
- Perform NPV tests
- Perform IRR tests
- Perform PBP and MIRR tests
- Scenario analysis in Excel
- NPV and scenario analysis
- Evaluate Excel models for accuracy
- Capital structure in Excel
- Describe the concept of WACC
- Build out a set of capital structure options in Excel
- Demonstrate changes in capital structure
- Estimate WACC in Excel for a capital structure
- Show sensitivity of WACC to changes in capital structure
- Determine optimal WACC
- Adjusting WACC for risk
- Introduce operational budgeting in Excel
- Demonstrate building a budget in Excel
- Add CAGRs to Excel for long-term assumptions
- Build percent of sales assumptions for expense
- Link budget to pricing and sales assumptions
- Provide stress test tools for budgets in Excel
- Valuation of assets in Excel
- Estimation of cash flows
- Determine a discount rate
- Identify the valuation
- Stress testing the valuation model
- Continue your corporate finance journey with Excel
Taught by
Michael McDonald
