Question

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 $
Please show formulas for the row of 2017. Thank you.

Answer 1

2017
Formula		PROCTER & GAMBLE	JHONSON & JHONSON
Net Profit Margin =	Net Income	$                                                          10,194,000.00	$                                                              16,540,000.00
	Net Sales	$                                                          65,058,000.00	$                                                              71,890,000.00
		16%	23%
Average Inventory =	Opening + Closing Inventory	4,716,000 + 4,624,000	8,053,000 + 8,144,000
	2	2	2
		$                                                            4,670,000.00	$                                                                8,098,500.00
Inventory Turnover =	Cost Of Goods Sold	$                                                          32,535,000.00	$                                                              21,685,000.00
	Average Inventory	$                                                            4,670,000.00	$                                                                8,098,500.00
		6.97	2.68
Current Ratio =	Current Asset	26,494,000.00	65,032,000.00
	Current Liabilies	30,210,000.00	26,287,000.00
		0.88	2.47
Average Assets =	Opening + Closing Total Assets	127,136,000 + 120,406,000	133,411,000+141,208,000
	2	2	2
		123,771,000.00	137,309,500.00
Return On Assets =	Net Income	$                                                          10,194,000.00	$                                                              16,540,000.00
	Average Assets	123,771,000.00	137,309,500.00
		8%	12%
Return On Equity =	Net Income	$                                                          10,194,000.00	$                                                              16,540,000.00
	Stockholders Equity	55,184,000.00	70,418,000.00
		18%	23%
Debt to Equity =	Total Liabities	65,222,000.00	70,790,000.00
	Stockholders Equity	55,184,000.00	70,418,000.00
		1.18	1.01
Earning Per Share =	Net Income	Information of no of shares issued are not provided anywhere, thus can't calculate EPS	Information of no of shares issued are not provided anywhere, thus can't calculate EPS
	Oustanding Shares