Intangibles As Percentage Book Value (Historical)
Measures how much of book value consists of intangible assets like goodwill and patents.
Syntax
=hf_Intangibles_as_percentage_book_value(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Intangibles as percentage of book value
Examples
=hf_Intangibles_as_percentage_book_value("MSFT", 2023, 4)When to Use
- Assessing asset quality
- M&A analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need tangible book value | hf_Price_to_tangible_book_ratio() |
Common Issues & FAQ
High intangibles - good or bad?
Depends on context. High intangibles from acquisitions may indicate overpayment.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Interest As A Percentage Of Invested Capital (Historical)
- Interest Coverage From Continuing Operations (Historical)
- Interest Expense (Historical)
- Interest Income (Historical)
- Inventories Adjustments And Allowances (Historical)
- Inventory (Historical)
- Inventory As Percentage Revenue (Historical)
- Inventory Turnover (Historical)
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?