Skip to main content
Intermediate ~20 hours

Three-Statement Model of a Public Company

Build a fully-linked three-statement model (income statement + balance sheet + cash flow) for one real public company.

Excel (no VBA)SEC EDGAR for filingsCFI or Wall Street Prep templates as reference only

About this project

The three-statement model is the bedrock financial-analyst portfolio piece. This project teaches the discipline: pull historical 10-Ks, model the linkages correctly (most candidates mess up working-capital changes), and produce a projection. Pick a public company you understand — ideally not too complex (SaaS, retail, consumer goods).

Why build this in 2026?

AI builds first-draft models but rarely gets the linkages right. Demonstrating you can is the floor of financial-analyst hiring.

What you'll ship

  • Excel file (no template starters)
5 years historical + 5 years projection
All three statements linked (no broken references)
Assumption tab with cells colour-coded

Sign up to see the full project brief

Full deliverables, success criteria, and AI Career Tutor support — free.

You'll unlock:Complete project brief, AI tutor that knows this project, and progress tracking when you start.

Skills you'll practice

accountingexcelfinancial modelingfinancial statements