Learn how to show a set of cash flows for a budget in Excel.
- We need to be able to build an effective…forward-looking financial model to help the firm…understand what its cash position will be next quarter.…To do that, we need to use a concept called CAGR,…or Compounded Annual Growth Rate.…I'm in the 04_02 Excel Begin exercise file.…Now, what we see here is our revenue,…broken down by two different products,…our operating cost, again,…based on these two different products,…our SGNA, EBET, interest, taxes, net income,…and additions to retained earnings.…
Now, we want to do a basic forecast…for what our revenues will be through the end of the year.…To do that, we can use that concept that we called CAGR.…Now, traditionally, CAGRs are annual figures,…so in this particular case, since we have…four different quarterly periods,…perhaps we want to divide that by four.…So, it'll be a two percent per quarter…increment on our sales.…So, I'm going to multiply our product sales…times our CAGR divided by four,…and then add one to that,…and we see that in the next period,…that is, the period starting April 1st 2020,…
- 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.