Sensitivity Analysis

In sheet “Data table & scenario manager”, after you have followed the videos to create one-input data

table and two-input data table, on the same page, create a new two-input data table as a sensitivity

analysis. We want to explore how purchasing price and tax rate together affect after-tax income.

Show After-tax income as a function of purchasing price ($5, $6, …$13) and tax rate (30%, 32%, …40%).

This question has been answered.

Get Answer