In: Finance
James King bought a house three years ago that cost $750,000. James put up 20% deposit and borrowed the rest from FC Bank at a rate of 7.2% per annum, compounded monthly, for 10 years.
Three months ago, FC Bank notified James that after the last monthly payment for the third year, the interest rate on his loan will increase to 9.6% per annum, compounded monthly, in line with market rates. Also, from the fourth year of his loan James can either increase the monthly repayment (so as to pay off the loan by the originally agreed date), or he can keep paying the same original monthly repayment and extend the term of the loan.
Use a spreadsheet for the ease in computations. Enter values and formulas in the spreadsheet as shown in the image below.
The obtained result is provided below.