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

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