if you could please give me the simple formula and excel formula for this question. thank you

von WN + Investment X offers to pay you $5,300 per year for eight years, whereas Investment Y offers to pay you $7,300 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 2 percent? If the discount rate is 15 percent? 3 4 Input area: 5 Payment for X $5,300 Number of years for X 8 Payment for Y $7,300 Number of years for Y 10 Discount rate 5% 11 Discount rate 12 13 (Use cells A6 to 811 from the given information to complete this question. Your answers should be positive values.) 6 7 8 9 5 15% 14 15 Output area: 16 17 Value of X at 5% 18 Value of Y at 5% 19 Value of X at 15% falin nf ynt 150 $3,587.25