TVM Amortization Rounds to Cents (or other)
04-03-2021, 08:44 PM (This post was last modified: 04-03-2021 08:46 PM by Rick314.)
Post: #1
 Rick314 Junior Member Posts: 31 Joined: Oct 2014
TVM Amortization Rounds to Cents (or other)
I've used HP Time Value of Money (TVM) calculators and programs for decades and just realized that my HP 10bII+ (and likely other HP calculators), when doing Amortization math, round BAL and PMT and INT to the current display resolution before doing the math. This is very useful, documented in the manual appendix that shows equation details, and has interesting impact.

For example, from the HP 10bII+ User Guide p76: P/YR = 12; N = 360; I/YR = 7.75; PV = 180,000; FV = 0; End Mode finds PMT = -1,289.54. So far so good. But now find amortization results for the last payment (#360) with display resolution set to 2 (cents, the typical default) versus 9 (or any high resolution). With high resolution you end up with a BALance of $0.00 as expected. But with cents display, you end up with a BALance of$3.00, which is correct if you made actual monthly payments to cents resolution for 30 years. I made an Excel spreadsheet with 360 rows to prove to myself this is what is going on.

There is a related defect in the HP 10bII+ User Guide p76 example. The manual shows PRINciple paid after the first 12 payments as "-1,579.84". If the calculator display resolution is the default cents (as implied by the ".84" in the answer) the calculator value is -1,579.82. The .84 value is the full-resolution value, likely found by the User Guide author using higher display resolution and then manually rounding to cents resolution. Doing this User Guide example and seeing the \$0.02 difference is what prompted me to look into these details. Just my two cents. (:-)
 « Next Oldest | Next Newest »

 Messages In This Thread TVM Amortization Rounds to Cents (or other) - Rick314 - 04-03-2021 08:44 PM RE: TVM Amortization Rounds to Cents (or other) - Dave Britten - 04-03-2021, 09:03 PM RE: TVM Amortization Rounds to Cents (or other) - Albert Chan - 04-03-2021, 09:36 PM

User(s) browsing this thread: 1 Guest(s)