PLEASE SHOW ALL FORMULAS USING EXCEL. FOR EXAMPLE =PV(C42,C41,C40,0,0)

B D G K ($83,735,721.59) 0 6 Points possible 45 46 47 5) At the end of each of the next 20 years, I will receive the following amounts: 48 Years Amounts 1-5 $200 6 - 10 $300 11 - 20 $400 Use the PV function to find the present value of these cash flows if the cost of capital is 10 percent 49 50 51 52 53 54 55 56 57 58 59 60 61 62 $200 for 5 years starting now. $300 for 5 yrs starting EOY6 $400 for 10 yrs starting EOY11 Total 0 2 Points possible 0 3 Points possible 0 3 Points possible 0 2 Points possible 0 10 Points possible 6) Use the FV function to determine the value to which $100 today accumulates to over three years if you are earning 7 percent per year. 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 00 Term Rate PV 3 7% 100.00 $ Amount 0 5 Points possible