Excel for Corporate Finance Professionals

Focused View

Michael McDonald

3:16:02

127 View

01 - Introduction

01 - Excels tools for corporate finance.mp4

00:51

02 - 1. Critical Tasks in Corporate Finance

01 - Describe corporate finance and its purpose.mp4

04:08

02 - Explore project selection in finance.mp4

04:05

03 - Explain the weighted average cost of capital and capital structure.mp4

06:50

04 - Estimate cash flows in budgeting.mp4

03:29

05 - Financial ratios and Excel.mp4

04:41

06 - Valuation tools and Excel.mp4

06:44

07 - Build scenarios and stress tests in Excel.mp4

05:00

03 - 2. Project Selection in Excel

01 - Define a capital budgeting scenario in Excel.mp4

09:12

02 - Build out a series of capital budgeting scenarios.mp4

09:43

03 - Perform NPV tests.mp4

07:18

04 - Perform IRR tests.mp4

06:27

05 - Perform PBP and MIRR tests.mp4

04:59

06 - Scenario analysis in Excel.mp4

04:20

07 - NPV and scenario analysis.mp4

04:34

08 - Evaluate Excel models for accuracy.mp4

04:58

04 - 3. WACC and Capital Structure in Excel

01 - Capital structure in Excel.mp4

03:45

02 - Describe the concept of WACC.mp4

03:39

03 - Build out a set of capital structure options in Excel.mp4

07:33

04 - Demonstrate changes in capital structure.mp4

06:05

05 - Estimate WACC in Excel for a capital structure.mp4

07:44

06 - Show sensitivity of WACC to changes in capital structure.mp4

05:48

07 - Determine optimal WACC.mp4

06:24

08 - Adjusting WACC for risk.mp4

05:51

05 - 4. Operational Budgeting in Excel

01 - Introduce operational budgeting in Excel.mp4

04:14

02 - Demonstrate building a budget in Excel.mp4

04:20

03 - Add CAGRs to Excel for long-term assumptions.mp4

05:27

04 - Build percent of sales assumptions for expense.mp4

06:19

05 - Link budget to pricing and sales assumptions.mp4

05:05

06 - Provide stress test tools for budgets in Excel.mp4

03:44

06 - 5. Valuation in Excel

01 - Valuation of assets in Excel.mp4

09:46

02 - Estimation of cash flows.mp4

06:12

03 - Determine a discount rate.mp4

02:27

04 - Identify the valuation.mp4

04:45

05 - Stress testing the valuation model.mp4

08:07

07 - Conclusion

01 - Continue your corporate finance journey with Excel.mp4

01:28

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Accounting

Financial Accounting

Michael McDonald

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.