From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,600 courses taught by industry experts.
Solution: Rolling forward and Excel-based cash flow model
From the course: Excel: Learning Cash Flow Forecasting
Solution: Rolling forward and Excel-based cash flow model
(upbeat music) - [Speaker] This was not an easy challenge as it really pushed you to think about what changes needed to take place within the model. Here's how I would encourage you to go about completing it. First, I'm going to take us over to the sales forecast. Remember, I wanted to add in all of these new sales for January 26. I'm going to keep everything else here, but add in this additional column and make sure that it is contained within my dynamic table. When I go all the way down to the bottom. Take note that I have in fact changed some of these formulas down below. Why? Because I want to make sure that I continue to have streamlined this percentage of the total and capture all of the seasonality. Let's go over to the payroll. I didn't need to make any changes here as it related to personnel. However, in the forecast period, I did need to add in an additional month for the salary forecast and an additional month for the bonus accrual. For AR aging and AP aging. I'm going to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.