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

Net Profit Margin (5-Year Growth, Annualized)

Hidden
Returns the annualized percent change in Net Profit Margin over the past 5 years.

How calculated

(Net Profit Margin for past 1 year minus Net Profit Margin from 5 years ago) divided by Net Profit Margin from 5 years ago

Example usage

=NetProfitMarginFiveYearAnnualizedGrowth("MSFT")