This Excel exercise is designed to find the present value of future cash flows. Assume there are two projects X & Y with cash flows at the end of the ne: ssume that the required rate of return on projects is equal to 10% Required I 10% Today Yearl Year2 Year3 Project X -100 10 60 70 Project Y -100 80 40 20 In the space below calculate the Net Present Values of projects X & Y by using the present value formula of Excel (=PV(rate,nper,pmt,[fv]). Note: because these are uneven cash flow streams the pmt = 0. We can then solve for the PV of each cash flow, where each cash flowisa FV. In cell C14, you can type "=c13". In cell D14 you will type "=PV(8$J$2, D12. 0, -D13)". You can then copy cell D14 to cells E14 and F14. Next you simply need to sum the cells C14, C14, E14. and F14. to calculate the NPV for Project X. ow we will find the NPV of Project X using a different approach. In cell C21 type "=C20". In cell D21 type "=D20/(1+8J$2)"D19". Copy cell D21 t Sum row 21 to calculate NPV. Cash Flows -100 PV(CF) NPV [Now copy cells B12 to F15 into the space below and change the information to calculate the NPV of project Y. Check your answers with the book Exan Complete the information in the Table below by changing the required rate of return. 7, in cell J2 and inputing the NPV for projects X & Y using your a Create a NPV profile in the space below, by inserting a line graph from using data in the above Table