Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Data

Book Value Per Share (1-Year Growth)

Live
Returns the percent change in book value per share over the past 12 months.

How calculated

(Book Value per Share most recent quarter minus Book Value per Share 4 quarters ago) divided by Book Value per Share 4 quarters ago.

Example usage

=BookValuePerShareOneYearGrowth("MSFT")
Book Value Per Share (1-Year Growth)
StockBook Value Per Share (1-Year Growth)
AAON Inc. logo

AAON Inc.

Sector: Basic Materials   

Industry: Building Materials

62.04
 
USD
  
0.13
  
(0.21%)
Optionable: Yes  Market Cap: 5,030 M  90-day average vol: 386,679

Previous close: 61.91  Open: 62.72  Bid: 60.18  Ask: 63.78
52 week range    
46.87   
   71.39
Peers   
LII / 
AOS / 
IR / 
MCCK / 
LXU / 
JCI / 
Last updated: Thursday 30th November 2023
53
MarketXLS Rank
40
Value
69
Technical
52
Quality

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

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.
Get started today