An end-of-day balance is the amount in an account after that day’s transactions have been applied. This calculator estimates a loan balance after a chosen number of monthly payments; enter the original loan, APR, term, and payments made to see the remaining balance and the amount repaid.
Formula
The phrase “end of day balance” can refer to different account types. For a bank deposit account, it usually means the ledger balance after transactions posted that day. For a loan, it can mean the debt remaining after payments and interest have been accounted for. This calculator handles the latter: it estimates a fixed-rate loan balance after a specified number of regular monthly payments. It does not calculate a deposit-account closing balance or a lender’s official payoff quote.
The balance formula is B = P(1 + r)k − M × ((1 + r)k − 1) / r, where the scheduled monthly payment is M = P × r / (1 − (1 + r)−n).
- B is the estimated remaining balance in dollars.
- P is the starting loan principal in dollars.
- r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200.
- k is the number of monthly payments made.
- M is the level monthly payment in dollars, calculated from the full loan term.
- n is the full term in months, calculated as years × 12.
The calculator uses the unrounded mathematical payment inside the balance equation. Real schedules generally round each payment to cents and may handle the final payment or daily interest differently, so the estimate can differ slightly from a lender’s statement.
Worked Example
Using the defaults, the loan principal is $20,000, APR is 8%, the term is 5 years, and 12 monthly payments have been made.
- Convert the APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
- Convert the term to months: n = 5 × 12 = 60.
- Calculate the scheduled payment: M = 20,000 × 0.0066667 ÷ (1 − (1 + 0.0066667)−60) ≈ $405.53 per month.
- Apply the balance formula after 12 payments: B = 20,000(1.0066667)12 − 405.53 × ((1.0066667)12 − 1) ÷ 0.0066667 ≈ $16,389.67.
- Payments made, using the calculator’s unrounded scheduled payment, are approximately 12 × $405.53 = $4,866.41.
The displayed remaining balance is an estimate using the formula and the exact payment calculation before display rounding. The separate payments-made figure is also an estimate; multiplying a rounded monthly payment by 12 can produce a slightly different amount.
Assumptions
- The interest rate remains fixed for the full modeled period.
- Payments are equal, occur monthly, and are made at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- The calculation excludes fees, late charges, extra payments, taxes, insurance, and other account-specific adjustments.
- The model assumes a standard fully amortizing loan with no payment holidays or rate changes.
What an End-of-Day Balance Means
In everyday banking, a closing or end-of-day balance is a snapshot rather than a promise that every transaction is immediately reflected. A transaction may be authorized, pending, posted, reversed, or settled at a different time. A debit-card purchase that is pending might reduce available funds before it changes the posted ledger balance. Deposits can also be subject to processing or availability timing.
For that reason, an account can show more than one meaningful number. The ledger balance reflects transactions recorded to the account. The available balance generally reflects funds accessible for use after certain holds or pending items are considered. Exact labels and processing conventions vary by account provider. Check the account’s own description when reconciling a discrepancy rather than assuming that “end of day” means all initiated transactions have settled.
How the Loan Balance Changes
Each scheduled payment covers interest accrued for the period first, with the remainder reducing principal. Early in a fully amortizing loan, a larger share of each payment typically goes to interest because the outstanding principal is larger. As principal falls, the interest portion generally declines and more of each level payment reduces the balance.
For example, the worked estimate starts at $20,000 and, after 12 payments, shows about $16,389.67 remaining. The difference is not simply the sum of payments: some of each payment paid interest rather than principal. The calculator’s “Payments made” output is the total of scheduled payments, not the amount of principal repaid.
How to Use the Estimate
- Enter the original amount borrowed, not the amount of a recent statement unless that was the original principal.
- Enter the APR as a yearly percentage, such as 8 for 8%, rather than 0.08.
- Enter the original term in years and the number of monthly payments already completed.
- Compare the estimate with a statement only after checking the statement date, payment posting dates, and whether the loan rate or payment changed.
The payment count must represent completed monthly periods for the model to align with its assumptions. If a payment is pending, late, extra, or applied on a different schedule, the estimated balance may not match the account. The maximum payment count input is 600, while the modeled loan term can be as long as 50 years; counts beyond the original term are not useful for an ordinary amortizing schedule.
Limits and Common Confusion
A balance is not necessarily the same as a payoff amount. A payoff quote may include interest accrued through a particular date and account-specific charges or credits. This calculator has no payment date, daily-interest convention, fee, or extra-payment input, so it cannot produce an official payoff figure. Ask the loan servicer for an amount valid through the date you intend to pay.
Other common causes of mismatch include rounding each monthly payment to cents, a variable rate, extra principal payments, skipped or delayed payments, payment dates that do not coincide with monthly periods, and fees added to the account. A statement’s balance may also be reported as of a different cutoff date. The calculator is most useful as a transparent estimate under standard fixed-rate assumptions, not as a replacement for the lender’s account records.
Frequently Asked Questions
Is end-of-day balance the same as available balance?
No. An end-of-day or ledger balance generally reflects transactions posted to the account, while available balance may account for pending transactions or holds. The exact treatment depends on the account provider.
How do I calculate a loan balance after payments?
Use the original principal, monthly interest rate, regular payment, and number of completed payments in the amortization balance formula. This calculator assumes a fixed APR and equal end-of-month payments.
Why is my lender’s balance different from this estimate?
Possible reasons include daily interest, payment timing, rounding, variable rates, fees, extra payments, or a statement date that differs from the modeled period. The lender’s current account record controls the actual balance.
Does the balance include interest for today?
Not necessarily. This calculator models interest in monthly periods and has no calendar date or daily-interest input. A lender’s displayed balance and payoff quote may use a different cutoff or accrue interest through a specified date.
Can this calculator give an exact payoff amount?
No. It estimates a scheduled balance under simplified assumptions. Request a dated payoff quote from the loan servicer for the exact amount needed to close the account.
This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 in k | Monthly payments made | - | 12 | 0 | 600 out bal | Balance after payments | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2 out paid | Payments made | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- United Test and Balance: What It Means in Finance
- Up-to-Date Loan Balance Calculator$16,611.20
- Trade Date Balance: Meaning and How It Works
- UBS Trade Date Balance: Meaning and How It Works
- Time Left on Loan Calculator: Estimate Payoff Time60 months
- The Balance in Journaling: Finding a Sustainable Practice