Business financial statements · Loan documents

Lend on statements your analyst has tied out.

Your analyst opens business financial statements already spread period by period and tied to the tax returns and the debt schedule. Margins, working capital, EBITDA and tangible net worth arrive with each figure cited, and covenant tests run from the same spread. What the trend means for the credit stays your analyst's decision.

FINANCIAL STATEMENTS · ILLUSTRATIVECPA-REVIEWED · TWO YEARS
Two years of statements, read line by line
SAMPLE FABRICATION, INC. · REVIEWED FINANCIAL STATEMENTS · PAGES 3 AND 4
INCOME STATEMENT · PAGE 4
LINETHIS YEARPRIOR YEAR
1Revenue12,000,00011,000,000
Cost of goods sold(8,400,000)(7,590,000)
2Gross profit3,600,0003,410,000
Operating expenses(2,350,000)(2,220,000)
Depreciation(320,000)(300,000)
Operating income930,000890,000
Interest expense(130,000)(140,000)
State taxes(20,000)(18,000)
3Net income780,000732,000
BALANCE SHEET · PAGE 3 · FISCAL YEAR END
4Total current assets3,500,000
Intangible assets200,000
Due from shareholder100,000
Total assets5,700,000
4Total current liabilities2,400,000
Total liabilities3,000,000
5Shareholders' equity2,700,000
READ FROM THIS DOCUMENT, EACH FIGURE CITED
1Revenue$12,000,000 · up 9.1%Financial statements, p. 4
2Gross margin30.0% · 31.0% priorFinancial statements, p. 4
3Net income$780,000Financial statements, p. 4 · 1120-S, p. 1
4Working capital$1,100,000 · 1.46x currentFinancial statements, p. 3
5Tangible net worth$2,400,000Financial statements, p. 3
Margin slipping as sales grow1.0 pt
Revenue rose 9.1% to $12,000,000 while gross margin fell from 31.0% to 30.0%. At last year's margin, gross profit would be $120,000 higher. EBITDA still rose 5.0%, to $1,250,000.
Financial statements, p. 4Prior-year statements
What a credit officer checks on business financial statements

Statements read for trend, quality and tie-outs.

Each check reads the statements against one another, the tax return, the debt schedule or your policy. The results come from the illustrative $1.2 million equipment term loan to Sample Fabrication.

THE CHECKON THE SAMPLE FILE · ILLUSTRATIVE
Statement quality
Audited, reviewed, compiled or internal, read from the accountant's report, against what your policy and the loan agreement require.
TIES OUT
Reviewed by an outside CPA for both years, with no departures noted in the review report. The proposed loan agreement asks for reviewed annual statements.
Financial statements, p. 1Loan agreement §5.1
Three statements that tie
Net income should carry to equity, and the balance sheet and cash flow statement should agree on cash, capital spending and distributions.
TIES OUT
Opening equity of $2,220,000 plus $780,000 of net income less $300,000 of distributions is $2,700,000, as reported. Cash of $350,000, $180,000 of capital spending and the distributions agree across the statements and the K-1s.
Financial statements, pp. 3 to 5K-1s
Add-backs to EBITDA
Each adjustment the borrower proposes needs support in the file and must not recur.
FLAGGED
EBITDA is $1,250,000. The documented $60,000 legal settlement is added back. The $40,000 of consulting the borrower calls one-time appears every year, so adjusted EBITDA is $1,310,000.
Financial statements, p. 4Add-back schedule
Working capital
Current assets against current liabilities, with the revolver's classification and the days receivables take to collect.
ON THE RECORD
$1,100,000; current ratio 1.46x, quick ratio 0.81x, 48.7 days of sales in receivables. With the revolver classed as long-term, the current ratio would be 2.33x.
Financial statements, p. 3
Debt against earnings and net worth
Funded debt to EBITDA and total liabilities to tangible net worth, today and with the new loan.
TIES OUT
Funded debt to adjusted EBITDA is 1.30x today and 2.21x with the new loan, against a 3.00x maximum. Liabilities are 1.25x tangible net worth of $2,400,000, after $200,000 of intangibles and $100,000 due from a shareholder come out.
Financial statements, p. 3Debt schedule
The trend
Revenue, margins and earnings year over year, read before an average hides them.
FLAGGED
Revenue up 9.1%, gross margin down from 31.0% to 30.0%, EBITDA up 5.0% to $1,250,000, and EBITDA margin down from 10.8% to 10.4%.
Financial statements, p. 4
What LenderBox returns

