Begin by plotting how the NPV of this project changes with different discount rates. Note that you'll have to find the NPV of the project first using a discount rate of your choosing. Use a data table to create this plot. Have your discount rates range from 0% to 60% in increments of 2%. Please label your x-axis "Discount Rate" and your y-axis "Net Present Value of Cash Flows". Title your graph "NPV Calculation". There should be no legend on the graph. How many IRRs does this project have? What are they? Perform your IRR calculations in the box on the left.

PLEASE SHOW EXCEL FORMULA/WORK

Year Cash Flow 0 -1000 800 2 1000 Begin by plotting how the NPV of this project changes with different discount rates. Note that you'll have to find the NPV of the project first using a discount rate of your choosing. Use a data table to create this plot. Have your discount rates range from 0% to 60% in increments of 2%. Please label your x-axis "Discount Rate" and your y-axis "Net Present Value of Cash Flows". Title your graph "NPV Calculation". There should be no legend on the graph. How many IRRs does this project have? What are they? Perform your IRR calculations in the box on the left. 1300 4 -2200