Updates for 2022: Historical Investment Calculator update to 15 indices through Dec. 2021
Compare different assets, for example, the S&P 500 with gold and housing, and optionally adjust for inflation.
Inflation Calculator U.S. and German historical inflation calculations plus future inflation. Investment Calculator inflation model updated.

# Remaining Balance CalculatorPrincipal Balance with Payment Schedule

Enter a "0" (zero) for one unknown value above.

×

#### Info...

Original Size

Copy and paste this URL to save your inputs to share them with others.

Click "Calc", "Clear", "Preview." or "Schedule" to update the URL. Paste it into any browser 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).

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!

## 13 Comments on “Remaining Balance Calculator”

Join the conversation. Tell me what you think.
• ##### Dicksays:

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?

• ##### Karlsays:

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.

• ##### Dicksays:

(A) the 27th payment to equal \$2,500 to pay it off

• ##### Karlsays:

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.

• ##### Dicksays:

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.

• ##### Dicksays:

Karl, I figured it out. I did not see the additional tab to set the dates. Thank You

• ##### Karlsays:

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

• ##### chase priestersays:

what is my ending balance if my principal is 80\$ and my interest rate is 10% over 3 years.

• ##### Gian Hodgsonsays:

Hi, when I try to calculate remaining balance after payment# 1 it calculates it as if 2 payments have been made. So:

Amount of Loan = 2,000
Annual rate = 10%
Balance after Payment = 1
Periodic Payment = 200
Loan Balance after payment = 0

The result says Total Principal & Interest = \$400
Shouldn’t it be 200?

• ##### Karlsays:

hi Gian, you are correct. The calculator has what is known as a "one off" error, but only if the user sets the "Balance After Payment" to 1. The "Loan Balance After Paymen" is calculated correctly either way.

The problem is, the "Total Interest Paid" and "Total Principal & Interest" show the same value whether the user enters 1 or 2 for balance after period.

For accurate numbers, please look at the schedule. I’ll fix this shortly and I’ll let you know once I do.

• ##### Karlsays:

Gian, I fixed the problem when calculating the loan’s remaining balance after one payment. Thank you for taking your time to let me know, and sorry again for the problem.

If you do not see the fix, you may have to perform a hard refresh of the page:

Depending on your operating system all you need to do is the following key combination:

• Windows: ctrl + F5
• Mac/Apple: Apple + R or command + R
• Linux: F5