Modify your Excel budget to link to pricing, sales, and market share forecasts.
- [Instructor] Once you've constructed a budget,…it can seem like a straightforward business process…to manage the firm thereafter.…But, there are a number of major challenges that you'll face…as a corporate finance professional.…And one of the challenges arises…out of the problem of price.…In particular, firms need to decide what the price is…and how they should trade off that price against volume.…So let's ask a basic question- price or volume?…Which would you prefer for your firm: a 1% boost…to your selling price with no decrease in volume,…or a 1% rise in volume with no price deflation?…Beware, the answer to this question is one…that stumps a lot of seasoned executives in my experience.…
In my executive education work I've talked to mid-career…and even senior executives at many firms about this issue,…and it continues to be one where there's…a lot of confusion and a lot of issues.…The key to answering this question…is to understand the cost-volume-profit analysis.…So let's talk about the bottom line for a company.…
- 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.