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?

Input area:

Payment for X $$5,300$

Number of years for X $8$

Payment for Y $$7,300$

Number of years for Y $5$

Discount rate $5\%$

Discount rate $15\%$

$($Use cells A$6$ to B$11$ from the given information to complete this question.Your answers should be positive values.$)$

Output area:

Value of X at $5\%$ Formula?

Value of Y at $5\%$ Formula?

Value of X at $15\%$ Formula?

Value of Y at $15\%$ Formula?