Question

Mister Greenjeans wants to borrow $2.5 million to purchase farmland to grow soybeans. He has approached the agriculture services division at his bank to arrange a farm mortgage. The bank has quoted him a rate of 5% over a 25 year amortization with quarterly payments of $43 801. Mister Greenjeans anticipates that he will have to borrow an additional $0.475 million after 12 years for land improvement costs. This extra principal will be added to the balance owing on the mortgage. If Mister Greenjeans continues making quarterly payments shown above, how long will it take him to pay off the mortgage? (Express your answer in years and round to the nearest integer value.)

PLEASE EXPLAIN AND SHOW ALL STEPS. THANKS IN ADVANCE.

Answer 1

Original loan	2,500,000.00
Tenure	100
Rate	0.0125
Quarterly payments	43801
Loan balance paid in 12 years	-827467.56
Balance remaining after 12 years	1,672,532.44
New loan amount	2,147,532.44
Rate	0.0125
Quarterly payments	43801
Quarters taken for paying the amount	76.39
Number of years	19.10
Years rounded off	19 years

WORKINGS