Question: ASSIGNMENT: (a) Using an one-way data table, perform a sensitivity analysis to show how NPV of the project change with different inputs of variable costs

ASSIGNMENT: (a) Using an one-way data table,
ASSIGNMENT: (a) Using an one-way data table, perform a sensitivity analysis to show how NPV of the project change with different inputs of variable costs per unit in the expected range by $0.1 increments ($2.5, $2.6, $2.7, ...) (b) Using an two-way data table, perform a sensitivity analysis to show how NPV of the project change with different inputs of variable costs per unit in the expected range by $0.1 increments ($2.5, $2.6, $2.7, ...) and different inputs of fixed costs per unit in the expected range by $10 increments ($17,400, $17,410, $17,420, ...) (c) What can you comment when looking at the sensitivity analysis? Are variable cost and fixed cost important to our project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!