A 4 Loan Amortization 5 A You Are Contemplating Purchasing A Home Given The Following Information Concerning The Mortg 1 (55.24 KiB) Viewed 23 times
A 4 Loan Amortization 5 A You Are Contemplating Purchasing A Home Given The Following Information Concerning The Mortg 2 (94.6 KiB) Viewed 23 times
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)