List the last eleven-year net incomes of your company and the competitor. Calculate their means, annual...

Transcribed Image Text:

List the last eleven-year net incomes of your company and the competitor. Calculate their means, annual growth rate, mean annual growth rates, and standard deviations (STD) in Excel. Copy the results below: Fiscal Your firm's Net Your firm's NI Income (NI) ($millions) Lompetitor's Competitor's NI year Annual Net Income Growth rate ($millions) Annual Growth rate (%) (%) NA $ 5,007 $ 4,002 $ 3,659 $ 3,134 $ 2,679 $ 2,350 $ 2,377 $ 2,058 $2,039 $ 1,709 $ 1,462 $ 2,770 $ 94,680 $ 57,411 $ 55,256 $ 59,531 $ 48,351 $ 45,687 $ 53,394 $ 39,037 $ 37,037 $ 41,733 $ 25,922 $ 55,803 1 2021 NA 2020 3 2019 4 2018 2017 2016 7 2015 8 2014 2013 10 2012 11 2011 Mean STD List the last eleven-year net incomes of your company and the competitor. Calculate their means, annual growth rate, mean annual growth rates, and standard deviations (STD) in Excel. Copy the results below: Fiscal Your firm's Net Your firm's NI Income (NI) ($millions) Lompetitor's Competitor's NI year Annual Net Income Growth rate ($millions) Annual Growth rate (%) (%) NA $ 5,007 $ 4,002 $ 3,659 $ 3,134 $ 2,679 $ 2,350 $ 2,377 $ 2,058 $2,039 $ 1,709 $ 1,462 $ 2,770 $ 94,680 $ 57,411 $ 55,256 $ 59,531 $ 48,351 $ 45,687 $ 53,394 $ 39,037 $ 37,037 $ 41,733 $ 25,922 $ 55,803 1 2021 NA 2020 3 2019 4 2018 2017 2016 7 2015 8 2014 2013 10 2012 11 2011 Mean STD

Answer rating: 100% (QA)

Your firms Net Your firms Competitors Competitors in... View the full answer