A 1 Herman Miller 2 Income Statement 3 (000,000's omitted) 4 B 0 Inputs are highlighted D E F G H J K L M Common Size RMA FYE % FYE % FYE % 5 5/28/11 Chng _ 6/2/12 Chng 6/1/13 Chng FYE 5/31/14 % Chng FYE % of Ind 5/30/15 Sales Comp 6 Sales 7 COGS 1649.2 1111.1 5% 1724.1 3% 1774.9 6% 1882.0 -100% #DIV/0! 100.0% 2% 1133.5 3% 1169.7 7% 1251.0 -100% #DIV/0! 71.7% Gross Margin 538.1 10% 590.6 2% 605.2 4% 631.0 -100% 0.0 #DIV/0! 28.3% 9 Selling, Gen & Adm Exp. 329.8 9% 360.5 10% 394.8 33% 526.5 -100% #DIV/0! 0 Research & Design 45.8 15% 52.7 14% 59.9 10% 65.9 -100% #DIV/0! 1 Restr & Impair Exp 3.0 80% 5.4 -78% 1.2 2108% 26.5 -100% 2 Depreciation Exp.* 36.2 -5% 34.4 0% 34.4 10% 37.8 -100% #DIV/0! 3 Total Operating Exp. 414.8 9% 453.0 8% 490.3 34% 656.7 -100% 0.0 #DIV/0! 23.8% 4 EBIT 123.3 12% 137.6 -16% 114.9 -122% (25.7) -100% 0.0 #DIV/0! 4.5% 5 Less Expenses (Income) 6 Interest Expense 19.9 -12% 17.5 -2% 17.2 2% 17.6 -100% #DIV/0! 7 Interest (Income) (1.5) -33% (1.0) -60% (0.4) n/a (0.4) n/a #DIV/0! 8 Other Expenses (Income) 2.4 1.6 0.9 0.5 9 Net Other Expenses (Income 20.8 -13% 18.1 -2% 17.7 0% 17.7 -100% 0.0 #DIV/0! 0 EBT 102.5 17% 119.5 -19% 97.2 -145% 1 2 Taxes & Cum Eff of Act Chg Net Income 31.7 40% 44.3 -35% 29.0 -173% (43.4) -100% (21.3) -100% 0.0 #DIV/0! #DIV/0! 70.8 6% 75.2 -9% 68.2 -132% (22.1) -100% 0.0 #DIV/0! 3 4 5 6 *Depretiation Expenses are included in the total Selling, General and Administration Expense. In order to calculate Cash Flow 7 you will need to look for the amount of Depreciation Epense by clicking on the Notes to Financial Statements section on Edgar.com. 8 Under the notes section you will click on Supplemental Disclosure of Cash Flow Information to obtian the Depreciation Expense. 9 You will then need to reduce the amount of total Selling, General & Administration Expenses in Cell J9 above to reflect the amount of 0 Depretiation Expense broken out. (See the formula in Cell H9 for example.)