What it does
Generate a formula-driven five-year annual Excel workbook for a US-listed company: metric-specific SEC accession notes, Source Data, Standardized Data, editable assumptions, average-equity ROE, a historical working-capital view, and Base/Upside/Downside forecasts with year-specific margin, tax, and share-count assumptions. When available, forecast working capital from DSO/DIO/DPO. The workbook includes a DCF with illustrative CAPM/WACC inputs, terminal-value sensitivity, a Dashboard, formula-driven Model Checks, and Audit Flags. Missing data displays as n/a; a generation-time formula scan is included. DCF assumptions are not market-verified and the output is not a target price. Annual periods only (quarterly company facts have a structural Q4 gap). Ask whether the user wants the optional Valuation tab before setting includeValuation — it pulls a live Finnhub price snapshot.
An Excel download link and workbook-generation status; source accessions and missing data are represented in the workbook.
Who it helps
Analysts who want a reviewable workbook built from reported company history and explicit assumptions.
Inputs
Input names and constraints below come from the registered MCP tool schema.
| Input | What it controls |
|---|---|
| ticker required | ZodString |
| limit required | Number of most recent annual periods to include Default: 5. |
| includeValuation required | Add a Valuation tab (P/E, P/S, P/B, EV/Revenue, EV/EBITDA) from a live price snapshot Default: false. |
Example request
Build an annual five-year model for Apple using five historical periods, without the optional live-price Valuation tab.
{
"ticker": "AAPL",
"limit": 5,
"includeValuation": false
}What to expect
An Excel download link and workbook-generation status; source accessions and missing data are represented in the workbook.
Important limits
Forecasts and DCF assumptions are illustrative, not market-verified, and the output is not a target price. Annual periods only; ask before including the optional Valuation tab, which uses a price snapshot.
Data sources and verification
EdgarStack uses SEC EDGAR filings and, for applicable tools, SEC XBRL company-facts data. Coverage depends on the issuer, filing, taxonomy tags, and tool inputs. Follow the source filing references and verify material facts against the official filing.