From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,600 courses taught by industry experts.
Developing business scenarios with Excel's form controls
From the course: Excel: Learning Cash Flow Forecasting
Developing business scenarios with Excel's form controls
- [Instructor] All right, now it's time to have some fun. We've completed a foundational cash flow model. It reveals to us what cash inflows are from collections of accounts receivable on sales and equipment financing. It reveals what cash outflows are, payments to employees, payments for raw material ingredients like cocoa powder, butter, and sugar, prepayments for rent, disbursements for utilities and marketing, CapEx, debt service, and I've included a line for taxes. But now Leslie, the owner of our company, wants to run additional business scenarios to reflect changing assumptions. Let's go over to our assumptions page and create a scenario management tool. Here, I'm going to add in four columns. I'm going to create a pessimistic case, a base case, an optimistic case, and I'm also going to add a column for active. Now, under each one of these cases, pessimistic, base, and optimistic, I've created assumptions as it relates to AR collection terms, AP payment terms, accrued expense…
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.