New for 2020: Added support for over 90 additional currencies including Japanese Yen (¥12,345,679), Indian Rupee/Lakh/Crore (₹1,23,45,678.99) & Swiss Franc (CHF12’345’678.99). Click on "More" above.
advertisement
Enter a "0" (zero) for one unknown value above.

×

Info...

  Original Size  

Click, copy, paste this URL to save the inputs for yourself or to share with others.

This custom URL updates when you click the "Calc", "Clear" or "Schedule" buttons. Paste it into a browser's address bar to reload.

The key to understanding the distinction is understanding accrued interest. When a payment is due and paid, the principal amount owed on the debt is the balance as shown on the amortization schedule. That's the remaining balance, and that's what this calculator is calculating.

But, one day later, after the payment is paid, the balance is no longer the same as it was the day before.

There is one day's interest due on the previous day's balance. This interest is known as accrued interest, and it is the reason the interest balance (and thus the loan balance) increases every day until the next payment.

The amortization schedule shows this repeating pattern. A payment gets applied to the accrued interest with the remaining amount used to reduce the principal balance, and the amortization table shows the balance after the payment (plus or minus a small rounding adjustment).

advertisement

If you want to know the loan pay off amount (balance), including the accrued interest, then use the balloon payment calculator. A balloon payment is equal to the prior period's loan balance plus the accrued interest. That is, the balloon amount the balance on a scheduled due date, but before accounting for any payments.

Other uses for this Loan Balance Calculator

Need a loan with a specific balance?

At times a borrower might want to make a periodic payment that results in a specific balance after making payments for say four or five years. What should the monthly payment be to achieve this goal?

This calculator will tell you.

Enter the loan amount, interest rate, and balance after payment (48 months, for example, for four years). Then, rather than enter 0 for the loan balance after a payment number, enter the balance that you want and enter 0 for the periodic payment.

Pay the periodic payment amount calculated, and the loan balance will be the one you entered.

Check out the amortization schedule and see for yourself.

You can also calculate a particular loan amount or interest rate needed using the same technique.

Or you can calculate when the balance will be a particular amount.

The calculator is very flexible!

advertisement

10 Comments on “Remaining Balance Calculator”

financial online calculator Join the conversation. Tell me what you think.
  • I am trying to get a lease payment amount on the remaining balance calculator. There would be a balance of $2,500 after 26 bi-weekly payments. It will figure a payment if I use loan arrears, but when I use lease advance it will not compute. Am I doing something wrong?

    • Dick, I agree with what you are saying. It looks as if I need to revisit that calculation. It’s not working for me either.

      One question.

      If you want the balance after 26 biweekly payment to be $2,500, does that mean you want (A) the 27th payment to equal $2,500 to pay it off, or do you want the 27th payment to (b) equal $2,500 plus accrued interest since the 27th payment?

      If (B), then you should use this balloon calculator.

      I tried the calculation and it works. (Set the loan date and first payment date to be the same day for advance.

        • Okay, in that case, you need to use the balloon payment calculator anyway. The difference between the two calculators is this:

          The remaining loan balance calculator assumes the "Loan Balance After Payment" is the payoff amount for a loan immediately after a payment is received. There is no interest due since the last payment would have paid interest first and then principal.

          The balloon payment calculator assume the "Final/Balloon Payment (can be 0)" is the payoff amount for the loan on the day a payment is due. That is, is also includes the interest accrued since the last payment.

          A subtle, but important difference.

          I confirmed that the balloon payment calculator will work when the payment is set to advance. (Set the loan date and first payment date equal).

          Also, in case you ever need it, I have fixed the problem you reported with the remaining balance calculator. I’ll release an update over the weekend, so users will have it by Monday.

  • Thanks Karl. I did try using the balloon payment calculator, but the problem I am running into is that this is a lease so the first payment is due the day the lease is signed.

    • Right, that’s typical for leases.

      That’s handled on the "Set Dates or Extra Payments" tab.

      Set these two dates to be the same:

      Loan Date?: 08/01/2019
      First Payment Due?: 08/01/2019

Comments, suggestions & questions welcomed...

Scroll
to calculator
to questions/comments
advertisement