Business Loan & Equipment Finance Calculator
Business loan, hire purchase and equipment lease calculator — payment, total interest, effective annual rate including fees, balloon and total cost of ownership for every finance offer, ranked side by side, with a cent-exact amortisation schedule. Nothing is uploaded.
Version 1.0.0 · Updated Oct 23, 2026
Use Business Loan & Equipment Finance Calculator now
Runs in your browser · nothing is uploaded
This in-page version cannot save your work between visits — browser storage is switched off inside the sandbox. The full version saves your work locally after download.
Overview
Frequently asked questions
How are business loan repayments calculated?
For a fixed-rate loan the periodic payment is P × r ÷ (1 − (1 + r)^−n), where P is the amount financed, r the periodic interest rate and n the number of payments. A balloon or residual reduces the payment but is paid at the end, so the calculator includes it in the total cost.
How do I compare asset finance offers fairly?
Compare total cost — every payment, fees and any balloon — and the effective APR, not the headline rate. A lower rate with a large arrangement fee or balloon can cost more. The calculator ranks offers on total cost and shows the spread between best and worst.
Can I see an amortisation schedule?
Yes. The report includes the payment schedule — interest, principal and balance, including any balloon — for the cheapest offer in view; filter to a single offer to see its own schedule. The ranked comparison of every offer sits alongside it.
How does the Business Loan & Equipment Finance Calculator licence work?
It is a one-time purchase for a downloadable tool — no subscription. You buy it once and the file is yours to keep and use.
Can I try the Business Loan & Equipment Finance Calculator before buying?
Yes. Use the Try online button for a fully interactive demo with sample data already loaded — nothing to install and nothing is saved.
Can I import my data from a spreadsheet?
Yes. Use the Spreadsheet template button to save a CSV with the right headings, fill it in Excel or any spreadsheet, then Import spreadsheet to load it back. The file is read in your browser — nothing is uploaded.
Does my data stay private?
Yes. The tool is a single HTML file that runs entirely on your computer and makes no network requests, so nothing you enter is ever uploaded or shared.
Do I need Excel or any other software?
No. It replaces the spreadsheet template entirely: open the file in your browser (Chrome, Edge, Firefox or Safari) on Windows, Mac, Linux or a tablet, and start working.
How to use Business Loan & Equipment Finance Calculator
The complete in-tool guidance, reproduced here so you can read it before you download.
What this tool does
This business loan and equipment finance calculator turns each finance quotation into the four numbers that decide whether a deal is good: the payment, the total interest, the effective annual rate once fees are included, and the total cost of ownership. Enter one row per offer — a bank term loan, an equipment loan, hire purchase, a finance lease or an operating lease — and the tool ranks them on what they really cost, not on the headline rate or the size of the monthly payment.
It is deliberately opinion-free about rates. Every rate, fee, term and balloon comes from the lender's own paperwork. Nothing about any country's tax treatment, subsidy scheme or disclosure rule is built in. What the tool guarantees is that the arithmetic on your figures is right and reconciles to the cent: the amortisation schedule for the cheapest offer closes exactly on zero, or exactly on the balloon.
Optionally, enter your monthly operating profit in Settings and every payment is tested against a comfort ceiling you set yourself. Add a regular overpayment or lump sums to an offer and the tool reports the interest and payments you would save.
How loan interest actually works
An instalment loan is an annuity. The lender advances a sum today; you promise a series of equal payments, set so that their present value at the periodic interest rate equals the amount advanced. Write P for the amount financed, i for the periodic rate, n for the number of payments and B for any balloon:
P = asset price − deposit + fees (only when the fees are added to the loan) i = nominal annual rate ÷ payments per year n = term in months × payments per year ÷ 12 (or term in years × payments per year) a(n,i) = (1 − (1 + i)^−n) ÷ i (when i = 0, a(n,i) = n)
Setting the discounted payments plus the discounted balloon equal to the advance and solving for the payment gives:
Payments in arrears (end of period): PMT = (P − B × (1 + i)^−n) ÷ a(n,i) Payments in advance (start of period, an "annuity due"): PMT = (P − B × (1 + i)^−n) ÷ [ a(n,i) × (1 + i) ]
Paying at the start of each period means every payment sits with the lender one period longer, so the payment falls. Equipment leases are usually written in advance for exactly this reason — the monthly figure looks better without the lessor giving anything away.
The schedule then runs period by period, rounded to the cent. In arrears, interest is the opening balance times i and the rest of the payment reduces the balance. In advance, the payment comes off first and interest accrues on what is left. The last payment is adjusted by a few cents so the schedule closes exactly, which is standard lender practice.
Total of payments = PMT × (n − 1) + final payment Total interest = total of payments + balloon − P Cost of credit = total interest + fees Total cost of ownership = deposit + total of payments + balloon + fees paid up front = asset price + fees + total interest
Nominal, effective and APR — the three numbers people confuse
A nominal annual rate is a quoting convention. "7.2 % per annum, monthly rests" means the lender charges 0.6 % each month; because those charges compound, it says nothing directly about what a year costs. The effective annual rate is the measurement:
EAR = (1 + nominal ÷ m)^m − 1 m = payments per year 7.2 % nominal, monthly: (1 + 0.072/12)^12 − 1 = 7.4424 % 7.2 % nominal, quarterly: (1 + 0.072/4)^4 − 1 = 7.3977 % 7.2 % nominal, weekly: (1 + 0.072/52)^52 − 1 = 7.4590 %
Never compare a monthly-rest quote with a quarterly-rest quote on the nominal number alone.
APR is a regulated disclosure that folds fees into the rate, and the conventions differ by jurisdiction. In the United States, Regulation Z computes it by the actuarial method and discloses it as a nominal annualisation — the periodic rate times the number of periods. In the European Union, the annual percentage rate of charge sets the present value of all drawdowns equal to the present value of all repayments and charges, and expresses it as an effective annual rate. This tool reports both, from the internal rate of return of the real cash flows:
Cash flows: + (P − all fees) at t = 0 − each payment at t = k (arrears) or t = k − 1 (advance) − balloon at t = n j = the periodic rate at which the cash flows sum to zero (solved by bisection) Effective annual rate incl. fees = (1 + j)^m − 1 (EU APRC-style) Nominal APR incl. fees = j × m (US APR-style) Fees add = effective rate incl. fees − effective rate with fees removed
The fees are taken off the money you actually receive however they are dressed up — a fee added to the loan is cash you never see, and a fee paid up front is cash you hand back on day one.
Why fees usually matter more than the headline rate
An arrangement, documentation or option-to-purchase fee is interest wearing a different hat. Added to the loan, you also pay interest on it for the whole term; paid up front, you receive less cash than the agreement says you borrowed. Either way the true rate rises, and it rises hardest on short terms and small amounts.
Take 30,000 over 36 monthly payments at 6.0 % nominal: the payment is 912.66. Add a 900 fee to the loan and the payment rises only to 940.04 — but the effective rate including the fee climbs to 8.30 %, against 6.17 % on the rate alone. A lender offering 6.0 % with a 900 fee is dearer than one offering 7.5 % with none (7.76 % effective, and 246 less in total). That is why the offers are ranked on total cost of ownership, the one ranking that cannot be gamed by moving cost between the rate, the fee and the term. Keep the asset price and deposit the same across offers so the ranking stays like for like, and remember that a longer term always accrues more interest — ask for quotes at equal terms where you can.
Balloon and residual payments — and the risk at the end
A balloon (a residual on a lease) is a lump sum left outstanding at the end of the term. Because that slice of principal is never amortised, the regular payment drops — a real advantage for an asset that earns steadily and holds its value. But you pay interest on the balloon for the entire term, and at the end you owe it in one go. There are three ways out: pay cash, refinance at whatever rate exists then, or sell the asset and hope it fetches at least the balloon. Treat any balloon above a third of the advance as a decision that needs its own written plan before you sign; the summary flags those offers.
Finance lease, operating lease, hire purchase or loan?
- Structure — Who owns it — End of term
- Loan — You, from day one — The debt is simply repaid
- Hire purchase — The lender, until the final payment — Title transfers, often with a small option fee
- Finance lease — The lessor — Secondary rental, sale or return — you rarely take title
- Operating lease — The lessor — The asset goes back; the lessor carries the residual risk
Under IFRS 16 a lessee recognises a right-of-use asset and a lease liability for almost all leases over twelve months, so the lessee-side accounting distinction has largely gone — but who carries residual value risk and what happens at the end remain what you are negotiating. The arithmetic here applies to all four: a lease is an annuity due with a residual, hire purchase is usually an annuity in arrears with an option fee. For an operating lease you intend to hand back, the residual is entered as if paid; deduct it mentally, and remember you no longer own the machine. The accounting and tax consequences are a conversation with your accountant.
Overpaying strategically
Every extra payment goes straight to principal and stops accruing interest for the rest of the term, so overpayments are powerful early and weak late. Two levers are modelled per offer: a regular overpayment added to every instalment, and lump sums written as amount@payment number (for example 5000@12, 2500@24).
Payment with overpayments = PMT + regular overpayment + any lump sum due that period Interest saved = contractual total interest − total interest with overpayments Payments saved = n − payments made with overpayments
Check the agreement for early repayment charges, which can wipe out the saving, and confirm overpayments reduce the balance immediately rather than sitting as a credit.
Questions to ask a lender
- What is the total amount payable, in cash, from today until the end — including every fee?
- Is the quoted rate nominal or effective, how often is interest applied, and is it fixed for the whole term?
- What is the disclosed APR or APRC, and does it include the arrangement, documentation and option fees?
- Are payments in advance or in arrears, and does the first payment fall on drawdown?
- What is the balloon or residual, how was it set, and what happens if the asset is worth less?
- What is the early settlement figure part-way through, and are overpayments allowed without charge?
- What security or personal guarantee is required, and what are the insurance and maintenance obligations?
Put the answers into this tool and check the effective rate against what you were told. Where it does not match, the gap is usually a fee somebody forgot to mention.
References
- European Union (2008). Directive 2008/48/EC on credit agreements for consumers — Article 3, Article 19 and Annex I (the annual percentage rate of charge equation).
- Consumer Financial Protection Bureau, United States. Regulation Z, 12 CFR §1026.22 — Accuracy of the annual percentage rate, and Appendix J (the actuarial method).
- IFRS Foundation / International Accounting Standards Board (2016, effective 1 January 2019). IFRS 16 Leases.
- Sekhon, R. & Bloom, R. Applied Finite Mathematics, §6.4 "Present Value of an Annuity and Installment Payment".
- Olivier, J. Business Mathematics, §12.4 "Leases" — leases as annuities due and the role of the residual value.
Where this fits
Part of Finance & Funding in Small Business & Freelance.
Before this tool
Related tools
Record business expenses in any currency, track reclaimable input tax (VAT/GST/HST), deductible spend, rebillable client costs and budget variance, then print an accountant-ready report. Runs entirely in your browser. No installation, no account, no upload.
Work out the fully-loaded annual cost of an employee, the true cost per productive hour, the on-cost multiplier and the charge-out rate you need — then compare the same work priced as a contractor. Runs entirely in your browser. No installation, no account, no upload.
Work out break-even volume, break-even revenue, contribution margin, margin of safety and the price you need to hit a target profit. Handles fixed amounts and percentage-of-price costs, compares three scenarios and prints an investor-ready report. Runs entirely in your browser. No installation, no a
Work out the hourly, day and week rate a freelancer or consultant must charge to reach a target take-home income, after unbillable time, business costs, taxes and contributions. Any currency, any country. Runs entirely in your browser. No installation, no account, no upload.
Convert between margin and markup without getting them the wrong way round, price from a target margin, and see how much extra you must sell to stand still after a discount. Runs entirely in your browser. Nothing is uploaded.
Create professional invoices for any country: 40+ currencies, VAT / GST / HST / sales-tax handling, tax-inclusive or tax-exclusive pricing, per-line discounts, and a built-in invoice register with paid / outstanding charts. Runs entirely in your browser. No installation, no account, no upload.