An overdraft (OD) repayment schedule estimates how a balance drawn from an overdraft facility can fall as you make payments, while interest may accrue on the amount outstanding. Enter the amount used, annual interest rate, and planned monthly payment to estimate months to repay and total interest; your lender’s actual terms determine the real schedule.
Formula
This calculator applies a simplified fixed-payment amortization calculation to an overdraft balance. It treats the balance as a loan repaid by equal payments at the end of each month, with interest compounded monthly:
- Monthly rate, r = APR ÷ 1200.
- Estimated months, n = round up [−ln(1 − r × B ÷ M) ÷ ln(1 + r)]. The result is rounded to six decimal places before rounding up to a whole month.
- Estimated total paid = M × n.
- Estimated interest = estimated total paid − B.
B is the overdraft balance used, in dollars; APR is the annual percentage rate, entered as a percent; M is the planned monthly payment, in dollars; and n is the estimated number of monthly payments. For the result to be meaningful, the payment must exceed the first month’s interest, or M > r × B. If it does not, the formula cannot produce a payoff schedule. The input limits prevent zero or negative values, but this condition still needs to be checked against the entered figures.
Worked Example
Using the calculator’s defaults: balance B = $20,000, APR = 8%, and monthly payment M = $500.
- Monthly rate: r = 8 ÷ 1200 = 0.0066667, or about 0.66667%.
- First month’s interest is approximately $20,000 × 0.0066667 = $133.33. The $500 payment exceeds that interest, so the balance can decline under the model.
- Months: round up [−ln(1 − 0.0066667 × 20,000 ÷ 500) ÷ ln(1.0066667)] = round up (about 48.88) = 49 months.
- Total paid: $500 × 49 = $24,500. Estimated interest: $24,500 − $20,000 = $4,500.
The result is 49 monthly payments of $500 in this simplified calculation. In practice, a final payment may be smaller than the planned amount, and the lender may calculate interest daily or apply other charges. The displayed total therefore should not be treated as a statement balance or payoff quote.
What an OD Repayment Schedule Shows
An OD, or overdraft, is a credit facility attached to an account or otherwise made available by a lender. It lets the account holder draw funds beyond their own available balance, up to the facility’s limit and subject to its terms. Unlike a conventional installment loan, an overdraft often does not automatically have a fixed repayment period or equal scheduled installments. The facility may allow repayments and further withdrawals, so the amount owed can change from day to day.
An OD repayment schedule is therefore usually an estimate or a lender-provided projection, rather than a universal schedule that applies to every overdraft. It can help answer a practical question: if no more money is drawn and a set amount is paid regularly, roughly how long might repayment take and how much interest might accrue? The calculator above isolates that scenario. It does not reproduce every facility’s billing method.
How to Use the Estimate
- Enter the amount currently drawn, not the unused facility limit.
- Use the rate that applies to this balance, expressed as an annual percentage. Confirm whether the lender quotes a variable rate or a rate that can change.
- Enter the amount you expect to pay each month. If payments will vary, this fixed-payment model cannot represent that pattern exactly.
- Compare the result with the lender’s statement, repayment terms, and any payoff figure. Check whether new withdrawals, charges, or payment timing alter the balance.
For example, a $20,000 facility limit does not mean the schedule should use $20,000 if only $6,000 has been drawn. The starting figure should be the actual amount owed that is being modelled. If the account continues to be used, the schedule becomes less representative because new draws can offset repayments.
OD Schedule Versus a Regular Loan Schedule
A standard amortization schedule generally assumes a known principal, a fixed interest rate, regular payments, and no additional borrowing. An overdraft may instead be revolving: repayments reduce what is owed, but funds can be drawn again. Interest may be calculated on the daily outstanding balance, and the required minimum payment may not be a fixed installment that clears the debt on a specified date.
This distinction explains a common misconception: making a payment does not necessarily close or repay an overdraft facility. It reduces the outstanding balance according to how the lender applies the payment, while the facility itself may remain available. A schedule that assumes no further draws estimates repayment of the balance, not cancellation of the credit arrangement.
Limits and Common Sources of Difference
The calculation assumes the APR stays constant, the same payment is made each month at month-end, and interest compounds monthly at APR divided by 12. Actual overdraft interest may use daily balances and a different day-count convention, and the interest rate or payment requirements may change. Fees, charges, taxes, insurance, and other account activity are not included.
- Payment too small: If a payment does not exceed interest accruing for the period, the balance may not shrink. The formula requires a payment above the first month’s estimated interest.
- Variable rate: A changed rate changes both the pace of repayment and total interest; one fixed APR cannot forecast future changes.
- Further use of the facility: Withdrawals increase the balance and can extend repayment.
- Rounding: The estimate rounds the payoff period up to a whole month and assumes the planned payment in each month, including the final month. A real lender may instead calculate a smaller final payment.
- Different payment timing: A payment made earlier in a period can affect interest differently from a payment made at month-end.
For a closer projection, use the lender’s stated balance, rate, interest method, payment date, and fees. If the lender provides a repayment illustration or payoff amount, it is specific to the facility’s terms and current balance, unlike this general arithmetic estimate.
Assumptions
- The APR remains fixed throughout the estimated repayment.
- Payments are equal and made at the end of each month.
- Interest compounds monthly at APR ÷ 12.
- No further withdrawals, fees, taxes, insurance, or other charges are included.
Frequently Asked Questions
What does OD mean in a repayment schedule?
OD commonly means overdraft: credit drawn beyond the available account balance, up to a facility’s terms. An OD repayment schedule estimates how that drawn amount may be repaid.
Does an overdraft have a fixed repayment schedule?
Not necessarily. Overdraft facilities can be revolving and may not use fixed installment payments. Check the facility agreement and account information for its repayment requirements.
Can I repay an overdraft with a fixed monthly amount?
You can use a fixed amount as a planning assumption, but whether it meets the facility’s terms depends on the lender. This calculator estimates a no-new-draw scenario and is not a payment instruction.
Why is my lender’s interest different from this estimate?
The lender may calculate interest daily, use different payment dates or compounding, change the rate, or include fees and new transactions. The calculator uses a simplified monthly method.
What happens if my monthly payment is less than the interest?
The balance may fail to decrease and can grow if interest or charges are added. This calculator cannot estimate a payoff period when the planned payment does not cover the modeled interest.
This result is an estimate for education, and the lender’s disclosure gives the exact figures.
Related
Formula used
in bal | OD balance used | $ | 20000 | 0.01 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in pmt | Planned monthly payment | $ | 500 | 0.01 | 100000000 out months | Estimated months to repay | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0 out total | Estimated total paid | $ | pmt * months | 2 out interest | Estimated interest | $ | pmt * months - bal | 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
- Avalanche Game Schedule: Dates, Times and Where to Check
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate