Financial Spreading
Financial spreading is entering a borrower’s financial statements and tax returns into the lender’s standard format, line by line and period by period, so that ratios can be calculated and periods and borrowers compared on the same basis.
What does a credit officer check in a spread?
There is no formula for a spread. It is a structured restatement, done in order: source figures mapped to standard lines, subtotals recomputed, tie-outs checked, then ratios calculated. What it contains:
- Standard lines: the lender's chart of accounts for the income statement, balance sheet and cash flow, so one borrower's "cost of sales" and another's "direct costs" land on the same line.
- Subtotals: gross profit, operating income, EBITDA, current assets, total liabilities, equity, recomputed from the lines rather than copied.
- Tie-outs: checks that the balance sheet balances, that net income agrees with the tax return or explains the difference, and that debt on the balance sheet agrees with the debt schedule.
- Source: the document and page for every figure, and the statement quality (audited, reviewed, compiled, internal or tax return).
What does a spread show on a sample C&I deal?
Illustrative figures for Sample Fabrication, Inc. for the most recent fiscal year.
| Spread line | Amount | Check |
|---|---|---|
| Revenue | $12,000,000 | |
| Gross profit | $3,600,000 | Revenue less $8,400,000 cost of goods sold |
| Operating income | $930,000 | Less $2,350,000 operating expenses and $320,000 depreciation |
| Net income | $780,000 | Agrees with total K-1 income of $468,000 + $312,000 |
| EBITDA | $1,250,000 | Net income plus $20,000 taxes, $130,000 interest, $320,000 depreciation |
| Total assets | $5,700,000 | Equals liabilities $3,000,000 + equity $2,700,000 |
| Funded debt | $1,700,000 | Revolver $900,000 + current portion $200,000 + long-term $600,000, agrees with the debt schedule |
Two items are tagged for the analyst rather than buried in operating expenses: $400,000 of officer compensation and $300,000 of rent paid to Sample Realty, a related entity. Both matter later, in global cash flow, where each is counted once. The $100,000 due from shareholder is tagged for deduction from tangible net worth.
How do lenders use financial spreading?
Every ratio in the memo, every covenant level and every risk rating rests on the spread. A mistyped figure looks normal in a table of numbers, so the tie-outs and source references are what make a spread reviewable. Many lenders spread at least three years plus an interim period, and spread related entities and guarantors separately before combining them.
Illustrative policy treatment: three fiscal years plus the latest interim, with the borrower, related entities and guarantors spread separately and each figure tied to its source.
Where does spreading go wrong?
- Copying subtotals from the source instead of recomputing them, so a source error passes through.
- Mapping the same item to different lines in different years, which creates a false trend.
- Spreading a tax return and a CPA statement for the same year without reconciling them.
- Burying related-party rent, officer pay or owner receivables in general lines where the analyst cannot see them.
- Losing the link between each figure and its page, so a reviewer has to search the file to check it.
Where does the spread appear in the credit memo?
The spread is the appendix behind the financial analysis, ratio summary and covenant table.
Related terms
Tax return analysis, EBITDA and add-backs, K-1 income, personal financial statement, credit memo.
Where LenderBox does this work
LenderBox handles financial spreading for the statements and returns in the file, with each figure linked to the document and page it came from, so your analyst, your committee or an examiner can check a number in seconds.