OLVED QUESTIONS 1 and 2 and need help solving QUESTION 3 ONLY 1. A bank customer obtains a $150,000 mortgage with a term of 15 years and a nominal interest rate of 4.20%. The monthly debt service/payment for the mortgage : Answer - $1,124.63 2) If the homeowner makes the minimum monthly required payments on the mortgage, what is the balance on the mortgage after 5 years – i.e. after the 60th payment is made: Answer - $110,043.38 3) Assume the homeowner has made the minimum required monthly payments on the mortgage and 5 years have passed. If the homeowner’s income has increased and he/she decides to increase the monthly payments to $1500, how many months and years will it take to retire the mortgage? Months Years?
QUESTIONS 1,2,3 ARE CONNECTED. I SOLVED QUESTIONS 1 and 2 and need help solving QUESTION 3 ONLY
1. A bank customer obtains a $150,000 mortgage with a term of 15 years and a nominal interest rate of 4.20%. The monthly debt service/payment for the mortgage : Answer - $1,124.63
2) If the homeowner makes the minimum monthly required payments on the mortgage, what is the balance on the mortgage after 5 years – i.e. after the 60th payment is made: Answer - $110,043.38
3) Assume the homeowner has made the minimum required monthly payments on the mortgage and 5 years have passed. If the homeowner’s income has increased and he/she decides to increase the monthly payments to $1500, how many months and years will it take to retire the mortgage?
Months Years?
*PLEASE SOLVE #3 USING EXCEL ONLY AND SHOW THE FUNCTIONS/FORMULAS USED*
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
