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 (3-Year Growth, Annualized)

Hidden
Returns the annualized percent change in book value per share over the past 3 years.

How calculated

(sum of Book Value per Share from past 1 year minus sum of Book Value per Share for year ended 3 years ago) divided by sum of Book Value per Share for year ended 3 years ago, and divide this by 3.

Example usage

=BookValuePerShareThreeYearAnnualizedGrowth("MSFT")
Book Value per Share (3-Year Growth, Annualized)
StockBook Value per Share (3-Year Growth, Annualized)
Almadex Minerals Ltd - Ordinary Shares logo

Almadex Minerals Ltd - Ordinary Shares

Sector: Basic Materials   

Industry: Industrial Metals & Minerals

0.25
 
USD
  
0.01
  
(6.34%)
Optionable: No  Market Cap: 14 M  90-day average vol: 20,988

Previous close: 0.235  Open: 0.23155  Bid:   Ask:
52 week range    
0.15   
   0.27
Peers   
Last updated: Thursday 14th April 2022

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