1.calculate the current ratio2.average payables period in days3.calculate the inventory days4.calculate the times interest earned 5.calculate the operating income margin

1 1 24 Home What's New S XYZ Company.xisx Q X Menu ~ A PG ? C V Home Insert Page Layout Formulas Data Review View Tools Smart Toolbox Q Wrap Text General Rows and Columns Calibri 11 A A Conditional Format Paste BIUA & A. Q Orientation Merge and Center ~ % 090 568 50 Worksheet ~ Formatting Painter J11 fx Long term Debt A B D E F G H I K 1 Income statement XYZ Company $ Thousand 2 Balance Sheet XYZ Liability 2020 221 2020 2021 Assets D W Revenues Current Assets: 2020 2021 Current Liabilities Product A 12700 26500 Cash 12,450 11,000 Account Payable 10,500 12,000 6 Product B 10000 10000 Marketable securitie 1,000 1,000 Notes Payable 24,200 22,500 Total Revenue 22700 36500 Account Receivable 18,750 13,000 Wages accrued 1,000 500 00 Cost of Goods Sold 8,900.00 19,500.00 Inventories 22,000 21,000 Total Current Liabilities 35,700 35,000 9 Total Current Assets 54,200 46,000 10 Gross Profit (Loss) 13,800.00 17,000.00 Long term Liabilities 11 Fixed Assets Long term Debt 175,000 165,000 12 Operation Expenses Property, land &equi 195,000 181,000 13 Depreciation 500.00 500.00 Total Liabilities 210,700 200,000 14 Marketing & Sale 1,600.00 2,400.00 Total Fixed Assets 195,000 181,000 15 Insurance 300:00 300.00 Shareholder's Equity 16 Administration 450.00 430.00 Total Assets 249,200 227,000 Common Shares 28,000 18,000 17 Total Operation Expense 2,850.00 3,630.00 Retained Earning 10,500 9,000 18 Operation Income 10,950.00 13,370.00 Total shareholder's Equity 38,500 27,000 19 Interest 7,200.00 7,200.00 20 Net Income before taxes 3,750.00 6,170.00 Total Liabilities & S/E 249,200 227,000 21 Taxes @ 4% 150.00 246.80 22 Net Income 3,600.00 5,923.20 23 24 1 >1 Sheet1 + 112% Type here to search O CHORE