Q: My mortgage balance is $37,500, the interest rate is 5.99 percent, the maturity date 2019. I have been making periodic principle payments. Do you have a calculator that will provide information on how to pay off my mortgage given my current balance and making principle payments?
A: Most of HSH.com's prepayment calculators allow for regular additional payments of principal and will tell you when the loan will end and what your savings will be. Specifically, HSH.com’s It's My Term Prepayment Calculator allows you to enter the date when you want your loan to end and will tell you how much you'll need to pay to make that happen.
If you are making occasional, irregular prepayments of principal, we do have a calculator you can use, but you will need to download it and install it locally on your windows-based computer. You should visit www.hsh.com/hbcalc.html and download version 2.2.05 of HSH.com's Homebuyer's Calculator Suite.
Once you have downloaded and installed it, you can run your loan's amortization using the dropdown for "Amortization"; put in the basic loan parameters of start date, rate and term, then calculate payments.
Next, add your irregular prepayments one at a time on the dates you made them. Click "add prepayments," then using the "single payment" selection, select the payment number where you included extra cash and the amount, then click "apply extra." Repeat as needed for all the prepayments you made, and the updated results will appear at the bottom.
A 25-year expert observer of the mortgage and consumer debt markets, Keith Gumbinger has been cited in thousands of articles covering a wide range of consumer finance and economic topics in outlets ranging from the Wall Street Journal to the Bottom Line newsletters. He has been a featured guest on national broadcasts for CNN, CNBC, ABC, CBS and NBC television networks and has been heard on NPR and other national and local radio programs. Keith is the primary researcher and writer for HSH.com's MarketTrends newsletter and has authored or co-authored a number of consumer guides on mortgages, home equity, refinancing and more.
- Apr 26, 2013 How do I calculate the monthly payment on my HAMP mortgage?
- Apr 22, 2013 Should I refinance with a bank, direct lender or credit union?
- Apr 05, 2013 Why are mortgage rates higher for mobile homes?
- Mar 29, 2013 Where’s your amortization calculator?
- Mar 15, 2013 How do I calculate my interest-only mortgage payments?
- Mar 08, 2013 Why are home equity loan rates so high?
- Mar 01, 2013 Do you have a calculator that will track my prepayments?
- Feb 20, 2013 How do I shop for a refinance?
- Feb 13, 2013 How much do I owe on my mortgage?
- Feb 08, 2013 I have 3 years left on my loan, should I refinance?
- Jan 30, 2013 How many service providers must my lender identify?
- Jan 24, 2013 Can I refinance a rental property through HARP?
- Jan 16, 2013 What’s the website for obtaining a free credit report?
- Jan 09, 2013 What is a mortgage insurance premium? Do I need this?
- Jan 03, 2013 Can I get copies of checks from a past refinance?
- Dec 26, 2012 Can I do a deed-in-lieu of foreclosure if I have an FHA loan?
- Dec 19, 2012 Have you ever heard of a 60-year mortgage?
- Dec 12, 2012 Can I refinance an underwater ‘kiddie condo’?
- Dec 05, 2012 Will I still have an interest-only loan after a HAMP modification?
- Nov 27, 2012 My lender refuses to convert my second home to my primary residence so I can refinance. What can I do?
- Nov 14, 2012 What does the term ‘conforming’ mean?
- Nov 08, 2012 Is a construction-to-permanent mortgage right for me?
- Oct 31, 2012 Can my mortgage lender ask about my disability?
- Oct 25, 2012 How can I find out if HUD owes me a refund?
- Oct 15, 2012 I received a HAMP modification in 2010. Can I modify again?
- Oct 10, 2012 How can I contact the regulator that oversees my mortgage lender?
- Oct 03, 2012 Does mortgage insurance assist the survivors of a deceased policy holder?
- Sep 26, 2012 Can another lender modify my mortgage?
- Sep 19, 2012 Should I choose a cash-out refinance or a home equity loan?
- Sep 14, 2012 My credit score is 614. Can I get a mortgage?
- Sep 07, 2012 After bankruptcy, how long till I can get another mortgage?
- Aug 30, 2012 A suicide took place in the home I just bought. Why didn’t anyone tell me?
- Aug 24, 2012 My lender is using the wrong index when resetting my ARM. Help!
- Aug 15, 2012 How do I get off HUD’s ‘black list’?
- Aug 10, 2012 Am I eligible for HARP 2.0 despite my recent bankruptcy?
- Aug 03, 2012 Will shopping around for a refinance affect my credit?
- Jul 19, 2012 Is my lender required to give me a lower rate?
- Jul 11, 2012 What options and assistance are available to VA borrowers?
- Jul 06, 2012 Will these documents satisfy my lender's ‘gift’ requirements?
- Jun 28, 2012 Will biweekly mortgage payments save me money?
- Jun 20, 2012 Does PMI give any benefits to someone's credit if they default?
- Jun 12, 2012 We just sold our house, when do we have to pay the IRS?
- Jun 06, 2012 Can my friends and I buy a house together?
- May 30, 2012 I'm eligible for HARP, but my servicer doesn't participate. What can I do?
- May 23, 2012 My ARM rate changed—how can I check my lender’s calculation?
- May 17, 2012 Do I have mortgage insurance?
- May 03, 2012 The plumbing in my home is failing. Is there help?
- Apr 24, 2012 When do you predict the housing market to turn around?
- Apr 18, 2012 Why didn’t my bank notify me of my reduced HELOC?
- Apr 13, 2012 How do I get answers regarding CAIVRS?
- Apr 05, 2012 Can I lower my interest rate without refinancing?
- Apr 04, 2012 Are there any relief programs for underwater mortgages NOT backed by the FHA, Freddie Mac or Fannie Mae?
- Mar 27, 2012 Can I sign home equity loan papers at my house and mail them in?
- Mar 22, 2012 Am I eligible for a ‘Fannie Mae non-HAMP’ loan modification?
- Mar 20, 2012 How do I know when it's time to refinance?
- Mar 16, 2012 How can I pay off my mortgage in one year?
- Mar 14, 2012 Can I refinance for free?
- Mar 06, 2012 A failed bank holds a lien. How to proceed?
- Mar 02, 2012 Should I pay private mortgage insurance out of pocket or finance the cost?
- Feb 29, 2012 How can I find out who owns my mortgage?
- Feb 24, 2012 To get savings, is it better to prepay or refinance my mortgage?
- Feb 22, 2012 High debt loads but lots of equity. Can I get money for home improvement?
- Feb 15, 2012 Does it benefit me to make my mortgage payment 25 days early each month?
- Feb 07, 2012 Are reverse mortgage interest rates fixed or variable?
- Feb 03, 2012 Can I get forbearance for my mortgage?
- Jan 27, 2012 Haven't paid HOA fees. They are suing me. Can they foreclose?
- Jan 24, 2012 Can I refinance with an LTV above 80 percent?
- Jan 20, 2012 Living on investment income. Can we refinance our Jumbo mortgage?
- Jan 13, 2012 In bankruptcy, how soon can I refinance?
- Jan 10, 2012 Is a home equity line of credit tax-deductible?
- Jan 06, 2012 Will home sales finally improve in 2012?
- Dec 20, 2011 What is a home equity loan?
- Dec 16, 2011 Is it worth refinancing this mortgage?
- Dec 13, 2011 Which is better, a home equity loan or line of credit?
- Dec 09, 2011 What is the total interest cost of my loan?
- Dec 06, 2011 What is a home equity line of credit?
- Dec 02, 2011 We did a HARP refinance. Are we eligible for a HAMP modification?
- Nov 29, 2011 Should you refinance an adjustable-rate mortgage?
- Nov 25, 2011 I have equity, but am behind on a number of payments. Can I refinance?
- Nov 22, 2011 Can I refinance a fixed-rate FHA loan?
- Nov 17, 2011 What is a rate and term refinance?
- Nov 14, 2011 Will a refinance hurt my chances of getting my next mortgage?
- Nov 08, 2011 How can I get a FHA loan when my credit score is a 581?
- Nov 03, 2011 Is a Shared-Appreciation Modification really a good deal?
- Oct 31, 2011 Is a reverse mortgage right for you?
- Oct 28, 2011 Is this mortgage quote "bait and switch"?
- Oct 25, 2011 What is a reverse mortgage?
- Oct 20, 2011 Low appraisal, falling rates. Should the lender offer new terms?
- Oct 18, 2011 Where do I find a lender's current mortgage rates?
- Oct 14, 2011 I have lots of equity, but bad credit. Can I refinance?
- Oct 11, 2011 Will today's stock market influence tomorrow's mortgage rates?
- Oct 06, 2011 Deep in debt and want to retire. Should we "walk away"?
- Oct 04, 2011 Do record-low mortgage rates matter today?
- Sep 30, 2011 Can I refinance my home if my credit is bad?
- Sep 27, 2011 How are mortgage interest rates determined?
- Sep 22, 2011 How will I pay for my child's college?
- Sep 20, 2011 Why do mortgage rates change?
- Sep 16, 2011 How can I tell what my mortgage fees will be?
- Sep 13, 2011 Where can I find mortgage rates?
- Sep 08, 2011 How do I create a custom amortization schedule?
- Sep 06, 2011 Where are mortgage rates headed?
- Aug 30, 2011 How much house can I afford to buy?
- Jun 14, 2011 Will lenders ever consider my payment history over my FICO score?
- May 28, 2011 How do I cancel my Private Mortgage Insurance (PMI)?
- May 27, 2011 Can I refinance my second mortgage?
- May 26, 2011 I'm struggling with my payment. Can I refinance?
- May 20, 2011 Worried about ARM Reset
- May 19, 2011 Why is refinancing such a hassle?
- May 18, 2011 What are the rates and terms for an adjustable rate mortgage?
- May 17, 2011 Refinance a commercial office building?
- May 16, 2011 Reverse Mortgages for Co-ops?
- May 13, 2011 If I cancel seldom used credit cards, will this have an adverse effect on my credit rating?
- May 12, 2011 Is this loan fee normal?
- May 11, 2011 What mortgage rates is the Federal Reserve offering?
- May 10, 2011 What is the down payment required to get a mortgage these days?
- May 09, 2011 Where is my favorite mortgage amortization and prepayment calculator?
- May 06, 2011 How do I compare construction loan offers?
- May 05, 2011 Is refinancing a good idea for me?
- Apr 05, 2011 Can I qualify to refinance?
- Mar 29, 2011 Finding a Home Improvement Loan
- Feb 04, 2011 Two years into a 20-year mortgage. Should I accept this refinance offer?
- Feb 03, 2011 Should I consolidate my mortgage and line of credit into one loan?
- Feb 02, 2011 How much will I save by prepaying my mortgage?
- Feb 01, 2011 Should we consolidate our first and second mortgages into one loan?
- Jan 31, 2011 Bad credit but solid incomes. Can we get a mortgage?
- Jan 27, 2011 With a five-year time window, should I refinance?
- Jan 26, 2011 Underwater after a bankruptcy 3.5 years ago. Can I refinance?
- Jan 25, 2011 Should I lock in my interest rate or wait?
- Jan 24, 2011 Can I consolidate a second mortgage with a car loan?
- Jan 21, 2011 If I roll fees into my mortgage, what happens if it doesn't fund?
- Jan 20, 2011 We filed bankruptcy 2.5 years ago. Can we refinance?
- Jan 19, 2011 how best to consolidate credit card debt
- Jan 18, 2011 Does HSH.com have average auto loan rates?
- Jan 17, 2011 Do you have any mortgage rate tables?
- Jan 14, 2011 I want to prepay my mortgage
- Jan 13, 2011 I am looking for an home addition construction loan
- Jan 12, 2011 What is the best web site to use to find a mortgage?
- Jan 11, 2011 I'm trying to refinance a jumbo loan.
- Dec 09, 2010 We've got a six-year old mortgage. Should we refinance?
- Dec 08, 2010 Can you get a reverse mortgage on your home while you still have a first mortgage?
- Dec 07, 2010 With these qualifications, can I successfully refinance?
- Dec 06, 2010 Building a first home instead of buying?
- Dec 03, 2010 Refinance my two mortgages into one?
- Dec 02, 2010 Can I refinance an investment property with no equity?
- Dec 01, 2010 Can the seller of the property also be a cosigner of my loan?
- Nov 30, 2010 What is the difference between "rate" and "APR"?
- Nov 29, 2010 Can I use an equity loan to pay off my mortgage?
- Nov 26, 2010 What loan amount does a mortgage need to be for it to be considered a Jumbo Loan?
- Nov 25, 2010 What is the cost of getting a mortgage loan?
- Nov 24, 2010 Should I take and ARM or a fixed-rate mortgage?
- Nov 01, 2010 Would a reverse mortgage (HECM) work for me?
- Oct 31, 2010 Is it worth shortening my loan term?
- Oct 30, 2010 Financial trouble due to high property tax bill
- Oct 29, 2010 Modular home loan refinancing
- Oct 28, 2010 Relocating: Get my new mortgage here or there?
- Oct 27, 2010 Will my lender re-subordinate my second lien?
- Oct 26, 2010 After just two years, should I refinance again?
- Oct 25, 2010 Can we shorten our loan term without huge monthly prepayments?
- Oct 23, 2010 How long will late mortgage payments keep me from refinancing?
- Oct 22, 2010 Can we do a "cash-in" refinance?
- Oct 21, 2010 Can I refinance into an ARM instead of a fixed rate?
- Oct 20, 2010 What do the acronyms APR, FRM and ARM mean?
- Sep 30, 2010 Reverse Mortgages and Long-Term Costs
- Sep 29, 2010 Can I get a "no-cost" refinance?
- Sep 28, 2010 Should I walk away from this mortgage?
- Sep 27, 2010 Don't have 20% equity? Consider FHA refinance
- Sep 26, 2010 Are ten-year fixed-rate mortgages (FRM) available anywhere?
- Sep 25, 2010 What was the interest rate for a 30-year amortized fixed rate loan in 1993?
- Sep 24, 2010 Timing a refinance
- Sep 23, 2010 Piggyback for Conforming Refinance?
- Sep 22, 2010 Building a second home from overseas
- Sep 21, 2010 I'm an inexperienced refinancer. What can I expect?
- Sep 14, 2010 How fast will this prepayment retire my mortgage?
- Sep 13, 2010 Should I refinance my Home Equity Line of Credit?
- Sep 12, 2010 Elderly: Should we pay off our mortgage?
- Sep 11, 2010 Where can I get a good car loan?
- Sep 10, 2010 Should I use a home equity loan or a cash-out refinance?
- Sep 09, 2010 construction and permanent financing
- Sep 08, 2010 are there mortgages with five year terms?
- Aug 29, 2010 Is there a calculator to show the savings from prepaying my mortgage?
- Aug 28, 2010 Is there a website which tracks Federal mortgage regulations?
- Aug 27, 2010 Buying out partners with a cash-out refinance
- Aug 26, 2010 Should I use my construction lender for my permanent financing?
- Aug 25, 2010 On what day of month are home mortgage payments usually due and when late?
- Aug 24, 2010 Is it safe to use a direct lender to refinance
- Aug 23, 2010 Can you recommend a company specializing in mortgage modifications?
- Aug 09, 2010 Is there a ten year refinance mortgage out there?
- Aug 02, 2010 How do I remove or add a name to a home loan?
- Nov 29, 2009 What's involved in a prequalification?
- Nov 20, 2009 Why does the lender need this?
- Nov 16, 2009 How much do points affect the interest rate?
- Nov 14, 2009 Can I get a 40-year mortgage?
- Oct 23, 2009 How do you feel about owner financing?


