From 10-K to Simple Financial Model: A Step-by-Step Case Study

10-K to 3-Statement Model: Fast, Defensible Setup

A 10-K is a company’s audited annual report filed with the SEC. A simple three-statement model is a compact income statement, balance sheet, and cash flow forecast tied to a few operating drivers. The goal is to translate the 10-K’s facts into cash flows you can use for a first-pass valuation or credit screen.

Think of this as a disciplined shortcut. You reconcile to the filed statements, pick two or three core drivers, and produce free cash flow and leverage metrics that hold up to scrutiny. When built cleanly, a simple three-statement model gets you from disclosures to direction in a working day.

Where a Simple Model Fits and What You’ll Get

You are building a speed model that reconciles to the filed statements, isolates two or three core drivers, and produces free cash flow and leverage views. It suits an initial screen, a pre-LOI underwriting pass, or an idea sprint with a one-day timeline. It is not a long-range plan or a covenant model. Therefore, stick to public historicals, the disclosed business model, and clean extrapolations.

What “Simple Model” Actually Means

Single revenue bridge: Use at most two drivers such as units and price, stores and average unit volume, or subscribers and ARPU. Keep the bridge auditable.
Passive cost structure: Link COGS and operating expenses to revenue using trailing ratios, lightly adjusted by management commentary. Make only one or two explicit margin moves.
Lean working capital: Drive working capital with days sales outstanding, days inventory, and days payables. Hold other current items as stable ratios unless the 10-K flags a structural shift.
Capex and D&A separated: Tie capex to capacity or revenue; tie D&A to the fixed asset base, including lease depreciation when material.
Debt and taxes: Build from the debt note’s rates and maturities. Model cash taxes using a blended rate and net operating losses if disclosed.
Core outputs: Unlevered and levered free cash flow, net leverage, interest coverage, and a small two-way sensitivity for valuation guardrails.

If you need a broader tutorial, see a concise external refresher on a three-statement financial model.

Source Stack and Data Hygiene

Make the latest 10-K your primary source. Reconcile every line to the three-year historicals and footnotes. Anchor your driver tree in the segment and revenue recognition notes. iXBRL tags help with speed but are not authoritative, so always cross-check to printed statements. Use ASC 842, ASC 606, ASC 805, and ASC 740 only to resolve gray areas, and note that new FASB updates on segment reporting and taxes improve footnote depth starting with 2024-2025 year-ends. Only use non-GAAP when reconciled in the 10-K.

Selecting the Right Candidate Saves Hours

Clear unit economics: Favor businesses with obvious unit and price or volume drivers such as stores, seats, miles flown, or installed base.
Clean working capital: Be cautious with commodity exposure and LIFO layers unless you will normalize LIFO reserves.
Straightforward leases: Under ASC 842, right-of-use assets and liabilities are on balance sheet. Decide if lease liabilities sit in net debt and whether EBITDA needs adjusting for your benchmarking set. Be explicit either way.
Adequate segment detail: ASU 2023-07 improves visibility into segment expenses from late-2023 to 2025 filers. If segments are too aggregated to defend your drivers, switch targets.

Retailer Case Setup and Modeling Plan

Assume a U.S. GAAP retailer. The 10-K discloses stores at period end, openings and closures, AUV, and same-store sales. The revenue note explains recognition for delivery and digital channels. The leases note provides liabilities, discount rates, and terms. Debt consists of a term loan and a revolver. Taxes include an effective rate and any NOLs.

Revenue: AUV times average store count, plus an explicit comp and a new-store productivity ramp.
Margins: Store-level margin rolling to gross margin; SG&A as a percent of sales, adjusted for disclosed initiatives.
Working capital: Days-based mechanics tied to COGS and revenue.
Capex and D&A: New-store and maintenance capex; D&A linked to PPE and lease ROU assets.
Interest and taxes: Pull interest from the debt note; cash taxes at a blended rate adjusted for stock comp benefits when material.

10-K Map: Where Each Assumption Lives

Business overview: Segments and model. This sets the driver tree.
MD&A: Causes of year-over-year movements, seasonality, initiatives, cost pressures, pricing, and capex plans. Use Item 303’s analysis to build margin bridges and working capital trends.
Consolidated statements: Three years of IS, BS, and CF. Pull your historicals here, and use the indirect cash flow statement to verify linkages.
Revenue recognition: Performance obligations and timing. Break out subscription or delivery only if detail ties to total revenue.
Segments and disaggregation: Validate which unit economics matter and align to the dominant channel.
PPE and leases: Useful lives, gross additions, ROU assets and liabilities, discount rate, and term. Decide lease treatment for leverage and EBITDA.
Debt and equity: Maturities, rates, covenants, availability, and stock comp.
Taxes: Effective rate reconciliation and losses. Expect more detail under ASU 2023-09.
Commitments: Purchase obligations that affect capex or margins.

