CHAPTER 3: WORKING WITH FINANCIAL STATEMENTS DUE ON 6/7/2022 [10 POINTS ] ASSIGNMENT 1 (PART-A): [PLEASE DROP THE COMPLETED ASSIGNMENT IN THE DROPBOX] INDIVIDUAL ASSIGNMENT. WINDOWS COMPATIBLE FORMAT ONLY [NO MACS PLEASE] MICHIGAN CORP. HAS PREPARED THE FOLLOWING FINANCIAL STATEMENTS: Michigan Corp. Income Statement For the Year Ended Dec. 31 2020 Michigan Corp. Balance Sheet As of Dec. 31 2020 2020 Assets 2020 Sales 3,074,000 Cash 431,000 Cost of Goods Sold 2,088,000 Accounts Receivable 503,000 Gross Profit 986,000 Inventories 289,000 Selling and G&A Expenses 294,000 Total Current Assets 1,223,000 Fixed Expenses 35,000 Gross Fixed Assets 4,669,000 Depreciation Expense 239,000 Accumulated Depreciation 2,295,000 EBIT 418,000 Net Fixed Assets 2,374,000 Interest Expense 93,000 Total Assets 3,597,000 Earnings Before Taxes 325,000 Liabilities and Owners' Equity Taxes 94,000 Accounts Payable 382,000 Net Income 231,000 Short-term Notes Payable 79,000 Accrued Expenses 159,000 Total Current Liabilities 620,000 Long-term Debt Total Liabilities 1,023,000 1,643,000 Common Stock Retained Earnings Total Shareholder's Equity 819,000 1,135,000 1,954,000 Total Liabilities and Owners' Equity 3,597,000 a) Calculate all of the ratios (given below) for Michigan Corp. for the year 2020 b) Using the following 2020 industry averages, evaluate Michigan Corp.'s financial situation. [That is benchmark each of the ratios using Industry Average (Ind. Average) for all ratios] Ratio Ind. Average FIRM Ratio Ind. Average FIRM Current Ratio 2.0x Quick Ratio 0.5x Times Interest Earned 5.5x Inventory Turnover Ratio 6.5x Accounts Receivable Turnover Ratio 12.0x Profit Margin 5.0% Average Collection Period (Day's sales in receivables 30.0 days Return on Common Equity R 10.0% Return on Total Assets 6.0% Total Asset Turnover 1.5x Total Debt Ratio 40.0% Benchmarking Example (not related to above data): [Need to Benchmark all the ratios above] Ratio Firm Value Industry Average Comment Return on Equity (ROE) Current Ratio 9.8% 2.3x 5.8% 3.0x Good Poor