Book Value Per Share (Historical)
Returns historical book value per share (BVPS) for a company. This represents the net asset value per outstanding share of common stock, calculated as shareholders' equity minus preferred equity, divided by shares outstanding.
Formula
Book Value Per Share = (Shareholders Equity - Preferred Equity) / Shares OutstandingSupported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Interpretation
| Comparison | Interpretation |
|---|---|
| Price < BVPS | Stock may be undervalued (trading below book) |
| Price > BVPS | Stock trades above book value (common for growth stocks) |
| Growing BVPS | Company is building shareholder value |
Notes
- BVPS is used in price-to-book ratio calculations
- Value investors often look for stocks trading near or below book value
- Technology companies often have low BVPS relative to market price
Syntax
=hf_Book_Value_per_Share(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (lq, ly, etc.)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Book value per share in company's reporting currency
Examples
=hf_Book_Value_per_Share("AAPL", 2023)=hf_Book_Value_per_Share("BRK.B", 2023, 2)=hf_Book_Value_per_Share("JPM", "ly")=hf_Book_Value_per_Share("MSFT", 2023, , "TTM")=hf_Book_Value_per_Share(A1, B1, C1)When to Use
- Value investing analysis
- Calculating price-to-book ratio
- Tracking net asset value over time
- Comparing companies on book value basis
- Assessing shareholder value growth
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current BVPS | BookValue() |
| Need total equity | hf_Shareholders_Equity() |
| Need P/B ratio directly | PricePerBook() |
| Need shares outstanding | hf_Total_common_shares_outstanding() |
Common Issues & FAQ
Why is BVPS so low for tech companies?
Tech companies often have low tangible assets and high intangible value not reflected on the balance sheet. Their market value exceeds book value.
Why is my calculated P/B different?
Ensure you're using current price with the same period's BVPS, and that shares outstanding are consistent.
Why am I getting "NA"?
Check that the symbol is valid and the company has positive shareholders' equity.
Excel Templates Using Book Value Per Share (Historical)
These ready-made MarketXLS templates call hf_Book_Value_per_Share() 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