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.
Profit, the loan and a bad year. How many times the repayments are covered, at a line you choose.
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.
Also counted: the same £100,000 of tax and drawings in a bad year, and no other repayments.
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.
In a normal year £240,000 is left against £146,000 of repayments. In your bad year £140,000 is left against £146,000.
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.
| Repaid over | 6% | 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 |
| Repaid over | A year's repayments | Covered, normal year | Covered, bad year | Interest in all |
|---|---|---|---|---|
| 3 years | £225,600 | 1.06 | 0.62 under | £76,900 |
| 5 years | £146,000 | 1.64 | 0.95 under | £130,000 |
| 7 years | £112,200 | 2.13 | 1.24 under | £185,500 |
| 10 years | £87,400 | 2.74 | 1.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.
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
| Repaid over | 6% | 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
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.
A competitor's for sale. Put in the price and how it's paid, and see whether the cash keeps its reserve if their biggest customer walks.
Have a goThe same sum two ways. What each takes back over five years and a sale, and what each does to the cash in a bad year.
Have a goRough sums only get you so far. Bring the real ones to a first call.
Book a callAsk about this result