Part 6. Evaluating Risk: Sensitivity Analysis I. Sensitivity of NPV to Changes in Inputs. Here we use an Excel "Data Table" to find NPV different unit sales, holding other thing constant. \begin{tabular}{|r|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} \% Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ lst YEAR UNIT SALES } \\ \cline { 2 - 3 } & Units & NPV \\ \hline Base Case & 1,000 & 3,543.12 \\ \hline20% & 800 & \\ \cline { 2 - 3 } & 900 & \\ \hline10% & 1,000 & \\ \hline 0% & 1,100 & \\ \cline { 2 - 3 } & 1,200 & \\ \hline 20% & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} \% Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ VARIABLE COSTS } \\ \cline { 2 - 3 } Bariable & Vase & NPV \\ \cline { 2 - 3 } & 17.50 & 3,543.12 \\ \hline20% & $14.00 & $4,336 \\ 10% & $15.75 & \\ \hline 0% & $17.50 & $3,543 \\ \hline 10% & $19.25 & \\ \hline 20% & $21.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{c} % Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ FIXED COSTS } \\ \hline & Fixed & NPV \\ \hline Base Case & $1,000.00 & 3,543.12 \\ \hline20% & $800 & $6,779 \\ \hline10% & $900 & \\ \hline 0% & $1,000 & $3,543 \\ \hline 10% & $1,100 & \\ \hline 20% & $1,200 & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} \% Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ WACC } \\ \cline { 2 - 3 } Base Case & WACC & NPV \\ \cline { 2 - 3 } & & 3,543.12 \\ 20% & 8.0% & 4,336.04 \\ 10% & 9.0% & 3,932.02 \\ \hline 10% & 10.0% & 3,543.12 \\ \hline 20% & 11.0% & 3,168.61 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline% Deviation & \multicolumn{2}{|c|}{ SALES PRICE } \\ \hline from & Sales & NPV \\ \hline Base Case & 24.00 & 3,543.12 \\ \hline20% & $19.20 & \\ \hline10% & $21.60 & \\ \hline 0% & $24.00 & $3,543 \\ \hline 10% & $26.40 & \\ \hline 20% & $28.80 & \\ \hline \end{tabular} Part 6. Evaluating Risk: Sensitivity Analysis I. Sensitivity of NPV to Changes in Inputs. Here we use an Excel "Data Table" to find NPV different unit sales, holding other thing constant. \begin{tabular}{|r|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} \% Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ lst YEAR UNIT SALES } \\ \cline { 2 - 3 } & Units & NPV \\ \hline Base Case & 1,000 & 3,543.12 \\ \hline20% & 800 & \\ \cline { 2 - 3 } & 900 & \\ \hline10% & 1,000 & \\ \hline 0% & 1,100 & \\ \cline { 2 - 3 } & 1,200 & \\ \hline 20% & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} \% Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ VARIABLE COSTS } \\ \cline { 2 - 3 } Bariable & Vase & NPV \\ \cline { 2 - 3 } & 17.50 & 3,543.12 \\ \hline20% & $14.00 & $4,336 \\ 10% & $15.75 & \\ \hline 0% & $17.50 & $3,543 \\ \hline 10% & $19.25 & \\ \hline 20% & $21.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{c} % Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ FIXED COSTS } \\ \hline & Fixed & NPV \\ \hline Base Case & $1,000.00 & 3,543.12 \\ \hline20% & $800 & $6,779 \\ \hline10% & $900 & \\ \hline 0% & $1,000 & $3,543 \\ \hline 10% & $1,100 & \\ \hline 20% & $1,200 & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} \% Deviation \\ from \end{tabular}} & \multicolumn{2}{|c|}{ WACC } \\ \cline { 2 - 3 } Base Case & WACC & NPV \\ \cline { 2 - 3 } & & 3,543.12 \\ 20% & 8.0% & 4,336.04 \\ 10% & 9.0% & 3,932.02 \\ \hline 10% & 10.0% & 3,543.12 \\ \hline 20% & 11.0% & 3,168.61 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline% Deviation & \multicolumn{2}{|c|}{ SALES PRICE } \\ \hline from & Sales & NPV \\ \hline Base Case & 24.00 & 3,543.12 \\ \hline20% & $19.20 & \\ \hline10% & $21.60 & \\ \hline 0% & $24.00 & $3,543 \\ \hline 10% & $26.40 & \\ \hline 20% & $28.80 & \\ \hline \end{tabular}