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

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 Accounting Questions!