all these go together

Additional Guidance The Week 4 Financial Performance exercise helps you synthesize learned concepts with realistic financial information. As in previous financial exercises. you should show your work with an Excel formula in the worksheet, a written calculation in the worksheet, or the written calculations in a separate document. Keen in mind the nerformance summary is a renuired nart of the assignment The calculations.count for 65% of E G K M BALANCE SHEET INCOME STATEMENT (S in millions) (S in millions) ASSETS Cash & Marketable Securities LIABILITIES Accounts Payable Salaries Payable Revenue 28.681 10 449 90 1,611 20 Cost Of Goods Sold 20,768 0 Accounts Receivable Inventories 954 80 225 20 Geoss Profit 7912 30 3,645 20 Other Curent Liabdties 1,118 80 Other Carent Assets 11660 5166 50 Total Current Liablnes Operating Espenses Selling, General & Admin Depreciation Opmating inceme 2955 20 Total Current Assets 5,950 50 Other Liabties 691 40 307.30 Machinery & Equipnent Land Baldings Depreciation Property, Plant & Eqaip-Net- Other Long Tem Assets 1690 L129.70 L624.20 Tetal Liabes 3,648 60 2348 40 (575 60) Interest SHAREHOLDER'S EQUITY Other Espense (Income) (13.10 4,591 40 120 90 Commen Stock Retained Eamings Total Shareholder's Equity $28 50 Income Befeee Tases Income Tases 1,637 30 618 10 5,001.20 6230 20 Total Leng Tem Assets 4,712 30 Net Income 1,019.20 Total Assets Tetal Liahilities & Euiry 9878.50 9878.50 Number of Common Stock Shares Outstanding 1,012 271 Financial Perfewce Smary Iapat Assers Bele LIQUIDITY RATIOS Problem for Students 27 28 Inpat Answers Below Financial Perfermance Summary LIQUIDITY RATIOS Curent Ratio (tmes) 29 30 Quaick Ratio (times) Average Payment Period (days) 31 37 ASSET MANAGEMENT RATIOS Tetal Asset Tumaver (himes) Average Collection Period (days) Inventory Tumover (imes) 33 34 35 36 31 38 FINANCIAL LEVERAGE RATIOS Tetal Debt to Total Assets Equity Multiplher (mes) 39 40 41 43 PROFITABILITY RATIOS Operating Prefit Margin Net Profit Margin Retum on Total Assets Retum on Eqary Eamings per Share 44 45 46 48 40 50 Problem for Students