Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows $6$ through $11.$ The required answers are in rows $17$ through $20.$

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\%$

Value of Y at $5\%$

Value of X at $15\%$

Value of Y at $15\%$