Help please!

A 4 Loan Amortization 5 a) You are contemplating purchasing a home. Given the following information concerning the mortgage, calculate 6 the borrowed amount and the monthly payment, then complete the MONTHLY amortization table (to the right). 7 8 House purchase price 19 Down payment % 10 Borrowed amount 11 12 Loan Term (years) 13 APR (%) 14 Monthly payment 15 B 21 22 Extra payment amount 23 $210,000 18% 15 3.45% C D HINT: the amount borrowed is the purchase price minus the down payment amount. E F 16 17 b) You are considering making an additional payment each month to reduce the principal more quickly. Incorporate the extra payment into your amortization table. 18 197 Then, use GOAL SEEK to determine the extra payment amount that would pay off your mortgage 20 in 11 years. G H Place a negative sign in front of the PMT function so a positive payment is displayed (this works better when creating the amortization table) 600an is WN 3 5 8 9 10 11 12 422T 13 14 15 16 597 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Period Beginning Balance 1 2 13 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 K 32 33 34 Accrued Interest M N Monthly Payment Principal Payment O Ending Balance