← All prebuilt solutions
Planning & Finance

Loan, Overdraft & Invoice Finance Calculator

What borrowing really costs – and whether your business can afford it

£20

Secure checkout. Your download link is sent as soon as payment clears.

Loan, Overdraft & Invoice Finance Calculator

Overview

Lenders quote borrowing in different ways – a nominal rate, a margin over base, a flat rate, a monthly rental, a service fee as a % of turnover – which makes it hard to tell which option is really cheapest. This workbook puts every kind of business borrowing on the same footing. It builds a full schedule for a loan (with holidays, balloons, variable rates, fees and early repayment) and works out the true APR, compares up to four loan offers, costs an overdraft from your actual bank balances, compares factoring and invoice discounting with an overdraft and a loan, turns asset finance quotes into a true interest rate, and tests whether the business can afford the lot.

Price
£20
Who it’s for
Planning & Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Loan Calculator

One loan in full, with results, a plain-English summary and a chart. What you do: fill in the yellow cells, the base-rate path and the ERC table.

Loan Calculator
Loan Schedule

Step 2

Loan Schedule

Month-by-month schedule and a year-by-year summary. What you do: nothing to enter.

Step 3

Compare Loans

Four offers side by side with a total cost chart and balance chart. What you do: enter the offers.

Compare Loans
Overdraft

Step 4

Overdraft

Overdraft inputs, a month-by-month cost table and the effective rate. What you do: enter the facility details; monthly balances if not using daily.

Who it is for

Made for people like you

  • Example – text
  • Owners and finance managers – A clear answer to 'which is cheapest?' before you sign anything.
  • Businesses planning to borrow – The monthly payments, total cost and the affordability tests a lender will run.
  • Businesses with an overdraft or invoice finance – What your existing facilities really cost and whether something else would be cheaper.
  • Advisers and brokers – A clear, printable comparison to talk clients through.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business name, the current Bank of England base rate and your tax rate.
  2. Loan Calculator – Enter the loan amount, term, repayment type, any capital holiday or balloon, the interest rate (fixed, or margin plus your base-rate forecast), the fees and, if you're testing it, the month you'd repay early.
  3. Compare Loans – Type in up to four offers – amount, term, rate, fees – and see the cheapest overall and the lowest APR.
  4. Overdraft – Enter your limit, rates and fees. Paste a year of end-of-day balances into Daily Balances, or type monthly averages into the table on the Overdraft sheet.
  5. Invoice Finance – Enter your credit sales and debtor days, then the factoring and invoice discounting quotes.
  6. Asset Finance – Enter up to four quotes for the same asset – deposit, payments, final payment, fees and what it'll be worth at the end.
  7. Affordability – Enter EBITDA, tax, capital spending and existing borrowing, pick which new borrowing to include and read the tests.
  8. Dashboard – See everything together.

Key features

  • Loan calculator: fixed or variable rates, repayment or interest-only, capital holidays, balloons, fees and early repayment with ERCs – full month-by-month schedule, APR and total interest.
  • Compare up to four loan offers side by side on monthly payment, total cost and true APR.
  • Overdraft cost from your daily or monthly balances – arranged and unarranged interest, fees and the effective rate you really pay.
  • Factoring vs invoice discounting vs overdraft vs loan, asset finance (HP, leases, loans) converted to a true rate, and affordability tests: DSCR, interest cover and debt ÷ EBITDA.

What’s included

  • Dashboard – Costs and affordability at a glance
  • Settings – Base rate, tax relief, business name
  • Loan Calculator – One loan in full
  • Loan Schedule – Month-by-month schedule
  • Compare Loans – Up to four offers side by side
  • Overdraft – Overdraft cost from your balances
  • Daily Balances – Daily bank balances for the overdraft
  • Invoice Finance – Factoring and invoice discounting
  • Asset Finance – HP, leases and loans for assets
  • Affordability – DSCR, interest cover, leverage, stress test
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions