Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show formulas for the row of 2017. Thank you. 2017 % $ 65,058,000100.00% S 32,535,000 50.01% $ 32,523,000 49.99% S S $ Procter &

image text in transcribedimage text in transcribedimage text in transcribedPlease show formulas for the row of 2017. Thank you.

2017 % $ 65,058,000100.00% S 32,535,000 50.01% $ 32,523,000 49.99% S S $ Procter & Gamble 2016 % 65,299,000 100.00% 32,909,000 50.40% 32,390,000 49.60% 2015 $ 70,749,000 S 37,056,000 $ 33,693,000 % 100.00% 52.38% 47.62% 2017 S 71,890,000 S 21,685,000 $ 50,205,000 % 100.00% 30.16% 69.84% $ S $ Johnson & Johnson 2016 % 70,074,000 100.00% 21,536,000 30.73% 48,538,000 69.27% 2015 $ 74,331,000 S 22,746,000 $ 51,585,000 % 100.00% 30.60% 69.40% $ 18,568,000 28.54% $ 18,949,000 29.02% $ 22,644,000 32.01% $ $ $ 9,095,000 19,945,000 520,000 12.65% 27.74% 0.72% S S S 9,046,000 21,203,000 733,000 12.91% 30.26% 1.05% S S S 8,494,000 21,954,000 178,000 Income Statements Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development SG&A Non Recurring Other Operating Income or Loss Other Income/Expenses (Net) EBIT Interest Expense Income Before Taxes Income Tax Expense Net Income S S $ 13,955,000 (233,000) 13,722,000 4 65,000 13,257,000 3,063,000 10,194,000 S 21.45% -0.36% 21.09% 0.71% 20.38% 4.71% 15.67% S S $ S $ $ $ 13,441,000 507,000 13,948,000 579,000 13,369,000 3,342,000 10,027,000 20.58% 0.78% 21.36% 0.89% 20.47% 5.12% 15.36% $ S S S $ $ S 11,049,000 589,000 11,638,000 626,000 11,012,000 2,725,000 8,287,000 15.62% 0.83% 16.45% 0.88% 15.56% 3.85% 11.71% 20,645,000 S (116,000) $ 20,529,000 S 726,000 $ 19,803,000 S 3,263,000 $ 16,540,000 28.72% -0.16% 28.56% 1.01% 27.55% 4.54% 23.01% S S $ S $ $ S 17,556,000 2,192,000 19,748,000 552,000 19,196,000 3,787,000 15,409,000 25.05% 3.13% 28.18% 0.79% 27.39% 5.40% 21.99% 11.43% 29.54% 0.24% 0.00% 28.20% 0.18% 28.38% 0.72% 27.66% 5.70% 21.96% $ 20,959,000 S 137,000 $ 21,096,000 S 533,000 $ 20,563,000 $ 4,240,000 $ 16,323,000 $ S $ 2011 2016 % 2015 2017 2016 2015 % 6 528% 11.14% 5.569.000 9,568,000 4.994.000 4,624,000 2,139,000 26,494,000 4.63% 7.95% 382% 3.84% 1.78% 22.00% 7,102.000 6,246,000 000 4,716,000 5 S S S $ s $ 4.57% 5.99% S 4.91% 4.62% 3.71% 7.74% 26.57% 18.972.000 22,935,000 11,099.000 8,144.000 $ S $ $ $ ,816,000 4,767,000 5.924,000 4.979,000 7.140.000 29,646,000 12.44% 16.24% 8.28% 5.77% 2.32% 46.05% $ S S 12,712.000 24,644,000 10,734,000 8,053,000 3,047.000 80,210,000 S $ S S 10.29% 18.47% 8.05% 6.04% 2.28% 45.13% 14.523,000 18.556,000 10.986.000 8,184,000 3,486,000 55,744,000 5.51% 22.89% 2.67% 42.76% $ 33,782,000 S 65.002.000 S S Balance Sheet Current Assets Cash and Equivalents Short Term Investments Net Receivables Inventories Other Current Assets Total Current Assets Long Term Investments Property, Plant, and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Assets Total Assets $ S S $ 19.893,000 44,699,000 24,187,000 16.52% 37.12% 20.09% 19,385.000 44,350,000 24.527,000 15.25% 34.88% 19.29% S S S S S 24.899.000 44,622,000 25,010,000 19.20% 34.46% 19.31% 15,912.000 22.805.000 26,876,000 11.27% 16.15% 19.00% $ S 15,905.000 21,629.000 25,764,000 11.92% 16.21% 19:31% $ S 16,126,000 21.832.000 27,222,000 12.37% 16.75% 20.88% $ 5,133,000 4.26% S 5.092,000 4.01% S S 358,000 4.14% 3.14% S S 4,435,000 6,148.00 141,208,000 4 ,413,000 5.490,000 138,411.000 331% 4.12% 100.00% 3,232,000 6,202.000 130,358,000 2.48% 4.76% 100.00% $ 120,406.000 100.00% $ 127,136,000 100.00% S 129,495.000 100.00% 100.00% $ $ 12.53% $ S 16,656,000 13.554.000 13 83% 11.26% $ S $ $ 21,600,000 4,684,000 1530% 3.32% $ S 20,743,000 7,004,000 15.55% 5.25% $ S 21,393,000 3,638,000 16.41% 2.79% $ S $ 25.09% 14.98% 6.86% 6.75% S $ $ S 30,210,000 18,008,000 8,254,000 8,126,000 994.000 65,222,000 16,774.000 11.653.000 2,343,000 30,770,000 18,945,000 10.325.000 ,113,000 13.19% 9.17% 1.84% 24.20% S 14.90% 8.12% 7.17% 16,229,000 12,018,000 1.540.000 2 9,790,000 18,327,000 9,149,000 9,179.000 $ S S 23.00% 14.15% 7.07% 7.09% 26.287.000 22,442,000 19,151,000 2,910,000 18.62% 15.89% 13.56% 2.06% $ $ $ $ 27,747,000 12.857.000 19,095.000 2.562,000 20.80% 9.64% 14.31% 1.92% S S $ S 25,031,000 15,122.000 18,006,000 ,447.000 19.20% 11.6% 1381% 1.88% S $ 9 2 031.000 $ $4.17% $ 69,795,000 $4.90% $ 67,076,000 51.80% 70,790,000 $0.13% 62.261.000 46,67% 6.000 46.49% Current Liabilities Accounts Payable Short Current Debt Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Long-Term Liabilities Minority Interests Total Liabilities Stockholder's Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surphes Other Stockholders' Equity Total Stockholders' Equity Total Lin & Stockholders' Equity $ $ S 3,120,000 110,551,000 (28_152,000) 2.21% S 78.29% -20.08% $ S 3 ,120,000 103,879.000 (22.084,000) 244% 77.86% -17.00% $ S .120.000 97,245,000 (19.891,000) 2.19% 74.80% -15.26% $ $ S $ S S $ 4.009.000 96,124.000 (93,715,000) 63.641,000 (15.881,000) 55.184.000 120,406,000 3.33% 79.83% 77.83% 52.86% -13.19% 45.83% 100.00% S $ S $ S $ $ 4.009.000 87,953,000 (82,176,000) 63,714,000 (17,197,000) 57,341,000 127,136,000 3.15% 69.18% -64.64% 50.11% - 13.53% 45.10% 100.00% $ S S S S 3 $ 4.009.000 84,807,000 (77,226,000) 63.852.000 (14,100,000) 62,419.000 129,495.000 3.10% 65.49% -99.64% 49.31% 10.19% 48.20% 100.00% (14,201.000 70,418.000 141.200.000 -10.5% 49.87% 100.00% $ (13.165.000 71,190,000 111.411.000 9 87% $3.33% 100.00% S S S (10.722.000 69,752,000 1.158.000 82% SB.51% 100.00% S Solution Procter & Gamble 2016 Johnson & Johnson 2016 2017 2015 2017 Net Profit Margin Inventory Turnover Current Ratio Return on Assets Return on Equity Debt to Equity Earnings Per Share

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial and managerial accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

1st edition

111800423X, 9781118233443, 1118016114, 9781118004234, 1118233441, 978-1118016114

Students also viewed these Accounting questions

Question

Describe contributions of Melanie Klein.

Answered: 1 week ago