Skills › Financial Services › 3-statement-model › sec-filings.md
sec-filings.md
125 lines · plugins/vertical-plugins/financial-analysis/skills/3-statement-model/references/sec-filings.md at 6056506
Most marks come from matching words in the file, so treat them as pointers.
1# SEC Filings Data Extraction Reference
3**When to Use:** Only reference this file when a model template specifically requires pulling data from SEC filings (10-K, 10-Q). For templates that provide data directly or use other data sources, this reference is not needed.
5---
SEC Filings Data Extraction Reference
When to Use: Only reference this file when a model template specifically requires pulling data from SEC filings (10-K, 10-Q). For templates that provide data directly or use other data sources, this reference is not needed.
Raw lines 1 to 6
7## Extracting Data from SEC Filings (10-K / 10-Q)
9When populating a model template with public company data, extract financials directly from SEC filings.
Extracting Data from SEC Filings (10-K / 10-Q)
When populating a model template with public company data, extract financials directly from SEC filings.
Raw lines 7 to 1011### Step 1: Locate the Filing
131. Use SEC EDGAR: `https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=[TICKER]&type=10-K`
142. For quarterly data, use `type=10-Q`
Step 1: Locate the Filing
- Use SEC EDGAR:
https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=[TICKER]&type=10-K - For quarterly data, use
type=10-Q
Runs code bin/browse-edgar :13
16### Step 2: Identify Filing Currency
18Before extracting data, identify the reporting currency:
19- Check the cover page or header for reporting currency
20- Look at statement headers (e.g., "in thousands of U.S. dollars")
21- Review Note 1 (Summary of Significant Accounting Policies)
23**Common Currency Indicators**
25| Indicator | Currency |
26|-----------|----------|
27| $, USD | US Dollar |
28| €, EUR | Euro |
29| £, GBP | British Pound |
30| ¥, JPY | Japanese Yen |
31| ¥, CNY, RMB | Chinese Yuan |
32| CHF | Swiss Franc |
33| CAD, C$ | Canadian Dollar |
35Set model currency to match filing; document in Assumptions tab.
Step 2: Identify Filing Currency
Before extracting data, identify the reporting currency:
- Check the cover page or header for reporting currency
- Look at statement headers (e.g., "in thousands of U.S. dollars")
- Review Note 1 (Summary of Significant Accounting Policies)
Common Currency Indicators
| Indicator | Currency |
|---|---|
| $, USD | US Dollar |
| €, EUR | Euro |
| £, GBP | British Pound |
| ¥, JPY | Japanese Yen |
| ¥, CNY, RMB | Chinese Yuan |
| CHF | Swiss Franc |
| CAD, C$ | Canadian Dollar |
Set model currency to match filing; document in Assumptions tab.
Raw lines 16 to 3637### Step 3: Navigate to Financial Statements
39Within the 10-K or 10-Q, locate:
40- **Item 8** (10-K) or **Item 1** (10-Q): Financial Statements
41- Key sections to extract:
42 - Consolidated Statements of Operations (Income Statement)
43 - Consolidated Balance Sheets
44 - Consolidated Statements of Cash Flows
45 - Notes to Financial Statements (for schedule details)
Step 3: Navigate to Financial Statements
Within the 10-K or 10-Q, locate:
- Item 8 (10-K) or Item 1 (10-Q): Financial Statements
- Key sections to extract:
- Consolidated Statements of Operations (Income Statement)
- Consolidated Balance Sheets
- Consolidated Statements of Cash Flows
- Notes to Financial Statements (for schedule details)
47### Step 4: Data Extraction Mapping
49**Income Statement (from Consolidated Statements of Operations)**
51| Filing Line Item | Model Line Item |
52|------------------|-----------------|
53| Net revenues / Net sales | Revenue |
54| Cost of goods sold | COGS |
55| Selling, general and administrative | SG&A |
56| Depreciation and amortization | D&A |
57| Interest expense, net | Interest Expense |
58| Income tax expense | Taxes |
59| Net income | Net Income |
61**Balance Sheet (from Consolidated Balance Sheets)**
63| Filing Line Item | Model Line Item |
64|------------------|-----------------|
65| Cash and cash equivalents | Cash |
66| Accounts receivable, net | AR |
67| Inventories | Inventory |
68| Property, plant and equipment, net | PP&E (Net) |
69| Total assets | Total Assets |
70| Accounts payable | AP |
71| Short-term debt / Current portion of LT debt | Current Debt |
72| Long-term debt | LT Debt |
73| Retained earnings | Retained Earnings |
74| Total stockholders' equity | Total Equity |
76**Cash Flow Statement (from Consolidated Statements of Cash Flows)**
78| Filing Line Item | Model Line Item |
79|------------------|-----------------|
80| Net income | Net Income |
81| Depreciation and amortization | D&A |
82| Changes in accounts receivable | ΔAR |
83| Changes in inventories | ΔInventory |
84| Changes in accounts payable | ΔAP |
85| Capital expenditures | CapEx |
86| Proceeds from issuance of common stock | Equity Issuance |
87| Proceeds from / Repayments of debt | Debt activity |
88| Dividends paid | Dividends |
Step 4: Data Extraction Mapping
Income Statement (from Consolidated Statements of Operations)
| Filing Line Item | Model Line Item |
|---|---|
| Net revenues / Net sales | Revenue |
| Cost of goods sold | COGS |
| Selling, general and administrative | SG&A |
| Depreciation and amortization | D&A |
| Interest expense, net | Interest Expense |
| Income tax expense | Taxes |
| Net income | Net Income |
Balance Sheet (from Consolidated Balance Sheets)
| Filing Line Item | Model Line Item |
|---|---|
| Cash and cash equivalents | Cash |
| Accounts receivable, net | AR |
| Inventories | Inventory |
| Property, plant and equipment, net | PP&E (Net) |
| Total assets | Total Assets |
| Accounts payable | AP |
| Short-term debt / Current portion of LT debt | Current Debt |
| Long-term debt | LT Debt |
| Retained earnings | Retained Earnings |
| Total stockholders' equity | Total Equity |
Cash Flow Statement (from Consolidated Statements of Cash Flows)
| Filing Line Item | Model Line Item |
|---|---|
| Net income | Net Income |
| Depreciation and amortization | D&A |
| Changes in accounts receivable | ΔAR |
| Changes in inventories | ΔInventory |
| Changes in accounts payable | ΔAP |
| Capital expenditures | CapEx |
| Proceeds from issuance of common stock | Equity Issuance |
| Proceeds from / Repayments of debt | Debt activity |
| Dividends paid | Dividends |
90### Step 5: Extract Supporting Detail from Notes
92For schedules, pull from Notes to Financial Statements:
93- **Note: Debt** → Maturity schedule, interest rates, covenants
94- **Note: Property, Plant & Equipment** → Gross PP&E, accumulated depreciation, useful lives
95- **Note: Revenue** → Segment breakdowns, geographic splits
96- **Note: Leases** → Operating vs. finance lease obligations
Step 5: Extract Supporting Detail from Notes
For schedules, pull from Notes to Financial Statements:
- Note: Debt → Maturity schedule, interest rates, covenants
- Note: Property, Plant & Equipment → Gross PP&E, accumulated depreciation, useful lives
- Note: Revenue → Segment breakdowns, geographic splits
- Note: Leases → Operating vs. finance lease obligations
98### Step 6: Historical Data Requirements
100Extract 3 years of historical data minimum:
101- 10-K provides 3 years of IS/CF, 2 years of BS
102- For 3rd year BS, pull from prior year's 10-K
103- Use 10-Qs to fill in quarterly granularity if needed
Step 6: Historical Data Requirements
Extract 3 years of historical data minimum:
- 10-K provides 3 years of IS/CF, 2 years of BS
- For 3rd year BS, pull from prior year's 10-K
- Use 10-Qs to fill in quarterly granularity if needed
105### Data Extraction Checklist
107- Identify reporting currency and scale (thousands, millions)
108- 3 years historical Income Statement
109- 3 years historical Cash Flow Statement
110- 3 years historical Balance Sheet
111- Verify IS Net Income = CF starting Net Income (each year)
112- Verify BS Cash = CF Ending Cash (each year)
113- Extract debt maturity schedule from notes
114- Extract D&A detail or useful life assumptions
115- Note any non-recurring / one-time items to normalize
Data Extraction Checklist
- Identify reporting currency and scale (thousands, millions)
- 3 years historical Income Statement
- 3 years historical Cash Flow Statement
- 3 years historical Balance Sheet
- Verify IS Net Income = CF starting Net Income (each year)
- Verify BS Cash = CF Ending Cash (each year)
- Extract debt maturity schedule from notes
- Extract D&A detail or useful life assumptions
- Note any non-recurring / one-time items to normalize
117### Handling Common Filing Variations
119| Variation | How to Handle |
120|-----------|---------------|
121| D&A embedded in COGS/SG&A | Pull D&A from Cash Flow Statement |
122| "Other" line items are material | Check notes for breakdown |
123| Restatements | Use restated figures, note in assumptions |
124| Fiscal year ≠ calendar year | Label with fiscal year end (e.g., FYE Jan 2025) |
125| Non-USD reporting currency | Adapt model currency to match filing |
Handling Common Filing Variations
| Variation | How to Handle |
|---|---|
| D&A embedded in COGS/SG&A | Pull D&A from Cash Flow Statement |
| "Other" line items are material | Check notes for breakdown |
| Restatements | Use restated figures, note in assumptions |
| Fiscal year ≠ calendar year | Label with fiscal year end (e.g., FYE Jan 2025) |
| Non-USD reporting currency | Adapt model currency to match filing |