Investment X offers to pay you $$4,700$ per year for $8$ years, whereas Investment Y offers to pay you $$6,700$ per year for $5$ 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?

Please show calculations as in excel