The bank said yes. Did the bad year?

A normal year and your bad year, side by side. The starting figures are a joinery workshop borrowing for a new line, so swap in your own.

Starting figures · add your own
The business

From your accounts: profit before interest, with depreciation added back.

Replacing what wears out, not growth.

Drawings and dividends together with the business's tax.

The loan

Repaid monthly, in equal amounts of interest and capital.

The rate is
The bad year and your line

Yours to set. Think of the worst year you've had, then a bit worse.

We started it at 1.25, which is our guess, not a rule. 1.25 means £1.25 left for every £1 of repayments.

Also counted: the same £100,000 of tax and drawings in a bad year, and no other repayments.

1.64 times
Covered in a normal year
£460,000
The most your bad year carries at 1.25
What the numbers sayShort in a bad year

How much can we carry?

At your 1.25, a normal year carries £785,000 of loan and your bad year £460,000. The loan you're looking at is £600,000.

Where the money goes

In a normal year £240,000 is left against £146,000 of repayments. In your bad year £140,000 is left against £146,000.

What moves it

The most a bad year carries at your 1.25, by term. At 8%: 3 years £295,000, 5 years £460,000, 7 years £595,000, 10 years £765,000. At 6%: 3 years £305,000, 5 years £480,000, 7 years £635,000, 10 years £840,000. At 10%: 3 years £285,000, 5 years £435,000, 7 years £560,000, 10 years £705,000.

On your figures, the £600,000 is covered 1.64 times in a normal year, and profit can fall 14% before that drops under the 1.25 you chose. In your bad year the repayments come to more than the cash left to pay them: covered 0.95 times. The most your bad year carries at 1.25 is £460,000 over 5 years. Two more years on the term carries £135,000 more, where 2 points off the rate carries £20,000; the longer term costs £55,500 more interest in all.

The most a bad year carries at 1.25. By term and rate, rounded down to the nearest £5,000
Repaid over6%8%10%
3 years£305,000£295,000£285,000
5 years£480,000£460,000£435,000
7 years£635,000£595,000£560,000
10 years£840,000£765,000£705,000
Your £600,000, by term. Repaid monthly at 8%
Repaid overA year's repaymentsCovered, normal yearCovered, bad yearInterest in all
3 years£225,6001.060.62 under£76,900
5 years£146,0001.640.95 under£130,000
7 years£112,2002.131.24 under£185,500
10 years£87,4002.741.60£273,600

Rough sums on your figures, before any fees. Not financial advice, not a credit assessment, and not a view on whether to borrow, how much, or from whom. The cover you're comfortable with is your choice; any lender does its own sums in its own way. Everything runs in your browser.

Downloads propellr-borrowing-reminder.ics. Opens in Outlook, Google or Apple calendars. No sign-up, no email.

How this works

It takes what's left of a year's profit after the kit you have to replace, tax and what the owners take out, and divides it by a year's repayments. That's how many times the repayments are covered.

It does that twice: a normal year, and your bad year, with profit down by the amount you chose and, on a variable rate, the rate up by your guess. Both are the first year of the loan, when the most is owed.

Cover you're comfortable with is your line, not ours and not a bank's. We started it at 1.25. Move it and see what changes.

The most carried is the loan whose repayments your bad year covers exactly that many times, rounded down. The tables show it for other terms and rates, and what the loan you typed costs in interest over each term.

Covered = (profit − kit to stand still − tax and drawings) ÷ a year's repayments
Most carried in a bad year = (bad-year cash ÷ your cover − other repayments) ÷ a year's repayments on £1

How much loan £10,000 a year of repayments pays off, repaid monthly, to the nearest £1,000
Repaid over6%8%10%12%
3 years£27,000£27,000£26,000£25,000
5 years£43,000£41,000£39,000£37,000
7 years£57,000£53,000£50,000£47,000
10 years£75,000£69,000£63,000£58,000
15 years£99,000£87,000£78,000£69,000

It leaves out arrangement fees, security, repayment holidays, interest-only spells and what any bank will test for itself. A bank does its own sums in its own way; these are yours.

We did one like it

The money · Advise, then Build

The bank wants the working. So do you.

A property developer. The bank wanted more than the budget. We set out the funding need, when the money is needed and how it gets repaid, in one pack with the working behind it.

More on strategic finance

Profitable but short of cash?

Try next

Seen something familiar?

Rough sums only get you so far. Bring the real ones to a first call.

Book a callAsk about this result