Please use excel fumula as answer.

Angrent Number Conditional Format as Cell Formatting Table Styles . Styles Cells . Editing pard Font B E F GH 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,700 Payment for X Number of years for X $ 6,700 Payment for Y Number of years for Y Discount rate Discount rate 5% 15% Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. -EV-CO I QTILIUI! 6.700 Number of years for Y 5 Discount rate Discount rate 5% 15% Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Value of X at 5% Value of Y at 5% Value of X at 15% Value of Y at 15%