Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need a horizontal analysis of the income statements of the following three companies Johnson&Johnson, Unilever, and P&G. I need this on an Excel document

image text in transcribed

I need a horizontal analysis of the income statements of the following three companies Johnson&Johnson, Unilever, and P&G. I need this on an Excel document and I attached some data to help!

image text in transcribed Johnson & Johnson Income Statement Proctor & Gamble Common-Size Income Statement Revenue Other revenue Total Revenue 2014 % 74,331.00 100.00% 0.00 0.00% 74,331.00 100.00% 2013 % 71,312.00 100.00% 0.00 0.00% 71,312.00 100.00% 2012 % 67,224.00 100.00% 0.00 0.00% 67,224.00 100.00% Cost of Revenue - Total 21,992.00 29.59% 21,659.00 30.37% 21,658.00 Gross Profit 52,339.00 70.41% 49,653.00 69.63% Selling/General Administrative Research and Development Depreciation/Amortization Interest Expense (Income) Unusual Expense (Income) Other Operating Expense Operating Income 21,954.00 8,494.00 0.00 0.00 932.00 (65.00) 20,563.00 29.54% 11.43% 0.00% 0.00% 1.25% -0.09% 27.66% ### 21,830.00 8,187.00 0.00 0.00 1,263.00 2,563.00 15,471.00 Interest Income (EXP) Gain/Loss Sale of Assets Other, Net Income before Tax Income Tax Total Income After Tax 0.00 0.00 0.00 20,563.00 0.00% 0.00% 0.00% 27.66% 0.00 0.00 0.00 15,471.00 Percent Change Income Statement Income Statement Common-Size Income Statement 2014 100.00% 0.00% 100.00% 2013 100.00% 0.00% 100.00% 2012 100.00% 0.00% 100.00% % 4.23% 0.00% 4.23% % 6.08% 0.00% 6.08% 2014 76,279.00 0.00 76,279.00 % 100.00% 0.00% 100.00% 2013 80,510.00 0.00 80,510.00 % 100.00% 0.00% 100.00% 2012 80,116.00 0.00 80,116.00 % 100.00% 0.00% 100.00% 2014 100.00% 0.00% 100.00% 2013 100.00% 0.00% 100.00% 2012 100.00% 0.00% 100.00% 32.22% 65.02% 63.62% 64.04% 1.54% 0.00% 38,248.00 50.14% 40,611.00 50.44% 39,991.00 49.92% 78.69% 76.32% 74.63% 45,566.00 67.78% 34.98% 36.38% 35.96% 5.41% 8.97% 38,031.00 49.86% 39,899.00 49.56% 40,125.00 50.08% 21.31% 23.68% 25.37% 30.61% 11.48% 0.00% 0.00% 1.77% 3.59% 21.69% 20,869.00 7,666.00 0.00 0.00 2,902.00 (113.00) 13,775.00 31.04% 11.40% 0.00% 0.00% 4.32% -0.17% 20.49% 21.04% 1.29% 0.41% 0.00% -0.01% 0.00% 12.25% 23.20% 1.18% 0.43% 0.00% 0.56% 0.00% 11.00% 21.46% 1.20% 0.07% 0.00% -0.15% 0.00% 13.37% 0.57% 3.75% #DIV/0! 0.00% -26.21% 0.00% 32.91% 4.60% 6.80% #DIV/0! 0.00% -56.48% 0.00% 12.31% 23,158.00 0.00 0.00 0.00 1,055.00 2,028.00 11,790.00 30.36% 0.00% 0.00% 0.00% 1.38% 2.66% 15.46% 24,402.00 0.00 0.00 0.00 757.00 0.00 14,740.00 30.31% 0.00% 0.00% 0.00% 0.94% 0.00% 18.31% 26,000.00 0.00 0.00 0.00 308.00 0.00 13,817.00 32.45% 0.00% 0.00% 0.00% 0.38% 0.00% 17.25% 14.92% 0.00% 0.00% 0.00% 0.15% 0.00% 4.71% 11.87% 0.00% 0.00% 0.00% 0.40% 0.00% 9.97% 16.15% 0.00% 0.00% 0.00% 0.40% 0.00% 7.49% 0.00% 0.00% 0.00% 21.69% 0.00 0.00 0.00 13,775.00 0.00% 0.00% 0.00% 20.49% 0.00% 0.00% 0.03% 7.40% 2.33% 5.07% 0.00% 0.00% 0.06% 10.18% 2.93% 7.25% 0.00% 0.00% #DIV/0! 32.91% #VALUE! 18.02% 0.00% 0.00% #DIV/0! 12.31% #VALUE! 31.55% 0.00 0.00 531.00 11,846.00 8,930.00 0.00% 0.00% 0.70% 15.53% 11.71% 0.00 0.00 206.00 14,337.00 11,318.00 0.00% 0.00% 0.26% 17.81% 14.06% 0.00 0.00 941.00 14,179.00 10,953.00 0.00% 0.00% 1.17% 17.70% 13.67% 0.00% 0.00% 0.00% 4.71% 1.48% 3.24% 0.00% 0.00% 0.00% 9.97% 3.43% 6.54% 0.00% 0.00% 0.00% 7.49% 2.43% 5.06% 16,323.00 21.96% 13,831.00 19.40% 10,514.00 15.64% 0.00% 0.00% -0.44% 8.78% 2.25% 6.52% Minority Interest Equity in Affiliates U.S. GAAP Adjustment Net Income Before Extra Items 0.00 0.00 0.00 16,323.00 0.00% 0.00% 0.00% 21.96% 0.00 0.00 0.00 13,831.00 0.00% 0.00% 0.00% 19.40% 339.00 0.00 0.00 10,853.00 0.50% 0.00% 0.00% 16.14% -0.04% 0.00% 0.00% 6.49% -0.05% 0.00% 0.00% 5.02% -0.02% 0.00% 0.00% 7.23% #DIV/0! 0.00% 0.00% 18.02% -100.00% 0.00% 0.00% 27.44% (108.00) 0.00 0.00 8,822.00 -0.14% 0.00% 0.00% 11.57% (142.00) 0.00 0.00 11,176.00 -0.18% 0.00% 0.00% 13.88% (90.00) 0.00 0.00 10,863.00 -0.11% 0.00% 0.00% 13.56% -0.05% 0.34% 0.00% 3.53% -0.01% 0.21% 0.00% 6.74% 0.02% 0.18% 0.00% 5.27% Total Extraodrdinary Items Accounting Change Discontinued Operations Net Income 0.00 0.00 0.00 16,323.00 0.00% 0.00% 0.00% 21.96% 0.00 0.00 0.00 13,831.00 0.00% 0.00% 0.00% 19.40% 0.00 0.00 0.00 10,853.00 0.00% 0.00% 0.00% 16.14% 0.00% 0.00% 0.00% 6.49% 3.34% 0.00% 3.34% 8.36% 0.56% 0.00% 0.56% 7.80% #DIV/0! 0.00% #DIV/0! 18.02% #DIV/0! 0.00% #DIV/0! 27.44% 0.00 0.00 0.00 7,036.00 0.00% 0.00% 0.00% 9.22% 0.00 0.00 0.00 11,643.00 0.00% 0.00% 0.00% 14.46% 0.00 0.00 0.00 11,312.00 0.00% 0.00% 0.00% 14.12% 0.00% 0.00% 0.00% 3.53% -0.09% 0.00% -0.09% 6.65% -0.16% 0.00% -0.16% 5.11% - - - - - - Unilever Percent Change Income Statement Income Statement Nestle Common-Size Income Statement % -5.26% 0.00% -5.26% % 0.49% 0.00% 0.49% 2014 % 48,436.00 100.00% 0.00 0.00% 48,436.00 100.00% 2013 % 49,797.00 100.00% 0.00 0.00% 49,797.00 100.00% 2012 % 51,324.00 100.00% 0.00 0.00% 51,324.00 100.00% -5.82% 1.55% 28,387.00 58.61% 29,065.00 58.37% 30,703.00 -4.68% -0.56% 20,049.00 41.39% 20,732.00 41.63% -5.10% 0.00% 0.00% 0.00% 39.37% 0.00% -20.01% -6.15% 0.00% 0.00% 0.00% 145.78% 0.00% 6.68% 11,114.00 955.00 0.00 0.00 0.00 0.00 7,980.00 22.95% 1.97% 0.00% 0.00% 0.00% 0.00% 16.48% 12,175.00 1,040.00 0.00 0.00 0.00 0.00 7,517.00 0.00% 0.00% 0.00% -17.37% #VALUE! -21.10% 0.00% 0.00% 0.00% 1.11% #VALUE! 3.33% 0.00 0.00 (94.00) 7,646.00 0.00% 0.00% -0.19% 15.79% 0.00 0.00 (133.00) 7,114.00 -23.94% #DIV/0! 0.00% -21.06% #DIV/0! 0.00% #DIV/0! -39.57% Income Statement Percent Change Income Statement Common-Size Income Statement 2014 100.00% 0.00% 100.00% 2013 100.00% 0.00% 100.00% 2012 100.00% 0.00% 100.00% % -2.73% 0.00% -2.73% % -2.98% 0.00% -2.98% 2011 83,642.00 128.00 83,770.00 % 99.85% 0.15% 100.00% 2010 % 109,722.00 100.00% 0.00 0.00% 109,722.00 100.00% 2009 % 107,618.00 100.00% 0.00 0.00% 107,618.00 100.00% 2011 99.85% 0.15% 100.00% 2010 100.00% 0.00% 100.00% 2009 100.00% 0.00% 100.00% 59.82% 93.18% 91.16% 95.50% -2.33% -5.33% (44,127.00) -52.68% (45,849.00) -41.79% (45,208.00) -42.01% -52.68% -41.79% -42.01% 20,621.00 40.18% 6.82% 8.84% 4.50% -3.29% 0.54% 39,643.00 47.32% 57.99% 47.32% 58.21% 57.99% 24.45% 2.09% 0.00% 0.00% 0.00% 0.00% 15.10% 13,571.00 0.00 0.00 0.00 73.00 0.00 6,977.00 26.44% 0.00% 0.00% 0.00% 0.14% 0.00% 13.59% 2.83% 0.00% 0.00% 0.00% 0.02% 0.00% 3.96% 3.27% 0.00% 0.00% 0.00% 0.32% 0.00% 5.26% 3.15% 0.00% 0.00% 0.00% 2.11% 0.00% -0.75% -8.71% 0.00% 0.00% 0.00% #DIV/0! 0.00% 6.16% -10.29% 0.00% 0.00% 0.00% -100.00% 0.00% 7.74% (17,395.00) (1,423.00) 0.00 (7,602.00) 51.00 (736.00) 12,538.00 -20.77% -1.70% 0.00% -9.07% 0.06% -0.88% 14.97% (36,270.00) -33.70% (2,021.00) -1.88% 0.00 0.00% (8,420.00) -7.82% 509.00 0.47% (1,238.00) -1.15% 14,970.00 13.91% -20.77% -1.70% 0.00% -9.07% 0.06% -0.88% 14.97% -33.98% -1.71% 0.00% -7.76% 22.55% -1.93% 35.38% -33.70% -1.88% 0.00% -7.82% 0.47% -1.15% 13.91% 0.00% 0.00% -0.27% 14.29% 0.00 0.00 (145.00) 6,533.00 0.00% 0.00% -0.28% 12.73% 0.00% 0.00% -0.07% 4.23% 1.54% 2.69% 0.00% 0.00% -0.07% -2.03% 0.03% -2.06% 0.00% 0.00% -29.32% 7.48% #VALUE! 4.79% 0.00% 0.00% -8.28% 8.89% #VALUE! 8.83% 112.00 115.00 (536.00) (179.00) (3,112.00) 8,938.00 0.13% 0.14% -0.64% -0.21% -3.71% 10.67% 94.00 0.00 (847.00) (3,693.00) 34,374.00 0.09% 0.00% -0.77% -3.37% 31.33% 0.00 179.00 0.00 (794.00) (3,362.00) 10,993.00 0.00% 0.17% 0.00% -0.74% -3.12% 10.21% 0.13% 0.14% -0.64% -0.21% -3.71% 10.67% 0.09% 0.00% -0.77% -3.37% 31.33% 0.00% 0.17% 0.00% -0.74% -3.12% 10.21% 63,873.00 58.21% (37,288.00) -33.98% (1,881.00) -1.71% 0.00 0.00% (8,510.00) -7.76% 24,741.00 22.55% (2,115.00) -1.93% 38,820.00 35.38% 62,410.00 5,515.00 11.39% 5,263.00 10.57% 4,836.00 9.42% 0.00% 0.00% 0.06% 3.33% 1.06% 2.27% 57.78% #DIV/0! 0.00% 2.88% (344.00) 0.00 0.00 5,171.00 -0.71% 0.00% 0.00% 10.68% (421.00) 0.00 0.00 4,842.00 -0.85% 0.00% 0.00% 9.72% (468.00) 0.00 0.00 4,368.00 -0.91% 0.00% 0.00% 8.51% 0.05% 0.00% 0.00% 2.32% 0.05% 0.00% 0.00% 2.74% 0.01% 0.00% 0.00% -2.04% -18.29% 0.00% 0.00% 6.79% -10.04% 0.00% 0.00% 10.85% 0.00 866.00 0.00 9,804.00 0.00% 1.03% 0.00% 11.70% 0.00 1,010.00 0.00 35,384.00 0.00% 0.92% 0.00% 32.25% 0.00 800.00 0.00 11,793.00 0.00% 0.74% 0.00% 10.96% 0.00% 1.03% 0.00% 11.70% 0.00% 0.92% 0.00% 32.25% 0.00% 0.74% 0.00% 10.96% #DIV/0! 0.00% #DIV/0! 2.93% 0.00 0.00 0.00 5,171.00 0.00% 0.00% 0.00% 10.68% 0.00 0.00 0.00 4,842.00 0.00% 0.00% 0.00% 9.72% 0.00 0.00 0.00 4,368.00 0.00% 0.00% 0.00% 8.51% 0.00% 0.00% 0.00% 2.32% 0.00% 0.00% 0.00% 2.74% 0.00% 0.00% 0.00% -2.05% 0.00% 0.00% 0.00% 6.79% #DIV/0! 0.00% 0.00% 10.85% 0.00 0.00 0.00 9,804.00 0.00% 0.00% 0.00% 11.70% 0.00 0.00 0.00 35,384.00 0.00% 0.00% 0.00% 32.25% 0.00 0.00 0.00 11,793.00 0.00% 0.00% 0.00% 10.96% 0.00% 0.00% 0.00% 11.70% 0.00% 0.00% 0.00% 32.25% 0.00% 0.00% 0.00% 10.96% - - - - - - Percent Change Income Statement 2011 -23.77% 0.00% -23.65% 2010 1.96% 0.00% 1.96% -3.76% 1.42% -37.93% 2.34% -53.35% -24.35% 0.00% -10.67% -99.79% -65.20% -67.70% 2.81% -6.93% 0.00% 1.07% 4760.71% 70.84% 159.32% 0.00% 22.34% 0.00% -78.87% -15.73% -74.00% 0.00% -47.49% 0.00% 6.68% 9.85% 212.69% 0.00% -14.26% 0.00% -72.29% 0.00% 26.25% 0.00% 200.04% 0.00% 0.00% 0.00% -72.29% 0.00% 0.00% 0.00% 200.04%

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

Managerial Accounting

Authors: James Jiambalvo

6th edition

9781119158226, 111915801X, 1119158222, 978-1119158011

More Books

Students also viewed these Accounting questions

Question

=+2 What is the cost of unused capacity?

Answered: 1 week ago

Question

4. Pupils often misbehave in order to make the teacher look bad.

Answered: 1 week ago