Please show how to DO this using formulas. thank you!

11. Time value-Annuities Personal Finance Problem Marian Kirk wishes to select the better of two 4-year annuities. Annuity 1 is an ordinary annuity of $2,670 per year for 4 years. Annuity 2 is an annuity due of $2,530 per year for 4 years. a. Find the future value of both annuities at the end of year 4, assuming that Marian can eam (1) 4% annual interest and (2) 8% annual interest. b. Use your findings in part a to indicate which annuity has the greater future value at the end of year 4 for both the (1) 4% and (2) 8% interest rates.. c. Find the present value of both annuities, assuming that Marian can eam (1) 4% annual interest and (2) 8% annual interest. d. Use your findings in partc to indicate which annuity has the greater present value for both the (1) 4% and (2) 8% interest rates. e. Briefly compare, contrast, and explain any differences between your findings using the 4% and 8% interest rates in parts b and d. a. The future value of Annuity 1 at 4% interest is $ (Round to the nearest cent.) The future value of Annuity 2 at 4% interest is $ (Round to the nearest cent.) The future value of Annuity 1 at 8% interest is $ (Round to the nearest cent.) The future value of Annuity 2 at 8% interest is $ (Round to the nearest cent.) b. Using your findings in part a, which annuity has the greater future value at the end year 4 at 4% interest? (Select the best answer below.) O Annuity 2 a Annuity 1 Using your findings in parti which annuity has the greater future value at the end of year 4 at 8% interest? (Select the best answer below.) O A. Annuity 1 OB. Annuity 2 c. The present value of Annuity 1 at 4% interest is $ (Round to the nearest cent.) The present value Annuity 2 at 4% interest is $ (Round to the nearest cent.) The present value of Annuity 1 at 8% interest is $ (Round to the nearest cent.) The present value of Annuity 2 at 8% interest is $ (Round to the nearest cent.) d. Using your findings in part c, which annuity has the greater present value at the end of year 4 at 4% interest? (Select the best answer below.) Annuity 1 Annuity 2