Tax Return Analysis

Tax return analysis is the review of a borrower’s business returns, its related entities’ returns and its owners’ personal returns to confirm reported income, trace pass-through earnings and cash, and build cash flow on figures filed with the tax authorities.

Formula

How does tax return analysis reconcile the figures?

Book net income ± book-to-tax differences = entity taxable income

Each owner's K-1 income = entity taxable income × ownership share

Income taxed to the owner but kept in the entity = K-1 income − distributions received

  • Business returns: an S corporation files Form 1120-S and a partnership files Form 1065. Each issues a Schedule K-1 to every owner reporting that owner's share of income, deductions and credits.
  • Book-to-tax differences: items such as accelerated depreciation that make taxable income differ from the financial statements.
  • Personal returns: show the owners' wages, investment income, pass-through income and taxes, and list other entities the owners hold.

What do the returns show on a sample C&I deal?

Illustrative figures. Sample Fabrication, Inc. is an S corporation; Sample Realty is taxed as a partnership; both are owned 60% by Owner A and 40% by Owner B. Book income is assumed equal to taxable income.

EntityTaxable incomeOwner A K-1Owner B K-1Distributions
Sample Fabrication$780,000$468,000$312,000$300,000
Sample Realty$62,000$37,200$24,800$50,000

Sample Realty's taxable income is its $240,000 of net operating income less $108,000 of mortgage interest and $70,000 of depreciation. Depreciation is non-cash, so the cash behind that $62,000 is $132,000 before principal, and $72,000 after the $60,000 of principal. At Sample Fabrication, owners were taxed on $780,000 and received $300,000, leaving $480,000 of taxed income in the company.

How do lenders use tax returns?

Returns are signed and filed with the IRS, and they are often the main outside check on internally prepared statements for a closely held company. They reveal related entities, owner compensation, interest expense (a check on the debt schedule) and depreciation. Many lenders require two or three years of business and personal returns for owner-guaranteed loans and verify them with the tax authority through a transcript request.

Illustrative policy treatment: each year's returns reconciled to the statements spread for that year, with any difference in net income explained before cash flow is built.

Where does tax return analysis go wrong?

  • Counting K-1 income as the owners' cash when the entity kept it; Owner A's K-1 income of $505,200 compares with $210,000 of distributions received.
  • Adding K-1 income to personal cash flow and also counting the entity's cash flow in a global cash flow analysis.
  • Treating a loss on a K-1 as a cash drain without checking whether it is depreciation.
  • Missing an entity that appears on the personal return but not on the personal financial statement.
  • Comparing returns and statements for different fiscal years.

Where do tax returns appear in the credit memo?

They support the financial analysis (with a reconciliation to the statements), the guarantor analysis and the global cash flow schedule, with each figure cited to the return and page.

Related terms

K-1 income, global cash flow, financial spreading, personal financial statement, EBITDA and add-backs.

Where LenderBox does this work

Through financial spreading, LenderBox reads business and personal returns against the financial statements, with every figure cited to its page, so differences surface on day one.

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.