Build a 3-Statement Financial Model from Scratch
6 weeks · 0 milestones
Build a complete, linked 3-statement financial model (P&L, balance sheet, cash flow) for a real company from scratch.
Milestone map
Milestone map
3 milestones
Select a real public company whose 10-K (or equivalent annual report) is freely available on SEC EDGAR or the company's investor relations page. Gather at least three years of historical financials and build the historical income statement with proper line item structure: revenue segmented by business line, gross profit, EBIT, and net income — not a simplified summary. Every cell must trace to a specific line item in the filing.
Proof required
Excel or Sheets file showing the historical income statement for your chosen company with at least 3 years of data, each major line item labelled, and a footer note citing the specific 10-K filing each year's data comes from.
What gets checked
- At least 3 years of historical income statement data from real public filings
- Revenue segmented by business line where disclosed — not a single revenue line
- Every major line item traces to a specific source in the annual report