JaxWorks Mobile

JaxWorks is a Microsoft Partner




 

Z-Score Analysis Calculation-Public

 

Z-Score If Publicly Held Firm
NOTE: Dr. Altman occasionally updates his Z-Score formulae.
We suggest checking his site routinely: Click Here

 

 
 
Check your Z-Score: How's your Fiscal Fitness?
This worksheet figures out the Z-Score for your company, which indicates financial health. 

From Your Financial Statement You'll put in:

  • Earnings before taxes
  • Total assets
  • Net Sales
  • Market Value of Equity
  • Total Liabilities
  • Working Capital (Current  Assets minus Current Liabilities)
  • Retained Earnings 

The worksheet will indicate:

The short-term potential for financial problems at your company.

For more detail explanations and the formula see our two worksheets:
Altman Z-Score Analysis - Background and The Altman Z-Score Analysis

Please Note: Altman's Publicly Held model is probably the classic of this genre. The original data sample consisted of 66 firms, half of which had filed for bankruptcy under Chapter 7. All businesses in the database were manufacturers, and small firms with assets of less than $1 million were eliminated.

Also Note: The z-score represents a point in time. As such, the z-scores should be examined over time. Consistently low scores each year are more of a concern than a one time low score.

The Z score has proven successful in the real world. It correctly predicted 72% of bankruptcies two years prior to the event. Z score profiles for failing businesses often indicate a consistent downward trend as they approach bankruptcy.

We have preloaded some numbers for you. Click on Calculate Z-score to see the results. Then come back here and enter your numbers.

RATIO FORMULA WEIGHT FACTOR WEIGHTED RATIO
 
Return on Total Assets Earnings Before Interest and Taxes

Total Assets

x 3.3 ---
Sales to Total Assets Net Sales

Total Assets

x 0.999 ---
 
Equity to Debt Market Value of Equity

Total Liabilities

x 0.6 ---
 
Working Capital to Total Assets Working Capital

Total Assets

x 1.2 ---
Retained Earnings to Total Assets Retained Earnings

Total Assets

x 1.4 ---

 

KEY:

  • Z-SCORE ABOVE 2.99--YOU'RE IN GOOD SHAPE
  • Z-SCORE BETWEEN 2.99 and 1.81--WARNING SIGNS
  • Z-SCORE BELOW 1.81--BIG TROUBLE--COULD BE HEADING TOWARD BANKRUPTCY
 



Copyright, 2014, JaxWorks, All Rights Reserved.   |   Privacy Statement   |   Terms of Use