Question: Problem 2 You are building a simple model of projected sales forecasts. You have four analysts working for you who have each come up with

Problem 2 You are building a simple model of projected sales forecasts. You have four analysts working for you who have each come up with their own individual forecasts. Create a model that does the following (I will grade for strict adherence to the instructions on this one so please read carefully): Using the MATCH function in rows 15 and 16, find the appropriate row and column for each years sales data based on the choice of analyst in input cell B2. Use the data from the previous step in combination with the INDEX function to find the sales for row 18. In row 18, find the year over year annual sales growth rate for each year starting in 2022. In cell B19, take the average of those numbers. In cell B20, find the compounded annual growth rate (CAGR) for the sales from 2021 to 2027. In the outputs, link to these two single measures of growth. In cells J6:L11, create a one-way data table to show the results for each analyst You will want to change the analyst (B2) to see if your model is reacting. Please be sure to set it back to Naomi for submission.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!