How to Calculate the Altman Z-Score from SEC 10-K Filings in Excel
Published October 2026 • Sourced from US-GAAP SEC XBRL Taxonomy
The Altman Z-Score, developed by NYU Stern Finance Professor Edward Altman in 1968, remains one of the most reliable multi-factor formulas for predicting corporate distress, credit degradation, and bankruptcy risk within a two-year horizon.
While many commercial terminals present the Z-Score as a black-box number, institutional equity and credit analysts calculate it directly from audited Balance Sheet and Income Statement line items. Here is the exact formula, US-GAAP XBRL mapping, and Excel implementation:
Where each X-ratio measures liquidity, cumulative profitability, operational productivity, market leverage, and asset turnover.
The 5 Ratios & US-GAAP XBRL Line Item Mapping
| Factor | Financial Ratio | 10-K Formula | US-GAAP XBRL Taxonomy Tags |
|---|---|---|---|
| X1 | Working Capital / Total Assets | (Current Assets − Current Liabilities) / Total Assets | AssetsCurrent - LiabilitiesCurrent / Assets |
| X2 | Retained Earnings / Total Assets | Cumulative Retained Earnings / Total Assets | RetainedEarningsAccumulatedDeficit / Assets |
| X3 | EBIT / Total Assets | Operating Income / Total Assets | OperatingIncomeLoss / Assets |
| X4 | Market Value of Equity / Total Liabilities | (Shares Outstanding × Share Price) / Total Liabilities | Market Cap / Liabilities |
| X5 | Sales / Total Assets | Total Net Revenues / Total Assets | Revenues / Assets |
Z-Score Interpretation Zones & Risk Thresholds
Company exhibits pristine balance sheet liquidity, low leverage, and minimal likelihood of distress.
Moderate vulnerability. Requires close inspection of debt maturity schedules and cash conversion cycles.
High probability of insolvency or restructuring within 24 months. Warning signal for credit investors.
How CALIO Automates the Altman Z-Score
Instead of manually looking up each of the 5 ratios across SEC EDGAR footnotes and entering them into a spreadsheet, CALIO automatically parses the audited US-GAAP XBRL company facts in real time.
In CALIO's Industry Peer Benchmark Desk and Valuation Terminal, the Altman Z-Score is calculated dynamically alongside the Beneish M-Score (earnings manipulation check) and Cash Conversion Cycle for any US-listed company.
Run Automated Solvency Forensics
Open any stock in CALIO to view real-time Altman Z-Scores, Beneish M-Scores, and 25-sector peer matrices.