Discount rate B C D E H 15% a) Use NPV function to compute the net present value for the project to the left. Present Value b) Use Data Table to compute the net present value of the project for discount rate Cash flow of 0%, 4%, 8%..... 48%. Graph the results and estimate the project's internal rate -600 of return. 100 c) Use the IRR function to compute the internal rate of return of the project. 200 300 400 500 312.73 NPV(B1,B4:B9)*(1+B1) Year 0 1 2 3 8 4 9 5 10 NPV 11 12 Discount Rate WN 900 1234567 ggg123BBBB% 14 15 16 17 18 19 20 21 22 23 24 25 26 27 NPV 0 0.04 0.08 0.12 0.16 0.2 0.24 0.28 0.32 0.36 0.4 0.44 0.48