2 4 1 Acct No. Name 2 1010 Cash 3 1030 Accounts Receivable 4 1035 Allowance for Bad Debt 5 1050 Inventory 6 1700 Fixed Assets 7 1750 Accumulated Depreciation 8 2010 Accounts Payable 9 2030 Payroll W/H&Taxes Payable 10 2070 Interest Payable 11 2080 Income Tax Payable 12 2700 Long-term Notes Payable 13 3900 Capital Stock 14 3999 Retained Earnings 15 4010 Sales 16 4020 Sales Returns 17 4030 Sales Discounts 18 5000 Purchases 19 5010 Purchase Returns 20 5020 Purchase Discounts 21 5999 Cost of Goods Sold 22 6000 Wage & Salary Expense 23 6010 Rent Expense 24 6020 Utilities Expense 25 6030 Office Supplies Expense 26 6040 Payroll Tax Expense 27 6050 Depreciation 28 6060 Bad Debt Expense 29 6070 Interest Expense 30 6080 Provision for Income Tax YTD 174535.7 582380 -61488.3 1733000 917500 -39202 -630000 -9527.95 -5000 1-236949 -600000 -700000 -177453 -6174020 320280 59910 0 0 0 4205114 70878 122650 72820 35800 27135.25 11750 57938.3 5000 236948.9 31 53 50 Selected Ratios: 51 ROI Return on Investment = Net Income/Avg. Owners Equity 72% GM% 52 Gross Margin % -Gross Margin/Net Sales 72% CR Current Ratio - Current Assets / Current Liabilities ?? 54 DE Debt-to-Equity = Total Liabilities / Owners' Equity 77% 55 Notes payable are lon-term. 3. Using "show formulas" or "formula and audit" mode, display the formulas you used to calculate the ratios on the worksheet and then print the ratio computations along with them indicating the cell numbers. . o a