From the course: Excel: Learning Cash Flow Forecasting

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Solution: Building a dynamic scenario manager tool in Excel

Solution: Building a dynamic scenario manager tool in Excel

From the course: Excel: Learning Cash Flow Forecasting

Start my 1-month free trial Buy for my team

Solution: Building a dynamic scenario manager tool in Excel

“

(upbeat music) - [Instructor] So how did you do in this challenge? Let me revisit what I asked you to do. So I asked you to go onto the assumptions page and to expand this scenario management tool beyond just these working capital assumptions. I asked you to include scenario management options for uncollectible reserve, salary deductions, bonus percentage, utility minimum spend, and price increase. But further, I also ask you include options to turn on and turn off your new NFL confidential customer sales. Turn on and turn off your hiring, and turn on and turn off your CapEx investments specifically for the commercial kitchen, the tempering machine, and the automatic filler. This is what I did. The benefit of using these kinds of scenario management tools is you can create consistency from one line to the next. Over here, if you remember from a prior video, I use the Choose function. Tying it over here to the case assumption of one, two, and three for pessimistic base and optimistic…

Contents