plesse do on paper not excel

1 200 1. Consider the following ANNUAL cash flows from 5 potential capital budgeting projects (A-E). NOTE that the negative cash flows in year 0 are the initial cash flows. Year A B C D E 0 -250 -375 -550 -750 -1150 50 45 350 80 2 90 55 210 235 135 140 65 165 250 190 4 80 55 55 255 5 45 45 6 35 10 50 380 7 25 275 8 15 100 9 45 10 25 3 265 100 315 5 Using a 10% required rate of return, calculate the NPV and the IRR for each project