Question: I am working on an excel problem - with if statements involved - The formulas all appear to be corrrect but my scernario is not

I am working on an excel problem - with if statements involved - The formulas all appear to be \corrrect but my scernario is not coming out coorectly

I have three value input in three different cells - W, 1% and M - - The equation uses a 12% growth and 6% at the low endIf y

Scenario Manager

Once you have completed the template, you will need to run your DSS model through the Scenario Manager to generate all the possible combination of inputs and produce a tabular summary of the results

You will follow the same steps you learned in the DSS tutorial to set up the Scenario Manager, so you can refer back to the DSS tutorial walkthrough for guidance. For the case study, there are 12 possible combinations of inputs and you are interested in the same four outputs as the tutorial. Once you have constructed the scenario summary you will need to edit it in the same way you did in the tutorial. The figure below shows you what the first 11 columns of the scenario summary should look like. The summary should extend to column N

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!