Book Value Per Share (1-Year Growth)
Returns the 1-year percentage change in book value per share.
Syntax
=BookValuePerShareOneYearGrowth(Symbol)Returns
number
1-year book value per share growth as decimal
Examples
=BookValuePerShareOneYearGrowth("AAPL")=BookValuePerShareOneYearGrowth("BRK.B")When to Use
- Equity growth analysis
- Value creation measurement
- Long-term wealth creation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current book value | BookValue() |
| Price to book ratio | PricePerBook() |
Common Issues & FAQ
What affects book value growth?
Retained earnings, buybacks, and comprehensive income changes.
Related Formulas
More MarketXLS Growth 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?