Using the information in the income statement and balance sheet, prepare the following ratios for 12/31/20: Current Ratio Acid Test A/Rec Turnover Inventory Turnover Total Asset Turnover Debt Ratio Times Interested Earned Profit Margin Ratio Return on Total Assets Return on Comm. Stock Equity

Please help. Your feedback is much appreciated. Thank you.

1. PREPARE A HORIZONTAL BALANCE SHEET 2. PREPARE A COMMON SIZE INCOME STATEMENT 123/31/20 12/31/19 $ CHANGE % CHANGE 12/31/20 % 50 150 450 510 10 1170 45 140 510 520 12 1227 5 10 -60 -10 11% 7% -12% -2% -17% -5% CURRENT ASSETS CASH SHORT TERM INVEST. ACCTS. RECEIVABLES INVENTORIES PREPAID ASSETS TOTAL CURR. ASSETS LONG TERM ASSETS MACHINERY LAND BUILDING PATENTS TOTAL LONG TERM TOTAL ASSETS SALES REVENUES COST OF GOODS SOLD GROSS PROFIT OPERATING EXPENSES OPERATING INCOME INTEREST EXPENSE INCOME BEFORE TAX INCOME TAX NET INCOME 2650 1225 1425 750 675 67 608 304 304 100% 46% 549 28% 25% 3% 23% 11% 119 -57 10 360 1180 4500 230 6270 7440 350 1180 4600 250 6380 7607 0 -100 -20 -110 -167 3% 0% -2% -8% -2% -2% -15 CURRENT LIABILITIES ACC. PAY WAGES PAY TOTAL CURRENT LONG TERM DEBT TOTAL LIABILITIES STOCKHLD'S EQUITY COMMON STOCK RETAINED EARNINGS TOTAL ST. EQUITY TOTAL LIAB.+ST. EQ 360 65 425 2300 2725 375 74 449 2350 2799 -24 -50 -74 -4% -12% -5% -2% -3% 3000 1715 4715 3000 1808 4808 7607 0 -93 -93 -167 0% -5% -2% -2% 7440 DO NOT AVERAGE. USE 12/31/20 ONLY 3. Using the information in the income statement and balance sheet in 1 and 2 prepare the following ratios. ing ratios for 12/31/20 ANSWER CURRENT RATIO ACID TEST A/REC TURNOVER INVENTORY TURNOVER TOTAL ASSET TURNOVER DEBT RATIO TIMES INTEREST EARNED PROFIT MARGIN RATIO RETURN ON TOTAL ASSETS RETURN ON COMM. STOCK EQUITY