Can these answers be done using excel formulas. And please answers all the questions $1.$ The current $10-$year bond offers a $2\mathrm{.}75\%$ in yield. The real rate as shown by $10$year

inflation adjusted bonds is $0\mathrm{.}95\%.$

Calculate the expected inflation. Be precise in your approach.

$2.$ You would like to borrow $$185,000$ over $30$ years at $4\mathrm{.}5\%$ interest.

a$.$ Calculate the monthly payments.

b$.$ Calculate the balance due after $10$ years.

$3.$ You would like to borrow $ $185000$ over $30$ years. The interest rate applied is $4\mathrm{.}5\%$ with

$1\mathrm{.}5$ points. Calculate the effective annual rate of interest you will be charged.

$4.$ Assume a homeowner at age $62,$ with an equity in the house of $$600,000,$ applies for a

reverse mortgage for $10$ years.

a$.$ Calculate the expected dollar value of the reverse mortgage $($see the textbook for the

terms and conditions in reverse mortgages$).$

b$.$ Calculate the monthly income received by the homeowner if the bank applies $3\mathrm{.}25\%$

in annual rate of interest.

$5.$ You borrow $$65,000$ with a variable rate loan for $10$ years. During years $1-3($for $3$ years$)$

you pay $2\mathrm{.}75\%.$

a$.$ Calculate the monthly payments.

b$.$ After the $3$rd year, the rate rises to $3\mathrm{.}5\%.$ Calculate your new monthly payments.

$6.$ Consider a $$250,000$ loan, $30$ years in maturity and $4\mathrm{.}25\%$ interest. Calculate the market

value of the loan after $5$ years if interest rates rise to $4\mathrm{.}5\%.$