Learn about WACC and capital structure and their relevance to business.
- [Instructor] Weighted Average Cost of Capital…and Capital Structure.…Another critical tool for corporate finance is WACC…or Weighted Average Cost of Capital.…Like project selection, you might have heard of WACC before,…but the reality is that WACC is a lot more crucial…and complex than many people assume initially.…I've talked to seasoned corporate finance executives…who still have questions about WACC…and how it applies to their business,…so it's crucial that you have…a really strong understanding of this…because it'll help you in your career moving forward…as your firm thinks about different types of projects…they wanna pursue.…
Now, when it comes to borrowing money,…people generally borrow money in a bank, right?…When you wanna buy a house or a car,…you generally go to a bank.…When you wanna buy a car,…maybe you go to a car dealership,…but then the car dealership gets the money from the bank.…Companies though have more options.…Sure, companies can rely on banks and many of them do…for credit lines, for term loans, revolvers,…
- 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
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.