Question: Using the pro forma statements for the previous project and your knowledge of sensitivity analysis determine the input to which the analysis is most sensitive

Using the pro forma statements for the previous project and your knowledge of sensitivity analysis determine the input to which the analysis is most sensitive. From the baseline nubmers (which are the values given in the previous problem) use a range of +/-10% to determine the sensitivity of our outcome variables (NPV/IRR) to each of the following inputs: Revenue, Expenses, the Initial Investment, the NWC percentage required, the discount rate, and the tax rate. Use a discount rate of 12% to calculate the NPV for the project. Display the sensitivities in a table below, similar to the table that we discussed in the slides. The most sensitive input is the input for which the outcome (NPV) changes the most as a result of a +/-10% change in the input. Everything should be done in Excel and should tie back to the actual values from part 1

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!