A 1 Herman Miller B C D E Proformas F G H Inputs are highlighted 2 (000,000's are omitted all numbers are in millions) 3 4 5 FYE 5/30/15 CS % of Sales Proforma 6 Sales #DIV/0! 7 Cost of Goods Sold(COGS) #DIV/0! #DIV/0! 8 Gross Profit #DIV/0! #DIV/0! 9 Operating Expense #DIV/0! 10 Research & Dev. & Non Recur #DIV/0! Step 1: Input Parameter Estimates 11 14 Depreciation Expense 12 EBIT 13 Less (Expenses) Income Interest (Expense) 15 Interest Income #DIV/O! Parameters & Ratios #DIV/0! #DIV/0! Days Sales Outstanding #DIV/O! Days in Inventory #DIV/O! #DIV/O! Days in Accounts Payable #DIV/0! #DIV/0! 16 Other (Expenses) Income #DIV/0! 17 Net Other Expenses (Income) #DIV/0! Growth Rate on Sales 0% 18 NIBT #DIV/0! #DIV/0! 19 Income taxes #DIV/0! #DIV/0! Interest & Tax Rate Parameters 20 Net Income 21 22 Dividends 23 Retained Earnings 24 25 Herman Miller 26 Balance Sheet (000's) 27 ASSETS 28 Cash & Mkt Securties (plug) 29 Accounts Receivable 30 Inventory 31 Prepaids 32 Other Current Assets #DIV/0! #DIV/0! Marketable Sec. 0.50% Long Term Invest. 7.00% #DIV/0! NP - Bank 4.00% #DIV/0! #DIV/0! Long Term Debt 6.90% Tax Rate 42.00% FYE CS % of 5/30/15 Tot Assets Proforma #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! JDIVISI 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 #DIV/0! 24 25 Herman Miller 6 Balance Sheet (000's) 27 ASSETS 28 Cash & Mkt Securties (plug) 29 Accounts Receivable 0 Inventory 1 Prepaids 2 Other Current Assets 33 Total Current Assets 4 Tax Rate 42.00% FYE CS % of 5/30/15 Tot Assets Proforma #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 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 #DIV/0! #DIV/0! #DIV/0! Total Liabilities & Equity #DIV/0! Should be 0: A-(L+E)= #DIV/0! If not adjust plug until it is. 15 Property, Plant, & Equip #DIV/0! $6 Notes Receivables 7 Other Assets 38 Total Assets 19 -0 LIABILITIES 1 Notes Payable - Bank (Plug) 2 Accounts Payable 3 Accruals #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 44 Current Maturities - LTD #DIV/0! 45 Other Current Liabilities #DIV/0! 6 Total Current Liabilities #DIV/O! #DIV/0! 7 Other Liabilities 8 Long Term Debt (LTD) #DIV/0! 49 Total Liabilities #DIV/0! #DIV/0! 50 Common Stock #DIV/0! 1 Other 52 Retained Eamings #DIV/0! #DIV/O! 53 Total Liabilities & Equity #DIV/0! #DIV/0! 4