- Net Income growth analysis: explain in plain English what these numbers of the two companies in requirement 1 and in requirement 2 suggest. What is the main takeaway of your analysis of these results?
1. List 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: Cisco Systems Inc vs F5 Networks Your firm's Net Income (NI) (Smillions) $6,134 $7,767 $6,490 $8,041 $9,983 $7,853 Fiscal year end date Your firm's NI Competitor firm's Competitor's NI Annual Growth Annual Growth Net Income rate (%) rate (%) ($millions) $92 07/25/2009 NA NA 07/28/2010 $151 27% 64% 07/28/2011 $241 60% -16% 07/28/2012 4 $275 24% 14% 07/28/2013 $277 24% 1% 07/28/2014 $311 21% 129 07/28/2015 $8,981 $10,739 $9,609 14% $365 17% 07/30/2016 20% $366 0% 07/30/2017 $421 -11% 15% 10 07/30/2018 $110 $454 -99% 8% 07/27/2019 $11,621 $7,939 $428 -6% 11 10465% Mean 1043% 19% STD 3100.774 3311% 24% Create their time-series plots of net income annual growth rates for the two firms in one figure using Excel and copy and paste it here. 2. Annul Growth Rate (millions) $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 2016 2017 2018 2019 2009 2010 2011 2012 2013 2014 2015 Cisco Systems Inc F5 Networks 1. List 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: Cisco Systems Inc vs F5 Networks Your firm's Net Income (NI) (Smillions) $6,134 $7,767 $6,490 $8,041 $9,983 $7,853 Fiscal year end date Your firm's NI Competitor firm's Competitor's NI Annual Growth Annual Growth Net Income rate (%) rate (%) ($millions) $92 07/25/2009 NA NA 07/28/2010 $151 27% 64% 07/28/2011 $241 60% -16% 07/28/2012 4 $275 24% 14% 07/28/2013 $277 24% 1% 07/28/2014 $311 21% 129 07/28/2015 $8,981 $10,739 $9,609 14% $365 17% 07/30/2016 20% $366 0% 07/30/2017 $421 -11% 15% 10 07/30/2018 $110 $454 -99% 8% 07/27/2019 $11,621 $7,939 $428 -6% 11 10465% Mean 1043% 19% STD 3100.774 3311% 24% Create their time-series plots of net income annual growth rates for the two firms in one figure using Excel and copy and paste it here. 2. Annul Growth Rate (millions) $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 2016 2017 2018 2019 2009 2010 2011 2012 2013 2014 2015 Cisco Systems Inc F5 Networks