Credit: Shutterstock photoWe are pleased to announce a new method of computing the bankruptcy risk of companies, the "Probability of Financial Distress."
Background
John Campbell, Jens Hilscher and Jan Szilagyi developed a logit probability model based on eight explanatory variables:
- Net income to market total assets (NIMTAAVG).
- Total liabilities to market total assets (TLMTA).
- Cash to market total assets (CASHMTA).
- Excess return compared to the S&P 500 (EXRETAVG).
- Standard deviation of daily returns over the past three months (SIGMA).
- Relative size (RSIZE).
- Market-to-book equity ratio ( MB ).
- The log of the stock price, capped at log(15) (PRICE).
The logit formula to compute the probability of financial distress ( PFD ) is given below:
LPFD = -20.12 * NIMTAAVG + 1.60 * TLMTA - 7.88 * EXRETAVG + 1.55 * SIGMA - 0.005 * RSIZE - 2.27 * CASHMTA + 0.070 * MB - 0.09 * PRICE - 8.87
To compute the PFD, we take the ratio of exp (LPFD) to 1 plus exp (LPFD), where "exp" stands for the exponential function. This PFD measures the probability that a company will go bankrupt within the next 12 months given its current financial position.
Example calculation
Consider Apple Inc. ( AAPL ), which currently has a PFD of approximately 0.02%.
Although most of the X variables have straightforward calculations, three of them require deeper calculations: NIMTAAVG, EXRETAVG and SIGMA.
For NIMTAAVG, we consider the net income over the market total assets over the past four quarters. Table 1 shows the NIMTA ratios of Apple for the past four quarters.
Table 1: NIMTA Ratios for Apple, Past Four Quarters
We then take the sum of the adjusted NIMTA's (last row of Table 1) to obtain 0.01095, the NIMTAAVG for Apple.
Note the "Weight" row in Table 1. According to the research paper, the NIMTAAVG is a "geometrically weighted average level of profitability where the weight is halved each quarter." We compute the EXRETAVG in a similar way, i.e., we place more weight on the more recent returns. Table 2 illustrates the EXRETAVG calculation for Apple.
Table 2: Excess Returns (EXRET) for Apple, Past 12 Months
The "Month" column in Table 2 refers to Month m, i.e., Month 0 refers to the current month and Month 1 refers to the previous month. The "Factor" column is constructed so the weight is halved each quarter. This means the weight for Month m is 2 ^ (-1/3) times the weight for Month m-1.
For sigma, we consider the annualized standard deviation of a company's returns over the past 92 days (or 63 trading days). Figure 1 shows the exact formula for sigma according to the research paper.
Figure 1
The other calculations should be straightforward: the TLMTA is simply total liabilities over market total assets while CASHMTA is simply cash and equivalents over market total assets. For relative size, we take the log of market equity over the market value of the Standard & Poor's 500 index. For the market-to-book value, we take the market equity over the adjusted book value of equity, which is the maximum value of one and the following sum: book equity plus one-tenth of the difference between market equity and book equity. Finally, we take the log of 15 or the company's share price, whichever is lower.
Screening for companies based on PFD
You can screen for companies based on their PFD through our All-in-one Guru Screener . The PFD filter is located in the first column, under the Fundamental tab as illustrated in Figure 2.
Figure 2
You can screen for PFD in increments of 5% using the drop-down menus for "Probability of Financial Distress" shown in Figure 2 above. For example, the highlighted filter in Figure 3 screens for companies with, at most, a 15% probability of financial distress.
Figure 3
We also have the PFD filter in our Customized section if you wish to screen for companies with at most a 7% probability of financial distress. If you click on the Customized tab and then the blue "Create New Filter" button, you should see an Edit Filter Formula pop-up window like the one shown in Figure 4.
Figure 4
If you enter 'Probability of Financial Distress (%)'
How is the PFD different from the Altman Z-score?
Like the Altman Z-score , the PFD measures a company's bankruptcy risk in the upcoming year. However, the main drawback of the Z-score is it does not apply to banks and insurance companies. According to Investopedia, the concept of "working capital" does not apply to banks like Bank of America Corp. ( BAC ) as financial institutions do not have typical current assets or current liabilities like inventories or accounts payable.
See also
Premium members get full access to our value screeners, including the All-in-one Guru Screener. Premium Plus members get access to portfolio data on over 4,000 institutions that file 13Fs, up to 10 years of backtesting in the All-in-One Guru Screener, and the Manual of Stocks for all companies subscribed.
This article first appeared on GuruFocus .
The views and opinions expressed herein are the views and opinions of the author and do not necessarily reflect those of Nasdaq, Inc.
The views and opinions expressed herein are the views and opinions of the author and do not necessarily reflect those of Nasdaq, Inc.
