6.3 Calculating the Final Payment

If you have ever paid off a loan you may have noticed that your last payment was a slightly different amount than your other payments. Whether you are making monthly insurance premium payments, paying municipal property tax instalments, financing your vehicle, paying your mortgage, receiving monies from an investment annuity, or dealing with any other situation where an annuity is extinguished through equal payments, the last payment typically differs from the rest, by as little as one penny or up to a few dollars. This difference can be much larger if you arbitrarily chose an annuity payment as opposed to determining an accurate payment through time value of money calculations.

Why is it important for this final payment to differ from all of the previous payments? From a consumer perspective, you do not want to pay a cent more toward a debt than you have to. In 2011, the average Canadian is more than $100,000 in debt across various financial tools such as car loans, consumer debt, and mortgages. Imagine if you overpaid every one of those debts by a dollar. Over the course of your lifetime those overpayments would add up to hundreds or even thousands of dollars.

Calculating the Final Payment

When you calculate out the payment for a loan, the actual payment is rounded to two decimal places.  It is rare for a calculated loan payment not to require rounding. The rounding up or down of the payment forms the basis for adjusting the final payment.

Consider the situation where the loan payment is rounded up.  Suppose the calculated loan payment is $999.995.  Rounding to two decimals, the actual payment made is $1,000.  So with each $1,000 loan payment, you are overpaying the debt by $1,000 − $999.995 = $0.005.  If you make 20 such payments, you end up overpaying the debt by 20 × $0.005 = $0.10. Therefore, when it comes to the final payment you need to compensate for all of the overpayments made, reducing the final payment by $0.10. Because the principal is slightly smaller at all times as a result of the overpayment, an additional adjustment may be needed because of less interest being calculated.

Now, consider the situation where the loan payment is rounded down.  Suppose the calculated loan payment is $1,000.0025.  Rounding to two decimals, the actual payment made is $1,000.  So, with each $1,000 loan payment, you are underpaying the debt by $1,000.0025 − $1,000 = $0.0025. If you make 20 such payments, you end up underpaying by 20 × $0.0025 = $0.05.  Therefore, when it comes to the final payment, you need to increase the final payment by this amount.  Because the principal is slightly larger at all times as a result of the underpayment, an additional adjustment may be needed because of more interest being calculated.

We have already learned how to calculate the final payment by completing the last row of the amortization schedule. This method gives the following formula for calculating the final payment.

[latex]\mbox{Final Payment} = \mbox{Balance from Second Last Row}+\mbox{Interest from Last Row}[/latex]

Alternatively, we can calculate the final payment without constructing the last row of the amortization schedule.  This method is based on the assumption that all of the payments, including the final payment are the same.  The final payment is found by adjusting the regular payment (PMT) by the amount overpaid or underpaid.

[latex]\begin{eqnarray*} \mbox{Final Payment} & = & PMT-\mbox{Amount Overpaid} \\  \\ & \mbox{or} & \\ \\ \mbox{Final Payment} & = & PMT+\mbox{Amount Underpaid} \end{eqnarray*}[/latex]

Attribution

“13.2: Calculating the Final Payment” from Business Math: A Step-by-Step Handbook Abridged by Sanja Krajisnik; Carol Leppinen; and Jelena Loncar-Vines is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

“13.2: Calculating the Final Payment” from Business Math: A Step-by-Step Handbook (2021B) by J. Olivier and Lyryx Learning Inc. through a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License unless otherwise noted.