calculate-loan

01 Loan payments

Loan Balance Calculator for Irregular Payments

Calculator No. 01-27566 · Updated · Formula and assumptions shown below

Balance after this payment $19,631.93
Accrued interest before payment
$131.93
Level-payment formula, rounded to the cent
Principal reduction from payment
$368.07
= Payment during period − accrued interest before payment
Original loan amount
$20,000
Input
You enter
Original loan amount ($), Interest rate (APR) (%), Days in calculation period (days), Payment during period ($)
You get
Balance after this payment ($), Accrued interest before payment ($), Principal reduction from payment ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A loan balance calculator for irregular payments estimates what remains after payments made in different amounts or on different dates. Enter the original principal, annual APR, and a dated sequence of payments; the calculator returns the estimated balance after the last payment and the interest accrued between payment dates.

Formula

This calculator models one interval between a starting balance and a single payment. It uses daily interest accrual with a nominal APR divided by 365, assumes no compounding within each day, and applies the payment at the end of the entered interval. The balance formula is:

B = P(1 + APR/36500)d − M

  • B is the balance after the payment, in dollars.
  • P is the starting principal or balance, in dollars.
  • APR is the annual percentage rate, entered as a percent.
  • d is the number of days interest accrues.
  • M is the payment made at the end of the interval, in dollars.

Accrued interest before the payment is I = P[(1 + APR/36500)d − 1]. The amount of the payment that reduces principal is M − I. When a payment is smaller than accrued interest, that difference is negative: the unpaid interest remains in the modeled balance. The displayed balance expression uses a sign-preserving absolute-value calculation so that a negative result is possible when payments exceed the amount owed. It is not a full loan schedule, because it evaluates only one interval.

Worked Example

Using the block’s defaults: starting balance P = $20,000, APR = 8%, interval d = 30 days, and payment M = $500. The daily rate in the formula is 8/36,500, or approximately 0.000219178.

  1. Growth factor: (1 + 0.08/365)30 ≈ 1.006595.
  2. Interest accrued: $20,000 × (1.006595 − 1) ≈ $131.90.
  3. Principal reduction: $500 − $131.90 = $368.10.
  4. Balance after payment: $20,000 + $131.90 − $500 = $19,631.90.

Displayed monetary amounts are rounded to cents. The calculation retains the formula’s unrounded intermediate values before display rounding.

How to Calculate a Sequence of Irregular Payments

To model more than one payment, repeat the same balance update for every interval, using the previous ending balance as the next starting balance. The number of days must match the actual time between the relevant dates. For each interval, accrue interest first and then subtract the payment:

  • Start with the opening balance.
  • Count the days from the prior balance date to the next payment date.
  • Calculate interest for that interval using the selected day-count convention.
  • Add that interest to the balance, then subtract the payment made on that date.
  • Use the resulting balance as the next interval’s starting balance.

For instance, if a payment is made 17 days after the previous one, the interval is 17 days, not an assumed month. If the next payment arrives 43 days later, use 43 for that interval. Irregular schedules can also include extra payments or skipped payments; a skipped payment is represented by a zero payment, while an extra payment is entered as its actual total amount. This page’s calculator handles one interval at a time, so repeat it sequentially for a longer schedule.

What Irregular Payments Change

With fixed monthly payments, a conventional amortization schedule can use one repeated payment and regular periods. With irregular payments, the balance depends on both the amount and timing of each payment. Paying the same total amount earlier generally leaves less time for interest to accrue on the reduced balance, while delaying a payment leaves the existing balance accruing for longer. The exact result still depends on the loan’s contract and servicing method.

“Irregular” can describe different arrangements: varying payment amounts, uneven dates, extra principal payments, or missed and deferred payments. Those are not automatically treated alike by a lender. A payment may be credited on a processing date, allocated to accrued interest or charges first, or applied under another contractual rule. The calculator’s simple end-of-interval assumption does not determine how a particular account is serviced.

Inputs, Assumptions, and Limits

Enter the balance at the start of the interval, not necessarily the original amount borrowed if earlier payments or charges have changed it. APR is a percentage per year, so enter 8 for 8%, not 0.08. Enter actual elapsed calendar days for the interval. Payment is the amount assumed to be applied at the interval’s end. If you need to model several payments, run one interval at a time and carry forward the previous result.

  • The model uses a 365-day denominator; it does not account for a lender’s different day-count convention.
  • It assumes interest accrues at a constant APR throughout each interval, with the daily rate represented as APR/365.
  • It does not model fees, penalties, payment allocation rules, changing rates, capitalization rules, taxes, insurance, escrow, or lender-specific rounding.
  • It does not decide whether an amount above the balance is refunded, held as credit, or treated another way.

A key misconception is that APR alone always determines the exact payoff balance. It does not: dates, day-count method, payment posting, charges, and contract terms can affect the amount shown by a servicer. For an accurate account figure, use the lender’s current balance or request a payoff quote, especially when closing or settling an account.

Frequently Asked Questions

Can I calculate a loan balance when payments are different amounts?
Yes. Calculate each interval using its actual payment amount, then carry the resulting balance into the next interval. This calculator processes one payment interval per calculation.

How do I handle payments made on different dates?
Use the actual number of days between the dates under the stated 365-day method. Do not assume every interval is 30 days if the dates show otherwise.

What if my payment is less than the interest?
The payment does not fully cover accrued interest in this model, so the remaining interest increases the balance. The loan’s actual treatment depends on its terms and servicing.

Does this calculator show an exact payoff amount?
No. It provides an arithmetic estimate under simplified assumptions. A lender’s payoff figure may include additional accrued amounts or contract-specific adjustments.

Can I include an extra payment?
Yes. Enter the full payment made in that interval, including the extra amount, if it is applied to the balance as assumed. Check how the servicer applies additional payments because allocation can vary.

Assumptions

  • The APR is fixed during the entered interval.
  • Interest accrues daily using APR divided by 365, and the payment is applied at the end of the interval.
  • The model does not include fees, taxes, insurance, PMI, escrow, or lender-specific payment allocation and rounding.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Original loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in days | Days in calculation period | days | 30 | 1 | 36500
in pay | Payment during period | $ | 500 | 0 | 100000000
out bal | Balance after this payment | $ | (p * (1 + apr / 36500) ^ days - pay) * (p * (1 + apr / 36500) ^ days - pay) / abs(p * (1 + apr / 36500) ^ days - pay) | 2
out due | Accrued interest before payment | $ | p * ((1 + apr / 36500) ^ days - 1) | 2
out net | Principal reduction from payment | $ | pay - due | 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

The whole Loan payments section →