excel formulas

Investment X offers to pay you $4,700 per year for olght 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? 5 6 Payment for X Number of years for X 4,700 8 7 8 Payment for Y Number of years for Y 6.700 5 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. Value of X at 5% 17 18 19 20 Value of Y at 5% Sheet1 + READY + 100 Attempt(s) 9 10 Pion for y Numbor of yours for Y 0700 5 12 Discount ratio Discount rato 5% 15% 13 15 16 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Value of X at 5% 18 19 20 Value of Y at 5% Value of X at 15% 24 25 Value of Y at 15% 28