From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,600 courses taught by industry experts.
Using data mapping to update actuals in the financial model
From the course: Excel: Learning Cash Flow Forecasting
Using data mapping to update actuals in the financial model
- [Instructor] How can we update the model for actuals and how can we roll it forward? These are two common questions I get when it comes to cashflow forecasting and modeling in Excel. In this video, I'll share with you how I update models for actuals. And in a forthcoming challenge, I'll show you how we can roll the cashflow forecast forward. In this work file, not only do I have my original cashflow forecast and financial forecast, I also have P&L actuals and cashflow actuals. Assuming that we have decent accounting systems and we close the books every month, this shouldn't be difficult to get. However, bringing this information together is critical. I'm going to bring this over to the rolling forecast. Now you're going to note that up at the top, I have my cashflow forecast. And as I scroll down, down here, you'll notice that I have my P&L forecast, but that's not all. When I put my cursor here on row 12, these are my trade receivables, my collections. When I put my cursor here…
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.