Book Value
Returns the book value per share for a company. Book value represents the net asset value of a company divided by the number of shares outstanding.
Formula
Book Value Per Share = (Total Assets - Total Liabilities) / Shares Outstanding
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Common Uses
- Price-to-Book Ratio: Compare stock price to book value
- Value Investing: Identify undervalued stocks trading below book value
- Financial Health: Assess a company's net asset position
Notes
- Book value data is updated quarterly based on financial reports
- Returns "NA" if data is unavailable
- Negative book values indicate the company has more liabilities than assets
Syntax
=BookValue(Symbol)Examples
When to Use
- Calculating Price-to-Book (P/B) ratio
- Value investing analysis
- Comparing asset values across companies
- Financial health assessment
- Screening for undervalued stocks
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Historical book value | hf_Book_value() |
| Tangible book value | Different metric function |
| Total book value (not per share) | Multiply by shares outstanding |
| Real-time streaming data | Not applicable for book value |
Common Issues & FAQ
Why am I getting "NA"?
Book value data may not be available for all securities. ETFs and indices may not have book value.
Why is the book value negative?
A negative book value means the company has more liabilities than assets, which can occur with highly leveraged companies.
How do I calculate Price-to-Book ratio?
Use the formula =Last("AAPL")/BookValue("AAPL") to get the P/B ratio.
When is book value data updated?
Book value is updated quarterly following earnings reports and SEC filings.
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?