\"EXCEL\" Compute the operating margin, net profit margin, current ratio, asset
ID: 2570175 • Letter: #
Question
"EXCEL" Compute the operating margin, net profit margin, current ratio, asset turnover ratio, days sales outstanding, days payable, and inventory turnover for fiscal year 2017 , 2016 (SHOW STEPS AND LABLE EACH)
"Excel" Compile common-size Income Statements and Balance Sheets for the firm’s fiscal years 2017, 2016 (show steps)
Identify the number of common shares the firm currently has outstanding. What is the most recent share price and how have the firm’s shares performed over the past year? (show steps)
Years ended September 30, 2017 September 24, 2016 September 26, 2015 Net sales Cost of sales $ 229,234 $ 215,639 S 233,715 141,048 88,186 131,376 84,263 140,089 93,626 Gross margin Operating expenses Research and development Selling, general and administrative 11,581 15,261 26,842 10,045 14,194 24,239 8,067 14,329 22,396 Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income 71,230 1,285 72,515 19,121 53,394 61,344 60,024 2,745 64,089 15,738 48,351 $ 1,348 61,372 15,685 45,687 $ Earnings per share Basic Diluted 9.27 $ 9.21 $ 8.35 $ 8.31 $ 9.28 9.22 Shares used in computing earnings per share Basic Diluted 5,217,242 5,251,692 5,470,820 5,500,281 5,753,421 5,793,069 Cash dividends declared per share 2.40 $ 2.18 $ 1.98Explanation / Answer
2017 2016 Operating Margin Note 1 26.76% 27.84% Net Margin Note 2 21.09% 21.19% Asset turnover Note 3 0.61 0.67 Current Ratio Note 4 1.28 1.35 Days sales outstanding Note 5 28.47 26.66 Days payable Note 6 127.18 103.69 Inventory turnover Note 7 29.05 61.62 Number of common shares outstanding 5126201 5336166 Working notes: 1. Operating margin Operating Profit / Net Sales = 26.76% 27.84% Operating income 61344 60024 Net Sales 229234 215639 2. Net Profit Margin Net profit / Net sales = 21.09% 21.19% Net Income 48351 45687 Net Sales 229234 215639 3. Current Ratio Current assets /Current liabilities = 1.28 1.35 Current assets 128645 106869 Current liabilities 100814 79006 4. Asset turnover ratio = Net Sales / Total Assets = 0.61 0.67 Net Sales 229234 215639 Total assets 375319 321686 5. Days sales outstanding = 365 / Receivables turnover = 28.47 26.66 Days 365/12.82 365/13.69 Receivables turnover = Net sales / Receivables = 12.82 13.69 Net sales 229234 215639 Accounts receivables 17874 15754 6. Days payable = 365 /Payables turnover 127.18 103.69 365/2.87 365/3.52 Payables Turnover cost of goods sold / payables = 2.88 3.52 Cost of goods sold 141048 131376 Accounts payable 49049 37294 7. Inventory turnover = Cost of goods sold / Inventory = 29.05 61.62 Cost of goods sold 141048 131376 Inventory 4855 2132 Common size income statements Year ended Septemer 30, 2017 Septemer 30, 2016 Amount % Amount % Net Sales 229234 100.00% 215639 100.00% Cost of sales 141048 61.53% 131376 60.92% Gorss margin 88186 38.47% 84263 39.08% Operating expenses: Research and development 11581 5.05% 10045 4.66% Selling and administrative 15261 6.66% 14194 6.58% Total operating expenses 26842 11.71% 24239 11.24% Operating income 61344 26.76% 60024 27.84% Other income / (expense), net 2745 1.20% 1348 0.63% Income before provision for income taxes 64089 27.96% 61372 28.46% Provision for income taxes 15738 6.87% 15685 7.27% Net Income 48351 21.09% 45687 21.19% Common size balance sheets Year ended Septemer 30, 2017 Septemer 30, 2016 Amount % Amount % Assets Current assets: Cash and cash equivalents 20289 5.41% 20484 6.37% Marktable securities 53892 14.36% 46671 14.51% Accounts receivable less allowances 17874 4.76% 15754 4.90% Inventories 4855 1.29% 2132 0.66% Vendor non trade receivables 17799 4.74% 13545 4.21% Other current assets 13936 3.71% 8283 2.57% Total current assets 128645 34.28% 106869 33.22% Long term marketable securities 194714 51.88% 170430 52.98% Prpperty , plant and equipment , net 33783 9.00% 27010 8.40% Goodwill 5717 1.52% 5414 1.68% Acquired intangible assets 2298 0.61% 3206 1.00% Other non current assets 10162 2.71% 8757 2.72% Total Assets 375319 100.00% 321686 100.00% Liabilities and shareholders' equity Current liabilities: Accounts payable 49049 13.07% 37294 11.59% Accrued expenses 25744 6.86% 22027 6.85% Deferred revenue 7548 2.01% 8080 2.51% Commercial paper 11977 3.19% 8105 2.52% Current portfolio of long term debt 6496 1.73% 3500 1.09% Total Current liabilities 100814 26.86% 79006 24.56% Deferred revenue , non current 2836 0.76% 2930 0.91% Long term debt 97207 25.90% 75427 23.45% Other non-current liabilities 40415 10.77% 36074 11.21% Total liabilities 241272 64.28% 193437 60.13% Shareholders' equity Common stock 35867 9.56% 31251 9.71% Retained earnings 98330 26.20% 96364 29.96% Acumulated other comprehensive income / (Loss) -150 -0.04% 634 0.20% Total shareholders' equity 134047 35.72% 128249 39.87% Total liabilities and shareholders' equity 375319 100.00% 321686 100.00%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.