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.

Formula

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 lineAmountCheck
Revenue$12,000,000
Gross profit$3,600,000Revenue less $8,400,000 cost of goods sold
Operating income$930,000Less $2,350,000 operating expenses and $320,000 depreciation
Net income$780,000Agrees with total K-1 income of $468,000 + $312,000
EBITDA$1,250,000Net income plus $20,000 taxes, $130,000 interest, $320,000 depreciation
Total assets$5,700,000Equals liabilities $3,000,000 + equity $2,700,000
Funded debt$1,700,000Revolver $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.

See it worked on a deal you bring.

A 30-minute demo can run on documents you bring: LenderBox reads the file, shows the source page behind each figure, and checks the result against your credit policy.

See it on your deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.