Build Steps You Can Execute in a Day

Reconstruct historicals: Input three years as presented. Map each cash flow line to balance sheet changes and income items. Prove that cash flow equals change in cash every year.
Define the driver tree: Pick one pair that explains most revenue variance, such as average stores times AUV, with comps and new-store ramping.
Confirm revenue recognition: Check gross vs. net for returns, loyalty, or delivery commissions. If contract liabilities are significant, model deferred revenue as working capital using a historical ratio.
Set margin assumptions: Start with gross margin and SG&A as a percent of sales. Use MD&A to justify moves such as pricing, mix, freight normalization, and wage inflation.
Build working capital: Compute DSO, DIO, and DPO on trailing math. Smooth one-offs and hold days flat unless structural changes are disclosed.
Model leases: Pull ROU assets and liabilities, discount rate, and term. Decide whether to include leases in net debt and keep consistency in EBITDA and coverage metrics.
Capex and D&A: Separate maintenance and growth only when disclosed or derivable. Otherwise tie capex to revenue or openings and project D&A from net PPE plus capex or useful lives.
Debt and interest: Build a debt schedule from maturities and rates. Compute cash interest on period averages and include the revolver commitment fee. Stress floating exposure by +100 to +200 bps.
Taxes: Use the latest effective rate unless credits are expiring or mix is shifting. Apply NOLs for cash tax holidays when disclosed.
Shares and equity: Pull diluted weighted average shares and project based on buybacks and issuance. Include stock comp in opex and present a clearly labeled adjusted EBITDA for comps if needed, while keeping GAAP EBITDA as the anchor.
Checks: Reconcile the cash flow statement, segment sums, lease rollforward, and the effective tax rate bridge before forecasting.

Quick Numerical Illustration: Revenue to Cash Flow

Assume 1,000 year-end stores vs. 950 prior year-end. Average stores equal 975. AUV is 3.0 million dollars, so base revenue is 2.925 billion dollars. With a 5 percent comp and 50 net new stores opening mid-year, incremental revenue from new units is 0.5 times 50 times 2.1 million dollars if year-one AUV is 70 percent of mature AUV, or 52.5 million dollars. Total revenue equals the 2.925 billion dollar base plus comp uplift plus 52.5 million dollars from new units.

At 35 percent gross margin and 22 percent SG&A, operating margin is 13 percent. If working capital equals five days of revenue, a 10 percent revenue lift uses roughly 40 million dollars of cash. Maintenance capex at 2 percent of revenue is 60 million dollars. Growth capex at 2 million dollars per new store with half-year weighting is 50 million dollars. D&A at 2.5 percent of revenue is about 73 million dollars. With a 25 percent cash tax rate, unlevered free cash flow is EBIT times (1 – tax) plus D&A minus capex minus the change in working capital. You now have two clean levers: comp and unit growth.

Translate MD&A into Modeling Assumptions

Gross margin moves: If mix and pricing power increased margin, take a 50 to 100 bps step-up. Avoid double counting if freight relief already landed in the base.
Labor inflation: If wage inflation of 4 to 5 percent hits a labor base of 30 percent of COGS and SG&A, test a 120 to 150 bps headwind unless pricing offsets it.
Capex guidance: If guidance is 300 to 350 million dollars for 80 to 90 stores, use midpoints for growth capex per store and treat the remainder as maintenance.

Working Capital Mechanics That Drive Cash Conversion

Receivables: DSO equals ending receivables divided by revenue times 365. For retailers with limited trade receivables, model gift card and credit card receivables as a percent of revenue when DSO is not meaningful.
Inventory: DIO equals ending inventory divided by COGS times 365. If LIFO applies and the reserve is disclosed, decide whether to normalize to FIFO for comps.
Payables: DPO equals ending payables divided by COGS times 365. Adjust only when MD&A supports vendor term changes.
Other current items: Tie accrued expenses to revenue unless programs with specific timing are disclosed.

Leverage, Coverage, and Lease Choices Must Align

Net leverage views: Present net leverage both with and without operating leases. If leases are in net debt, include lease interest in interest coverage for consistency.
Rate risk: If floating exposure is material, model period-average debt and shock +100 to +200 bps.
Off-balance context: If minimum purchase obligations or royalties exist, table them as off-balance-sheet details.

Accounting and Regulatory Touchpoints

