Herman Miller ML HR) Common Size Analysis Project General Guidelines: Each individual should gatber data fiom Edgar.com to create the coon size analysis, You can diseuss your answers with the group prior to tuning in the assignment Hand in a printout of the ratio page (see tab below) and a printout of this instruction sheet with your completed answers. (You are not required to type your answers but you may type and highlight your answers.) A. Obtain the most recent annual financial report (10-K) for Miller Herman using EDGAR.gov at Under Company Tieker enter MLHR for Hen Miller B. Use MLHR's 10-K annual report from Edgar.com to ud Financial Infomation for Coinmon Size analysh Fill in your answers in the yellew Bexes below. The light red arrows indicate the answers you need to provide. For drop-down boxes, choose the apprepriate answer Locate the most recent 10-K report and click the Interactive Data link oa the web page then click Financial Statements 1. Cliek on the Income Statement tab below and fill in the infomation from Comsolidated Statements of Qperations in Edgar gov to fill in the highlighted area of the spreadsheet. Note use the previous year's information to guide you Notice the footote on the bottom of the Income Statement reganding Depreciation Expense 2. Click on the Balnce Sheet tab below and fill in the infomation from Comolidated Balauce Sheet from Edgar gov C. Answer the following questions regarding Herman Miller. 1. DuPont Analysis is a great place to start the analysis, because it shows how thee major areas interact to detemine ROE PM Hint: Cliek the Ratios tab below to fill in the appropriate ratios to compare MLHR to the industry. MLHR Industry What couponents) is(are) improving ML.HR's ROE relative to the industry average? (highlight your answels)) Based on this DuPont analysis which of the following areas are strengths for ML.HR? (could be more than one 4. Based on this DuPout apalysis which of the following areas are weaknesses for MLHR? (could be more than on) 5. How long is the operating cyele for MLHR for the most recent year ending financial infomation? See Ratio Page) 7. Is the length of the operating cycle a strength or weakness for MLHR compared to the industy? 8. If MLHR's cash cycle increases significantly it would need to: Operating Cycle in Days Cash Cycle in Days How long is the cash cycle for ML.HR for the most recent year ending financial infornation? (See Ratio Page Why?-Answer Succinctty Look at the trends over the past 5 years for the following ratio categories. Ideutity whether the tread is improving deteriorating. or neither. (For ratios that fluctuate over time compare 5 years ago with the most recent year.) Liquidity b. Inveatory Tumover c. Total Asset Turnover d. Days Sales Outstanding e. Asset Management Leverage . Profitability 10. What account causes the current ratio to be smaller than the industry and the quick ratio to be similar to the industry? 11. Does the amouat of time it takes Heman Miller to pay it's suppliers appear to be a problem Hint:compare their ratios to the industry 12. When comparing the assets on the balance sheet to industry averages, what account should the analyst question? 13. What was MLHR's Net Working Cpital for the last two years (omit 000's)? Most Cuirent Year- Previons Yenr- 14. How big a factor would you say market couditions played on the perfornmance of MLHR over the past 10 years Herman Miller ML HR) Common Size Analysis Project General Guidelines: Each individual should gatber data fiom Edgar.com to create the coon size analysis, You can diseuss your answers with the group prior to tuning in the assignment Hand in a printout of the ratio page (see tab below) and a printout of this instruction sheet with your completed answers. (You are not required to type your answers but you may type and highlight your answers.) A. Obtain the most recent annual financial report (10-K) for Miller Herman using EDGAR.gov at Under Company Tieker enter MLHR for Hen Miller B. Use MLHR's 10-K annual report from Edgar.com to ud Financial Infomation for Coinmon Size analysh Fill in your answers in the yellew Bexes below. The light red arrows indicate the answers you need to provide. For drop-down boxes, choose the apprepriate answer Locate the most recent 10-K report and click the Interactive Data link oa the web page then click Financial Statements 1. Cliek on the Income Statement tab below and fill in the infomation from Comsolidated Statements of Qperations in Edgar gov to fill in the highlighted area of the spreadsheet. Note use the previous year's information to guide you Notice the footote on the bottom of the Income Statement reganding Depreciation Expense 2. Click on the Balnce Sheet tab below and fill in the infomation from Comolidated Balauce Sheet from Edgar gov C. Answer the following questions regarding Herman Miller. 1. DuPont Analysis is a great place to start the analysis, because it shows how thee major areas interact to detemine ROE PM Hint: Cliek the Ratios tab below to fill in the appropriate ratios to compare MLHR to the industry. MLHR Industry What couponents) is(are) improving ML.HR's ROE relative to the industry average? (highlight your answels)) Based on this DuPont analysis which of the following areas are strengths for ML.HR? (could be more than one 4. Based on this DuPout apalysis which of the following areas are weaknesses for MLHR? (could be more than on) 5. How long is the operating cyele for MLHR for the most recent year ending financial infomation? See Ratio Page) 7. Is the length of the operating cycle a strength or weakness for MLHR compared to the industy? 8. If MLHR's cash cycle increases significantly it would need to: Operating Cycle in Days Cash Cycle in Days How long is the cash cycle for ML.HR for the most recent year ending financial infornation? (See Ratio Page Why?-Answer Succinctty Look at the trends over the past 5 years for the following ratio categories. Ideutity whether the tread is improving deteriorating. or neither. (For ratios that fluctuate over time compare 5 years ago with the most recent year.) Liquidity b. Inveatory Tumover c. Total Asset Turnover d. Days Sales Outstanding e. Asset Management Leverage . Profitability 10. What account causes the current ratio to be smaller than the industry and the quick ratio to be similar to the industry? 11. Does the amouat of time it takes Heman Miller to pay it's suppliers appear to be a problem Hint:compare their ratios to the industry 12. When comparing the assets on the balance sheet to industry averages, what account should the analyst question? 13. What was MLHR's Net Working Cpital for the last two years (omit 000's)? Most Cuirent Year- Previons Yenr- 14. How big a factor would you say market couditions played on the perfornmance of MLHR over the past 10 years