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 Outstanding

Supported 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

Examples

=hf_Book_Value_per_Share("AAPL", 2023)
Apple BVPS
=hf_Book_Value_per_Share("BRK.B", 2023, 2)
Berkshire Q2 2023
=hf_Book_Value_per_Share("JPM", "ly")
JPMorgan last fiscal year
=hf_Book_Value_per_Share("MSFT", 2023, , "TTM")
Microsoft TTM
=hf_Book_Value_per_Share(A1, B1, C1)
Cell references

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

Q: Why is BVPS so low for tech companies? A: Tech companies often have low tangible assets and high intangible value not reflected on the balance sheet. Their market value exceeds book value.

Q: Why is my calculated P/B different? A: Ensure you're using current price with the same period's BVPS, and that shares outstanding are consistent.

Q: Why am I getting "NA"? A: Check that the symbol is valid and the company has positive shareholders' equity.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Book Value Per Share (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions