Create an Excel spreadsheet solution for mortgage amortization for a $$450,000$ loan, $30-$year loan,

at $6\mathrm{.}25\%$ fixed interest compounded monthly with no points but the flexibility to make additional payment each

month like the example explained in class.

a$.$ What is your monthly payment?

b$.$ What is the total amount of interest you pay over $30$ years?

c$.$ Assuming the $6\mathrm{.}25\%$ interest rate, what is the present worth of the principal portion of the payment at

the end of $20$ years?

d$.$ If you rounded your payment up to the nearest $$100,$ how would this impact your total amount of

interest paid and the life of your loan?