Consolidation and VIEs: If VIEs are consolidated and material, ensure your drivers capture their economics.
Segment reporting: ASU 2023-07 expands significant segment expense categories and should improve cost allocation starting 2024-2025.
Income taxes: ASU 2023-09 adds jurisdictional rates and cash tax detail, improving multi-year forecasts.
MD&A requirements: Item 303 requires liquidity, capital resources, and known trends. Reflect supplier constraints or labor shortages in working capital and capex timing.
XBRL accuracy: The SEC’s September 2023 sample letter stresses consistent tagging and alignment. Always trust the printed statements.
Non-GAAP restraint: Only use metrics reconciled in the 10-K, and anchor comps on GAAP definitions.

Risks, Edge Cases, and Kill Tests

Revenue cut-off: If bill-and-hold or long-term contracts are material, unit times price may not hold. Consider backlog and remaining performance obligations only if they reconcile.
Volatile inputs: Swing DIO and DPO by plus or minus 10 days to quantify cash conversion risk.
Pensions and OPEB: If service cost or cash contributions are material, model them explicitly.
Impairment risk: If goodwill is near its implied fair value, include a non-cash impairment downside case.
Capitalized software: Confirm capitalization under ASC 350-40 and 340-10 and include amortization in D&A.
Kill tests: If you cannot tie cash flow to balance sheet changes within 30 minutes, stop and fix it. If segments do not disclose defendable unit economics, pick another company.

Implementation Timeline You Can Trust

Day 1 morning: Download the 10-K, build raw financials, reconcile cash flow.
Day 1 afternoon: Define the driver tree and margin assumptions; build working capital and capex logic.
Day 2 morning: Build debt, interest, leases, and taxes.
Day 2 afternoon: Run checks, compile source notes, and add a small two-way sensitivity on growth and margin.

Outputs You Can Put to Work

Unlevered FCF and a basic DCF: Use a WACC range based on capital structure and sector betas. If you need a refresher, see a short guide to DCF and how to select WACC.
Credit metrics: Net leverage with and without leases, interest coverage, and fixed charge coverage. Show covenant headroom if disclosed.
Scenario table: Low, base, and high for comp growth, new-unit productivity, and SG&A leverage. Include a sensitivity analysis for quick valuation bounds. For an outside perspective on structuring time-based paydowns, see this note on debt scheduling.

Comparisons and Alternatives

Use the latest 10-Q to update run rate and cost commentary, but keep the 10-K as the base. XBRL aggregators can speed historical input, but always audit against the printed 10-K. For IFRS filers, remember that IFRS 16 shifts more cost to depreciation and interest, so adjust EBITDA comps or present both GAAP-comparable and lease-adjusted EBITDA for clarity.

Governance, Audit Trail, and Deliverables

Traceability: Link each model line to a 10-K page and footnote. Keep a change log for assumption updates.
Retention: Store a PDF of the 10-K, note amendments, and document calculation policies. Legal holds override deletion.
Deliverables: One Excel file with Inputs, Model, and Outputs tabs, plus a two-page memo covering business overview, key drivers, three to five cited assumptions, and model outputs with open questions.
Verbatim extracts: Include an Item 1 business description paragraph, a bullet list of MD&A initiatives that support your assumptions, a short debt summary, and any explicit guidance with page cites.

Using Recent Accounting Changes to Your Advantage

ASU 2023-07: Expect sharper segment expense disclosure to refine SG&A allocation and segment margins.
ASU 2023-09: Use improved tax transparency to sharpen multi-year cash tax modeling for global filers.
SEC XBRL focus: Test sums and tags. When tags conflict with printed statements, default to the audited pages.

Speed Upgrades: One-Hour Triage and AI Assist

When the clock is tight, a one-hour triage gets you from zero to a defensible first draft without cutting corners. Start by rebuilding the revenue bridge from the segment and disaggregation notes, lock gross margin and SG&A as trailing ratios, and drop in days metrics from the latest year. Then wire the cash flow check using the indirect method and set a flat blended tax rate. Finally, stand up the debt inputs and a single sensitivity box on comp growth vs. SG&A leverage.

One-hour rule of thumb: If it does not reconcile or lacks a footnote, hold it flat and flag it. Speed never replaces proof.
Lightweight AI help: Use a retrieval-augmented summary to extract MD&A drivers or to tag every modeling input with a page reference. Keep AI outputs as annotations, not assumptions, unless you verify them against the printed 10-K.
Cash flow guardrail: Do not project until your historical indirect cash flow ties to the change in cash. This single check prevents cascading errors.

Conclusion

A simple model from a 10-K is a discipline: turn audited disclosures and MD&A into a driver-based cash flow view that balances precision with speed. If the economics clear your hurdle with conservative inputs tied to the 10-K, proceed to deeper diligence. If the build needs custom KPIs, unverified adjustments, or segment splits that do not tie back, move on and redeploy time where the facts line up.