- 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
Skill Level Intermediate
- [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.
Excel 2016: Power Query (Get & Transform)with Oz du Soleil1h 49m Intermediate
Excel: Analyzing and Visualizing Cash Flowswith Curt Frye1h 16m Intermediate
1. Critical Tasks in Corporate Finance
2. Project Selection in Excel
3. WACC and Capital Structure in Excel
4. Operational Budgeting in Excel
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.