REAL-TIME QUOTES


- advertisement -
Columns: Dr. Don
Don Taylor, Ph.D., CFA, CFP   Expert: Don Taylor, Ph.D., CFA, CFP
Ask Dr. Don
Savings can add up to thousands
Ask Dr. Don

Extra payments can trim decade off loan
 

Dear Dr. Don,
I've looked at Bankrate's mortgage amortization calculators. However, I am trying to calculate how much faster a loan pays off when extra payments are made to principal. These principal payments would start after the loan is three years into the initial term.

- advertisement -

I don't see an option to add $X amount to the principal with a starting date. I see where it says $X amount yearly, but not on a monthly basis. How can I calculate the payoff date?
-- Marlene Matrice

Dear Marlene,
It's pretty easy to use Bankrate's Mortgage payment calculator in a two-step process to achieve the result you're attempting to model. First, input the parameters of the initial loan. Then, go to the amortization schedule to find the loan balance at the end of three years.

Finally, change the loan term to 27 years, change the loan amount to the loan balance at the end of year three and input the amount of the monthly additional principal payment. Recalculate the amortization schedule and you're done. The amortization schedule will tell you how long it takes to pay off the remaining 27-year loan after considering the additional principal payments. Add three years to that payoff date and you have the final payoff date.

Here's an example that you can use to model your situation:
  Original
mortgage
Original mortgage with additional principal payments starting in year 3
Loan amount: $ 200,000.00 $ 192,168.14
(loan balance after three years)
Interest rate: 6.00%
Loan term (months): 360 324
(remaining loan term in months)
Loan balance after 36 months: $ 192,168.14  
Monthly payment: $ 1,199.10 $ 1,199.10
(monthly payment)
    $ 300.00
(additional principal payment)
$ 1,499.10
(total monthly payment)
Total payments: $ 431,676.38 $ 351,035.02
Total interest: $ 231,676.38 $ 151,035.02
Loan term (months): 360 242
(adjusted loan term: 36 + 206)

In this example, starting to pay an extra $300 a month in the third year reduces a 30-year fixed rate mortgage of $200,000 at 6 percent to roughly a 20-year mortgage. Making the additional principal payments saves you about $80,000 in interest expense on a pretax basis. The savings are less on an after-tax basis if you can use the mortgage interest deduction to reduce your federal income taxes.

Bankrate.com's corrections policy -- Posted: Jan. 31, 2008
More Q&A stories from Dr. Don
Ask a question

Mortgages
Compare today's rates
NATIONAL OVERNIGHT AVERAGES
30 yr fixed mtg 5.13%
15 yr fixed mtg 4.70%
5/1 ARM 4.30%
Rates may include points
RELATED CALCULATORS
  Calculate your monthly payment  
  How much house can you afford?  
  Fixed or adjustable rate: Which is right for you?  
VIEW ALL  
FINANCIAL LITERACY
Rev up your portfolio
with these tips and tricks.
- advertisement -
- advertisement -
News & Advice | Compare Rates | Calculators
Mortgage | Home Equity | Auto | Investing | Checking & Savings | Credit Cards | Debt Management | College Finance | Taxes | Personal Finance
About Bankrate | Privacy | Online Media Kit | Partnerships | Investor Relations | Press/Broadcast | Contact Us | Sitemap
NASDAQ: RATE | RSS Feeds | Order Rate Data | Bankrate Canada | Bankrate China

* Mortgage rate may include points. See rate tables for details. Click here.
* To see the definition of overnight averages click here.

Bankrate.com ®, Copyright © 2009 Bankrate, Inc., All Rights Reserved, Terms of Use.