You consider purchasing a $$450,000$ home for which you will be making a $20\%$ down payment and obtaining a mortgage to finance the remaining amount. The mortgage is for $30$ years $(360$ months$)$ and has a fixed nominal annual rate of $5\mathrm{.}5$ percent, with monthly payments made at the end of months.

$1.$ Fill out the blank blue cells in the Mortgage Input and Basic Output sections.

$2.$ Complete the mortgage amortization schedule.

$3.$ Insert the graphs for:

a$.$ Interest & Principal

$12$

$3$

$4$

$56$

$678$

$8$

$9$

$10$

$11$

$12$

$13$

$14$

$1516$

$1617$

$18$

$1920$

$2021$

$2223$

$2324$

$2526$

$2627$

$2829$

$30$