Question: 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
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 %/$). Q. How many IRRs does this project have?
please show it on excel
| Year | Cash Flow |
| 0 | -1000 |
| 1 | 800 |
| 2 | 1000 |
| 3 | 1300 |
| 4 | 300 |
| 5 | -2500 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
