Essay Available:
page:
1 pages/≈275 words
Sources:
1
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 APA Essay Samples:
-
Professional Request for New Computers for the Warehouse Department
2 pages/≈550 words | 2 Sources | Other | Business & Marketing | Other (Not Listed) |
-
Quantity and Price Index and the Personal Consumption Expenditures (PCE)
1 page/≈275 words | 3 Sources | Other | Business & Marketing | Other (Not Listed) |
-
Project Goals and Objectives: Retirement Party – Agreement of Meeting Notes
1 page/≈275 words | 5 Sources | Other | Business & Marketing | Other (Not Listed) |