(a) Develop your own spreadsheet model which should be executable and solved. Generate the“Sensitivity Report” from your model. (Use the above to verify your model results.)

Sensitivity Analysis:

Sensitivity analysis report in Excel is based on the assumption that  no coefficient changes. Correct Answer  one coefficient changes.   two coefficients change. You Answered  all coefficients change.

You should perform sensitivity analysis when:You want to reach more accurate forecast resultsYou want to demonstrate several business casesYou need to change multiple inputs at onceYou need to determine which assumptions matter the most

Spreadsheet models are referred to as what-if models because they _____.Group of answer choicesallow easy instantaneous recalculation for a change in model inputshave specialized functions to perform detailed analysiscome preloaded on computersare mathematical and logic-based models

Which of the following Microsoft Excel tool lets you Test out scenarios and determine the range of outcomes without changing the actual data?SolverWhat-If-AnalysisMacros