All calculators

Div 7A Calculator

Enter your company loan balance, term and repayments to see Division 7A interest, minimum yearly repayments and the closing balance.

Existing loan

Balance at the start of the selected income year.

Use the agreed original term, not a new term.

Original loan security

Mortgage means registered security and the 110% value test are met.

Dated entries

Entry 1

Entry type

Before loan-year lodgment day

Entry 2

Entry type

Before loan-year lodgment day

Available repayment

Tests the same rate and lawful remaining term.

Minimum yearly repayment

$17,251.47

Annual minimum for the existing loan.

Annual interest

$7,408

Existing loan closing balance

$76,908

Cash repayments

$6,000

Dividend offsets

$12,000

Estimated repayment shortfall

$0

Remaining original term

7 years

Applicable benchmark rate

8.77%

Separate new advances

$0

Opening balance from budget

$91,297

2026-27, 8.77%, 7 years remaining from an original 7-year term. One existing complying loan with a June year end. Advances stay separate.

Required repayment and available budget
Required repaymentAvailable budget
Required repayment: 7 points. Available budget: 7 points$0$47,587$95,1741357

Selected income-year schedule

DateEntryAmountExisting loan balance
1 Jul 2026Opening balance$87,500.00$87,500.00
31 Dec 2026Cash repayment$6,000.00$81,500.00
30 Jun 2027Dividend offset$12,000.00$69,500.00
30 Jun 2027Annual interest$7,408.49$76,908.49

Repayment-budget comparisons

Years remainingBenchmarkRequired repaymentBudget less requiredSupported opening balance
18.77%$95,173.75-$77,173.75$16,549
28.77%$49,585.90-$31,585.90$31,763
38.77%$34,425.69-$16,425.69$45,751
48.77%$26,872.28-$8,872.28$58,611
58.77%$22,361.50-$4,361.50$70,434
68.77%$19,371.92-$1,371.92$81,303
78.77%$17,251.47$748.53$91,297

How the Loan Schedule Works

This Div 7A calculator works out the minimum yearly repayment for one existing complying company loan. It uses the selected income year’s benchmark rate, the statutory opening amount and the remaining original term. Dated cash repayments and dividend offsets determine the interest and closing balance.

The annual formula is P × r ÷ [1 - (1 + r)-n]. P is the statutory opening amount, r is the benchmark rate as a decimal and n is the remaining term in whole years. The minimum covers both interest and principal. The schedule rounds to cents and displays at least one cent for a positive minimum.

For the first repayment year, the full original term remains. Each later income year reduces that term by one. A loan made in 2025-26 with an original seven-year term has seven years remaining in 2026-27 and six in 2027-28.

In the first repayment year, mark a repayment Yes only when its principal reduces the loan before the original loan year’s lodgment day. The calculator subtracts those marked amounts from the formula’s opening amount. It also retains their actual dates for daily interest and counts each payment once towards the annual minimum.

The opening loan balance is the amount outstanding at the start of the selected year, before that year’s dated entries. For later repayment years, use the preceding year’s notional closing balance calculated at the benchmark rate. A higher contractual rate can produce a different accounting balance.

Interest accrues on the reducing daily balance and is added at the year end. A payment reduces that balance from its effective date. The calculation uses the actual number of days in the income year, including a leap day, then rounds the annual interest to cents.

This Division 7A loan repayment calculator uses the applicable annual benchmark and remaining-term method. An ordinary mortgage calculator commonly divides a fixed rate into monthly periods. That monthly instalment does not establish the Division 7A minimum.

The ATO’s Division 7A loan guidance sets out the formula and loan requirements. A complying agreement needs written terms before the company’s lodgment day, the required interest and a lawful maximum term.

A Worked Company Loan

The fictional example starts with an $87,500 shareholder loan made in 2025-26. The borrower has a seven-year term with no qualifying mortgage security. For 2026-27, the 8.77% benchmark applies to the full seven years remaining.

The borrower pays $6,000 on 31 Dec 2026. A properly supported $12,000 dividend offset takes effect on 30 Jun 2027. Neither entry is marked as a before-lodgment principal adjustment. The statutory opening amount therefore remains $87,500.

