7. You receive $5,000 per year for the next 20 years from your Grandmothers trust. If a 7% interest rate is applied, what is the present value of the future payment?

8. If you deposit $5,000 per year for the next 20 years into an account paying 10%, how much money will you have in the account in after the 20 years? Suppose you decide to invest this $5,000 per year in the same account earning 10% for 40 years rather than 20, how much will you have in the account after 40 years?

please show work in excel. Thank you