1. Begin by plotting how the NPV of the project changes with different discount rates (table given below). 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%. Make sure all of the numbers in the data table have the proper format (e.g. decimal places and %/$).
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. Remove the grid lines. Remove any markers (the dots on the line).
2) How many IRRs does this project have?
Please show it on excel