To spread financial statements, you pull a company’s reported filings, recast every line into a single standardized template, and then apply a defined set of adjustments so the resulting numbers reflect real economic performance and can be compared cleanly against other companies and prior years. Accounting rules give companies wide latitude in how they label line items and group expenses, so raw filings rarely compare apples to apples. Spreading is the work that fixes that before any ratio or model gets built.
The stakes are simple. Every valuation, credit decision, and peer benchmark you build sits on top of these numbers. An inconsistency that slips through here quietly distorts everything downstream.
Start With the Right Source Documents
Public Companies
For U.S. public companies, work from the annual Form 10-K and the quarterly Form 10-Q filed with the SEC.1Securities and Exchange Commission. Form 10-K2Securities and Exchange Commission. Form 10-Q – General Instructions Prioritize the audited annual statements, which carry the highest level of assurance; use the unaudited quarterlies to fill gaps between fiscal year-ends. EDGAR provides full-text filings and XBRL-tagged data you can pull straight into a spreadsheet. Automated extraction cuts transcription errors, but you still have to verify that the tags map correctly to your template. When you enter data by hand, transcribe every line exactly as reported before reclassifying anything.
Don’t skip the narrative sections. SEC rules require the Management’s Discussion and Analysis to disclose material trends, unusual events, and known uncertainties likely to affect future results.3eCFR. 17 CFR 229.303 – Management’s Discussion and Analysis of Financial Condition and Results of Operations Companies also have to discuss off-balance sheet arrangements in a separately captioned section when those arrangements could materially affect financial condition or results.4Securities and Exchange Commission. Disclosure in Management’s Discussion and Analysis About Off-Balance Sheet Arrangements The footnotes and MD&A are where you find the items that require numerical adjustments later.
Private Companies
Most spreading in commercial lending involves private companies that file no public statements. The primary source is the federal tax return, usually IRS Form 1120 for C corporations, together with any compiled, reviewed, or audited statements the borrower provides. Form 1120 captures gross receipts, cost of goods sold, officer compensation, and taxable income on standardized lines, which makes year-over-year mapping straightforward.5Internal Revenue Service. Form 1120 – U.S. Corporation Income Tax Return For pass-through entities, that becomes Form 1065 for partnerships or Schedule C for sole proprietors.
Tax returns have an advantage and a limitation. The data follows one set of rules, and the owner has no incentive to overstate income. But tax accounting can diverge from economic reality, especially where accelerated depreciation understates true earnings in a capital-intensive business. Private company work needs its own adjustments, covered below.
How Far Back to Go
Pull at least five years of data. Ten is better for cyclical businesses. A single year is a snapshot; a historical baseline is what shows you how the company actually performs through different conditions.
Recast Everything Into One Template
Standardization matters because companies label similar items differently. One firm’s “Selling, General, and Administrative Expenses” is another’s “Operating Costs.” Drop both into a comparison without mapping them to the same row and the ratios you calculate are meaningless.
Income Statement
Separate core operating activity from everything else. Start with revenue, subtract cost of goods sold to reach gross profit, then deduct operating expenses to arrive at Earnings Before Interest and Taxes. Interest expense, non-operating income, and taxes each get their own rows below the EBIT line. Structured this way, operating margin and EBIT margin are calculated identically for every company you compare.
Watch EBITDA. Standard EBITDA adds depreciation and amortization back to EBIT. Many companies publish an “Adjusted EBITDA” that also strips out stock-based compensation, restructuring charges, and other items management labels non-recurring. Calculate standard EBITDA first and keep any adjustments in a separate reconciliation. Mixing an adjusted figure for one company with an unadjusted figure for another defeats the whole point.
Balance Sheet
Set uniform definitions for current assets, long-term assets, current liabilities, and long-term liabilities. Items like short-term investments and miscellaneous receivables need to land in the same bucket every time. Consistent classification is what makes liquidity ratios like the current ratio and quick ratio reliable.
Cash Flow Statement
Map the statement into three standard categories: cash from operations, cash from investing, and cash from financing. Most public companies already use the indirect method, starting with net income and adjusting for non-cash items. The occasional company using the direct method needs to be reformatted. You want a clean separation between cash generated by the core business, cash spent on capital investment, and cash used for debt and equity activity.
Convert to Common-Size
After recasting, restate every line as a percentage. On the income statement, each line becomes a percentage of revenue. On the balance sheet, each line becomes a percentage of total assets. Common-size format is one of the most useful outputs of the whole exercise because it lets you compare a $50 million company to a $5 billion one on equal footing. A cost of goods sold line reading 62% versus 71% tells you something immediately about relative efficiency, whatever the scale.
Apply the Adjustments That Change the Numbers
Recasting fixes structure. Adjustments fix substance. This is where you change the actual figures to reflect economic reality and strip out distortions from accounting choices, one-time events, and obligations that don’t show up on the face of the statements. Every change directly alters reported assets, liabilities, or earnings, so document each one and the reason for it.
Normalize Earnings
Normalization removes items that won’t recur so the earnings figure reflects sustainable operating performance. Common targets are restructuring charges, large litigation settlements, and gains or losses from selling a major asset. The mechanic is straightforward: add back a non-recurring charge or subtract a non-recurring gain from pretax income, then apply the company’s effective tax rate so the after-tax figure stays consistent.
The judgment call is what really qualifies as non-recurring. A company taking a “one-time” restructuring charge three years running doesn’t have a one-time expense. Look at the pattern across your full data window before accepting management’s label.
Stock-Based Compensation
Stock-based compensation is a non-cash expense that can be a large share of total compensation at technology and growth-stage companies. Whether to add it back to earnings is one of the more contentious calls in analysis. The case for adding it back is that no cash goes out and the economic cost shows up separately through diluted share counts. The case against is that if the company killed its equity program, it would have to pay higher cash salaries to keep the same people, so the cost is real.
The right answer depends on the purpose. For credit work, where cash flow is what matters, adding it back and then tracking share dilution separately makes sense. For equity valuation, treating it as a real expense is more conservative and arguably more honest. Whatever you pick, treat it the same way for every company in your peer set. Mixed treatments across the set are worse than either approach applied uniformly.
Capitalize Operating Leases (for Pre-ASC 842 Periods)
Before ASC 842 took effect, operating leases lived entirely off the balance sheet, so a company could finance billions in assets through leases and report no matching liability. ASC 842 now requires lessees to recognize a right-of-use asset and a lease liability for virtually all leases with terms longer than 12 months, whether operating or finance.6FASB. Leases
For current periods under ASC 842, the assets and liabilities are already on the balance sheet. When you’re spreading historical data from before adoption, capitalize the old operating leases yourself. Take the present value of the future minimum lease payments disclosed in the footnotes, discounted at the company’s incremental borrowing rate. Add that amount to property, plant, and equipment and to long-term debt. On the income statement, replace the lease expense with depreciation on the new asset plus interest on the new liability.
Other Off-Balance Sheet Debt
Operating leases were the most common form of off-balance sheet financing, but not the only one. Obligations from unconsolidated joint ventures, guarantees, and structured financing arrangements can all function as debt without appearing in the liability section. SEC rules require these to be disclosed in the MD&A when they could have a material effect on financial condition.4Securities and Exchange Commission. Disclosure in Management’s Discussion and Analysis About Off-Balance Sheet Arrangements Estimate the fair value of these obligations and add them to total debt. This raises the company’s true leverage and directly changes ratios like debt-to-equity and net debt-to-EBITDA. Ignoring these liabilities is where credit analysis most often goes wrong, because the company looks less leveraged than it really is.
Pension and Post-Retirement Obligations
An underfunded pension plan creates an obligation that functions much like debt. Credit analysts routinely treat the net pension liability as a debt equivalent, adding it to total debt when calculating leverage. The company owes this money to retirees and will have to fund it eventually, either through cash contributions or by issuing debt to make those contributions.
Tax-effect the adjustment. Future pension contributions are deductible, so the true economic burden is the net liability reduced by the related tax benefit. The pension footnotes give you the funded status, discount rate assumptions, and expected return on plan assets you need to size and direction the obligation.
Put LIFO and FIFO Companies on the Same Basis
When comparing companies with different inventory methods, convert them to a common basis. During periods of rising costs, a LIFO company reports lower inventory and higher cost of goods sold than an otherwise identical FIFO company. That produces artificial differences in gross margin and asset values that have nothing to do with operations.
Regulation S-X requires companies using LIFO to disclose the excess of replacement or current cost over the stated LIFO value, commonly called the LIFO reserve.7eCFR. 17 CFR Part 210 – Form and Content of and Requirements for Financial Statements To convert LIFO to FIFO, add the reserve to reported inventory on the balance sheet. On the income statement, the year-over-year change in the reserve adjusts cost of goods sold. If the reserve grew by $10 million, FIFO-basis cost of goods sold would be $10 million lower and gross profit $10 million higher.
Goodwill and Intangibles
Companies that have grown through acquisitions often carry substantial goodwill and other intangibles. These reflect the premium paid over fair value in past deals, and they can make two otherwise similar companies look very different on total assets and equity. Lenders commonly calculate tangible net worth by subtracting goodwill and other intangibles from total equity, giving the hard asset base actually available to creditors. For peer comparison, return on tangible assets or tangible equity gives a clearer picture of how efficiently the operating assets generate profits, without the noise of acquisition history.
Separate Non-Core Assets
Isolate assets that don’t contribute to core operations: excess cash beyond what the business needs to operate, marketable securities, non-operating real estate. Pull these assets and the income they generate out of the operating picture so that valuation multiples and return metrics reflect only the operating business. This matters most for return on invested capital. A company holding $500 million in excess cash earning 4% in a money market fund shows a diluted apparent return if you leave that cash in the capital base. Stripping it out reveals the return actually generated by the assets management deploys.
Private Company Adjustments
Private company spreading brings adjustments that rarely appear in public work. The most important is normalizing owner compensation. Private owners often pay themselves well above or below market for tax reasons. An owner drawing $800,000 from a business where a hired CEO would cost $250,000 is overstating expenses by $550,000 and understating true earning power by the same amount. Replace actual owner compensation with a reasonable market-rate estimate.
Other common private company adjustments include reversing accelerated tax depreciation to straight-line, removing personal expenses run through the business (vehicles, insurance, travel), and adjusting rent when the business leases property from a related party at above- or below-market rates. Document each adjustment in enough detail that another analyst could reproduce your work.
Where the Standard Template Doesn’t Apply
The template above works for manufacturing, retail, technology, and most other commercial and industrial companies. Financial institutions are a different animal. Spreading a bank on an industrial template will produce nonsense. A bank’s core assets are loans and securities, not inventory and fixed assets. Its core liabilities are customer deposits, not accounts payable and accrued expenses. The income statement centers on net interest income, the spread between what the bank earns lending and what it pays depositors, rather than gross profit. A loan loss provision replaces cost of goods sold as the primary expense deduction. The relevant profitability metric is net interest margin, and solvency measures are regulatory capital ratios rather than debt-to-equity. Insurance companies, real estate investment trusts, and utilities each have their own structural features that require modified templates. The principle still holds: every company in a peer group must be spread on the same template with the same definitions, or the comparison is worthless.
What the Spread Statements Are For
Once the statements are clean, adjusted, and consistent, the analysis they support gets a lot more reliable. Profitability ratios like return on assets and return on equity can be compared against industry benchmarks with confidence that any differences reflect real operational performance rather than accounting choices. Leverage ratios now include capitalized leases, off-balance sheet obligations, and pension liabilities, so they show the full debt picture. Coverage ratios like fixed charge coverage, which measures how comfortably earnings cover all fixed obligations including lease payments and interest, are meaningful only when the inputs are adjusted consistently.
In valuation work, the spread data feeds discounted cash flow models and comparable company analysis. Normalized earnings mean projected free cash flows reflect sustainable performance, not a year inflated by an asset sale or depressed by a restructuring charge. Adjusted balance sheet figures mean enterprise value calculations reflect the real debt load rather than just what appears on the face of the filing. For credit analysis, the adjusted statements give a realistic read on debt capacity and repayment ability. A lender sizing a $20 million facility needs actual leverage, actual coverage, and the actual trend in operating cash flow.
The single-company view over time is often the most revealing. Common-size percentages make structural shifts visible. If cost of goods sold creeps from 58% to 64% of revenue over four years, that’s a margin erosion story raw dollars can hide behind revenue growth. If debt-to-equity doubles over three years after adjusting for off-balance sheet items, that’s a leverage story the unadjusted balance sheet wouldn’t tell.