H39 X f C F E G A H B Inputs are highlighted Proforma #DIV/0! #DIV/0! #DIV/01 Step 1: Input Parameter Estimates Parameters & Ratios Days Sales Outstanding #DIV/0! Days in Inventory #DIV/0! Days in Accounts Payable #DIVIO! Growth Rate on Sales 0% 1 Herman Miller Proformas 2 (000,000's are omitted all numbers are in millions) 3 4 FYE CS % of 5 5/30/15 Sales 6 Sales #DIV/01 7 Cost of Goods Sold (COGS) #DIV/01 8 Gross Profit #DIV/ON 9 Operating Expense #DIV/0! 10 Research & Dev. & Non Recur #DIV/01 11 Depreciation Expense #DIV/OI 12 EBIT #DIV/01 13 Less (Expenses) Income 14 Interest (Expense) #DIV/01 15 Interest Income #DIV/01 16 Other (Expenses) Income #DIV/0! 17 Net Other Expenses (Income) #DIV/01 18 NIBT #DIV/01 19 Income taxes #DIV/0! 20 Net Income #DIV/01 21 22 Dividends #DIVOI 23 Retained Earnings #DIV/01 24 25 Herman Miller 26 Balance Sheet (000's) FYE CS % of 27 ASSETS 5/30/15 Tot Assets 28 Cash & Mkt Secuies Colug) #DIV/01 29 Accounts Receivable 30 Inventory 31 Prepaids 32 Other Current Assets 33 Total Current Assets #DIV/01 34 35 Property, plant, & Equip #DIV/01 36 Notes Receivables #DIV/01 37 Other Assets #DIV/OI #DIV/0! #DIV/0! #DIVIO Interest & Tax Rate Parameters Marketable See 0.50% Long Term Invest. 7.00% NP Bank 4.00% Long Term Debt 6.90% Tax Rato 42.00% MOIVIO Proforma #DIV/0! #DIVO! #DIVO! #DIVIO #DIV/01 #DIV/0! Step 2: Balance Sheet Check Make sure your proforma balance sheet is balanced. Use the plugs to force ALE. Use the following Balance Sheet Check Total Assets #DIV/0! Total Liabilities & Equity #DIV/0! Should be A-( LE) #DIVIO! If not adjust plug until #DIV/0! Instructions Edgarinstructions Notes Questions Income Statement B H39 + x fc C A G D H B 2 #DIV/0! #DIV/0! E F Long Term Invest NP - Bank Long Tem Debt Tax Rate 7.00% 4.00% 6.90% 42.00% #DIV/01 Proforma 21 22 Dividends 23 Retained Earnings 24 25 Herman Miller 26 Balance Sheet (000's) 27 ASSETS 28 Cash Mk Securies (olug) 29 Accounts Receivable 30 Inventory 31 Prepaids 32 Other Current Assets 33 Total Current Assets 34 35 Property, Plant, & Equip 36 Notes Receivables 37 Other Assets 38 Total Assets FYE CS % of 5/30/15 Tot Assets #DIV/01 #DIV/OI #DIV/01 #DIV/0! #DIV/01 #DIV/01 #DIV/0! #DIV/01 Step 2: Balance Sheet Check Make sure your proforma balance sheet is balanced. Use the plugs to force A=L+E. Use the following Balance Sheet Check Total Assets Total Liabilities & Equity #DIV/0! Should be 0: A - (L+E)= #DIV/OI If not adjust plug until it is #DIV/0! #DIV/0! #DIV/0! #DIV/01 #DIV/0! #DIV/01 #DIV/0! 39 #DIV/01 F #DIV/0! #DIV/01 #DIV/01 #DIVO #DIV/0! DIV/0! #DIV/0! 40 LIABILITIES 41 Notes Payable. Bank (Plus) 42 Accounts Payable 43 Accruals 44 Current Maturities - LTD 45 Other Current Liabilities 46 Total Current Liabilities 47 Other Liabilities 48 Long Term Debt (LTD) 49 Total Liabilities 50 Common Stock 51 Other 52 Retained Eamings 53 Total Liabilities & Equity 54 55 56 57 #DIV/01 #DIV/01 #DIV/01 #DIV/0! #DIV/01 #DIV/0! #DIV/01 #DIV/0! H39 X f C F E G A H B Inputs are highlighted Proforma #DIV/0! #DIV/0! #DIV/01 Step 1: Input Parameter Estimates Parameters & Ratios Days Sales Outstanding #DIV/0! Days in Inventory #DIV/0! Days in Accounts Payable #DIVIO! Growth Rate on Sales 0% 1 Herman Miller Proformas 2 (000,000's are omitted all numbers are in millions) 3 4 FYE CS % of 5 5/30/15 Sales 6 Sales #DIV/01 7 Cost of Goods Sold (COGS) #DIV/01 8 Gross Profit #DIV/ON 9 Operating Expense #DIV/0! 10 Research & Dev. & Non Recur #DIV/01 11 Depreciation Expense #DIV/OI 12 EBIT #DIV/01 13 Less (Expenses) Income 14 Interest (Expense) #DIV/01 15 Interest Income #DIV/01 16 Other (Expenses) Income #DIV/0! 17 Net Other Expenses (Income) #DIV/01 18 NIBT #DIV/01 19 Income taxes #DIV/0! 20 Net Income #DIV/01 21 22 Dividends #DIVOI 23 Retained Earnings #DIV/01 24 25 Herman Miller 26 Balance Sheet (000's) FYE CS % of 27 ASSETS 5/30/15 Tot Assets 28 Cash & Mkt Secuies Colug) #DIV/01 29 Accounts Receivable 30 Inventory 31 Prepaids 32 Other Current Assets 33 Total Current Assets #DIV/01 34 35 Property, plant, & Equip #DIV/01 36 Notes Receivables #DIV/01 37 Other Assets #DIV/OI #DIV/0! #DIV/0! #DIVIO Interest & Tax Rate Parameters Marketable See 0.50% Long Term Invest. 7.00% NP Bank 4.00% Long Term Debt 6.90% Tax Rato 42.00% MOIVIO Proforma #DIV/0! #DIVO! #DIVO! #DIVIO #DIV/01 #DIV/0! Step 2: Balance Sheet Check Make sure your proforma balance sheet is balanced. Use the plugs to force ALE. Use the following Balance Sheet Check Total Assets #DIV/0! Total Liabilities & Equity #DIV/0! Should be A-( LE) #DIVIO! If not adjust plug until #DIV/0! Instructions Edgarinstructions Notes Questions Income Statement B H39 + x fc C A G D H B 2 #DIV/0! #DIV/0! E F Long Term Invest NP - Bank Long Tem Debt Tax Rate 7.00% 4.00% 6.90% 42.00% #DIV/01 Proforma 21 22 Dividends 23 Retained Earnings 24 25 Herman Miller 26 Balance Sheet (000's) 27 ASSETS 28 Cash Mk Securies (olug) 29 Accounts Receivable 30 Inventory 31 Prepaids 32 Other Current Assets 33 Total Current Assets 34 35 Property, Plant, & Equip 36 Notes Receivables 37 Other Assets 38 Total Assets FYE CS % of 5/30/15 Tot Assets #DIV/01 #DIV/OI #DIV/01 #DIV/0! #DIV/01 #DIV/01 #DIV/0! #DIV/01 Step 2: Balance Sheet Check Make sure your proforma balance sheet is balanced. Use the plugs to force A=L+E. Use the following Balance Sheet Check Total Assets Total Liabilities & Equity #DIV/0! Should be 0: A - (L+E)= #DIV/OI If not adjust plug until it is #DIV/0! #DIV/0! #DIV/0! #DIV/01 #DIV/0! #DIV/01 #DIV/0! 39 #DIV/01 F #DIV/0! #DIV/01 #DIV/01 #DIVO #DIV/0! DIV/0! #DIV/0! 40 LIABILITIES 41 Notes Payable. Bank (Plus) 42 Accounts Payable 43 Accruals 44 Current Maturities - LTD 45 Other Current Liabilities 46 Total Current Liabilities 47 Other Liabilities 48 Long Term Debt (LTD) 49 Total Liabilities 50 Common Stock 51 Other 52 Retained Eamings 53 Total Liabilities & Equity 54 55 56 57 #DIV/01 #DIV/01 #DIV/01 #DIV/0! #DIV/01 #DIV/0! #DIV/01 #DIV/0
