Please show answer and calculation in an excel spreadsheet. You are offered the opportunity to put some money away for retirement. You will receive $10$ annual payments of $$5,000$ each beginning in $26$ years. If you desire an annual interest rate of $12\%$ compounded monthly, answer the following two questions:

a$.$ How much would you be willing to invest today?

b$.$ How much would the money $($that you will be willing to invest today$)$ be worth at the end of your last payment $($i$.$e$.,$ in year $35)?$

a$.$ Amount that you would be willing to invest today $=$

PV $=$ $$5,000/(1\mathrm{.}01)26*12+$ $$5,000/(1\mathrm{.}101)27*12+$ $$5,000/(1\mathrm{.}01)28*12+$ $$5,000/(1\mathrm{.}01)29*12+$ $$5,000/(1\mathrm{.}01)30*12+$ $$5,000/(1\mathrm{.}01)31*12+$ $$5,000/(1\mathrm{.}01)32*12+$ $$5,000/(1\mathrm{.}01)33*12+$ $$5,000/(1\mathrm{.}01)34*12+$ $$5,000/(1\mathrm{.}01)35*12$

$=$ $$1,388\mathrm{.}638$

b$.$ Amount that would the money worth at the end of your last payment $=$

FV $=$ $$1388\mathrm{.}64*(1+0\mathrm{.}01)35*12$

$=$ $$90691\mathrm{.}52$