Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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 decimals

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CIA Part 1 Essentials Of Internal Auditing Certified Internal Auditor 2019

Authors: Muhammad Zain

1st Edition

1091949182, 978-1091949188

More Books

Students also viewed these Accounting questions