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
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
Q: How do I calculate tangible book value? A: Tangible Book = Total Equity - Goodwill & Intangibles. Or: Total Assets - Total Liabilities - Goodwill & Intangibles.
Q: Why might goodwill decrease suddenly? A: Goodwill impairment charges when acquired businesses underperform. This is a non-cash charge that reduces reported earnings.
Q: Is high goodwill bad? A: Not necessarily - it indicates acquisition activity. But high goodwill relative to total assets may signal impairment risk if those acquisitions underperform.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?