Question: I understand how to change the project year back using the goal seek dialog box, but how do I add the models its asking? Please

I understand how to change the project year back using the goal seek dialog box, but how do I add the models its asking? Please Help ASAP.

I understand how to change the project year back using the goal

seek dialog box, but how do I add the models its asking?

After reviewing the printout from Part 1 , Yolanda is concerned that the revised sales figure is not attainable in the first year. Restore the sales for year 1 to the original value of $485,000. Yolanda has created the following three models for the startup investment worksheet: Yolanda would like you to set up the worksheet to save all three of these models. Hint: Use a comma to separate two cell references as the changing cells. Create a report that shows Yolanda the input variables for each model and how the model affects the number of months needed to recoup the initial investment. Save the revised workbook as EL2-C5-CS-P2-PBMStartup. Print the summary report. Switch to the worksheet and show the model that reduces the number of months to recoup the initial investment to the lowest value. Print the worksheet. Save EL2-C5-CS-P2-PBMStartup

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 Databases Questions!