Goodwill And Intangible Assets (Historical)
Returns the historical combined value of goodwill and intangible assets. Goodwill represents the premium paid in acquisitions above fair value of assets. Intangibles include patents, trademarks, software, and customer relationships.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., MSFT, GOOGL) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Components
| Component | Description |
|---|---|
| Goodwill | Acquisition premium above fair value |
| Patents/IP | Intellectual property rights |
| Trademarks/Brands | Brand and trademark values |
| Customer Relationships | Acquired customer bases |
| Software/Technology | Capitalized development costs |
Notes
- Increases with acquisitions
- Subject to annual impairment testing
- Amortized (intangibles) or tested (goodwill)
- High values indicate acquisition-heavy strategy
Syntax
=hf_Goodwill_and_Intangible_Assets(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (e.g., 2023, lq, ly)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Total goodwill and intangible assets value
Examples
=hf_Goodwill_and_Intangible_Assets("MSFT", 2023, 4)=hf_Goodwill_and_Intangible_Assets("GOOGL", "ly")=hf_Goodwill_and_Intangible_Assets("IBM", 2023, , "TTM")=hf_Goodwill_and_Intangible_Assets(A1, B1, C1)When to Use
- M&A analysis
- Calculating tangible book value
- Assessing acquisition strategy
- Impairment risk analysis
- Quality of assets assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total assets | hf_Total_Assets() |
| Need all non-current assets | hf_Assets_Non_Current() |
| Need book value | BookValue() |
| Need tangible assets | Calculate: Total Assets - Intangibles |
Common Issues & FAQ
How do I calculate tangible book value?
Tangible Book = Total Equity - Goodwill & Intangibles. Or: Total Assets - Total Liabilities - Goodwill & Intangibles.
Why might goodwill decrease suddenly?
Goodwill impairment charges when acquired businesses underperform. This is a non-cash charge that reduces reported earnings.
Is high goodwill bad?
Not necessarily - it indicates acquisition activity. But high goodwill relative to total assets may signal impairment risk if those acquisitions underperform.
Excel Templates Using Goodwill And Intangible Assets (Historical)
These ready-made MarketXLS templates call hf_Goodwill_and_Intangible_Assets() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today