sensitivity analysis 2

Get perfect grades by consistently using www.college-experts.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

In sheet “Data table & scenario manager”, create a 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%).

Submit only 1 sheet, instead of the entire file. Please use the rubric below to guide the development of your assignment.

M1 Assignment – Sensitivity Analysis Rubric
Successfully created ranges for 2 input variables 1 pt
Successfully linked the result cell 0.5 pt
Successfully completed the data table 3 pts
Formatted and labeled cells appropriately 0.5 pt
Total 5 pts

Rubric

M1A1

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeSuccessfully created ranges for 2 input variables

1.0 pts

Full Marks

0.0 pts

No Marks

1.0 pts

This criterion is linked to a Learning OutcomeSuccessfully linked the result cell

0.5 pts

Full Marks

0.0 pts

No Marks

0.5 pts

This criterion is linked to a Learning OutcomeSuccessfully completed the data table

3.0 pts

Full Marks

0.0 pts

No Marks

3.0 pts

This criterion is linked to a Learning OutcomeFormatted and labeled cells appropriately

0.5 pts

Full Marks

0.0 pts

No Marks

0.5 pts

Total Points: 5.0

Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper