Trailing Twelve-Month Financial Statements in Commercial Underwriting: A Borrower’s Guide

01

Define the exact twelve-month period

State the beginning and ending dates, the last closed month, fiscal year-end, accounting basis, currency, entities, and consolidation method. A TTM period ending September 30 should contain October of the prior year through September of the current year—twelve distinct months with no overlap or gap. Label preliminary months and do not silently insert estimates for an unclosed period. The lender may require a different testing date or the most recent available quarter, so confirm the requested cutoff before building the package.

02

Build the TTM from controlled monthly statements

Use the final monthly income statements and balance sheets produced from the accounting system, not a spreadsheet assembled from bank deposits or selected management reports. Preserve each month as a separate column and calculate the TTM total from those columns. Reconcile revenue, cost of goods sold, payroll, rent, interest, depreciation, amortization, taxes, and other material accounts to the general ledger. Investigate reopening entries, duplicate months, late adjustments, and differences between internal and CPA-issued statements.

• Requested amount and use of proceeds
• Historical and current financial statements
• Complete debt and ownership schedules
• Collateral and transaction documentation

03

Bridge the TTM to fiscal-year and year-to-date results

Show how the calculation moves from the most recent completed fiscal year to the current TTM period: begin with the fiscal-year result, subtract the months that rolled out, and add the new months that rolled in. Reconcile the current year-to-date period to the same months in the prior year. This bridge lets a lender distinguish genuine recent improvement or decline from a change caused only by replacing unusually strong or weak months.

04

Explain seasonality instead of hiding it in an annual total

A twelve-month total can conceal peak borrowing, low-cash months, weather exposure, holiday demand, construction cycles, school calendars, agricultural timing, or customer shutdowns. Present monthly revenue, gross margin, EBITDA or NOI, receivables, inventory, payables, cash, and line usage for at least the TTM period and, when useful, prior years. Explain when working capital is consumed and repaid so a lender can size the facility for the actual operating cycle rather than the annual average.

05

Separate acquisitions, dispositions, and discontinued operations

Identify the closing date and financial contribution of every acquired or sold business, location, product line, or property. Show reported TTM results, comparable same-entity results, and any permitted pro forma case separately. Reconcile purchase accounting, transaction costs, intercompany activity, transition services, duplicate overhead, and partial-period results. Do not present a full-year contribution for an acquisition that operated under the borrower for only part of the period unless the lender accepts a documented pro forma adjustment.

06

Normalize unusual items with the same discipline used for add-backs

List one-time gains, asset sales, casualty proceeds, legal settlements, subsidies, relocation costs, transaction expenses, owner-related items, and other proposed adjustments by month and general-ledger account. Explain why each item is nonrecurring and whether a cash receipt, reimbursement, or future cost offsets it. Present reported TTM results before adjustments. The lender may reject, cap, or time-limit a normalization, and an underwriting adjustment may differ from the definition used for future covenants.

07

Connect TTM earnings to working capital and cash

Reconcile earnings to changes in receivables, inventory, payables, customer deposits, accrued expenses, taxes, capital expenditures, owner distributions, and other uses of cash. Rapid growth can raise TTM EBITDA while consuming liquidity through a longer cash-conversion cycle. Show operating cash flow, maintenance capital spending, and free cash available for debt service rather than assuming the income-statement result is cash. Tie period-end balance-sheet amounts to aging schedules and bank activity.

08

Update debt service and lender-defined metrics

Use the current debt schedule, including principal, interest, leases, seller notes, related-party obligations, lines of credit, letters of credit, and proposed financing. Calculate leverage, debt-service coverage, fixed-charge coverage, liquidity, tangible net worth, debt yield, or other relevant tests using the lender’s definitions and the correct TTM measurement period. Identify floors, annualization rules, current maturities, add-back caps, and entity scope. Do not mix projected debt service with historical earnings without clearly labeling the pro forma case.

09

Stress the TTM rather than extrapolating the best months

Build sensitivities for slower sales, lower gross margin, customer loss, delayed collections, higher payroll or input costs, increased interest rates, necessary capital spending, and expiration of a favorable one-time item. Compare reported TTM, lender-adjusted TTM, and downside TTM cash flow. If recent months are stronger than the earlier part of the period, show whether backlog, contracts, recurring revenue, capacity, and collections support the trend instead of assuming the latest month will repeat twelve times.

010

Create a reproducible lender-ready package

Deliver the twelve monthly income statements, period-end balance sheet, TTM calculation, fiscal-year bridge, year-over-year monthly comparison, adjustment schedule, aging reports, debt schedule, cash-flow reconciliation, and downside case using consistent entity names and dates. Lock the submitted version, retain the general-ledger exports, and assign responsibility for later updates. Highlight subsequent results without rewriting the original case. PFCS can help organize the package and lender discussion, while lenders and qualified advisers determine accounting, tax, covenant, underwriting, approval, and final loan treatment.