Financial spreading

What spreading is. "Spreading" means transcribing a company's reported financials into your own standardized template. It's the same row structure for every company you'll ever analyze, so five years of three statements plus key notes fit on one screen, in one format, with every number traceable to a filing page. Banks spread borrowers before lending, and analysts spread companies before believing anything. Doing it by hand, once per company, is Working Agreement 2 in action. The screener can fetch numbers once you've proven you know where they come from and what the aggregator's standardization silently does to them.

The deliverable is one workbook (or paper grid) per company. It holds 5 fiscal years × (income statement + balance sheet + cash flow + notes panel + derived panel), a mapping log of every judgment call, and a passed self-check protocol. You'll build one for a US 10-K and one for an Indian AR, and the applied mini-project names the companies.

4.13.1 The standard template: exact row structure

Copy this structure as it stands. Rows are numbered for grading. The columns are FY-4, FY-3, FY-2, FY-1, FY0, plus a Source column for filing/page/note refs and a Notes column for mapping comments. Currency and units are fixed in the header: $m for the US company, ₹ crore for the Indian one.

META
M1  Company / ticker / exchange
M2  Source filings (with filing dates)
M3  Currency & units                     M4  Fiscal year-end
M5  Statements used (consolidated; standalone ref for India)
M6  Auditor & opinion type, per year     M7  KAM/CAM titles, per year
M8  Promoter holding % & pledge % (India), per year

INCOME STATEMENT
I1  Revenue (net)                        [India: revenue from operations only]
I2  Cost of revenue / COGS               [India: constructed — log method]
I3  GROSS PROFIT = I1 − I2
I4  Selling, general & administrative    [incl. employee costs not in I2 — log]
I5  Research & development               [if disclosed]
I6  Other operating expense / (income)   [operating items only]
I7  EBIT (operating profit) = I3 − I4 − I5 − I6
I8  Depreciation & amortization          [memo: from CFS/notes if not on face]
I9  EBITDA = I7 + I8
I10 Finance costs / interest expense
I11 Interest & investment income         [non-operating other income]
I12 Other non-operating items
I13 Exceptional / unusual items          [own row, pre-tax, never netted]
I14 PRE-TAX INCOME = I7 − I10 + I11 + I12 + I13
I15 Tax expense (current + deferred)
I16 Effective tax rate = I15 / I14
I17 Net income — continuing operations
I18 Discontinued operations, net of tax
I19 NET INCOME = I17 + I18
I20 Less: non-controlling interests
I21 NET INCOME TO PARENT = I19 − I20
I22 Basic EPS (as printed)               I23 Diluted EPS (as printed)
I24 Diluted weighted-average shares
I25 Dividends per share declared
CHK-I: I21 / I24 vs I23 (within ±1%)

BALANCE SHEET
B1  Cash & cash equivalents
B2  Short-term / current investments
B3  Trade receivables, net               [+ contract assets/unbilled — log]
B4  Inventories
B5  Other current assets                 [prepaid, current tax, ST loans given]
B6  TOTAL CURRENT ASSETS
B7  Net PP&E
B8  Capital work-in-progress             [US: usually inside PP&E note]
B9  Right-of-use assets                  [if presented separately]
B10 Goodwill
B11 Other intangibles
B12 Non-current investments
B13 Long-term loans & advances given     [India signal row — watch it]
B14 Deferred tax assets
B15 Other non-current assets
B16 TOTAL ASSETS
B17 Trade payables
B18 Short-term borrowings + current maturities of long-term debt
B19 Lease liabilities — current
B20 Other current liabilities            [provisions, contract liab./deferred revenue — log]
B21 TOTAL CURRENT LIABILITIES
B22 Long-term borrowings
B23 Lease liabilities — non-current
B24 Deferred tax liabilities
B25 Provisions & other non-current liabilities
B26 TOTAL LIABILITIES
B27 Share capital
B28 Additional paid-in capital / securities premium
B29 Retained earnings & other reserves   [log large components]
B30 Treasury stock (negative)
B31 Accumulated OCI
B32 EQUITY TO PARENT
B33 Non-controlling interests
B34 TOTAL EQUITY
CHK-B: B16 − B26 − B34 = 0 (exact, every year)

CASH FLOW STATEMENT
C1  Starting line (net income or pre-tax profit — note which)
C2  D&A
C3  Stock-based compensation
C4  Other non-cash / non-operating adjustments
C5  Δ Receivables      C6  Δ Inventories      C7  Δ Payables
C8  Δ Other working capital
C9  Direct taxes paid                    [Ind AS shows separately]
C10 CASH FROM OPERATIONS (CFO)
C11 Capex (PP&E + intangibles + CWIP additions paid)
C12 Acquisitions, net of cash acquired
C13 (Purchase)/sale of investments, net
C14 Interest & dividends received        [often CFI under Ind AS]
C15 Other investing
C16 CASH FROM INVESTING (CFI)
C17 Debt issued                          C18 Debt repaid
C19 Lease principal payments
C20 Interest paid                        [Ind AS: usually CFF; US GAAP: inside CFO]
C21 Equity issued / (buybacks)
C22 Dividends paid (incl. to NCI)
C23 Other financing
C24 CASH FROM FINANCING (CFF)
C25 FX effect on cash
C26 NET CHANGE IN CASH = C10 + C16 + C24 + C25
C27 Opening cash & equivalents
C28 CLOSING CASH = C26 + C27
CHK-C: C28 = B1 (or reconciled — overdrafts, held-for-sale cash — log)

NOTES PANEL (per year)
N1  Segment revenue, by segment          N2  Segment results/EBIT, by segment
N3  Contingent liabilities & guarantees (total; and as % of net worth)
N4  Related-party totals: sales / purchases / loans & guarantees outstanding
N5  Gross debt (B18 + B22 incl. current maturities); Net debt = gross − B1 − B2
N6  Debt profile: weighted rate, maturity wall, covenant notes (text)
N7  Capex per PP&E note (gross additions) — reconcile to C11
N8  SBC total; employee count
N9  Exceptional items detail (what, how much, cash or non-cash)
N10 Auditor flags: opinion, KAMs, CARO exceptions (India), ICFR issues

DERIVED PANEL (formulas only — no typed numbers)
D1  Revenue growth %          D2  Gross margin %       D3  EBITDA margin %
D4  EBIT margin %             D5  Net margin %         D6  Effective tax rate %
D7  CFO / EBITDA              D8  FCF = C10 − C11; FCF / I21
D9  Receivable days = B3/I1 × 365; Inventory days = B4/I2 × 365;
    Payable days = B17/I2 × 365
D10 Net debt / EBITDA         D11 ROE = I21 / average B32
D12 ROCE = I7 / average (B34 + N5 gross debt)   [refined properly in M2.03]

Print this template into your knowledge system. It's deliberately opinionated. EBITDA is built (I7 + I8) and never imported from a deck. Exceptional items get their own row so five-year margins can be read clean and dirty. Loans-given and pledge % are permanent rows, because this template must survive contact with Indian filings.

4.13.2 Sourcing five years

Filings carry limited history. A 10-K shows 2 balance-sheet years and 3 years of IS/CFS, and an Indian AR shows 2 years of everything. So you'll pull three filings per company:

The restatement rule covers the seams between filings. Sometimes the comparative column in a later filing differs from the number originally reported, because of a restatement. Reclassifications and discontinued-ops re-presentations do it too. When that happens, use the later (restated) figure and log the difference. A restated series is comparable, and the original is history. A large unexplained restatement is itself a finding, so flag it for your Phase 2 self.

4.13.3 The twelve steps (time budget ≈6–8 hours per company, first time)

1. Assemble documents (45–60 min): the three filings + latest DEF 14A (US) / latest shareholding pattern from BSE or NSE (India). Save PDFs locally with consistent filenames (CL_10K_FY2025.pdf).
2. Set up the workbook (20 min). Use the template above, with one sheet per statement or one long sheet, plus a MappingLog tab with columns row/filing/page/decision/reason.
3. Read before typing (30–40 min). Flip through FY0's statements and notes once, marking pages. You can't map lines when you haven't seen their shape.
4. Spread FY0 income statement from the audited statements (Item 8 / financial section), never from the press release, MD&A tables, or a screener. Log every mapping judgment.
5. Spread FY0 balance sheet. Force CHK-B to zero before moving on, and hunt typos now, while the page is open.
6. Spread FY0 cash flow. Run CHK-C. Reconcile or log.
7. Repeat 4–6 for the comparatives, then the older filings: FY-1 (inside the FY0 filing), FY-2/FY-3 (second filing), FY-4 (third). Apply the restatement rule at every seam.
8. Run the equity roll for every year (the self-check protocol ahead, check 5). Residual ≤1% of closing equity or explained.
9. Fill the notes panel: segments, contingents, RPT totals, debt profile, capex additions, SBC, auditor flags, pledge %.
10. Compute the derived panel, with formulas referencing spread cells only. Eyeball it for absurdities like negative payable days, 120% gross margin or a tax rate of 3%. Each one is almost always your mapping error. Fix upstream, never overtype.
11. Run the full self-check protocol (the grading key ahead) and record each check's result on the score sheet.
12. Write the one-pager: the 10-line summary (see the checklist format) + five things you learned about this company's disclosure habits + three open questions. File it in your knowledge system. This page is the seed of the company file you'll keep forever.

Which three notes join the notes panel?

Three notes join step 9's panel as the phase completes, and each one changes a number you'd otherwise quote wrongly. The employee-benefit note gives you the funded status, meaning plan assets less the defined-benefit obligation. A material deficit is a claim ranking ahead of shareholders. It belongs in net debt and in enterprise value before you compute a single leverage ratio. On the defined benefit obligation page you'll work the roll-forward and the discount-rate sensitivity that decides how big it really is. The foreign-currency note tells you which method each foreign operation uses. Translation puts closing and average rates to work and parks the difference in the translation reserve. Remeasurement runs the difference through profit. The answer decides how much of this year's revenue growth was the currency moving and how much was the business growing, and the method comparison and ratio grid are on the temporal vs current rate method page. The subsequent-events note tells you what has happened since the numbers were struck. Classify each item as adjusting or non-adjusting before you decide whether the balance sheet in front of you still describes the company. You met that distinction in your guided first read, and you'll drill it on live filings much later. Add all three to the notes panel and to your one-pager. Leave them out and you've spread the company as it was, which may not be the company as it is.

4.13.4 Mapping rules (the judgment layer)

1. Statements are the source, and notes are the decoder. Take face numbers from the audited statements and detail (D&A splits, capex, SBC) from the notes. Take nothing from decks or press releases.
2. Never net. Keep other income apart from other expense, and exceptional gains apart from charges. Each gets its own row and sign. Netting is where information dies.
3. Preserve printed totals as checks. Your I3/I7/I14 should recompute to the company's printed subtotals where they exist (US). Where they don't (India), the constructed subtotals are yours alone, so they must tie internally.
4. Constructing COGS from a Schedule III P&L (by-nature): COGS ≈ cost of materials consumed + purchases of stock-in-trade + changes in inventories of FG/WIP/stock-in-trade. You could add ± the manufacturing share of other costs if you choose to allocate, but most analysts don't at this stage. Log the method and keep it constant across all five years and all peers. Consistency beats theoretical perfection.
5. Split India's "other income". Interest goes to I11 (non-operating), and so do dividends and FV gains. I6 takes the items that really are operating. Think of export incentives and scrap sales, plus government grants tied to operations. Log the split, because it changes EBIT margin, sometimes by full percentage points.
6. Exceptional items (India face-of-P&L, US restructuring/impairment lines) always go to I13, gross, with N9 detail. You want margins with and without them.
7. Current maturities of long-term debt belong in B18 (debt), even when the filing parks them in "other current liabilities", as Ind AS presentation often does. Total debt must mean total debt.
8. Contract assets/unbilled revenue: map to B3 with a log entry. It behaves like a receivable, and the DSO analysis in efficiency ratios needs it visible.
9. Interest and dividend classification, from your cash-flow-statement work: note each company's CFO/CFI/CFF choices in the mapping log. Ind AS filers usually put interest paid in CFF and interest received in CFI, while US GAAP keeps both in CFO. Your C-rows keep the company's classification. Your derived FCF is computed consistently, and the log says how.
10. Units and rounding: US in $m, India in ₹ crore, one decimal at most. If the AR reports in ₹ lakh or ₹ million, convert at entry (1 crore = 100 lakh = 10 million) and note it. Mixed units are the most common first-spread disaster.

4.13.5 The self-check protocol: your grading key

This protocol is the answer key for the capstone. A spread that passes is presumptively correct, and every failure points you to where the error is. There are three tiers.

Tier 1: must be exact (every year, both companies):

Tier 2: within ±1%, else explained in the log:

Tier 3: sanity bands. Investigate anything outside them, and leave none unexplained:

What counts as passing the self-check?

The score sheet sets the pass bar. Tier 1 is 5 checks × 5 years × 2 companies = 50 cells, and all must pass, either to the digit or with a written reconciliation for #4/#5 naming the filing item. Tier 2 needs ≥90% of cells within tolerance, with the rest explained by name. An "explanation" cites a specific note or SOCE line, and "rounding" doesn't count. Tier 3 needs a one-line named cause for every out-of-band value. Passing this protocol on both companies is the module gate, and it's what "the spread ties" means in practice. When you're done, open screener.in / stockanalysis.com and diff their standardized numbers against yours. Every difference should now be explainable as their mapping choice, such as their COGS construction or their other-income treatment. If you can explain the aggregator's spread, you've graduated from it.