Financial spreading for automated business credit decisions
Enter a business borrower’s statements and your limits to see which ratios pass.
Policy limits met
The ratios outside the limits entered are Debt to equity.
Other figures
Income statement against revenue
Balance sheet, owned and funded
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.