Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The top two pictures are the company's financial information. I just need help doing the calculations for the bottom picture. If you show me how
The top two pictures are the company's financial information.
I just need help doing the calculations for the bottom picture. If you show me how to did one column, I can do the other column on my own. Thank you.
A B C D E E F G Comparative Income Statements For the years ending December 31 2020 2019 2018 Sales $ 290 $ 210 $ 150 Cost of Goods Sold 38 30 24 213 108 78 $ 251 S 138 102 Beginning Inventory Add: Purchases : D Less: Ending Inventory Cost of Goods Sold Gross Profit 54 38 30 197 100 72 $ 93 $ 110 78 | 30 | Less: Operating Expenses 5 ) Net Income from Operations (IBIT) 5 Interest Expense 37 56 34 76 $ S $ 48 | | | 3 1 S 53 $ $ 47 Income Before Income Tax Income Tax Net income 73 10 7 S 48 63 $ 40 Comparative Statements of Retained Earnings For the Year Ended December 31 2020 2019 2018 $ S 40 10 Balance, January 1 Add: Net Income for the Year 100 48 148 63 103 $ $ $ 40 50 D Less: Dividend 5 3 10 Balance, December 31 S 143 100 40 The following additional information is available: a. All sales are on credit; credit terms are net 60 days after invoice date. 40 5b. Number of shares of common stock were outstanding in 2018 40 5 Number of shares of common stock were outstanding in 2019 On January 1, 2020, 20 additional shares of common stock were sold. The total number of common stock outstanding is now 60 60 $ 120.00 The additional 20 common shares were sold for a total of: $ 16.00 c. Opening balance of accounts receivable on January 1, 2018 was $ 256.00 d. Net capital assets for January 1, 2018, was S $ 310.00 e. Total assets on January 1, 2018, was . , S $ 250.00 f. Total shareholders' equity on January 1, 2018, was $ 3.50 g. In 2018, market price per share was In 2019, market price per share was 4 $ $ 3.00 $ 2.50 In 2020, market price per share was The following are condensed financial statements of December 31, 2018, 2019, 2020. br the three years ended Comparative Balance Sheets For the years ending December 31 2018 2020 $ 47 $ 25 2019 $ 32 Current Assets Cash Accounts Receivable Less: Allowance for Doubtful Accounts $ 37 $ 18 $ 12 1 24 2 16 12 54 11 38 9 30 7 $ 136 $ 95 $ 86 Inventories Supplies Total Current Assets Capital Assets Less: Accumulated Depreciation Total Assets 634 97 375 45 256 27 537 330 229 $ 673 $ 425 $ 315 12 15 20 13 80 30 $ 110 60 $ 35 $ 25 60 Current Liabilities Accounts Payable Other Accrued Liabilities Total Current Liabilities Long Term Notes Payable Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity $ 170 $ 85 $ 35 360 143 240 100 240 40 $ 503 $ 340 $ 280 $ 673 $ 425 $ 315 2020 2019 2018 1 Current ratio 136/110 = 1.24:1 2 Quick ratio 2 (47+24)/110 - 0.65:1 Accounts receivable turnover 290/[(16+24)/2] - 14.5 times 4 Days' sales uncollected (24/290) x 365 = 30.21 days Inventory turnover 197/[(38+54)/2) = 4.28 2] times Days' sales in (54/197) x 365 = 100.05 inventory days Total asset turnover 290/[(673+425)/2] -0.53 times 8 Debt ratio (170/673) x 100% - 25.26% 9 Equity ratio (5037673) x 100% - 74.74% 10 Times interest 56/3 = 18.67 times earned 11 Profit margin (48/290) x 100% = 16.55% 12 Gross profit ratio (93/290) x 100% = 32.07% 13 Return on total 48/[(425+673)/2] x 100% = assets 8.74% Return on 14 common S/E equity 48/[(340+503)/2] x 100% = 11.39% 15 Earnings per share 48/60 - $0.80 Price-earnings 16 2.50/.8 - 3.13 per share 17 Dividend yield (5/60)/2.50] x 100% 3.33% Required: 1. Complete the required calculations on this worksheet in the boxes provided. Show your work for 2018 and 2019 as shown for 2020 that has been completed for you. Round all of your answers to 2 decimalsStep 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