Mortgage Center
Loan Center > Mortgage > Mistakes to Avoid >
Features
Today's Rates
 
Mtg Loan Rate APR
30-yr Fixed 5.62% 5.83%
15-yr Fixed 5.19% 5.52%
5-yr Adj 5.55% 6.40%

See today's rates for your area
Mortgage - Home Equity
Calculators
  Mortgage Payment
  How Much Can You Afford?
  Should You Refinance?
  More Calculators
Mortgage Education
  Overview
  Home Buying Tips
  How to Shop for a Loan
  Which Kind of Loan?
  Getting the Loan
  Managing Your Loan
  Refinancing
  Glossary
Mortgage Professor
  Ask the Professor
  Mistakes to Avoid
Yahoo! Real Estate Tools
  Find a Home
  Sell Your Home
  Find & Compare REALTORS®
  What's My Home Worth?
ADVERTISEMENT
Special Offers
 
Fail to check if the lender is crediting payments (especially extra payments) properly.

Q: I have read your columns about the benefits of paying early but how do I know that my extra payments are being properly credited so that I am getting the full benefit? With so much in the news about lender overcharges, how can anyone trust their lender with prepayments? Should borrowers have periodic independent audits?(Signed "untrusting").

A: You're fairly safe without an audit. I never heard of a case where a servicing agent misappropriated a prepayment. That would be outright larceny committed against the borrower, which is rare in this industry.

While servicing agents don't misappropriate prepayments, mistakes happen and it is a good idea to keep an eye out for them. A few lenders have begun to provide borrowers with access to their payment history on the internet but it will be awhile before this becomes standard practice.

Meanwhile, you can use Excel spreadsheets I developed for just this purpose. One is for FRMs, the other for ARMs. The spreadsheets show your entire amortization schedule, with an empty column for prepayments. When you enter a prepayment in the month you pay it, the entire schedule is recalculated.

For example, you take out an FRM for $200,000 at 6.5% for 15 years. You enter these numbers at the top of the spreadsheet and it gives you the complete schedule, including the balance at the end of every month. It shows, for example, that after 12 months, you will have a balance of $191, 854. If you make an extra payment of $1500 in month 5, the schedule recalculates to show a balance in month 12 of $190,296. If the lender has properly credited you with the prepayment, the balance shown for month 12 on the lender's statement should be identical.

If you enter every prepayment in the spreadsheet and save it, monitoring your lender's bookkeeping will be a breeze.

You can monitor amortization on an ARM in much the same way using the ARM spreadsheet. In this case, you must enter not only the extra payments but also the interest rate. Beyond that, it works the same way as the FRM spreadsheet.

I have tried to use the extra payments calculator on your web site to see when my loan will pay off, but it is for people with regular habits who pay a certain amount at regular intervals. My extra payments are scattered and for varying amounts. Can you help?

Yes, the Excel spreadsheet I just described will take account of any number of extra payments of any amount in any month, and show you when payoff occurs. You just scroll down the worksheet until you get to a zero balance. Extending the example I gave above, the first extra payment of $1500 in month 5 results in payoff in 177 months. If I add extra payments of, say, $2200 in month 11, $1200 in month 25 and $4500 in month 39, I find that payoff occurs in 167 months.

You can access the spreadsheet here.

Jack Guttentag is Professor of Finance Emeritus at the Wharton School of the University of Pennsylvania. Visit the Mortgage Professor's web site for more answers to commonly asked questions.

Next in "Managing the Mortgage"
Find a Mortgage on Yahoo! Finance
 
 


Copyright © 2008 Yahoo! Inc. All rights reserved. Privacy Policy - Terms of Service - Copyright Policy
Copyright © 2008 Jack Guttentag

All information available through or in connection with Ask the Mortgage Professor is informational only and provided "as is" without warranties, representations, or guarantees of any kind. Yahoo! disclaims any and all implied warranties respecting Ask the Mortgage Professor. Use of Ask the Mortgage Professor is entirely at your own risk and is not a substitute for conducting your own research.