What is the present value of a 6-year ordinary annuity of $2,500 per year plus an additional $1,000 at the end of Year 6 if the interest rate is 6%? Please solve using the present value formula in excel. Upload a copy of your spreadsheet to show your work and please separately include a written explanation to accompany your answer.

a.$6,679.73

b.$9,347.89

c.$11,278.17

d.$12,998.27

e.$13,735.8