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

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")