Question: Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes
Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.
| Chart | |
| Data Table | |
| Cash Flow | IRR |
| 17.95% | |
| 20,000 | -11.48% |
| 30,000 | -6.76% |
| 40,000 | -2.72% |
| 50,000 | 0.86% |
| 60,000 | 4.14% |
| 70,000 | 7.18% |
| 80,000 | 10.05% |
| 90,000 | 12.79% |
| 100,000 | 15.41% |
| 110,000 | 17.95% |
| 120,000 | 20.41% |
| 130,000 | 22.82% |
| 140,000 | 25.17% |
| Chart Tickler | |
| Data Table | |
| Investment | |
| Amount | NPV |
| 440000 | |
| 450000 | |
| 460000 | |
| 470000 | |
| 480000 | |
| 490000 | |
| 500000 | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
