Calculate the term (number of payments) for a conventional loan or mortgage with a specified regular payment amount. All of our financial calculators will calculate the term of a cash flow. What is different about the Ultimate Financial Calculator is that it will also calculate the term after a payment or interest rate adjustment.
All users should work through the first tutorial to understand basic concepts about the calculator.
To solve for an unknown term, follow these steps:
Your calculator should now look like this:
Note: There can never be a fractional period. That is, if the "# Periods" is unknown, the calculator will only calculate an integer value as the result. This can result in rather large rounding issues. If "Rounding" is set to "Open Balance", the balance may be considerably above or below zero. If the loan is over paid (the open balance is below zero) then the user may reduce the calculated "# Periods" by one in which case the open balance will be greater than zero. Or if the open balance is greater than zero, the user may increase the "# Periods" by one and then the open balance will be below zero. In either case, if the user sets the rounding option to "Adjust last amount to reach "0" balance", the calculator will make the necessary adjustments so that the final balance is zero. As the user, you do not have to accept the calculated term. You are able to adjust the term and the rounding to meet your needs.
Variations: In some cases, the borrower may specify the amount they are willing or able to pay while the lender may state the term for the loan. Assuming the above facts, the lender may agree to the $600.00 payment but they may also say that the loan has to be paid off in eight years (96 payments). To accomplish this, modify step 5 above. Set the "# Periods" to 96. Also, set Rounding to "Adjust last amount to reach "0" balance".
Under this scenario, there is no unknown value. Click the [Schedule] button to view the schedule. While the debtor gets to make the $600 regular payment, we learn that to pay the loan off in eight years, the final payment will be $4,484.92
Finally, it needs to be noted that calculating the term can result in a schedule with a significant rounding adjustment in the final period (assuming the calculator's rounding option isn't set to "Open Balance"). This is because the user set the payment amount and interest rate. The combination may mathematically require a fractional period. But there is no such option as a loan with 180 1/2 payment periods, regardless of what financial calculator is used. Therefore, the final payment will require an adjustment. Feel free to increase or decrease the calculated term as you desire to have a larger or smaller final payment.