Question

A while ago, a couple purchased a home with a sales price of $890,000, making a 20% down payment and financing the rest with a 30-year adjustable rate mortgage fixed at 3.5% for the first seven years. Now that the fixed rate period is up, the couple is facing a higher adjustable rate. They now plan to refinance into a fixed rate 15-year mortgage at 4.9%, allowing them to pay it off before they retire. What will their new monthly payments be? Assume there are no costs associated with the refinance.

Answer = $ (Round to the nearest cent/penny)

Note: In many adjustable rate mortgages, there is a period of time where the interest rate is fixed. After that time, the rate can adjust regularly based on economic conditions and bank policy. This means the monthly payments could change dramatically once the "fixed rate" period, in this case the first 7 years, is over.

Please show your work

Answer 1

Purchase consideration less: Down Payment @ 20% Amount Loan $ $ $ 8,90,000 1,78,000 7,12,000 Rate of Interest Tenure of Loan 3.50% 30 years Monthly Payments PMT rate/12, timex12, Present Value) PMT 3.5%/12, 30x12, $712,000) $ 3,197.20 per month Payment has been Made for 7 years ( 84 months), so will have to prepare a amortization schedule for 84 months Principal component Closing Month EMI(C) (d =c-b) Balance (a-d) Interest (b Opening = a + 3.50% Balance (a) | /12) $ 7,12,000 $2,076.67 $ $ 7,10,879.47 $2,073.40 $ $7,09,755.67 $2,070.12 $ $ 7,08,628.59 $2,066.83 $ $ 7,07,498.23 $2,063.54 $ $7,06,364.56 $2,060.23 $ $ 7,05,227.60 $2,056.91 $ $7,04,087.31 $2,053.59 $ $ 7,02,943.70 $2,050.25 $ $ 7,01,796.76 $ 2,046.91 $ $ 7,00,646.47 $ 2,043.55 $ $6,99,492.82 $ 2,040.19 $ $6,98,335.81 $ 2,036.81 $ $6,97,175.42 $2,033.43 $ $6,96,011.65 $2,030.03 $ $6,94,844.49 $ 2,026.63 $ $6,93,673.92 $ 2,023.22 $ $ 6,92,499.94 $2,019.79 $ $6,91,322.53 $2,016.36 $ $6,90,141.69 $ 2,012.91 $ $6,88,957.41 $2,009.46 $ $6,87,769.67 $2,005.99 $ $6,86,578.46 $ 2,002.52 $ $6,85,383.79 $ 1,999.04 $ $6,84,185.62 $ 1,995.54 $ $6,82,983.97 $ 1,992.04 $ $6,81,778.81 $ 1,988.52 $ $6,80,570.13 $ 1,985.00 $ 3,197.20 $ 1,120.53 $ 7,10,879.47 3,197.20 $ 1,123.80 $7,09,755.67 3,197.20 $ 1,127.08 $7,08,628.59 3,197.20 $ 1,130.36 $7,07,498.23 3,197.20 $ 1,133.66 $7,06,364.56 3,197.20 $ 1,136.97 $7,05,227.60 3,197.20 $ 1,140.28 $7,04,087.31 3,197.20 $ 1,143.61 $7,02,943.70 3,197.20 $ 1,146.95 $7,01,796.76 3,197.20 $ 1,150.29 $7,00,646.47 3,197.20 $ 1,153.65 $6,99,492.82 3,197.20 $ 1,157.01 $6,98,335.81 3,197.20 $ 1,160.39 $6,97,175.42 3,197.20 $ 1,163.77 $6,96,011.65 3,197.20 $ 1,167.16 $6,94,844.49 3,197.20 $ 1,170.57 $6,93,673.92 3,197.20 $ 1,173.98 $6,92,499.94 3,197.20 $ 1,177.41 $6,91,322.53 3,197.20 $ 1,180.84 $6,90,141.69 3,197.20 $ 1,184.28 $6,88,957.41 3,197.20 $ 1,187.74 $6,87,769.67 3,197.20 $ 1,191.20 $6,86,578.46 3,197.20 $ 1,194.68 $6,85,383.79 3,197.20 $ 1,198.16 $6,84,185.62 3,197.20 $ 1,201.66 $6,82,983.97 3,197.20 $ 1,205.16 $6,81,778.81 3,197.20 $ 1,208.68 $6,80,570.13 3,197.20 $ 1,212.20 $ 6,79,357.93

