Set up a cash flow and operational budget in Excel.
- [Instructor] Now that we understand profit drivers…like WACC and project selection,…it's time to drill down…and focus on how we can use this information…in a typical setting in corporate finance…where we're forecasting what will happen going forward.…From the standpoint of most corporate finance groups,…there's two perspectives on the world…that are key to their daily roles,…the long-term view and the short-term view.…Each of these distinct views on the world…are critical to building a successful company.…
If we don't have a company that's focused on the long term,…then we're not gonna be prepared for challenges…that are coming down the road in the future.…We're not gonna be positioned…for disruptive influences to the industry.…On the other hand, in the short term, we need to be focused…on dealing with the specific challenges…that come up on a day-to-day basis,…making sure we have the cash to operate that business…and making sure that we're really focusing on…our core drivers in the firm.…
In other words, the perspective for long term…
- 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.