From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,600 courses taught by industry experts.
Challenge: Rolling forward and Excel-based cash flow model
From the course: Excel: Learning Cash Flow Forecasting
Challenge: Rolling forward and Excel-based cash flow model
(upbeat music) - [Instructor] This is the final challenge. So far through this course, we've covered ways we can bring actual figures into our model, both manually and dynamically, and we've addressed variances between actuals and the forecast. But how do we go about rolling the cash flow model forward for future months? That's what you're going to be challenged to do here. In this file, you'll note that I have removed some of the new worksheets that we've done throughout this chapter. I have only included here the original forecast of the cash flow and the P&L. You'll also see all of our original supporting schedules. Now, you're going to note in the sales forecast all the way to the right, I have added in the sales forecast for January, 2026. This is coming from our sales team. It's going to be your responsibility to take these values and bring them into this dynamic table, specifically for January 26. You're going to want to revisit your payroll, your cost expense forecast, your…
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.