Quicken Home, Business and Rental 2018 for Windows mortgage payment calculation incorrect

MJB
MJB Member ✭✭
edited October 2018 in Business and Rental Property Tools (Windows)
I added a Rental Property Mortgage in Quicken and the monthly payment calculated by Quicken is incorrect.

Details of the loan:
Amount of loan $132,000
Interest Rate (fixed) 5%
Term 30 Years

Quicken Principal & Interest payment amount $708.60

Mortgage company payment required $708.61
Other 3rd party payment calculators arrive at $708.61

I know the difference is only $0.01 per month, but over time it adds up

Help!

Comments

  • Quicken Harold
    Quicken Harold Alumni ✭✭✭✭
    edited April 2018
    Hi MJB, appreciate your question.

    I just ran the same formula and got the same result with Quicken Premier 2018 for Windows:

    image

    Although, I also did the same on Quicken Premier 2018 for Mac and got the right numbers:

    image

    I will submit this up to Development to see if they can get this fixed.

    Thanks for letting us know.

    Respectfully,
    ~ Quicken Harold.


    QWIN-12639
    Quicken Harold
    Community Moderator
  • MJB
    MJB Member ✭✭
    edited February 2018
    Hi Harold,

    Thanks for the response.   Looking forward to the fix.  Once a fix is provided, how will I fix existing loan and payments made?

    Regards,
    Michael
  • Michael Jones
    Michael Jones Member, Windows Beta Beta
    edited February 2018
    you should be able to go to the schedule reminder and edit it to add the extra penny.  That SHOULD update the payment schedule on the loan as well.  Otherwise, if you want it 'perfect', you'll have to set up a new loan and transfer the transactions.  

    Make a backup and try playing around with it to see if you can get what you want before you make a final decision.  :)
  • mshiggins
    mshiggins SuperUser ✭✭✭✭✭
    edited February 2018

    From C. D. Bales:

    I just tested with Q2017 and Q2014 (both are Windows versions). Both compute a payment amount of $708.60.

    I also used the Navy Federal Credit Union mortgage loan calculator, and it too computed a payment of $708.60.

    Not sure why the difference exists - also not sure the evidence so far proves that $708.60 is incorrect.

    Did you compare the payment schedule created by Quicken against the payment schedule created by your lender to see where the $.01 was going (principal or interest)?

    You can override the Quicken computed loan payment amount in the loan setup process (which, by default, applies the difference to the principal payment amount). If that's where your financial institution is putting the extra $.01, that might take care of your problem.


    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the  Quicken Windows FAQ list
  • Michael Jones
    Michael Jones Member, Windows Beta Beta
    edited February 2018
    I'd venture to say it's a rounding problem of some sort.  Here is what Excel gives for the payment to 5 decimal places:  $708.60454
This discussion has been closed.

Categories