Question

1 Approved Answer

Posted on Jul 15, 2024

71.7% 10% Herman Miller Income Statement Inputs are highlighted Common (000,000's omitted) Size RMA FYE % FYE % FYE % FYE % FYE % of

image text in transcribed

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