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?

Complete your analysis setting up the spread sheet.

Do not hard code values in your calculations.

All answers should be positive.