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 to determine the sensitivity of our outcome variables NPVIRR 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 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 change in the input. Everything should be done in Excel and should tie back to the actual values from part
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
