Your grandmother will be giving you $10,000 every year for the next five years, the first payment beginning at the end of the first year

A) What is the present value of these receivables if the interest rate is 6%?

B) If you invest these receivables in a bank at 6%, what is the total value at the end of 10 years if you make withdrawals of $3,000 in years 9 and 10?

C) What is the relationship between interest rates and present value?

Please show the excel formulas