2 Investment X offers to pay you $5,300 per year for eight years, whereas Investment Y...

Transcribed Image Text:

2 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 percent? If the discount rate is 15 percent? 3 4 Input area: 5 6 Payment for X 7 Number of years for X 8 6 Payment for Y Number of years for Y Discount rate 10 11 Discount rate 12 $5,300 8 $7,300 5 5% 15% 13 14 (Use cells A6 to B11 from the given information to complete this question. Your answers should be p 15 Output area: 16 17 Value of X at 5% 18 Value of Y at 5% 19 Value of X at 15% 20 Value of Y at 15% 2 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 percent? If the discount rate is 15 percent? 3 4 Input area: 5 6 Payment for X 7 Number of years for X 8 6 Payment for Y Number of years for Y Discount rate 10 11 Discount rate 12 $5,300 8 $7,300 5 5% 15% 13 14 (Use cells A6 to B11 from the given information to complete this question. Your answers should be p 15 Output area: 16 17 Value of X at 5% 18 Value of Y at 5% 19 Value of X at 15% 20 Value of Y at 15%