M2 INDIVIDUAL ASSIGNMENT (75 points)THE ASSIGNMENT1.Calculate the ratios for Centric Brands.2.Analyze the ratios based on the material in M2. THE STEPSObtain the 2018 financials from the SEC (see below).Enter values and formulas into the inputs and outputs on Tab 1 of the M2 IND SUBMISSION TEMPLATE. When you have completed Tab 1, copy it to Tab 2 (copy range is A1:B29). In Tab 2, you click on Formulas, then on Show Formulas.Submit your assignment via Canvas.Check to see that your assignment is submitted correctly.The ADDITIONAL information you are graded on the ratios and analysis as well as your accuracy in using the Principles of Spreadsheet Design. When you analyze the ratios, remember the following:1.The analysis table includes only movements (increases, decreases, less than zero, etc.) that concern you.2.When you identify the movement of concern, you must also include the years.The link to submit your assignment closes at 11:59 pm on Sunday. You will not be able to submit your assignment once the link closes. I do not accept homework submitted via e-mail.Lack of planning on your part does not necessitate a change in the requirements on my part. ACCESSING FINANCIAL STATEMENTS: You will be using the financial statements from the companys SEC 10-K filings. To access those statements, go to www.sec.gov. Click on Company Filings. In the Company and Person Lookup box, type Centric and hit enter. Click twice on Centric Brands on the list of companies. Note that there are several companies named Centric something. You must make sure youre accessing Centric Brands.Click on Form Type. The most recent 10-K (2018 filed in 2019) is first on the list. Click on Filing, then Interactive Data, then View Excel File.This downloads the financials to your computer. Use the 2018 balance sheet, income statement, and cash flow statement to find the financials needed in your assignment.Note that:Sold receivables is not included in the accounts receivable turnover ratio.For long-term debt, use long-term debt, net of current portion.For net income, use net loss.

2018 2017 CENTRIC BRANDS (75 POINTS) Accounts receivable, net Inventories Total current assets Total assets Total current liabilities Long-term debt Total liabilities Total equity Net sales Cost of goods sold Net loss Net cash used in operating activities Net cash used in investing activities Net cash provided by financing activities Current Quick OCF FCF OCF+ICF Inv TO AR TO TA TO Debt D-E NPM ROA ROE 22.246 31.733 67,061 173,674 38,711 44,896 128,931 44,743 164053 92,303 (2.458) (1,726) (1,127) 4,669 1.732 0.913 (1,726) 4,669 (2.853) 2.909 7.374 0.945 0.742 1.003 (0.015) (0.014) (0.055) Problem indicated by movement 2016 20,225 23,977 54,927 166,171 34,317 47,218 121.647 44,524 149.267 87.987 (17,812) (16,570) (20.416) 41.463 1.601 0.902 (16,570) 41.463 (36,986) 3.670 7.380 0.898 0.732 1.061 (0.119) (0.107) (0.400) Movement that concerns you Current Quick OCF FCF OCF+ICF Inv TO AR TO TA TO Debt D-E NPM ROA ROE 2018 CENTRIC BRANDS (75 POINTS) Accounts receivable, net Inventories Total current assets Total assets Total current liabilities Long-term debt Total liabilities Total equity Net sales Cost of goods sold Net loss Net cash used in operating activities Net cash used in investing activities Net cash provided by financing activities Current Quick OCF FCF OCF+ICF Inv TO AR TO TA TO Debt D-E NPM ROA ROE 2018 2017 CENTRIC BRANDS (75 POINTS) Accounts receivable, net Inventories Total current assets Total assets Total current liabilities Long-term debt Total liabilities Total equity Net sales Cost of goods sold Net loss Net cash used in operating activities Net cash used in investing activities Net cash provided by financing activities Current Quick OCF FCF OCF+ICF Inv TO AR TO TA TO Debt D-E NPM ROA ROE 22.246 31.733 67,061 173,674 38,711 44,896 128,931 44,743 164053 92,303 (2.458) (1,726) (1,127) 4,669 1.732 0.913 (1,726) 4,669 (2.853) 2.909 7.374 0.945 0.742 1.003 (0.015) (0.014) (0.055) Problem indicated by movement 2016 20,225 23,977 54,927 166,171 34,317 47,218 121.647 44,524 149.267 87.987 (17,812) (16,570) (20.416) 41.463 1.601 0.902 (16,570) 41.463 (36,986) 3.670 7.380 0.898 0.732 1.061 (0.119) (0.107) (0.400) Movement that concerns you Current Quick OCF FCF OCF+ICF Inv TO AR TO TA TO Debt D-E NPM ROA ROE 2018 CENTRIC BRANDS (75 POINTS) Accounts receivable, net Inventories Total current assets Total assets Total current liabilities Long-term debt Total liabilities Total equity Net sales Cost of goods sold Net loss Net cash used in operating activities Net cash used in investing activities Net cash provided by financing activities Current Quick OCF FCF OCF+ICF Inv TO AR TO TA TO Debt D-E NPM ROA ROE