Excel for Corporate Finance Professionals

Created by: Michael McDonald

Produced in 2018

icon
Course Description

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 ExcelUsing Excel in project selectionAnalyzing capital structure using ExcelEstimating weighted average cost of capital (WACC)Applying Excel to operational budgetingCash flow budgetingStress test tools for budgets

icon
Instructor Details

Michael McDonald

Michael McDonald is a researcher and professor of finance at Fairfield University.He has extensive programming skills in SAS, Stata, Python, R, and SQL, among other programming languages. His past work experience includes using these programming languages to analyze big data sets in finance and economics and develop trading strategies based on data mining. He has done extensive work in investment banking, at tech startups, hedge funds, and on a wide variety of consulting projects. He has a track record of authoring creative and practical course materials for a variety of subject areas across business disciplines.

Read More

icon
Reviews

0

0 total reviews

5 star 4 star 3 star 2 star 1 star
0% Complete
0% Complete
0% Complete
0% Complete
0% Complete
0% 0% 0% 0% 0%