What excel formula would i plug in for all of the answer boxes to get the correct answer?

D18 . B C D E F G H I J - 1 2 3 Investment X offers to pay you $4,700 per year for eight years, whereas Investment Y offers to pay you $6,700 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? 4 + 5 $ 6 7 8 Payment for X Number of years for X 4.700 8 $ Payment for Y Number of years for Y 6,700 5 on 9 10 11 12 13 14 Discount rate Discount rate 5% 15% 15 16 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 17 18 Value of X at 5% 19 $ Payment for Y Number of years for Y 6,700 5 1 2 Discount rate Discount rate 3 5% 15% 2 5 6 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 7 8 Value of X at 5% 9 0 1 Value of Y at 5% 2 Value of X at 15% 3 4 Value of Y at 15% 5 6 + 7 8 Sheet1 READY Attempt(s) 1/3