$6,79,357.93 $ 1,981.46 $ $6,78,142.19 $ 1,977.91 $ $6,76,922.91 $1,974.36 $ $6,75,700.07 $ 1,970.79 $ $6,74,473.66 $ 1,967.21 $ $6,73,243.68 $ 1,963.63 $ $6,72,010.11 $ 1,960.03 $ $6,70,772.94 $1,956.42 $ $6,69,532.16 $1,952.80 $ $6,68,287.76 $ 1,949.17 $ $6,67,039.74 $1,945.53 $ $6,65,788.07 $ 1,941.88 $ $6,64,532.76 $ 1,938.22 $ $6,63,273.78 $ 1,934.55 $ $6,62,011.13 $1,930.87 $ $6,60,744.80 $ 1,927.17 $ $6,59,474.77 $1,923.47 $ $6,58,201.04 $1,919.75 $ $6,56,923.60 $ 1,916.03 $ $6,55,642.42 $ 1,912.29 $ $6,54,357.52 $ 1,908.54 $ $6,53,068.86 $ 1,904.78 $ $6,51,776.45 $ 1,901.01 $ $6,50,480.26 $ 1,897.23 $ $6,49,180.30 $ 1,893.44 $ $6,47,876.54 $ 1,889.64 $ $6,46,568.99 $ 1,885.83 $ $6,45,257.61 $ 1,882.00 $ $6,43,942.42 $ 1,878.17 $ $6,42,623.38 $ 1,874.32 $ $6,41,300.50 $ 1,870.46 $ $ 6,39,973.77 $1,866.59 $ $6,38,643.16 $ 1,862.71 $ $6,37,308.67 $ 1,858.82 $ $ 6,35,970.29 $ 1,854.91 $ $6,34,628.00 $ 1,851.00 $ $6,33,281.80 $1,847.07 $ $6,31,931.68 $ 1,843.13 $ $6,30,577.61 $ 1,839.18 $ $6,29,219.60 $ 1,835.22 $ $6,27,857.62 $ 1,831.25 $ $6,26,491.68 $1,827.27 $ $6.25.121.75 $ 1.823.27 $ 3,197.20 $ 1,215.74 $ 6,78,142.19 3,197.20 $ 1,219.28 $6,76,922.91 3,197.20 $ 1,222.84 $6,75,700.07 3,197.20 $ 1,226.41 $6,74,473.66 3,197.20 $ 1,229.98 $6,73,243.68 3,197.20 $ 1,233.57 $6,72,010.11 3,197.20 $ 1,237.17 $6,70,772.94 3,197.20 $ 1,240.78 $6,69,532.16 3,197.20 $ 1,244.40 $6,68,287.76 3,197.20 $ 1,248.03 $6,67,039.74 3,197.20 $ 1,251.67 $6,65,788.07 3,197.20 $ 1,255.32 $6,64,532.76 3,197.20 $ 1,258.98 $6,63,273.78 3,197.20 $ 1,262.65 $6,62,011.13 3,197.20 $ 1,266.33 $6,60,744.80 3,197.20 $ 1,270.03 $6,59,474.77 3,197.20 $ 1,273.73 $6,58,201.04 3,197.20 $ 1,277.45 $ 6,56,923.60 3,197.20 $ 1,281.17 $6,55,642.42 3,197.20 $ 1,284.91 $6,54,357.52 3,197.20 $ 1,288.66 $6,53,068.86 3,197.20 $ 1,292.41 $6,51,776.45 3,197.20 $ 1,296.18 $6,50,480.26 3,197.20 $ 1,299.96 $6,49,180.30 3,197.20 $ 1,303.76 $6,47,876.54 3,197.20 $ 1,307.56 $6,46,568.99 3,197.20 $ 1,311.37 $6,45,257.61 3,197.20 $ 1,315.20 $6,43,942.42 3,197.20 $ 1,319.03 $6,42,623.38 3,197.20 $ 1,322.88 $6,41,300.50 3,197.20 $ 1,326.74 $6,39,973.77 3,197.20 $ 1,330.61 $6,38,643.16 3,197.20 $ 1,334.49 $6,37,308.67 3,197.20 $ 1,338.38 $ 6,35,970.29 3,197.20 $ 1,342.28 $6,34,628.00 3,197.20 $ 1,346.20 $6,33,281.80 3,197.20 $ 1,350.13 $6,31,931.68 3,197.20 $ 1,354.06 $6,30,577.61 3,197.20 $ 1,358.01 $6,29,219.60 3,197.20 $ 1,361.97 $6,27,857.62 3,197.20 $ 1,365.95 $6,26,491.68 3,197.20 $ 1,369.93 $6,25,121.75 3.197 20 $ 1.272.92 $6.22.747.82

$6,23,747.82 $1,819.26 $ $6,22,369.89 $1,815.25 $ $6,20,987.93 $ 1,811.21 $ $6,19,601.95 $1,807.17 $ $6,18,211.93 $1,803.12 $ $6,16,817.85 $ 1,799.05 $ $6,15,419.70 $ 1,794.97 $ $6,14,017.47 $1,790.88 $ $ 6,12,611.16 $ 1,786.78 $ $ 6,11,200.75 $1,782.67 $ $6,09,786.22 $1,778.54 $ $6,08,367.56 $ 1,774.41 $ $6,06,944.77 $1,770.26 $ 3,197.20 $ 1,377.93 $6,22,369.89 3,197.20 $ 1,381.95 $6,20,987.93 3,197.20 $ 1,385.98 $6,19,601.95 3,197.20 $ 1,390.03 $6,18,211.93 3,197.20 $ 1,394.08 $6,16,817.85 3,197.20 $ 1,398.15 $6,15,419.70 3,197.20 $ 1,402.22 $6,14,017.47 3,197.20 $ 1,406.31 $6,12,611.16 3,197.20 $ 1,410.42 $6,11,200.75 3,197.20 $ 1,414.53 $6,09,786.22 3,197.20 $ 1,418.66 $6,08,367.56 3,197.20 $ 1,422.79 $6,06,944.77 3,197.20 $ 1,426.94 $ 6,05,517.83 82 83 84 After 7 years, Principal outstanding $6,05,517.83 New financing structure: Rate of Interest Tenure of Loan 4.90% 15 years Monthly Payments PMT rate/12, timex12, Present Value) PMT 4.90%/12, 15x12, $605,517.83) $ 4,756.91 Thus revised Monthly Payments will be : $ 4,756.91 per month

Hope it helps, In case of any doubt or Issue, Please comment below