Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started