Enterprise Value (Historical)

Returns the historical enterprise value (EV) for a company. Enterprise value represents the total value of a company including market cap, debt, and excluding cash.

Formula

EV = Market Cap + Total Debt - Cash and Cash Equivalents

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Quarter 1-4
TTM No "TTM" for trailing twelve months

Examples

=hf_Enterprise_Value("AAPL", 2023, 4)
Q4 2023 enterprise value
=hf_Enterprise_Value("MSFT", "ly")
Last year EV
=hf_Enterprise_Value("GOOGL", 2023, , "TTM")
TTM enterprise value

When to Use

  • Enterprise value analysis over time
  • Historical valuation comparisons
  • EV-based ratio calculations
  • M&A analysis

When NOT to Use

Scenario Use Instead
Current enterprise value EnterpriseValue()
EV/EBITDA ratio hf_Enterprise_Value_over_EBITDA()
Market cap only hf_Market_Capitalization()

Common Issues & FAQ

Q: Why is EV higher than market cap? A: EV includes debt and subtracts cash. High debt increases EV above market cap.

Q: What's included in enterprise value? A: Market cap + total debt - cash and equivalents.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Enterprise Value (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions