Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with question Number 3 please. 1. PREPARE A HORIZONTAL BALANCE SHEET 2. PREPARE A COMMON SIZE INCOME STATEMENT 12/31/20 12/31/19 $ CHANGE
I need help with question Number 3 please.
1. PREPARE A HORIZONTAL BALANCE SHEET 2. PREPARE A COMMON SIZE INCOME STATEMENT 12/31/20 12/31/19 $ CHANGE % CHANGE 12/31/20 % 50 45 5 11.11% 2650 140 10 1225 150 450 510 510 -60 1425 520 100% 46.23% 53.77% 28.30% 25.47% 7.14% -11.76% -1.92% -16.67% -4.65% -10 750 675 10 12 SALES REVENUES COST OF GOODS SOLD GROSS PROFIT OPERATING EXPENSES OPERATING INCOME INTEREST EXPENSE INCOME BEFORE TAX INCOME TAX NET INCOME -2 1170 1227 -57 67 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 2.53% 608 22.94% 10 360 1180 4500 350 1180 304 304 11.47% 11.47% 0 2.85 0.00% -2.17% -8.00% -100 4600 250 -20 230 6270 7440 6380 -110 -1.72% -2.20% 7607 -167 375 - 15 74 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 -24 -50 449 2350 2799 -4.00% -12.16% -5.35% -2.13% -2.64% -74 0 3000 1715 4715 3000 1808 0.00% -5.14% -93 -93 4808 -1.93% -2.20% 7440 7607 - 167 ing ratios for 12/31/20 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. 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 EQUITYStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started