Excel to construct a partial amortization schedule, along with total

principal and interest portions, for any given year of the amortization term. You will need to

include an input cell for a chosen year, and your partial amortization schedule should update

automatically when the chosen year changes.

$7.$ Catherine received a student loan of $$30,000$ at $3\mathrm{.}73\%$ compounded monthly. She

makes semi$-$monthly $($twice a month$)$ end$-$of$-$period payments for eight years to settle the

loan.

$8.$ John Stubbs wants to expand his prosthetics company and borrows $$400,000$ at $5\mathrm{.}63\%$

compounded daily. The loan is amortized over $20$ years with payments made at the end

of every month.