The schedule shows a $17,251.47 minimum yearly repayment and $7,408.49 annual interest. Total recognised repayments are $18,000, leaving no estimated shortfall. The closing balance is $76,908.49, calculated as $87,500 plus $7,408.49 less $18,000.

The result card shows annual interest and closing balance in whole dollars. The schedule and CSV keep cents for reconciliation. Reset example restores these exact inputs and dated entries.

Choose Cash for money actually paid to the company. Choose Dividend for an effective set-off of mutually existing liabilities. The cash and dividend totals stay separate even though accepted amounts reduce the same existing loan.

Choose Advance for new money lent during the selected year. A new advance belongs to its own loan-year assessment, so this schedule records it separately. It does not increase the existing loan’s minimum or assume that the new advance satisfies the agreement requirements.

Reading a Repayment Shortfall

The estimated shortfall is the minimum yearly repayment less accepted cash repayments and dividend offsets, with a floor of zero. In the example, changing the dividend offset to $10,000 creates a $1,251.47 shortfall. Its timing still affects interest independently of that comparison.

A shortfall can create an unfranked deemed dividend, subject to the applicable rules and the company’s distributable surplus. This calculator does not assess distributable surplus or the Commissioner’s discretion. Paying a later amount does not automatically cure an earlier year’s failure.

Confirm the original loan year, signed term and applicable security. Reconcile the opening balance and effective payment dates. Confirm each dividend offset is legally effective and each repayment can count, including any repayment funded by another company loan.

For the full recognition review, use the Division 7A minimum repayment guide. This schedule assumes you have already assessed which payments count.

Select Download schedule CSV to open the workpaper in Excel. The file contains the year, benchmark, original and remaining terms, calculation totals, dated entries and repayment-budget comparisons. Exporting does not rerun or change the calculation. Dates use ISO format and amounts remain plain numbers.

ATO Calculator and Decision Tool

The ATO calculator and decision tool assesses whether Division 7A applies and calculates complying-loan repayments. This page supplies an existing-loan schedule. It does not replace the ATO tool’s decision questions.

Cross-check using the same original loan year, term and statutory opening amount. Enter the same effective repayment dates and amounts. In a first repayment year, match the treatment of principal repayments made before the original loan year’s lodgment day.

Compare the minimum yearly repayment first, then interest and closing balance. A difference can arise from a substituted accounting period, a contractual rate above the benchmark or repayments allocated to another amalgamated loan. Enter each existing amalgamated loan separately.

This calculator covers ordinary income years ending in June. It uses 8.77% for 2026-27 and 8.37% for 2025-26, with earlier supported years in the selector. The ATO benchmark rate table also explains the different rate-selection rule for a substituted accounting period.

Entries stay in your browser. The calculator sends no loan details to Tax Genie and saves none in browser storage. The CSV is created on your device.

Test an Available Repayment

Enter an available annual repayment to solve the largest statutory opening balance it supports at the selected year’s benchmark. The inverse uses the same annual formula. It rounds the supported balance down to a cent so the unrounded required repayment fits the budget.

With the example’s $18,000 budget, 8.77% benchmark and seven-year remaining term, the supported opening balance is $91,296.54. The result card shows $91,297. The inverse calculates a mathematical repayment limit for the entered assumptions, capped at $99,999,999.

The comparison table tests each shorter remaining term through the entered loan’s remaining term. For the $87,500 example, six years requires $19,371.92 and exceeds the budget by $1,371.92. Seven years requires $17,251.47 and leaves $748.53 within the budget.

The original maximum is seven years for other loans. A term of up to 25 years requires a registered mortgage over real property securing the whole loan. After prior secured liabilities, the property’s value must be at least 110% of the loan when first made.

Select Mortgage only when those facts are established. Use the agreement’s actual original term, even when it is shorter than the legal maximum. Unknown security leaves the calculation unresolved. The comparisons never extend the entered original term or approve a refinance or security conversion.

Every comparison shows its assumed benchmark and remaining years. The result note also names the original term. Later income years use their own benchmark, so a future rate change alters later minimums and supported balances. Repeat the calculation for each year using its own balance and rate.