H 1094 This Exell 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 next three years as follows. Assume that the required rate of return on projects is equal to 10%. Required Return Year 1 Project X Project Y Today Year 2 Year 3 -100 10 60 70 -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 (PVrate.mper.pont.[v]). Note: because these are uneven cash flow streams the pat -0. We can then solve for the PV of each cash flow, where each cash flow is a FV. In cell C14. you can type "mc13". In cell D14 you will type "-PV(SJS2, D12, 0.-D13)". You can then copy cell D14 to cells E14 and 14 Next you simply need to sum the cells C14. C14, E14, and F14, to calculate the NPV for Project X 1 2 3 3 -100 10 60 70 Project X Cash Flows PV(CF) NPV 6 0 3 7 Now we will find the NPV of Project X using a different approach. In cell C21 type C20". In cell D21 type D20/1+$JS2D19". Copy cell D21 to E21 and F21. Sum row 21 to calculate NPV. Project X 1 2 Cash Flows -100 10 60 70 PV(CF) NPV 20 22 24 Now copy cells B12 to F1S into the space below and change the information to calculate the NPV of project Y Check your answers with the book Example 2 of Chapter 10 25 26 23 Sheet1 Sheet2 14 G O BI Type here to search 19 0 1 2 3 Project X Cash Flows 20 -100 10 60 70 23 PV(CE) NPV 22 23 24 Now copy cells B12 to F1s into the space below and change the information to calculate the NPV of project Y Check your wer with the book Example 2 of Chapter 10 25 26 27 2 20 30 31 Complete the information in the Table below by changing the required rate of retain cell J2 and inputing the NPV for projects XY uning your walysis above 12 33 F NPVX) NPV) 34 046 596 35 36 10% 37 159 2016 2:59 10 40 41 Create a NPV profile in the space below. by imetine a lime gruple from using data in the above Table 42 14 Sheet Sheet O G 2 28 Type here to search