On this page15 sections
- 01The line between a payment that finishes and one that never does
- 02Concepts to hold first
- 03The question a quote never answers
- 04The line below which no ending exists
- 05Reading a fractional horizon
- 06What the horizon is for
- 07How the method works
- 08Try it, verified
- 09What each input represents
- 10Worked example
- 11Reading the result
- 12Common mistakes
- 13Questions readers arrive with
- 14When this calculation is used
- 15Assumptions and guards
The line between a payment that finishes and one that never does
This inverts the usual loan question. Instead of fixing a term and deriving the payment, it fixes the payment and derives the term: a logarithmic rearrangement of the same annuity relation, solved for the number of periods. The answer arrives as a count of periods, usually fractional — the whole part is full payments, and the fraction says the last one is smaller than the rest.
Every balance carrying a rate has an interest-only line: the payment that exactly covers the interest one period accrues and touches nothing else. At that line the debt is a treadmill — serviced forever, reduced never. Below it the balance grows despite the paying. The relation only produces a finite horizon strictly above the line, which is why the calculator refuses at or below it instead of returning something meaningless.
Near that line the horizon is violently sensitive. A payment barely above interest-only takes a startlingly long time to finish, and a small increase from there removes years; far above the line the arithmetic calms down and looks almost like simple division of balance by payment. That asymmetry is the quiet danger of minimum payments on revolving balances: a card minimum is typically set just above the interest-only line, which parks the horizon at its slowest, longest extreme while remaining technically finite.
The relation also runs in reverse, and the workspace offers that direction: name the horizon instead — the date the debt is supposed to end — and it solves for the payment that gets there. Between the forward and reverse directions this is the honest conversation a balance and a budget can have: what the affordable payment buys in time, or what a chosen finish date demands in money.
At a rate of nought the whole drama disappears: with no interest accruing there is no line to stay above, and the horizon is simply the balance divided by the payment. That branch is handled separately because the logarithmic form divides by quantities that vanish exactly there.
Concepts to hold first
The number of periods a debt survives at a given payment. It usually arrives as a fraction: the whole part counts full payments, and the tail means the last payment is smaller than the rest — precision, not approximation.
The payment that exactly covers one period’s accrued interest and touches nothing else. At this line the debt is serviced forever and reduced never; below it the balance grows despite the paying. Every balance carrying a rate has one.
On revolving credit, a lender-set floor typically pitched just above the interest-only line — technically finite, practically glacial. It keeps an account in good standing while parking the horizon at its slowest extreme.
Asking a formula the opposite question. The loan-quote relation takes a term and produces a payment; this page takes a payment and produces the term. Same mathematics, opposite unknown — and a genuinely different conversation.
The question a quote never answers
Lenders reason from the calendar to the wallet: choose a term, derive the payment that clears the debt across it. Real budgets often run the other way — a household knows what it can pay each month, and the open question is what that payment buys in time. Inverting the relation dignifies that direction: the payment becomes a fact, the horizon becomes the answer.
The inversion matters most where no quote exists at all. A card balance, a store account, money owed to family — debts without contractual terms still obey the arithmetic of balance, rate and payment, and this calculation is how such a debt is given the ending its paperwork never specified.
It also runs in reverse. Name the finish date instead — the anniversary by which the debt should be gone — and the same relation solves for the payment that reaches it. Between the two directions this is the honest conversation a balance and a budget can have: what the affordable payment buys in time, or what a chosen ending costs in money.
The reasoning runs from the balance and its rate, past the interest-only line, to a payoff horizon
The direction of the inverted question: the payment is a fact of the budget, and time is the output. A quote runs this reasoning the other way around.
The line below which no ending exists
Each period, the balance accrues its interest. A payment first meets that accrual, and only the excess shrinks the debt. If the payment exactly equals the accrual, the balance is untouched — the same debt greets every payday, forever. If the payment falls short, the unpaid interest joins the principal and the debt grows while being paid. Neither case has a payoff horizon, and no rearrangement of the mathematics can produce one.
This is why the calculator refuses at or below the interest-only line rather than returning something. Any number it invented there would be a lie with units. The refusal is the answer: this payment cannot end this debt, and the honest response is to raise the payment, lower the rate, or restructure — not to reread the result.
Just above the line, the arithmetic is violently sensitive. A payment barely clearing the accrual takes a startlingly long time to finish, and small increases from there remove years at a time; far above the line, the horizon calms down toward what plain division of balance by payment would suggest. That asymmetry is the quiet danger of minimum payments — they live in the steep zone by design.
Principal retired accumulates each period until it crosses the full balance owed; the crossing is the payoff
A payment above the interest-only line retires principal every period until the accumulation crosses the balance. At or below the line, the climb never starts.
Reading a fractional horizon
The horizon comes back as a count of periods, and the count is rarely whole. The whole part is the number of full payments; the fraction says the final payment is partial — the debt runs out of balance before the last period runs out of payment. On a monthly schedule the count is months, on a fortnightly one fortnights, so the same debt at the same annual pace reads differently depending on the rhythm of paying.
A horizon is also a forecast with assumptions attached: the payment holds every period, the rate does not move, and nothing new is borrowed. The last assumption is the one revolving balances break daily — a horizon computed on a card that keeps being used is obsolete before the next statement. The number is honest about the debt as it stands today; keeping it true is behavioural, not mathematical.
What the horizon is for
The immediate use is diagnosis: the payment currently going out, converted into the years it implies. For a card balance drifting along at the minimum, that conversion is routinely the moment the debt becomes real — the balance looked manageable, the horizon does not.
The deeper use is negotiation with yourself. Because the horizon is so sensitive near the interest-only line, modest payment increases buy outsized time reductions exactly where the situation is worst. The lesson after this one prices that trade precisely — what adding a fixed extra to every payment buys back, in months and in money — and the reverse direction here already hints at it: pick the ending you want, and see the payment it demands.
How the method works
The payment is compared to the interest one period accrues on the balance. At or below that amount the calculation refuses: no count of such payments ends the debt, so no finite horizon exists to report.
Above the line, the number of periods is solved logarithmically from the balance, the periodic rate and the payment — the annuity relation rearranged for time instead of money.
The result is a period count, usually fractional; the fraction means a smaller final payment, not an approximate answer.
At a rate of nought the drama disappears and the horizon is the balance divided by the payment — handled as its own branch, because the logarithmic form divides by quantities that vanish exactly there.
The certified engine performs this calculation. This page explains what it does; it does not reproduce it, because a second implementation of a specified method is a second answer waiting to disagree with the first.
Try the worked scenario
The engine below arrives pre-filled with the pack’s anchor example: a six-figure balance at an unremarkable rate, paid monthly at an amount sitting comfortably above the interest-only line. Put in your own balance and your own honest payment first. Then walk the payment slowly down toward the interest the balance accrues each month and watch the horizon stretch — and finally watch the calculator refuse, which is the lesson’s whole argument performed live.
Read the result as the number of periods the debt survives if the payment holds, the rate stays put and nothing new is borrowed. A refusal is not an error: it is the engine reporting that this payment cannot end this debt. Every figure is computed live by the verified engine — this page stores none.
What each input represents
The balance owed today — not necessarily the amount originally borrowed. A debt part-way through its life enters here at its current size, which is what makes this page usable on a statement rather than only on a contract.
The nominal annual rate as a percentage. Divided by the payments per year, it becomes the periodic rate that both accrues against the balance and defines the interest-only line the payment must clear. Nought is permitted and removes the line entirely.
How many payments fall in a year — twelve for monthly, the default here. It converts the annual rate into the periodic one, and it is the unit the answer comes back in: a horizon of so many periods means months on a monthly schedule and weeks on a weekly one.
The amount actually paid each period — chosen by the payer, not derived from a term. This is the input that separates this page from a loan quote: it accepts the payment as a fact of the budget and reports the consequence in time.
Worked example
The scenario
The pack’s anchor vector is a six-figure balance at an unremarkable annual rate, paid monthly at an amount sitting comfortably above the interest-only line; its companion vectors run a smaller balance at a higher rate, and an interest-free balance where the answer is plain division.
The output is the number of periods the debt survives — on a monthly schedule, months. The anchor lands on a horizon of several years with a fractional tail, meaning a final payment smaller than the rest. Nudge the payment down toward the interest-only amount and watch the horizon stretch disproportionately; nudge it up and watch years fall away faster than proportion suggests.
Every figure is produced by the certified engine when the calculator loads; none is stored in this page. The pack also declares the refusal worth seeing once: the same balance offered a payment exactly at the interest-only line is declined, because no count of such payments ever ends the debt.
Reading the result
Convert the period count into years before reacting to it — a horizon in months flatters, and the division into years is where minimum-payment arithmetic usually lands its blow.
A horizon that stretches disproportionately when the payment dips slightly means you are operating near the interest-only line, which is precisely where extra payment does its most spectacular work.
A refusal means the payment services the debt without ending it. The options it points at are structural: a larger payment, a lower rate, or a different arrangement — not a different calculator.
Common mistakes
Estimating the horizon as balance divided by payment. That shortcut is only true at a rate of nought; at any real rate it undercounts, sometimes wildly, because interest keeps refilling what the payment drains.
Computing a horizon for a revolving balance and then continuing to spend on it. New borrowing invalidates the answer the moment the balance grows.
Treating a card minimum as a plan. Minimums are set just above the interest-only line, which makes the horizon technically finite and practically generational.
Reading the fractional part of the answer as imprecision, then rounding the horizon down to feel better about it. The fraction is a smaller final payment; the whole part is not negotiable.
Questions readers arrive with
Why does the calculator refuse my payment instead of showing a very long time?
Because at or below the interest-only line there is no long time — there is no time at all. The balance is not reduced by such a payment, so any horizon displayed would be an invention. The refusal is the mathematically honest answer.
My payment is only slightly above the interest each month. Why is the horizon so long?
Only the sliver above the accrual reduces the balance, so early progress is tiny. Progress does compound — each reduction shrinks the next accrual — but from just above the line the compounding starts from almost nothing. Small payment increases here buy huge time reductions, which is the next lesson’s subject.
Can I use this for a credit card?
Yes, with two caveats. The answer assumes the payment is a fixed amount, not a percentage-of-balance minimum that shrinks as the balance does — the true minimum case is even slower than this page reports. And it assumes no new spending on the account; a balance that keeps revolving has no fixed horizon to compute.
What does the fractional part of the answer mean?
That the debt ends partway through a period: every payment but the last is full size, and the final one is smaller. It is a statement of precision, not a margin of error.
How do I find the payment for a finish date I have chosen?
The workspace offers the reverse direction: fix the horizon and solve for the payment. It is the same relation with the roles of time and money swapped, and it turns a resolution — debt-free by a chosen anniversary — into a figure a budget can be tested against.
When this calculation is used
Working out how long a card or store balance lasts at the amount actually being paid, rather than the amount a quote once assumed.
Testing whether a proposed payment amortises the debt at all before committing to it.
Converting a sustainable monthly amount into a payoff horizon, in periods and therefore in years.
Using the reverse direction to size the payment a chosen finish date requires.
Seeing how sharply the horizon stretches as a payment drifts down toward the interest-only line.
Assumptions and guards
The payment is the same amount every period, paid without fail — a horizon computed from a payment that sometimes slips is optimistic by construction.
The rate is fixed for the whole horizon; variable-rate debt re-answers this question every time the rate moves.
The periodic rate is the annual rate divided by the payments per year — the nominal convention, not an effective rate compounded down.
Nothing new is borrowed along the way: a revolving balance that keeps revolving invalidates the horizon the moment it grows.
The answer is a count of periods, and its fractional part means the final payment is partial rather than the horizon being approximate.
A payment at or below the interest-only amount for the period is refused: such a payment services the debt without ever reducing it, so no finite horizon exists to report. The refusal is the answer — it says the payment cannot end the loan.
The balance and the payment must both be greater than nought — a horizon needs a real debt and a real payment to measure between.
The rate is bounded to a realistic range and the payments per year must be at least one, so the periodic arithmetic describes an actual repayment arrangement.