Build enterprise value from components

Enterprise value is market capitalization plus total debt minus cash and short-term investments. SheetsFinance provides the components, so you can build the formula in one cell.

The formula

=SF("AAPL","realTime","marketCap") + SF("AAPL","balancesheet","totalDebt","ttm") - SF("AAPL","balancesheet","cashAndShortTermInvestments","ttm")

What each part does

• marketCap from the real-time dataset gives the current equity value.

• totalDebt from the balance sheet gives interest-bearing liabilities.

• cashAndShortTermInvestments from the balance sheet gives the liquid assets to subtract.

Pre-built alternative

SheetsFinance also provides a pre-calculated enterprise value ratio:

=SF("AAPL", "ratios", "enterpriseValue", "ttm")

Use the pre-built metric when you only need the value. Use the component formula when you want to adjust the inputs, for example by using a different debt definition or a manual market-cap override.

For an annual enterprise value, replace ttm with a year:

=SF("AAPL", "ratios", "enterpriseValue", "2023")

For a quarterly enterprise value, use ratiosQ1, ratiosQ2, ratiosQ3, or ratiosQ4 as the type and pass a year:

=SF("AAPL", "ratiosQ4", "enterpriseValue", "2023")

What is next

For more on balance sheet data, read Financial Statements. For other custom calculations, see Financial Formulas.