Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. 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?image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Auditing

Authors: James A. Hall

4th edition

1133949886, 978-1305445154, 1305445155, 978-1133949886

More Books

Students also viewed these Accounting questions