DCF Model.
Five-year DCF valuation · gray cells are editable
输入美股代码，加载公司财报。所有金额与股数以 millions 显示。
Historical & forecast financials
Trace every number
Select a historical cell to see its XBRL tag and filing.
Key assumptions & formulas
- Data sources: Data comes from SEC Company Facts standard XBRL tags and supports USD / US GAAP 10-K annual and 10-Q quarterly reports. Fiscal periods are matched by actual start and end dates. Each item uses the latest filed value, which may include restatements, and retains its own filing date and source. Unmapped custom tags and undisclosed items remain blank.
- Base & inputs: SEC history is read-only. Gray fields are editable. Forecasts start at the selected annual or TTM period end; the default forecast tax rate is 25%.
- Cash flow: FCFF = EBIT − max(EBIT, 0) × tax rate + D&A − CapEx − ΔNWC. Forecast NWC = revenue × NWC ratio; CapEx is a positive outflow.
- Discounting & terminal value: Five-year FCFF and terminal value are discounted at year-end using WACC. Terminal value = final-year FCFF × (1 + g) ÷ (WACC − g), or final-year EBITDA × exit multiple. WACC must exceed g.
- Shared workspace: Company data and inputs persist across pages in this browser. Stock Analyzer's Base case uses the DCF's annual assumptions.