Essay Available:
Pages:
1 page/β275 words
Sources:
1 Source
Style:
Other
Subject:
Business & Marketing
Type:
Other (Not Listed)
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 4.32
Topic:
Time-Series Plots of ROA's of the Two Firms
Other (Not Listed) Instructions:
Hey there. Glad to work you. The instruction for this time is just to do Question no.6 in the document attached. Thank you so much. Try to keep the answer short.
Question no. 6
ROA analysis: Explain in plain English what these numbers of the two companies in requirement 4and in requirement 5 suggest, What is the main takeaway of your analysis of these results?
Other (Not Listed) Sample Content Preview:
Time-Series Plots of ROA's of the Two Firms
Question Six 1. 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 Year End Date
Coca-Cola Net Income
Coca-Cola Annual Growth Rate
Pepsi Net Income
Pepsi NI Annual Growth Rate
2011
2011-12-31
$8,634.00
NA
$6,462.00
NA
2012
2012-12-31
$9,086.00
5.24%
$6,214.00
-3.84%
2013
2013-12-31
$8,584.00
-5.52%
$6,740.00
8.46%
2014
2014-12-31
$7,098.00
-17.31%
$6,503.00
-3.52%
2015
2015-12-31
$7,356.00
3.63%
$5,452.00
-16.16%
2016
2016-12-31
$6,550.00
-10.96%
$6,379.00
17.00%
2017
2017-12-31
$1,283.00
-80.41%
$4,908.00
-23.06%
2018
2018-12-31
$6,476.00
404.75%
$12,559.00
155.89%
2019
2019-12-31
$8,985.00
38.74%
$7,353.00
-41.45%
2020
2020-12-31
$7,768.00
-13.54%
$7,175.00
-2.42%
2021
2021-12-31
$9,804.00
26.21%
$7,679.00
7.02%
Mean
NA
$7,420.36
35.08%
$7,038.55
9.79%
STD
NA
2308.17
1.268
1997.06
0.5405
2 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.
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 According to the graph in 2018, for coca cola, there was a spike in their annual growth rate
2 -colacompany.com/news/coca-cola-ceo-discusses-2018-earnings-report
3 /2019/02/15/pepsico-earnings-q4-2018.html
4 ...
Question Six 1. 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 Year End Date
Coca-Cola Net Income
Coca-Cola Annual Growth Rate
Pepsi Net Income
Pepsi NI Annual Growth Rate
2011
2011-12-31
$8,634.00
NA
$6,462.00
NA
2012
2012-12-31
$9,086.00
5.24%
$6,214.00
-3.84%
2013
2013-12-31
$8,584.00
-5.52%
$6,740.00
8.46%
2014
2014-12-31
$7,098.00
-17.31%
$6,503.00
-3.52%
2015
2015-12-31
$7,356.00
3.63%
$5,452.00
-16.16%
2016
2016-12-31
$6,550.00
-10.96%
$6,379.00
17.00%
2017
2017-12-31
$1,283.00
-80.41%
$4,908.00
-23.06%
2018
2018-12-31
$6,476.00
404.75%
$12,559.00
155.89%
2019
2019-12-31
$8,985.00
38.74%
$7,353.00
-41.45%
2020
2020-12-31
$7,768.00
-13.54%
$7,175.00
-2.42%
2021
2021-12-31
$9,804.00
26.21%
$7,679.00
7.02%
Mean
NA
$7,420.36
35.08%
$7,038.55
9.79%
STD
NA
2308.17
1.268
1997.06
0.5405
2 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.
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 According to the graph in 2018, for coca cola, there was a spike in their annual growth rate
2 -colacompany.com/news/coca-cola-ceo-discusses-2018-earnings-report
3 /2019/02/15/pepsico-earnings-q4-2018.html
4 ...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
π Other Visitors are Viewing These Other Other (Not Listed) Samples:
- The French Company Escadrille3 pages/β825 words | Other | Business & Marketing | Other (Not Listed) |
- Senior Student Questionnaire Research Assignemnt Paper7 pages/β1925 words | No Sources | Other | Business & Marketing | Other (Not Listed) |
- Focus Ore Attributes To Spur Innovation And Creativity1 page/β275 words | No Sources | Other | Business & Marketing | Other (Not Listed) |
- Using Systematic Inventive Thinking (SIT) Method than Brainstorming2 pages/β550 words | No Sources | Other | Business & Marketing | Other (Not Listed) |
- Gun Violence Prevention in United States1 page/β550 words | No Sources | Other | Business & Marketing | Other (Not Listed) |
- Entertainment ( Music, Sport, Art ...) Business & Marketing1 page/β275 words | Other | Business & Marketing | Other (Not Listed) |
- Metro PCS Analysis. Competitive Advantage. Sales team2 pages/β550 words | Other | Business & Marketing | Other (Not Listed) |