Nissim-Penman Decomposition
Perform the Nissim and Penman (2001) decomposition of the return on common equity (ROCE) into the return on the operations and the effect of how they are financed.
Where the DuPont analyses split the return on equity into margins, turnover and an equity multiplier that mixes operating and financing liabilities, Nissim and Penman separate the operating activities from the financing activities. The return on common equity becomes the return on net operating assets (RNOA) plus a leverage effect: the financial leverage (FLEV) times the spread between the RNOA and the net borrowing cost (NBC). Borrowing raises the return on equity only while the operations earn more than the debt costs, and a company with net financial assets (negative FLEV) has a return on equity below its RNOA when its financial assets earn less than its operations.
The formula is as follows:
\[\text{Net Financial Expense} = (\text{Interest Expense} - \text{Interest Income}) \cdot (1 - \text{Effective Tax Rate})\] \[\text{Operating Income} = \text{Net Income} + \text{Net Financial Expense}\] \[\text{Net Financial Obligations} = \text{Total Debt} + \text{Preferred Stock} - \text{Cash and Short Term Investments} - \text{Long Term Investments}\] \[\text{Common Equity} = \text{Total Shareholder Equity} - \text{Preferred Stock}\] \[\text{Net Operating Assets} = \text{Net Financial Obligations} + \text{Common Equity}\] \[\text{Return on Net Operating Assets} \;(\text{RNOA}) = \frac{\text{Operating Income}}{\text{Average Net Operating Assets}}\] \[\text{Net Borrowing Cost} \;(\text{NBC}) = \frac{\text{Net Financial Expense}}{\text{Average Net Financial Obligations}}\] \[\text{Spread} = \text{RNOA} - \text{NBC}\] \[\text{Financial Leverage} \;(\text{FLEV}) = \frac{\text{Average Net Financial Obligations}}{\text{Average Common Equity}}\] \[\text{Leverage Effect} = \text{FLEV} \cdot \text{Spread}\] \[\text{Return on Common Equity} \;(\text{ROCE}) = \text{RNOA} + \text{Leverage Effect}\]The balance sheet is split into operating and financial items as follows:
-
Financial assets: the cash and cash equivalents, the short term investments and the long term investments. Nissim and Penman treat the marketable securities as financial; the long term investments of the statements are mostly those securities (Apple’s long term marketable securities), but also hold equity method stakes (Coca-Cola’s bottlers), which Nissim and Penman count as operating and which are financial here.
-
Financial obligations: the Total Debt, which holds the short and long term debt and the lease obligations (capital leases are debt in Nissim and Penman), and the preferred stock, which Nissim and Penman treat as a financial claim.
-
Common equity: the Total Shareholder Equity minus the preferred stock.
-
Operating: everything else, so the net operating assets are the net financial obligations plus the common equity (the operating assets minus the operating liabilities and the minority interest).
Also known as: Nissim-Penman decomposition, ROCE decomposition, advanced DuPont analysis.
Nissim-Penman Decomposition in Python or via the MCP
Install the Finance Toolkit with:
pip install financetoolkit -U
Then call get_nissim_penman_decomposition as shown below.
from financetoolkit import Toolkit
toolkit = Toolkit(
["KO"],
api_key="FINANCIAL_MODELING_PREP_KEY",
start_date="2021-01-01",
end_date="2025-12-31",
)
toolkit.models.get_nissim_penman_decomposition()
Or, after setting up the Finance Toolkit MCP, ask:
How much of Coca-Cola's return on common equity came from its operations and how much from leverage from 2021 to 2025, according to the Nissim-Penman decomposition?
Which returns:
| Item | 2021 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Return on Net Operating Assets | 0.311 | 0.2795 | 0.3197 | 0.3076 | 0.337 |
| Net Borrowing Cost | 0.0765 | 0.0299 | 0.0508 | 0.0497 | 0.057 |
| Spread | 0.2345 | 0.2496 | 0.2689 | 0.2579 | 0.28 |
| Financial Leverage | 0.644 | 0.5033 | 0.4032 | 0.4304 | 0.4383 |
| Leverage Effect | 0.151 | 0.1256 | 0.1085 | 0.111 | 0.1227 |
| Return on Common Equity | 0.462 | 0.4051 | 0.4282 | 0.4186 | 0.4597 |
Parameters
get_nissim_penman_decomposition accepts the following parameters.
| Parameter | Type | Description | Example |
|---|---|---|---|
rounding | int | None | The number of decimals to round the results to. Defaults to None, which uses the rounding of the Toolkit (4 unless set otherwise). | 2 |
growth | bool | Whether to calculate the growth of the values. Defaults to False. | True |
lag | int | list[int] | The lag to use for the growth calculation. Defaults to 1. | 4 |
standardize | bool | Whether to standardize (Z-Score) the result. When combined with growth=True, standardizes the growth values instead of the raw values. Defaults to False. | True |
trailing | int | None | The number of periods to sum the income statement items over, with the balance sheet items averaged over the trailing + 1 period ends that open and close those periods, as in the Ratios module. E.g. 4 with quarterly data gives the trailing twelve months (TTM). The window counts calendar periods, so a period without a report makes it NaN. Defaults to None, which uses single-period flows over the average of the opening and closing balance. | 4 |
show_columns | str | list[str] | None | The 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 |