a. NPVIRRMIRRPaybackDiscounted PaybackM$4,330.8119.86%17.12%3 years4.17 yearsN$6,126.2716.80%15.51%3.21 years4.58 years Create the Scatterplot							Discount rate	NPV
1) Enter a range or Discount Rates in the appropriate column in Col H. I recommed starting at 0% and using increments of 5%.
2) Calculate the NPV for each Discount Rate. For your solution to Problem 7, enter in the various discount rates, and then type in the resulting NPV in the NPV column of Col I.
3) When finished, highlight your table, including the headings "Discount rate" and "NPV".
4) Click on the Insert menu across the top of the Excel window.
5) Within the Charts submenu across the top, click the picture that looks like a scatter of individual points. A window should pop up labeled "Scatter".
6) In the window that appears, select the picture that shows straight lines connecting individual points.
7) Make any formatting changes that you deem necessary.