I am trying to understand how to complete sensitivity analysis in excel an need help. The first screenshot shows part of the sensitivity analysis but what is also included is the information that went into the data table to complete the sensitivity analysis. I am trying to do the sensitivity analysis on my own so that I can see how to do it but I don't understand how the dollars amounts were derived. What are the steps to do a sensitivity analysis? The information shaded in orange under "NPV" is what I am trying to understand how to do. How was this data table created? What were the steps involved?

Conducting a sensitivity analysis to determine the sensitivity of "PU to changes in the sales price, variable costs per unit, and number at units sold is Deviation Sales uriee, Year 1 from -ilii."- Base Case 525,5\") Variable costs u -r unit, Year1 -IE- $11530 Number of units sold The dollar amounts that are shaded in greenwere derived from a sensitivity analysis. The formulas that are shaded in orange show the formula that were used to generate the dollar amounts under \"Base\" and 'WPVF' For NPV, I am trying to understand how to do a sensitivity analysis to arrive at the dollar amounts that are shaded in green. Howl do you do a sensitivity analysis? \f% Deviation Sales price, Year 1 from Base NPV Base Case $25,500 =B48 -20% =$8562*(1+A63) (=TABLE(,C8)} -10% =$8562*(1+A64) (=TABLE(,C8)} 0% =$B$62"(1+A65) (=TABLE(,C8)} 10% =$8562"(1+A66) (= TABLE(,C8)} 20% =$8562*(1+A67) {=TABLE(,C8)} % Deviation Variable costs per unit, Year 1 from Base NPV Base Case $17,500 =B48 -20% =$8571"(1+A72) {=TABLE(,C9)} -10% =$8571"(1+A73) (=TABLE(,C9)} 0% =$B$71*(1+A74) {=TABLE(,C9)} 10% =$B$71"(1+A75) (=TABLE(,C9)} 20% =SB$71"(1+A76) (=TABLE(.C9)} % Deviation Number of units sold from Base NPV Base Case 900 =B48 -20% =$B$80*(1+A81) (=TABLE(,C7)} -10% =$8580"(1+A82) {=TABLE(,C7)} 0% =$8580*(1+A83) {=TABLE(,CT)} 10% =$B$80*(1+A84) (=TABLE(,C7)} 20% =$B$80*(1+A85) =TABLE(,C7)}