Excel for Corporate Finance Professionals

3h 16mIntermediate2023-10-04

Authors

Michael McDonald

Researcher and Professor of Finance at Fairfield University

Course details

Learn how to use Excel for the bread-and-butter tasks required by corporate finance and financial planning and analysis (FP&A) professionals. In this hands-on course, Professor Michael McDonald steps through how to leverage this powerful tool for capital budgeting and corporate investment selection at your firm, determine your firm's cost of capital, and perform operational budgeting. Michael explains how to estimate weighted average cost of capital (WACC), build a budget, perform stress testing and scenario analysis, and more. Throughout the course, Michael includes exercises and downloadable exercise files that can give you a practical understanding of these key topics.

Skills covered

Personal FinanceCorporate FinanceSpreadsheetsMicrosoft ExcelFinance and AccountingPersonaProfessional DevelopmentBusiness Software and ToolsMicrosoft

Concepts

0. Introduction

01 - Excel's tools for corporate finance

1. Critical Tasks in Corporate Finance

02 - Describe corporate finance and its purpose
03 - Explore project selection in finance
04 - Explain the weighted average cost of capital and capital structure
05 - Estimate cash flows in budgeting
06 - Financial ratios and Excel
07 - Valuation tools and Excel
08 - Build scenarios and stress tests in Excel

2. Project Selection in Excel

09 - Define a capital budgeting scenario in Excel
10 - Build out a series of capital budgeting scenarios
11 - Perform NPV tests
12 - Perform IRR tests
13 - Perform PBP and MIRR tests
14 - Scenario analysis in Excel
15 - NPV and scenario analysis
16 - Evaluate Excel models for accuracy

3. WACC and Capital Structure in Excel

17 - Capital structure in Excel
18 - Describe the concept of WACC
19 - Build out a set of capital structure options in Excel
20 - Demonstrate changes in capital structure
21 - Estimate WACC in Excel for a capital structure
22 - Show sensitivity of WACC to changes in capital structure
23 - Determine optimal WACC
24 - Adjusting WACC for risk

4. Operational Budgeting in Excel

25 - Introduce operational budgeting in Excel
26 - Demonstrate building a budget in Excel
27 - Add CAGRs to Excel for long-term assumptions
28 - Build percent of sales assumptions for expense
29 - Link budget to pricing and sales assumptions
30 - Provide stress test tools for budgets in Excel

5. Valuation in Excel

31 - Valuation of assets in Excel
32 - Estimation of cash flows
33 - Determine a discount rate
34 - Identify the valuation
35 - Stress testing the valuation model

Conclusion

36 - Continue your corporate finance journey with Excel