Discover how to use Microsoft Excel for essential tasks required in corporate finance. Learn how to leverage Excel to pick investments, determine your cost of capital, and perform operational budgeting.
- [Michael] Hi, I'm Dr. Michael McDonald. I'm a professor of finance and a financial consultant with experience with more than a dozen major corporations and government groups. In this course, I will show you how to pick investments for your firm, determine your cost capital, and perform basic operational budgeting and scenario analysis. Now, all of this will be done through the lens of Excel, a key tool for corporate finance professionals. We will be using exercise files. If you'd like to follow along and do those with me, please download the exercise folder to your desktop.
Those exercise files are labeled based on the chapter number and video number. You'll start with the Begin Excel file for the chapter that you are working on and that same example will be used throughout the chapter. If you're ready to be a more effective corporate finance professional, then let's get started now.
- 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 budgets