Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Calculate the following ratios for the years 2020 and 2021

  1. Gross profit margin
  2. Net profit margin
  3. Return on equity
  4. Inventory turnover period
  5. Average settlement period (Accounts receivable)
  6. Asset turnover
  7. Current ratio
  8. Quick ratio
  9. Interest coverage ratio
  10. 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

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

Step: 3

blur-text-image

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

Financial Accounting

Authors: Carl S Warren, James M Reeve, Jonathan Duchac

12th Edition

0538478519, 9780538478519

More Books

Students also viewed these Accounting questions