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)Returns
number
Book value per share
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.
Related Formulas
More MarketXLS Price Quotes 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
▶
How does MarketXLS work?