« Book Review: The Only Guide to Alternative Investments You’ll Ever Need | Main | Book Review: A Failure of Capitalism »

04/09/2010

Creating a Z-Score Calculator on Your PDA


Click to Print This Page

Edward I. Altman’s z-score for predicting bankruptcy, introduced in 1968, was the precursor of credit-scoring models. Its application has since expanded to measure more than the publicly traded manufacturing companies investigated in Altman’s original paper. Using the following template—based on a paper by Arnold and Earl (2006)—you will be able to create a z-score calculator for your PDA. (In this case, we used an HP iPAQ PDA with Windows Mobile). While PDAs cannot take advantage of some of the Excel capabilities available on a PC, the Windows Mobile environment is functional enough to create a z-score template.

The z-score is based on a set of five ratios: X1 = (current assets - current liabilities) ÷ total assets; X2 = retained earnings ÷ total assets; X3 = EBIT (earnings before interest and taxes) ÷ total assets; X4 = (stock price × outstanding shares) ÷ total liabilities; and X5 = sales ÷ total assets. The z-score is defined as an equation with the five ratios: z = 1.2 × X1 + 1.4 × X2 + 3.3 × X3 + 0.6 × X4 + 0.999 × X5. A z-score below 1.81 indicates a high probability of failure, and a z-score above 2.99 indicates solvency. A z-score between 1.81 and 2.99 is inconclusive but generally not viewed as a positive sign.

The template requires nine readily available inputs: current assets, total assets, current liabilities, total liabilities, retained earnings, sales, EBIT, share price, and shares outstanding (see Figure 1). To finish the template, enter the coefficients into cells adjacent to the relevant ratio. The z-score is a matter of computing the above equation through cell references.

In the example below, the formulas entered into cells B13–B19 appear in red, and the results of the formulas appear in black. For these cells, only enter the red portion when replicating this template in Excel.

Figure 1: Z-Score Template
| Download the Template |

Figure 1: Z-Score Template
 

Coefficients are designated in individual cells because nonmanufacturing and private firms use different coefficients for calculating the z-score than those shown in this example. However, if such flexibility within the template is not necessary, the template can be made more compact (see Figure 2).

Figure 2: Compact Z-Score Template
| Download the Template |

Figure 1: Compact Z-Score Template

The z-score is still a very popular measure of solvency, and given the computational ease of the z-score—which requires only readily available data—it is well worth referencing as an initial measure of solvency.

References

Altman, Edward I., and Herbert A. Rijken. November 2004. “How Rating Agencies Achieve Rating Stability.” Journal of Banking and Finance, vol. 28, no. 11. 2679–2714.

Arnold, Tom, and John H. Earl, Jr. Summer 2006. “Applying Altman’s Z-Score in the Classroom.” Journal of Financial Education, vol. 32. 98–103.

–Tom Arnold, PhD, CFA; John H. Earl Jr., PhD, CFA; and David S. North, PhD, are associate professors of finance at the Robins School of Business at the University of Richmond.


Related Posts Plugin for WordPress, Blogger...

Comments

I love this template because it saves so much time.

There are really much more powerful application than that. What about Shumway's model? It's far simpler and more powerful.

There's Excel spreadsheet at http://investexcel.net/2746/altman-z-score which implements all three versions of Alman's Z-Score (for public manufacturing, private manufacturing and general companies).

The Z-score presented here is designed for publicly traded manufacturing companies.

The comments to this entry are closed.

UConn-ad

NYSSA Job Center Search Results

To sign up for the jobs feed, click here.


UPCOMING EVENT
MF16

NYSSA Market Forecast™: Investing In Turbulent Times
January 7, 2016

Join NYSSA to enjoy free member events and other benefits. You don't need to be a CFA charterholder to join!


CFA® EXAM PREP

CFA® Level I 4-Day Boot Camp
Midtown

Thursday November 12, 2015
Instructor: O. Nathan Ronen, CFA

CFA® Level II Weekly Review - Session A Monday
Midtown

Monday January 11, 2016
Instructor: O. Nathan Ronen, CFA

CFA® Level III Weekly Review - Session A Wednesday
Midtown

Wednesday January 13, 2016
Instructor: O. Nathan Ronen, CFA

CFA® Level III Weekly Review - Session B Thursday
Thursday January 21, 2016
Instructor: O. Nathan Ronen, CFA

CFA® Level II Weekly Review - Session B Tuesday
Thursday January 26, 2016
Instructor: O. Nathan Ronen, CFA