Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel for Corporate Finance Professionals

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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
1. Critical Tasks in Corporate Finance
  • Corporate finance and modern business
  • Project selection in finance
  • Weighted average cost of capital and capital structure
  • Cash flows in budgeting
2. Project Selection in Excel
  • 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
3. WACC and Capital Structure in Excel
  • 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
4. Operational Budgeting in Excel
  • 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
Conclusion
  • Next steps

Taught by

Michael McDonald

Reviews

4.6 rating at LinkedIn Learning based on 852 ratings

Start your review of Excel for Corporate Finance Professionals

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.