Excel for Corporate Finance Professionals (2018)

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.

Learning objectives
Explain how to make projections while capital budgeting.
Describe various capital budgeting scenarios.
Summarize how to handle unexpected events while capital budgeting.
Cite the various drawbacks of IRR.
Describe the important considerations for buying back stock.
Name the factors to consider when preparing a forecast.
Summarize the process of cash flow budgeting.
Name the factor that’s most difficult to change in an operating margin.
Identify stress test tools for budgeting in Excel.