Financial spreading for automated business credit decisions

Enter a business borrower’s statements and your limits to see which ratios pass.

Income statement
Balance sheet
Your credit policy limits

The business and limits in this demo are made up.

Policy limits met

3 of 4 met
Current ratio1.60×Met ≥ 1.2×
Debt to EBITDA3.00×Met ≤ 3.5×
Debt to equity3.00×Not met ≤ 2×
Interest cover4.00×Met ≥ 3×

The ratios outside the limits entered are Debt to equity.

Other figures

Quick ratio1.07×
Gross margin35.0%
EBITDA margin12.5%
Net margin5.4%
Days sales outstanding55
Equity€300,000

Income statement against revenue

Revenue
€2,400,000 100%
Cost of sales
−€1,560,000 −65%
Gross profit
€840,000 35%
Operating costs
−€540,000 −23%
EBITDA
€300,000 13%
Depreciation and amortisation
−€60,000 −3%
Interest
−€75,000 −3%
Tax
−€35,000 −1%
Net profit
€130,000 5%

Balance sheet, owned and funded

Assets
Cash8%
Receivables24%
Inventory16%
Fixed and other assets52%
Funding
Payables and other current liabilities20%
Short-term debt10%
Long-term debt50%
Equity20%

Email your result

These limits are credit policy rules that can run on every business application and be tested on your past applications before they change. Start your trial

Spreading statements and ratios

Financial spreading puts each borrower’s accounts into the same lines. You can read the same ratios and limits against each borrower.

EBITDA = Revenue − Cost of sales − Operating costs
Debt = Short-term debt + Long-term debt
Equity = Assets − Payables and other current liabilities − Debt
Current ratio = (Cash + Receivables + Inventory) ÷ (Payables and other current liabilities + Short-term debt)
Quick ratio = (Cash + Receivables) ÷ (Payables and other current liabilities + Short-term debt)
Debt to EBITDA = Debt ÷ EBITDA
Debt to equity = Debt ÷ Equity
Interest cover = EBITDA ÷ Interest
Days sales outstanding = Receivables ÷ Revenue × 365

The figures above show EBITDA, debt to EBITDA and current ratio.

€2,400,000 − €1,560,000 − €540,000 = €300,000
(€150,000 + €750,000) ÷ €300,000 = 3.00×
€720,000 ÷ €450,000 = 1.60×

The accounts are taken as entered, with no adjustments for owner’s pay, one-off items or leases. A ratio that cannot be read counts as outside its limit.

Business financial spreading and ratios

Financial spreading puts a business’s income statement and balance sheet into the same lines. The tool calculates current ratio, debt to EBITDA, debt to equity and interest cover from the figures entered.

A lender can compare those ratios with its own credit policy limits. The results show which limits the business meets and which ratios fall outside them.

Common questions

What is financial spreading?

Financial spreading puts a borrower’s income statement and balance sheet into the same lines. This makes the figures and ratios easier to compare across applications.

How do you calculate debt to EBITDA?

Divide total debt by EBITDA. If EBITDA is zero or less, debt to EBITDA cannot be read.

How do you calculate the current ratio?

Divide current assets by current liabilities. Current assets are cash, receivables and inventory.

How is interest cover calculated?

Divide EBITDA by interest. The result can be compared with the minimum interest cover in your credit policy.

How do you spread financial statements for a business loan?

Enter the borrower’s income statement and balance sheet figures in the tool. It calculates the ratios and compares them with the limits you enter.