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

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.

Discover how to use Microsoft 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 to pick corporate investments, determine your firm's cost of capital, and perform operational budgeting. Michael steps through 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—together with downloadable exercise files—that can provide you with a practical understanding of these key topics.

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

Related Courses

Reviews

Start your review of Excel for Corporate Finance Professionals

Never Stop Learning!

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

Sign up for free