← Back to Templates


Altman Z Score
Description

Calculates the Altman Z-Score, the five ratio distress model combining working capital, retained earnings, EBIT, market value of equity and sales against total assets and total liabilities.
Each ratio and its weight stays visible beside the composite, so it is obvious which component is dragging the score, and the distress, grey and safe zone cut offs are shown for reference. Market value is built from historical price and share count, which means the score can be recomputed as of a past date. The model was calibrated on manufacturers, worth remembering when applying it elsewhere.
Template Screenshots

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found