advertisement
Looking for something on the site? Search for it here! Also see Clark's Greatest Hits

Jan 26, 2009 -- Track your mortgage with a free amortization schedule

Years ago when Clark had his first home, the mortgage was sold off by the lender, and the result was a dispute about the balance. Clark contended he owed around $3,000 less than the new servicer of his mortgage claimed.

The penny-pincher had to prove his point by finding all his canceled checks. He also had to buy a book with an amortization table that allowed him to crunch the numbers himself. Obviously, this was in the pre-Internet days.

Now that we're in the era of computers, we assume the balances that lenders are tracking will be accurate. But they're not. With all the mortgage mess, this is not a time to blindly trust your lender when they report a mortgage balance.

Errors can easily be made when loans are sold, or banks are absorbed by other banks and there's a migration of records. The balance can be all fouled up -- and almost always the error is not in your favor.

Thankfully, it's very simple to ensure you're tracked correctly. Print out an amortization schedule for free at DinkyTown.net or HSH.com.

Finally, it is imperative that you keep proof of all mortgage payments throughout the entire life of your loan. That avoids the danger of your payments being misapplied to another loan.

Banking -- much like life -- is not completely accurate. In this case, it's not that the banks are trying to cheat you; it's just that their record-keeping is incompetent.

Unfortunately, Clark won't be able to answer any questions submitted via commenting. If you have a question, please try posting it to our message boards.

Avg. rating: N/A

Add your comment

Security Image * Please enter the code shown at left
what's this?

What others are saying

  • Chalk Up One for the Consumer
    I had a prepayment clause in my original mortgage. It was sold at least three times to different financial institutions. I paid off the 30 year mortgage in 18 years. Somewhere along the line the prepayment clause got lost and I never had to pay it. It's nice to win once in a while.
  • Banking error
    I'm had a bank miscalculate my mortgage and seen it happen several times with other people when I worked as a loan officer. The problem typically only occurs when it's transfered from one bank to another.

    In my case the new bank sent me notice that I was 1 payment behind and had been that way for a while. (How would they know, they didn't even own the loan before.) I did my homework and recalculated then after 10 or so phone calls with Mangers they finally sent me a check. As far as others I'd seen as a loan officer, sometimes they couldn't refi until the found it out with their bank.
  • Loan Calculator with Extra Payments
    D –
    Check out the Excel templates at Microsoft Office Template Gallery.
    http://office.microsoft.com/en-us/templates/results.aspx?qu=Loan+Calculator+with+Extra+Payments.xls&av=TPL000
  • Clark's not a very good penny picher
    Why didn't Clark simply calculate his own amortization table, instead of buying a book? You don't need a computer, though it would make it faster. Any calculator and a simple formula, i=prt, are all you need.

    This will work for you too, D. You know the initial balance and the amount of each payment. At first, calculate the interest in Month 1 using the formula, where i is interest, p is principal (the initial loan balance), r is the MONTHLY interest rate (divide the annual rate by 12 first), and t is the number of months (one). This will tell you the amount of interest paid in month 1. Add that to the loan amount, then subtract your first payment. Use this number as p in the formula the next time around.

    It's a piece of cake to do this in a spreadsheet, even with different payment amounts.

    I think Clark's a little off when he asserts that balances banks tell us are not accurate. I've never in seven years of various mortgages had any bank tell me a balance that was even a penny off of what I calculated myself.
  • detailed calculator?
    I'm making extra principal payments. My amortization sch changes constantly according to how much extra I pay and the date it is applied to my account. The next month's principal & interest no longer follow the old am sch. Is there a calculator that easily tracks these changes in amortization as extra pmts are made? Note that I don't always pay the same $ amt of extra to the principal.
send to a friend  view as printer-friendly  RSS feeds
advertisement
advertisement
THIS WEEK'S POLL
advertisement