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

Book Value per Share (5-Year Growth, Annualized)

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

How calculated

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

Example usage

=BookValuePerShareFiveYearAnnualizedGrowth("MSFT")