Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed

"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 firms 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 firms 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.98

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

Financial Accounting Tools for business decision making

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

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions

Question

1.Which are projected Teaching aids in advance learning system?

Answered: 1 week ago

Question

What are the classifications of Bank?

Answered: 1 week ago