Invested Capital (Historical)

Returns the historical invested capital for a company. Invested capital represents the total capital employed in the business.

Formula

Invested Capital = Total Debt + Total Equity - Cash and Equivalents OR Invested Capital = Fixed Assets + Net Working Capital

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_Invested_Capital("AAPL", 2023, 4)
Q4 2023 invested capital
=hf_Invested_Capital("MSFT", "ly")
Last year invested capital
=hf_Invested_Capital("GOOGL", 2023, , "TTM")
TTM invested capital

When to Use

  • ROIC calculations
  • Capital efficiency analysis
  • Comparing capital bases
  • Value creation assessment

When NOT to Use

Scenario Use Instead
Average invested capital hf_Invested_Capital_Average()
Return on invested capital hf_Retun_on_Invested_Capital()
Working capital hf_Working_Capital()

Common Issues & FAQ

Q: What's included in invested capital? A: Typically debt + equity - cash, representing capital actively used in operations.

Q: Why use invested capital vs total assets? A: Invested capital excludes non-operating assets and focuses on productive capital.

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 Invested Capital (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions