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 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 and find the appropriate row and column for each years sales data based on the choice of analyst in input cell B Use the data from the previous step in combination with the INDEX function to find the sales for row In row find the year over year annual sales growth rate for each year starting in In cell B take the average of those numbers. In cell B find the compounded annual growth rate CAGR for the sales from to In the outputs, link to these two single measures of growth. In cells J:L create a oneway data table to show the results for each analyst You will want to change the analyst B 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
