Cash & Market Securities . Notes Payable Bank 15. Suppose ML double the amount of time to pytle credits. Use the proforma shetto indicate the impact on the financial statement. (Start with the dentical parameters tuicated on Ratio page for precios year for Inx, AR, and AP and the double Days Payable) What we the new page to make the balance sheet blanc State answer omitting the consistent with proforma (Note on plug is always so for cells and 41 on the Proforma Spreadsheet 16. Suppore MHR Day Payable in the same leve prior your Use the peoforma shot to indicate the impact on the financial statement Days Sales Outstanding and Days in every both double coming the operating cycle te dobile in length What the new plug figure to make the balance sheet hoe State iwwer dette set with proforma (Note one plus ways rem for cells and in the Proforma Sprehod 4. Cash & Marketable Securities b. Notes Payable Bank 17 Use the same parameters in what is the proforma Netcome. (mitting 000,000 Proforma Net Income 18. Suppose all parler estimates who lost your sensep Sales is expected to What would be the impact on Net Income and the Pl? (Nele mit 0.00 done of the plugs is always were Cash & Marketable Securities Notes Payable Bank Proforma Net Income 19. Auming MLHR is expect255.c in Sales and they have the plant capacity that should they do now to prepare for this Inputs are highlighted Proforma 2,465.1 05159 9492 (556.6) (74.8) 372) 230.6 Step 1: Input Parameter Estimates Parameters & Rates Days Sales Outstanding Days in Inventory Days in Accounts Payable 32.7 514 43.0 (19.0) 0% Growth rate on Sales 2254 (479) 7,6 01.4) 219.2 (92.1) 5.4 1326 Interest Tax Rate Parameters Marketable Sec Long Term invest NP Bank Long Term Debt Tax Rate OSOS 7.00% 400% 6.90% 42.00% 183.9 132.6 Herman Miller Proformas 1000,000's are omitted all numbers are in millions) FYE CS % of 5/29/21 Sales 6 Sales 2.465.1 100% Cost of Goods SoldCOGS) (0515.9 61% B Gross Profit 9492 39% 9 Operating Expense (558.6) -23% 10 Research & Dev. & Non Recur (74.8) 3% 11 Depreciation Expense 1872) 12 EBIT 230.6 9% 13 Less (Expenses) Income 14 Interest (Expense) (13.9) -1% 15 Interest Income 2.1 OX 16 Other (Expenses) Income OS 17 Net Other Expenses (Income) 14.20 18 NIBT 9% 19 Income taxes 2% 20 Equity Eaming & Noncontrol 5.4 21 Net Income 183.9 7% 22 23 Dividends 0% 24 Retained Earnings 7% 25 25 Herman Miller 27 Balance Sheet (000's) FYE CS % of 28 ASSETS 5:20121 Tot Assets 29 Cash & Mt Securtis lug) 404.1 20% 30 Accounts Receivable 221.1 11% 31 Inventory 2136 10% 32 Prepaids 45.1 2% 33 Other Cument Assets 20 0% 34 Total Current Assets 8915 43% 35 38 Property. Plant, & Equip 3272 16% 37 Notes Receivables 781.7 38% 38 Other Assets 3% 39 Total Assets 20519 100% 40 41 LIABILITIES 42 Nos Payable Bank On 43 Accounts Payable 1784 9% 44 Accruais 3224 16% 45 Cument Matures - LTD 0% 46 Other Cumunt Listes ON 47 Total Current Labies 48 her abilities 359.6 40 Long Term Debt (TO) 2749 13% 50 Total Liabilities 1,1353 55% 51 Reedemable Nocontrolling 770 52 Common Stock 110 53 Additional Paid in Cap & Other 45 54 Petained Eamings 14 36% 55 Total Liabilites & Equity 20610 100 56 57 58 Proforma 221.1 213.6 45.1 76 487.4 Step 2: Balance Sheet Check Make sure your profoma balance sheet is balanced. Use the plugs to force ALE Use the following Balance Sheet Check Total Assets 1.6573 Total Liabilities & Equity 20105 Should be 0: A-L) 3523) If not adjust plug units 3272 781.7 1.6578 178.4 3224 500.5 5000 3596 274 1.1353 77.0 11. 945 20106 Cash & Market Securities . Notes Payable Bank 15. Suppose ML double the amount of time to pytle credits. Use the proforma shetto indicate the impact on the financial statement. (Start with the dentical parameters tuicated on Ratio page for precios year for Inx, AR, and AP and the double Days Payable) What we the new page to make the balance sheet blanc State answer omitting the consistent with proforma (Note on plug is always so for cells and 41 on the Proforma Spreadsheet 16. Suppore MHR Day Payable in the same leve prior your Use the peoforma shot to indicate the impact on the financial statement Days Sales Outstanding and Days in every both double coming the operating cycle te dobile in length What the new plug figure to make the balance sheet hoe State iwwer dette set with proforma (Note one plus ways rem for cells and in the Proforma Sprehod 4. Cash & Marketable Securities b. Notes Payable Bank 17 Use the same parameters in what is the proforma Netcome. (mitting 000,000 Proforma Net Income 18. Suppose all parler estimates who lost your sensep Sales is expected to What would be the impact on Net Income and the Pl? (Nele mit 0.00 done of the plugs is always were Cash & Marketable Securities Notes Payable Bank Proforma Net Income 19. Auming MLHR is expect255.c in Sales and they have the plant capacity that should they do now to prepare for this Inputs are highlighted Proforma 2,465.1 05159 9492 (556.6) (74.8) 372) 230.6 Step 1: Input Parameter Estimates Parameters & Rates Days Sales Outstanding Days in Inventory Days in Accounts Payable 32.7 514 43.0 (19.0) 0% Growth rate on Sales 2254 (479) 7,6 01.4) 219.2 (92.1) 5.4 1326 Interest Tax Rate Parameters Marketable Sec Long Term invest NP Bank Long Term Debt Tax Rate OSOS 7.00% 400% 6.90% 42.00% 183.9 132.6 Herman Miller Proformas 1000,000's are omitted all numbers are in millions) FYE CS % of 5/29/21 Sales 6 Sales 2.465.1 100% Cost of Goods SoldCOGS) (0515.9 61% B Gross Profit 9492 39% 9 Operating Expense (558.6) -23% 10 Research & Dev. & Non Recur (74.8) 3% 11 Depreciation Expense 1872) 12 EBIT 230.6 9% 13 Less (Expenses) Income 14 Interest (Expense) (13.9) -1% 15 Interest Income 2.1 OX 16 Other (Expenses) Income OS 17 Net Other Expenses (Income) 14.20 18 NIBT 9% 19 Income taxes 2% 20 Equity Eaming & Noncontrol 5.4 21 Net Income 183.9 7% 22 23 Dividends 0% 24 Retained Earnings 7% 25 25 Herman Miller 27 Balance Sheet (000's) FYE CS % of 28 ASSETS 5:20121 Tot Assets 29 Cash & Mt Securtis lug) 404.1 20% 30 Accounts Receivable 221.1 11% 31 Inventory 2136 10% 32 Prepaids 45.1 2% 33 Other Cument Assets 20 0% 34 Total Current Assets 8915 43% 35 38 Property. Plant, & Equip 3272 16% 37 Notes Receivables 781.7 38% 38 Other Assets 3% 39 Total Assets 20519 100% 40 41 LIABILITIES 42 Nos Payable Bank On 43 Accounts Payable 1784 9% 44 Accruais 3224 16% 45 Cument Matures - LTD 0% 46 Other Cumunt Listes ON 47 Total Current Labies 48 her abilities 359.6 40 Long Term Debt (TO) 2749 13% 50 Total Liabilities 1,1353 55% 51 Reedemable Nocontrolling 770 52 Common Stock 110 53 Additional Paid in Cap & Other 45 54 Petained Eamings 14 36% 55 Total Liabilites & Equity 20610 100 56 57 58 Proforma 221.1 213.6 45.1 76 487.4 Step 2: Balance Sheet Check Make sure your profoma balance sheet is balanced. Use the plugs to force ALE Use the following Balance Sheet Check Total Assets 1.6573 Total Liabilities & Equity 20105 Should be 0: A-L) 3523) If not adjust plug units 3272 781.7 1.6578 178.4 3224 500.5 5000 3596 274 1.1353 77.0 11. 945 20106