Lesson 6 of 6

Pull a company into your spreadsheet

Module 04 · The three financial statements

Pull a company into your spreadsheet

Get 3 years of statements into a sheet in 10 minutes by copying from the filing's interactive Financial Report pages, then lay them out.

9 min6 short steps

Step 1 of 6

Why this matters

Reading statements on a screen is fine. Analysing them is easier in your own spreadsheet. Once the numbers are in a sheet, you can line years up side by side, add your own rows (growth, margins, free cash flow) and spot trends in seconds.

You don't need a paid data service for this. The SEC gives you clean tables for free. It takes about 10 minutes per company.