Size-Age Index

Calculates the size-age (SA) index of financial constraints of Hadlock and Pierce (2010). They coded the financial constraints of a random sample of firms from the text of their 10-K filings (1995-2004) and found that, of the usual measures, only size and age predict the constraints well: the Kaplan-Zingales ratios do not, once size and age are known. The index is their ordered logit on size and age alone, so it needs no market data and has few of the accounting choices that move the other indices.

The formula is as follows:

\[\text{Size} = \ln(\min(\text{Total Assets in millions of 2004 dollars},\; \text{4,500}))\] \[\text{Age} = \min(\text{Years Listed},\; 37)\] \[\text{SA} = - 0.737 \cdot \text{Size} + 0.043 \cdot \text{Size}^{2} - 0.040 \cdot \text{Age}\]

The variables are as follows:

  • Total Assets in 2004 dollars: the total assets at the end of the fiscal period divided by the US consumer price index (CPI-U, all items, from the Bank for International Settlements) of the month the period ends in, relative to its 2004 average; a month not published yet uses the latest published month.

  • Years Listed: the year of the end of the fiscal period minus the year of the company’s IPO date in its profile (FinancialModelingPrep), the count of years a firm has a stock price in Compustat in Hadlock and Pierce. A period before the IPO is NaN.

  • The caps are those of Hadlock and Pierce: firms above $4.5 billion of assets or 37 years listed take those values, beyond which size and age hardly add to the prediction.

The size-age index can be interpreted as follows:

  • A higher (less negative) index means a more constrained firm: a small, young firm.
  • Its lowest value is -4.64, for a firm at both caps ($4.5 billion of 2004 assets and 37 years listed). A new firm with $1 million of 2004 assets has 0, and a smaller one above 0 (its Size is negative). A firm listed 10 years with $100 million of 2004 assets has -2.88.
  • As with the other indices, the literature calls the top third of firms constrained and the bottom third unconstrained, each year; the index has no absolute cut-off.

Also known as: SA index, Hadlock-Pierce index, HP index, financing constraints.

Size-Age Index in Python or via the MCP

Install the Finance Toolkit with:

pip install financetoolkit -U

Then call get_size_age_index as shown below.

from financetoolkit import Toolkit

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

toolkit.models.get_size_age_index().xs("Size-Age Index", level=1)

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

How financially constrained were Apple, Ford, Standard Motor Products and Airbnb from 2020 to 2025, according to the size-age index?

Which returns:

Item 2020 2021 2022 2023 2024 2025
AAPL -4.6369 -4.6369 -4.6369 -4.6369 -4.6369 -4.6369
ABNB -3.1569 -3.1969 -3.2369 -3.2769 -3.3169 -3.3569
F -4.6369 -4.6369 -4.6369 -4.6369 -4.6369 -4.6369
SMP -4.4611 -4.4875 -4.4849 -4.4844 -4.5306 -4.5398

Parameters

get_size_age_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
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