🏢 Div 7A Loan Calculator 2026 – Minimum Repayment, Full Schedule & ATO Interest Rate

Div 7A Loan Calculator — Everything You Need to Know

If your private company has lent money to a shareholder or director — to fund a property purchase, pay down personal debt, or cover a one-off expense — Division 7A of the Income Tax Assessment Act has strict rules about how that loan must be structured. Get it wrong, and the ATO can treat the entire amount as an unfranked deemed dividend, taxed at the shareholder's full marginal rate with no franking credits to soften the blow. This free Div 7A loan calculator works out your minimum yearly repayment, generates a complete year-by-year schedule, checks the current Division 7A interest rate, and shows you exactly what non-compliance would actually cost.

What Is a Division 7A Loan? A Worked Example

A Div 7A loan example typically looks like this: a private company has built up retained profits, and its sole shareholder-director borrows $200,000 from the company to help fund a property purchase. Done informally — with no paperwork and no interest charged — the ATO can treat that $200,000 as a deemed unfranked dividend, taxable to the shareholder in full. Structured correctly as a complying Division 7A loan instead, the company and shareholder sign a written loan agreement before the company's tax return lodgment day, charge interest at or above the ATO benchmark rate, and commit to a maximum 7-year unsecured term (or 25 years if secured by real property) — turning an unmanageable tax event into a manageable annual repayment.

Div 7A Minimum Repayment Formula — How It's Actually Calculated

The Div 7A minimum repayment formula is the same reducing-balance amortisation formula used for any standard loan — the kind that keeps every payment identical while the interest and principal split shifts over time:

Each subsequent year, the opening balance falls by the previous year's principal component, the remaining term (n) drops by one, and the benchmark rate is re-applied for that specific income year — which is exactly why a single flat number can't tell you the full picture, and why the Full Repayment Schedule tab above runs this calculation year by year automatically.

What Is the Current Division 7A Interest Rate?

The Division 7A interest rate — officially the ATO benchmark interest rate — is reset every income year using the Reserve Bank of Australia's "Indicator Lending Rates: Bank Variable Housing Loans" rate, taken as the most recently published figure before the new income year begins on 1 July.

*Always check the ATO's published rate for the exact figure once it's finalised for the new income year — this calculator updates automatically once it is.

Div 7A Loan Calculator Excel — Why You Don't Need a Spreadsheet

A lot of accountants and business owners search for a Div 7A loan calculator Excel template because they want the full year-by-year breakdown — opening balance, interest, principal, and closing balance for every year of the loan — not just a single year's repayment figure. The "Full Repayment Schedule" tab above generates exactly that same output instantly, with three advantages over a spreadsheet template:

• No formula errors: spreadsheet templates are notoriously easy to break with one wrong cell reference — this calculator runs the same amortisation logic correctly every time.
• Always uses the current benchmark rate: a downloaded Excel template only has whatever rate was current when it was built; this tool reflects the latest ATO-published rate for each income year automatically.
• Nothing to download or maintain: no macros, no broken formatting when opened in a different spreadsheet program, no version control headaches across a team.

Division 7A Loan Repayment — Due Dates and Deadlines

Getting the Division 7A loan repayment due date wrong is one of the most common (and costly) compliance failures, because there are actually two separate deadlines to track:

1. The loan agreement itself must be in writing and signed before the company's lodgment day for the income year the loan was made — the earlier of the actual lodgment date or the due date for lodging that year's tax return. An agreement signed after this date does not comply, no matter how clear the original verbal understanding was.
2. The first minimum yearly repayment is due by the end of the income year following the year the loan was made — and every subsequent minimum yearly repayment is due by 30 June each year for the remainder of the loan term.

Division 7A and the ATO — What the Rules Actually Cover

Division 7A applies whenever a private company makes a payment, loan, or forgives a debt to a shareholder or their associate, where the company has retained profits available. Rather than letting shareholders access company profits tax-free (or at the lower company tax rate) while deferring their own higher personal tax, the ATO deems the transaction to be an unfranked dividend unless it falls within specific exceptions — the main one being a complying Division 7A loan agreement. The ATO publishes its own benchmark rate and a Division 7A calculator and decision tool to help taxpayers self-assess, though most accountants use a dedicated calculator like this one for the actual year-by-year repayment maths, since the ATO's own tool is primarily a compliance checklist rather than a full amortisation engine.

Division 7A also extends to Unpaid Present Entitlements (UPEs) — amounts a trust owes to a private company beneficiary that haven't actually been paid out. Following the 2025 High Court decision in Commissioner of Taxation v Bendel, a UPE is not automatically treated as a "loan" for Division 7A purposes, but the ATO still expects careful documentation of how UPE balances are managed to avoid unintended consequences.

What Happens If a Div 7A Loan Doesn't Comply?

The financial gap between a compliant loan and a failed one is enormous — and the "Deemed Dividend Cost" tab above quantifies it for your own numbers. As a general illustration:

Common Mistakes With Division 7A Loans

• Relying on a verbal agreement: no verbal understanding qualifies under Division 7A, regardless of how clear it was between the parties — it must be a written, signed agreement.
• Signing the agreement too late: the agreement must exist before lodgment day for the year the loan was made, not whenever it's convenient afterward.
• Forgetting interest must hit the benchmark rate every year: charging a fixed rate forever, rather than updating it as the ATO's benchmark rate changes annually, can cause a previously compliant loan to fall out of compliance.
• Treating round-robin transactions as real repayments: using a freshly declared dividend to "repay" the loan, where the same funds effectively flow straight back to the shareholder, does not satisfy the minimum repayment requirement.
• Ignoring UPEs: assuming an unpaid trust distribution to a corporate beneficiary carries no Division 7A risk, without proper documentation of how and why it's being managed.

Frequently Asked Questions — Div 7A Loan Calculator

Q: What is the Div 7A minimum repayment formula?
A: MYR = Opening Balance × [r × (1+r)ⁿ] ÷ [(1+r)ⁿ − 1], where r is the benchmark rate for that income year and n is the number of years remaining in the loan term.

Q: What is the current Division 7A interest rate?
A: 8.37% for the 2025-26 income year, down from 8.77% in 2024-25. The rate is reset annually based on the RBA's variable housing loan rate.

Q: What does the ATO say about Division 7A?
A: The ATO treats non-complying payments and loans from a private company to a shareholder or associate as deemed unfranked dividends, and provides its own benchmark rate, calculator, and decision tool to help taxpayers determine their obligations.

Q: What is an example of a Div 7A loan?
A: A $200,000 loan from a private company to its shareholder, structured as an unsecured 7-year complying loan at the benchmark rate, requiring a minimum yearly repayment of roughly $38,900–$39,400 depending on the year's applicable rate.

Q: When is the Division 7A loan repayment due?
A: The first minimum yearly repayment is due by the end of the income year following the year the loan was made; subsequent repayments are due by 30 June each year for the rest of the loan term.

Q: Do I need Excel for a Division 7A loan schedule?
A: No — the Full Repayment Schedule tab above generates the same year-by-year breakdown instantly, with the correct benchmark rate applied for each income year automatically.

Use our free Div 7A loan calculator above to work out your minimum yearly repayment, generate a complete repayment schedule, and see the real cost of non-compliance — all updated for current ATO benchmark rates. This tool provides general information only and is not a substitute for advice from a registered tax agent.