Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

We just paid a lump sum to our mortgage to reduce principal. Can some one give me a formula to find savings?

I want to find out the monthly interest saved and how many years we have taken off the loan, especially if we continue to reduce principal.

4 Answers

Relevance
  • Dan B
    Lv 7
    1 decade ago
    Favorite Answer

    Go to the site below and download an Excel spreadsheet for the "Home Mortgage Calculator". It will allow you to figure EVERYTHING out, really! It will allow you to put in a monthly added principal and/or a lumpsum payment (as in your case). It will show you what you owe, how much you've paid, how long it will take you to pay your mortgage. It shows your amortization schedule, also.

    I've been using it for a couple of years. It's the best program I've found.

  • Anonymous
    1 decade ago

    there is no single easy formula - you basically knocked a couple of mortgage payments off teh ned of the mortgage and gong forward, the amount of your monthly payment that goes towrds principle with increase a little faster

    without knowing how big a lump sum - hard to answer any further

    most mortgage alulators online assume an extra amount being paid every month - some might have a lump sum calculation included

    google mortgage calculators

  • sar
    Lv 5
    1 decade ago

    if you make every year 1 extra payment you are reducing 7 years of your loan

  • 1 decade ago

    Hi,

    I used "Quicken Loans" to refinance my home.Their rates for refinance and mortgage are very low even though my credit score is very bad.Check it out here:

    http://quickenloans2010.notlong.com/

Still have questions? Get your answers by asking now.