need a formula on excel to plug into the cell for these answers. if it specifies a function to use we need to use that function.

5) At the end of each of the next 20 years, Iwill receive the following amounts Years Amounts 1-5 $200 6 10 $300 11 -20 $400 fows f the ost of oapital is 10 Use the PV function to find the present value of these cash flows if the cost of capital is 10 percent $200 for 5 years starting now $300 for 5 yrs starting EOYS $400 for 10 yrs starting EOY11 Total 0 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 Term Rate Pv 7% 100.00 Amount