calculate-loan

01 Loan payments

Loan Repayment With Offset: How It Works

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

Monthly payment $304.15
Total interest
$3,248.75
= Monthly payment × loan term × 12 − (loan amount − offset balance)
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years), Offset balance ($)
You get
Monthly payment ($), Total interest ($)
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.

Loan repayment with offset means using money in a linked account to reduce the balance on which interest is calculated, while your scheduled repayments continue under the loan terms. This calculator estimates the monthly repayment and total interest for a simple loan after subtracting an offset balance from the amount charged interest; enter the loan amount, annual APR, term, and offset balance.

Formula

The calculator treats the offset as reducing the principal used in the standard fixed-payment loan formula. It calculates the payment as M = B × r ÷ [1 − (1 + r)−n], where B = P − O, r = APR ÷ 1,200, and n = 12 × Y. Total interest is estimated as I = M × n − B.

  • P is the loan amount in dollars.
  • O is the offset balance in dollars.
  • B is the amount treated as accruing interest, in dollars.
  • APR is the entered annual percentage rate.
  • r is the monthly rate as a decimal.
  • Y is the loan term in years, and n is its number of monthly payments.
  • M is the calculated monthly payment in dollars; I is estimated total interest in dollars.

This is a simplified model: it calculates a fixed payment that repays the offset-adjusted balance over the full term. Real offset arrangements often apply the account balance to daily interest calculations while the contractual payment is still based on the full loan. The results may therefore differ from a lender’s repayment schedule.

Worked Example

Using the defaults—$20,000 loan, 8% APR, five years, and a $5,000 offset—the calculator first finds the interest-bearing amount: $20,000 − $5,000 = $15,000. The monthly rate is 8 ÷ 1,200 = 0.0066667, and the term is 5 × 12 = 60 payments.

Substituting these values: M = 15,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $304.15 per month, rounded to cents. Estimated interest is $304.15 × 60 − $15,000 = $3,249.00. The calculation uses the rounded monthly payment in its total, so the displayed figures are internally consistent with the stated formula.

Assumptions

  • The rate stays fixed throughout the loan term.
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR divided by 12.
  • The offset is constant and does not exceed the loan amount; the input allows a larger value, but a negative interest-bearing balance is not a meaningful loan amount. If the offset is greater than the loan, use the loan balance as the maximum for this model.
  • Fees, taxes, insurance, mortgage insurance, escrow, changing account balances, and lender-specific offset rules are not included.

What an Offset Does to Repayment

An offset is generally a deposit account linked to a loan. The account’s money remains available to its owner, but the lender may use its balance when calculating interest. For example, if a loan balance is $200,000 and an eligible linked account holds $20,000, interest may be calculated as though $180,000 were outstanding for the relevant period. The loan itself may still show a balance of $200,000; the deposit is not necessarily a payment that permanently reduces principal.

Because less interest accrues, more of a regular repayment can go toward reducing the loan principal, or the borrower may repay the loan sooner if the contractual payment stays unchanged. The exact result depends on the loan agreement. Some products change the required payment, while others keep the scheduled payment and let the lower interest accelerate payoff. This calculator uses the first, simplified approach: it recalculates a level payment on the offset-adjusted amount.

Choosing Inputs and Reading Results

Enter the principal, APR, term, and an offset balance that reflects the amount actually eligible under the account’s terms. The APR and loan term should match the period being modelled. If the linked balance moves up and down, a single offset figure is only a snapshot; an average balance may be more representative for an estimate, but the lender’s method determines the actual interest calculation.

  • Compare the calculator’s payment with the loan’s stated required payment before treating the result as a repayment schedule.
  • Try several offset balances to see how sensitive the estimate is to cash held in the account.
  • Keep dollars, years, and annual percentage rates in their labelled units. Do not enter 8 for 8% as a decimal such as 0.08; the APR field expects 8.
  • Use the lender’s loan statement or disclosure for the actual balance, eligible offset rules, payment dates, and charges.

A key distinction is that an offset balance is not automatically the same as an extra repayment. A repayment usually reduces the debt itself, whereas offset funds may remain withdrawable and may only reduce the interest calculation. That flexibility can matter, but it also means the balance and interest benefit can change whenever money is added or withdrawn. Whether an account qualifies, and how much of its balance counts, are product-specific details to verify with the lender.

Limits and Common Misunderstandings

The model assumes an offset that stays unchanged for the whole term and applies fully from the beginning. It does not simulate daily balances, payment dates, variable rates, redraws, fees, or a lender’s rules for calculating interest. It also assumes the offset-adjusted amount is repaid with a new fixed monthly payment. Actual offset loans may instead retain a payment based on the full principal, so this estimate should not be read as a promise of a particular payment or payoff date.

Another common misconception is that an offset account always saves interest dollar-for-dollar. The effect depends on the eligible balance, how long funds remain in the account, the loan’s rate and calculation method, and any account costs. This calculator does not assess those costs or determine whether a product is suitable. Use neutral figures for exploration, and obtain the real rate, fees, eligible balance rules, and repayment schedule from the lender.

Frequently Asked Questions

Does an offset account reduce the loan balance?
No, not necessarily. The deposit may remain separate and accessible while reducing the balance used to calculate interest. Check the account and loan terms to see how it is treated.

Does an offset reduce monthly repayments?
It depends on the loan’s rules. Some arrangements can lower a required payment; others keep repayments unchanged, meaning less of each payment goes to interest and the loan may be repaid sooner. This calculator models a recalculated level payment.

Can my offset balance be higher than the loan?
This calculator’s simplified formula assumes the offset does not exceed the loan principal. A greater balance would produce a zero or negative interest-bearing amount, which this fixed-payment formula cannot represent meaningfully.

Is an offset the same as making an extra repayment?
No. An extra repayment typically pays down principal, while offset funds may stay in a separate account and be withdrawable. The exact consequences depend on the loan’s terms.

Why does my lender’s figure differ from this calculator?
The lender may use daily balances, a changing offset, different payment timing, a payment based on the full loan, variable rates, or fees. The calculator is an estimate, and the lender’s disclosure gives the exact figures.

This result is an estimate for education, not financial advice; 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 off | Offset balance | $ | 5000 | 0 | 100000000
out pmt | Monthly payment | $ | (p - off) * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - (p - off) | 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 →