How do you verify that a spread ties out?
You verify a spread by checking that its figures agree with each other and with the source documents. Confirm the balance sheet balances, roll retained earnings forward using net income and distributions, reconcile the statements to the tax return, match debt to the debt schedule, and test interest expense against the debt and its rates.
Each of these checks catches a different kind of error: a keying mistake, a line mapped to the wrong place, a missing liability or a distribution nobody mentioned. None of them takes long once the spread is built, and together they tell the reviewer whether the ratios built on the spread can be trusted.
Why does a spread need a separate review?
Spreading involves hundreds of small decisions: which line goes where, which items are one-time, how to treat related-party balances, what to do with a statement that uses different categories from last year. Most errors are not arithmetic. They are mapping and judgment errors that leave totals looking reasonable while a ratio is wrong.
A short, standard set of tie-outs makes the review consistent across analysts and reviewers, and leaves a record that the checks were done. That record matters later, when loan review or an examiner asks how the bank got comfortable with the numbers behind a covenant test or a risk grade.
What tie-outs should every spread pass?
The table below lists the core checks, what each compares and what a difference usually means. Run them for every period in the spread, not just the latest one, because an error in a prior year flows into trends and into the roll-forward.
| Tie-out | What you compare | What a difference usually means |
|---|---|---|
| Balance sheet balances | Total assets vs total liabilities plus equity | A keying error or a line left out of the spread |
| Totals agree to source | Spread subtotals vs statement subtotals | A line mapped twice or not at all |
| Retained earnings roll-forward | Beginning equity + net income - distributions vs ending equity | An unreported distribution, prior period adjustment or wrong net income |
| Tax return reconciliation | Book income and balance sheet vs Schedules M-1, L and M-2 | Timing differences, or statements that do not match what was filed |
| Debt schedule to balance sheet | Sum of loans on the schedule vs debt on the balance sheet | Debt missing from the schedule, or current portion misclassified |
| Interest reasonableness | Interest expense vs average debt x rates | Missing debt, capitalized interest or misclassified costs |
| Depreciation reasonableness | Depreciation vs fixed assets and capital spending | Assets missing, or depreciation buried in cost of sales |
How do you roll retained earnings forward?
Start with last year's ending retained earnings (or total equity for a partnership or S corporation), add this year's net income, subtract distributions or dividends, and adjust for any capital contributions. The result should equal this year's ending figure. If it does not, the difference is something the statements did not explain.
Example only. Beginning retained earnings are $3,200,000. Net income is $650,000 and the statement of cash flows shows $400,000 of distributions. The expected ending balance is $3,200,000 + $650,000 - $400,000 = $3,450,000, but the balance sheet shows $3,410,000. The $40,000 gap could be an extra distribution, a prior period adjustment or a different net income figure from the one spread. Ask the borrower, and if it turns out to be a distribution, include it in the cash flow used for debt service coverage.
How do you reconcile the financial statements to the tax return?
For many smaller borrowers the tax return is the most reliable document in the file, because it was prepared by an outside preparer and filed. Business returns usually include a book balance sheet (Schedule L), a reconciliation of book income to taxable income (Schedule M-1 or, for larger filers, M-3) and an analysis of retained earnings or capital accounts (Schedule M-2). Smaller filers are sometimes allowed to skip these schedules, so check what is there.
Schedule L should match the year-end balance sheet you spread. Schedule M-1 should start from the net income on the statements and explain the difference to taxable income through items such as depreciation timing, nondeductible expenses and tax-exempt income. Schedule M-2 gives the same roll-forward as the retained earnings check. Large unexplained differences between the statements and the return are a reason to ask which version is right before spreading either one.
- 1Compare Schedule L total assets, debt and equity with the spread balance sheet for the same year-end.
- 2Start from book net income and walk through Schedule M-1 to taxable income, noting each reconciling item.
- 3Check that the M-1 items make sense, such as tax depreciation that is higher than book depreciation for a company buying equipment.
- 4Compare distributions on Schedule M-2 with those on the cash flow statement or equity statement.
- 5Record each difference, its explanation and whether it changes the spread.
How do you tie debt on the balance sheet to the debt schedule?
Ask the borrower for a debt schedule listing every loan, line and lease with the lender, original amount, current balance, rate, maturity and monthly payment. Add up the balances and compare the total with interest-bearing debt on the balance sheet, including the current portion of long-term debt, lines of credit, finance leases and loans from owners.
A schedule that totals less than the balance sheet usually means a loan was left off, often equipment financing or an owner loan. A schedule that totals more may mean a loan sits in a different company in the group. Also check that the current portion on the balance sheet roughly equals the principal due in the next twelve months on the schedule, since that figure feeds debt service.
How do you test whether interest expense is reasonable?
Multiply the average debt for the year by the rates on the debt schedule and compare the result with interest expense on the income statement. It will not match exactly, because balances move during the year and rates on lines float, but it should be close.
Example only. Debt was $4,300,000 at the start of the year and $3,900,000 at the end, an average of $4,100,000. The debt schedule shows rates between 6.5% and 7.0%. Expected interest is roughly $4,100,000 x 6.75%, or about $277,000. Reported interest expense is $190,000. A gap of almost a third needs an explanation: perhaps some interest was capitalized into a construction project, part of the debt was drawn late in the year, interest on a related-party loan was not accrued, or some interest was recorded under another expense line. Each explanation changes the spread differently.
How does spreading work when the financials do not split principal versus interest?
Some borrowers record total loan payments as a single line, or their cash flow statement shows only the net change in debt. Debt service coverage needs principal and interest separately, so the reviewer has to rebuild the split. The most reliable method is to rebuild each loan's amortization from its terms and take principal and interest for the borrower's fiscal year.
Example only. A $2,000,000 loan at a fixed 6.5% with a 10-year monthly amortization has a payment of about $22,710, or $272,515 a year. In the first year, interest is about $125,677 and principal about $146,839, leaving a balance of about $1,853,161. If the borrower's statements show $272,515 of loan payments and no interest line, the spread should show $125,677 as interest expense and $146,839 as principal. In year two interest falls to about $115,843 and principal rises to about $156,673, so the split must be rebuilt each year, not copied.
When an amortization schedule is not available, a quick cross-check is: principal repaid = beginning debt + new borrowings - ending debt. Interest is then total payments minus that principal. Use the lender statements or the bank's own loan system for the bank's loans, and ask the borrower for statements from other lenders.
| Year | Total payments | Interest | Principal | Ending balance |
|---|---|---|---|---|
| 1 | $272,515 | $125,677 | $146,839 | $1,853,161 |
| 2 | $272,515 | $115,843 | $156,673 | $1,696,489 |
What should you record when a tie-out fails?
A failed tie-out is not always a problem with the borrower. Often it is a mapping error in the spread, which the reviewer can fix. When it is a real difference, record it so the next person does not have to rediscover it.
- Which check failed, for which period, and the size of the difference.
- The explanation, where it came from (borrower, accountant, tax return) and whether it was verified.
- Any change made to the spread as a result, and who made it.
- Whether the difference affects a covenant test, the risk grade or the credit memo.
- Anything left unresolved, and the follow-up request sent to the borrower.
How Aarvion helps
Aarvion Risk OS Commercial Credit spreads statements and tax returns into the bank's own spread template with each figure linked back to the page it came from, and runs tie-outs such as the balance check and retained earnings roll-forward automatically. Failed checks are flagged for the analyst instead of being buried in the totals.
The analyst confirms or corrects the spread, a named reviewer signs off, and every change is recorded with who made it and why. Covenant tests, risk grades and memo drafts then use the confirmed figures, so they all start from the same verified numbers.
