1. Gather data from Edgar.com to create the common size analysis.
   1. See the EdgarInstructions worksheet in the Excel File.
2. Take a look at the Notes worksheet for detailed instructions and some FAQs.
3. Fill in the Income Statement and Balance Sheet using the data from the May 30, 2015 Column. The Financial Ratios will be automatically calculated for you in the Ratios worksheet when you fill in the data in the above financial statements.
4. Respond to the questions listed on the Questions worksheet.
5. Submit the Excel file to the assignment

Lesson 4 How the Market Works Discussion\" style=\"float: left;\">PreviousNext Module: Lesson 5: Time Value of Money Lump Sums\" style=\"float: right;\">Next

Consolidated Statements of Comprehensive Income - USD ($) $ in Millions	12 Months Ended
May 28, 2016	May 30, 2015	May 31, 2014
Statement of Comprehensive Income [Abstract]
Net sales	$ 2,264.9	$ 2,142.2	$ 1,882
Cost of sales	1,390.7	1,350.8	1,251
Gross margin	874.2	791.4	631
Operating expenses:
Selling, general, and administrative	585.6	543.9	564.3
Restructuring and impairment expenses	0	12.7	26.5
Design and research	77.1	71.4	65.9
Total operating expenses	662.7	628	656.7
Operating earnings (loss)	211.5	163.4	(25.7)
Other expenses (income):
Interest expense	15.4	17.5	17.6
Interest and other investment income	(0.8)	(0.6)	(0.4)
Other, net	0.3	1.3	0.5
Net other expenses	14.9	18.2	17.7
Earnings (loss) before income taxes	196.6	145.2	(43.4)
Income tax expense (benefit)	59.5	47.2	(21.2)
Equity earnings from nonconsolidated affiliates, net of tax	0.4	0.1	0.1
Net earnings (loss)	137.5	98.1	(22.1)
Net earnings attributable to noncontrolling interests	0.8	0.6	0
Net earnings (loss) attributable to Herman Miller, Inc.	$ 136.7	$ 97.5	$ (22.1)
Earnings (loss) per share basic	$ 2.28	$ 1.64	$ (0.37)
Earnings (loss) per share diluted	$ 2.26	$ 1.62	$ (0.37)
Other comprehensive income (loss):
Foreign currency translation adjustments (net of tax of ($0.3), $0.3, and $ - )	$ (8.8)	$ (9.7)	$ 2.9
Pension and post-retirement liability adjustments (net of tax of ($1.4), $2.2 and $(50.9))	0.5	(8.6)	83.5
Total other comprehensive income (loss)	(8.3)	(18.3)	86.4
Comprehensive income	129.2	79.8	64.3
Comprehensive income attributable to noncontrolling interests	0.8	0.6	0
Comprehensive income attributable to Herman Miller, Inc.	$ 128.4	$ 79.2	$ 64.3

Attachments:

Financial-Rep....xlsx

MLHR-2015-stu....xlsm