Whited-Wu Index

Calculates the Whited-Wu (WW) index of financial constraints, the shadow value of external funds that Whited and Wu (2006) estimate from the Euler equation of a firm’s investment on quarterly Compustat data for 1975-2001. Where the Kaplan-Zingales index comes from a classification of a few firms, this index is the cost of external finance implied by how firms invest, and leaves out Tobin’s Q, which measures investment opportunities with much error. Sales growth and the industry’s sales growth take its place: a constrained firm is one with good investment opportunities (a growing industry) it cannot fund (it grows less).

The formula is as follows:

\[\text{CF} = \frac{\text{Income Before Extraordinary Items} + \text{Depreciation and Amortization}}{\text{Total Assets}}\] \[\text{DIVPOS} = 1 \;\text{if the firm paid cash dividends} \;(\text{common or preferred}) \;\text{else}\; 0\] \[\text{TLTD} = \frac{\text{Long-Term Debt}}{\text{Total Assets}}\] \[\text{LNTA} = \ln(\text{Total Assets in millions})\] \[\text{SG} = \frac{\text{Revenue} - \text{Previous Revenue}}{\left|\text{Previous Revenue}\right|}\] \[\text{ISG} = \text{the average SG of the tickers in the firm's industry}\] \[\text{WW} = - 0.091 \cdot \text{CF} - 0.062 \cdot \text{DIVPOS} + 0.021 \cdot \text{TLTD} - 0.044 \cdot \text{LNTA} + 0.102 \cdot \text{ISG} - 0.035 \cdot \text{SG}\]

The coefficients are those of equation 13 (column 4 of Table 1) of Whited and Wu (2006). The variables are those of Hennessy and Whited (2007) and Farre-Mensa and Ljungqvist (2016):

  • Income Before Extraordinary Items: the net income from continuing operations, or the net income where it is not reported.
  • Depreciation and Amortization: that of the cash flow statement.
  • Total Assets and Long-Term Debt: at the end of the period.
  • The sales growth compares with the period before on yearly data and with the same quarter a year earlier on quarterly data, which leaves out the seasons.

The industry sales growth is the average sales growth (equally weighted, the firm itself included) of the tickers in the Toolkit that share the firm’s industry in their company profile (FinancialModelingPrep’s industry, close to the three-digit SIC industries of Whited and Wu). A firm without industry peers in the Toolkit, or without a profile, uses its own sales growth: add companies of its industry to the tickers for an industry figure.

The Whited-Wu index can be interpreted as follows:

  • A higher index means a more constrained firm. As with the Kaplan-Zingales index, the literature calls the top third of firms constrained and the bottom third unconstrained, each year; the index has no absolute cut-off.
  • The size term dominates the level: -0.044 * ln(assets in millions) is about -0.20 for a firm with $100 million of assets and -0.51 for one with $100 billion, so the index of most listed firms lies between about -0.6 and -0.1 on yearly data.

Also known as: WW index, Whited-Wu, financing constraints, shadow cost of external funds.

Whited-Wu Index in Python or via the MCP

Install the Finance Toolkit with:

pip install financetoolkit -U

Then call get_whited_wu_index as shown below.

from financetoolkit import Toolkit

toolkit = Toolkit(
    ["F", "GM", "LEA", "SMP"],
    api_key="FINANCIAL_MODELING_PREP_KEY",
    start_date="2020-01-01",
    end_date="2025-12-31",
)

toolkit.models.get_whited_wu_index().xs("Whited-Wu Index", level=1)

Or, after setting up the Finance Toolkit MCP, ask:

How financially constrained were Ford, General Motors, Lear and Standard Motor Products from 2020 to 2025, according to the Whited-Wu index?

Which returns:

Item 2020 2021 2022 2023 2024 2025
F -0.6137 -0.6083 -0.5897 -0.602 -0.6054 -0.6073
GM -0.6182 -0.6054 -0.6006 -0.6063 -0.609 -0.6122
LEA -0.4838 -0.4732 -0.4797 -0.4865 -0.4812 -0.4755
SMP -0.3814 -0.3745 -0.375 -0.3751 -0.3894 -0.3925

Parameters

get_whited_wu_index accepts the following parameters.

ParameterTypeDescriptionExample
roundingintThe number of decimals to round the results to. Defaults to None.2
growthboolWhether to calculate the growth of the values. Defaults to False.True
lagint | list[int]The lag to use for the growth calculation. Defaults to 1.4
standardizeboolWhether to standardize (Z-Score) the result. When combined with growth=True, standardizes the growth values instead of the raw values. Defaults to False.True
trailingint | NoneThe number of periods the cash flow, the dividends and the revenue are summed over; the balances are those at the end of the period. The window counts calendar periods, so a period without a report makes it NaN. Defaults to None, which is a single period: the quarter on quarterly data, as the index was estimated on quarterly statements.4
show_columnsstr | list[str] | NoneThe columns to keep, a name or a list of names, matched on every column level, or the rows when no column has those names (such as the line items of a financial statement). Names that do not exist are logged, and when none exist the result is returned in full. Defaults to None, which keeps every column.None, which keeps every column
Share