Spreads that arrive built, period by period.

The statements become the spread, the ratios and the covenant tests, with each figure cited to its page.

PERIOD BY PERIODMargins, working capital and interim results are read period by period, so a trend an average would hide is on the record.
READ AGAINST ONE ANOTHERTax returns, financial statements and interim figures are read against one another, and a gap arrives with both pages.
TRACED TO ITS SUPPORTEach adjustment to earnings is traced to its support in the file, so you know how much of the cash flow is documented.
YOUR WORKBOOK, FILLEDFigures from the file fill your own Excel workbook, and changes made there come back.
HELD FOR A PERSONAn uncertain figure on the statements waits for your analyst, and the spread stays open until it is confirmed.
See spreading on a full file →
WHERE THE FIGURES GO · ILLUSTRATIVESAME SAMPLE FILE
The spread, funded debt, net worth and the memo
SPREADRevenue $12,000,000; EBITDA $1,250,000
Financial statements, p. 4
FUNDED DEBT TO EBITDA2.21x with the new loan against a 3.00x maximum
TANGIBLE NET WORTH$2,400,000 against a $2,000,000 covenant
Financial statements, p. 3
CREDIT MEMOTrend, adjusted EBITDA and covenant levels in the financial analysis

Your analyst's calls on the statements.

Reading
LENDERBOX DOESReads the accountant's report and every statement, for each year and any interim period.
STAYS WITH YOUR TEAMWhich years and interim periods the analysis needs.
Spreading
LENDERBOX DOESSpreads each line to your format, with each figure cited to its page.
STAYS WITH YOUR TEAMYour chart of accounts and where unusual items go.
Tie-outs
LENDERBOX DOESTies net income to equity and the statements to the returns and the debt schedule, with both pages for any gap.
STAYS WITH YOUR TEAMWhether a difference is explained.
Add-backs
LENDERBOX DOESTraces each proposed add-back to its support, or flags that it has none.
STAYS WITH YOUR TEAMWhich add-backs count.
The memo
LENDERBOX DOESDrafts the financial analysis with trend and adjusted EBITDA cited.
STAYS WITH YOUR TEAMThe credit decision.

Statements at every review the loan will have.

01 · FIRST LOOKLast year's statements with the request show early whether coverage and funded debt to EBITDA clear your credit box.
02 · UNDERWRITING · THIS DOCUMENTStatements are spread period by period and read against the returns and the debt schedule.
03 · CREDIT DECISIONCommittee sees the trend, adjusted EBITDA with its support, and the covenant levels it sets.
04 · CLOSINGThe 120-day statement deadline enters the loan agreement.
05 · LIFE OF THE LOAN · THIS DOCUMENTEach year's statements arrive for the annual review and the covenant tests, with covenant monitoring on the loan.

Audited, reviewed or internal: statement questions

Do internal statements work too?

Yes: audited, reviewed, compiled and internal statements, annual and interim, with the accountant's report. Each figure is cited to its page, and the statement quality is on the record.

Does it tie the statements to the tax returns?

Yes. Tax returns, financial statements and interim figures are read against one another. On the sample, net income of $780,000 agrees with ordinary business income on Form 1120-S.

Which add-backs make it into EBITDA?

Those with support that do not recur. Each adjustment to earnings is traced to its support in the file. On the sample, the documented $60,000 settlement counts and $40,000 of recurring consulting does not.

Does it fill our own spreading template?

Yes. Figures from the file fill your own Excel workbook, and changes made there come back.

Does it show EBITDA year over year?

Yes, side by side. On the sample, EBITDA rises 5.0% to $1,250,000 while the margin slips from 10.8% to 10.4%.

Two years of statements plus the interim that worries you.

The demo can run on your own deal documents: the statements come back spread, tied to the returns and cited to the page.

See it on your deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing