Scenario $1-$Vanilla $$ Sheet $2$

You are a loan officer and your next client is Sandra Patterson. Sandra wants to borrow $$720,000$ from the bank at $9\%$ percent interest compounded monthly to be repaid over $45$ years. Complete the following:

$$ Workings illustrating the payment to be paid monthly

$$ Amortization table for entire loan period

Scenario $2-$Pre$-$Payment $$ Sheet $3$

Sandra is advised to make additional monthly payments on the principal of $$1440$ for the first four years. Complete the following:

$$ Workings illustrating the payment to be paid monthly

$$ Amortization table for entire loan period

Scenario $3-$Downpayment on Vanilla $$ Sheet $4$

Assume after explaining Scenario $1$ and $2$ to your boss, they recommend that Sandra make a down payment of $$21600,$ thereby reducing the loan to $$698400.$ Complete the following:

$$ Workings illustrating the payment to be paid monthly

$$ Amortization table for entire loan period

Scenario $4-$Downpayment on Vanilla and prepayments $$ Sheet $5$

In addition to the down payment of $$21600,$ Sandra is advised to make additional monthly payments on the principal of $$1440$ for the first four years. Complete the following:

$$ Workings illustrating the payment to be paid monthly

$$ Amortization table for entire loan period