1.10-Year Financial Benchmarking Automation
kpi cards and line chart · 2026
An FP&A analyst needed to extract and normalize a decade of nested SEC EDGAR JSON filings into an executive-ready visual summary. The resulting automated dashboard tracks a ten-year financial benchmarking model. The analysis highlights annual revenue scaling from $91.2 billion in 2016 to $281.7 billion in 2025, representing a 13.4% CAGR. It also reveals operating margin expanding by 1701 basis points to 45.6% and net income growing 5.0x to $101.8 billion. An annual P&L trend line chart tracks Revenue, Gross Profit, Operating Income, and Net Income. While originating in corporate finance, these benchmarking methods are highly transferable to manufacturing management tools for evaluating long-term operational profitability.
What it shows:
Automate the extraction of nested JSON financial data to build executive-ready benchmarking models.




