Build a Three-Statement Financial Model for Industry Analysis
6 weeks · 0 milestones
Build a complete, linked three-statement financial model (income statement, balance sheet, cash flow statement) from publicly available filings for a real company, and use it to identify the key drivers of financial performance — not merely to reconcile the statements. The model must include at least two years of historical data and a one-year projection with documented assumptions. Proof requires review by a finance professional who can confirm that the model links correctly, the projection assumptions are explicit and defensible, and the performance driver analysis is analytically sound.
Milestone map
Milestone map
3 milestones
Select a publicly listed company and download three full years of income statement, balance sheet, and cash flow statement data from public filings. Build a clean historical data model in a spreadsheet with consistent formatting, correct line-item labelling, and a colour-coded input/formula structure (blue cells for hard-coded inputs, black for formulas). Verify that your historical cash flow statement reconciles with the balance sheet — cash ending balance must match in both.
Proof required
Submit your spreadsheet (or a shareable link) with three years of historical three-statement data for a named publicly listed company. The spreadsheet must show: (a) income statement, balance sheet, and cash flow statement on separate tabs, (b) a reconciliation check (cash balance cross-checks between BS and CFS), and (c) correct accounting equation balance (Assets = Liabilities + Equity) for each year. Cite the specific filings used (SEC EDGAR or company IR page, with filing date).
What gets checked
- Balance sheet balances for all three historical years — Assets = Liabilities + Equity with zero or explained rounding error
- Cash flow statement reconciles to balance sheet ending cash balance for all three years
- Input/formula colour-coding is applied consistently — hard-coded numbers are visually distinguishable from formula-driven cells