and
the
to
for
A
In
of
a
in
For
• Excel for Corporate Finance ProfessionalsBy: Michael McDonaldSkill Level: IntermediateDuration: 2h 31mReleased: May 29, 2018Description: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.Topics include:• Capital budgeting in Excel• Using Excel in project selection• Analyzing capital structure using Excel• Estimating weighted average cost of capital (WACC)• Applying Excel to operational budgeting• Cash flow budgeting• Stress test tools for budgetsContents:Introduction1.
• Project Selection in Excel3.