Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2009
    Location
    White Plains, NY, USA
    Posts
    45
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Question How Come Loan Templates In Excel Never Match Bills

    1 house, 4 car loans. I download all sorts of Excel templates for car loans and house loans yet monthly payments never match nor do balances match, although loan amounts and interest are accurate. Do the lenders do something on their calculations that I miss?

    I am willing to provide an example from a current car loan I have.

    Thank you!!!

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Just a question, do the monthly payments shown equal what you sent which includes the interest or do the figures show the separated principal and interest amounts?

  3. #3
    Lounger
    Join Date
    Dec 2009
    Location
    White Plains, NY, USA
    Posts
    45
    Thanks
    6
    Thanked 0 Times in 0 Posts
    OK, loan is 60 months at 4.99% interest. Amount is 22090.89. Every loan calculator says monthly payment is 416.78 but the bill says 417.50. I also prepay which makes the statements even more bizarre.

    The bill will show a breakdown between principal and interest (though this lender requires you send prepayments to a 2nd address.) But iit does not show how it applies the monthly bill.

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Does the lender have a service charge added to the bill? Are you rounding your calculations which can alter the results slightly?

  5. #5
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    The frequency of interest calculations will alter the repayments a little - daily, twice daily, weekly . . .

    Or maybe there's a simpler explanation - the lender is rounding to the nearest $2.50.

    Another explanation is that there is a $50 admin fee - that would actually make the payments $417.52

    Have you asked the lender ?
    Last edited by MartinM; 2014-12-11 at 07:14.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •