From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,900 courses taught by industry experts.
Challenge: Building a dynamic scenario manager tool in Excel
From the course: Excel: Learning Cash Flow Forecasting
Challenge: Building a dynamic scenario manager tool in Excel
(upbeat music) - In this challenge, you are going to build out this dynamic Scenario Manager tool even more. You're going to incorporate additional scenarios for uncollectible reserves, salary deductions, bonus percentage, utility minimum spend, and price increase, as it relates to the assumptions page. However, you're also going to incorporate three additional scenarios. One, down here at line 71, you're going to create a toggle to turn on and off the NFL confidential customer. You're also going to create a toggle that allows you to turn on and off the chef, baker, chocolatier, two additional salespeople and the account executive. And finally, as it relates to CapEx, you're going to create a new scenario that allows you to turn on and turn off the investment in the commercial kitchen, tempering machine, and automatic filler. In the solution, I'll share with you how I would go about solving this challenge.
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.