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

Total Cash on Hand (5-Year Growth, Annualized)

Hidden
Returns the annualized percent change in cash on hand over the past 5 years.

How calculated

(Total cash on hand most recent balance sheet minus total cash on hand from 5 years ago balance sheet) divided by total cash on hand from 5 years ago, and this number is then divided by 5.

Example usage

=CashAndEquivalentFiveYearAnnualizedGrowth("MSFT")