10-K / 10-Q to Excel
Statements come straight from SEC XBRL filings with the filing number for every figure. The workbook is a working model: change an assumption in Excel and the forecast, valuation and sensitivity grid recalculate.
Examples: · · · · ·
What the workbook contains
- Annual and quarterly statements (values, with quarter derivations disclosed)
- Assumptions sheet: growth, free-cash-flow margin, discount rate, terminal growth
- Five-year forecast and DCF valuation as formulas
- Sensitivity grid: value per share by discount rate and terminal growth
- Checks (balance sheet, gross profit, trailing four quarters) and a source register with SEC links