Calculate the following ratios for the years 2020 and 2021 Gross profit margin Net profit margin Return
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the following ratios for the years 2020 and 2021
- Gross profit margin
- Net profit margin
- Return on equity
- Inventory turnover period
- Average settlement period (Accounts receivable)
- Asset turnover
- Current ratio
- Quick ratio
- Interest coverage ratio
- Debt to equity ratio
Present the calculation and answer for each ratio in a table. It is sufficient to show the calculation for the year 2020 ONLY. Round the ratios to 2 decimal places.
STATEMENT OF FINANCIAL POSITION | |||
Fiscal Year: | 2019 | 2020 | 2021 |
(FYR Ending): | (31DEC2019 ) | (31DEC2020 ) | (31DEC2021 ) |
Cash & Equivalents | 55,297 | 84,629 | 96,291 |
Receivables - Total (Net) | 17,663 | 19,981 | 26,500 |
Inventories - Total | 19,868 | 22,943 | 31,758 |
Current Assets - Total | 96,334 | 132,733 | 161,580 |
Plant, Property & Equip (Net) | 97,846 | 150,667 | 216,363 |
Intangibles | 18,803 | 19,998 | 20,478 |
TOTAL ASSETS | 225,248 | 321,195 | 420,549 |
Accounts Payable | 47,183 | 72,539 | 78,664 |
Total Current Liabilities | 87,812 | 126,385 | 142,266 |
Long Term Debt | 63,205 | 87,789 | 122,595 |
TOTAL LIABILITIES | 163,188 | 227,791 | 282,304 |
TOTAL SHAREHOLDERS EQUITY | 62,060 | 93,404 | 138,245 |
INCOME STATEMENT | |||
Fiscal Year: | 2019 | 2020 | 2021 |
(FYR Ending): | (31DEC2019 ) | (31DEC2020 ) | (31DEC2021 ) |
Sales (Net) | 280,522 | 386,064 | 469,822 |
Cost of Goods Sold | 150,386 | 217,068 | 249,435 |
Gross Profit | 130,136 | 168,996 | 220,387 |
Selling, General, & Admin Expenses | 100,244 | 129,933 | 172,537 |
Research and Development Expense | 35,931 | 42,740 | 56,052 |
Depreciation, Depletion, & Amortization | 15,715 | 16,748 | 23,421 |
Interest Expense | 1,600 | 1,647 | 1,809 |
Net Profit | 11,588 | 21,331 | 33,364 |
Related Book For
Accounting Principles Volume 2
ISBN: 978-1119502555
8th Canadian Edition
Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak
Posted Date: