Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the data from the balance sheet and income statement, and Calculate the Ratios for the years 2017, 2018, and 2019. Current Ratio Quick (Acid
Use the data from the balance sheet and income statement, and Calculate the Ratios for the years 2017, 2018, and 2019.
Current Ratio Quick (Acid Test) Ratio Debt to Equity Ratio Return on Equity Return on Sales Inventory Turnover Return on assets Asset utilization ratio
Balance sheet:
| |||||||
12/2019 | 12/2018 | 12/2017 | 12/2016 | 12/2015 | |||
Cash and Equivalents | 128,390 | 90,212 | 93,453 | 55,928 | 73,844 | ||
Restrictable Cash | - | - | - | - | - | ||
Marketable Securities | 94 | 77 | 16 | 424 | 114 | ||
Receivables | - | - | - | - | - | ||
Inventories | 86,216 | 102,894 | 80,432 | 78,475 | 65,543 | ||
Prepaid Expenses | 8,218 | 7,761 | 6,983 | 5,923 | 6,081 | ||
Current Deferred Income Taxes | - | - | - | - | - | ||
Other Current Assets | (1) | 6 | 1 | 13,805 | - | ||
Total Current Assets | 382,761 | 390,518 | 324,283 | 243,146 | 265,573 | ||
Gross Fixed Assets | 348,284 | 303,447 | 296,277 | 256,338 | 148,592 | ||
Accumulated Depreciation | (159,854) | (139,587) | (129,368) | (104,943) | (86,856) | ||
Net Fixed Assets | 188,430 | 163,860 | 166,909 | 151,395 | 61,736 | ||
Intangibles | 48,752 | 41,236 | 34,733 | 25,299 | 23,309 | ||
Cost in Excess | - | - | - | - | - | ||
Non-Current Deferred Income Taxes | 17,442 | 19,315 | 18,446 | 15,001 | 17,056 | ||
Other Non-Current Assets | 31,081 | 22,675 | 12,413 | 19,349 | 1 | ||
Total Non-Current Assets | 333,830 | 294,658 | 287,006 | 236,294 | 116,595 | ||
Total Assets | 716,590 | 685,177 | 611,289 | 479,440 | 382,168 | ||
| |||||||
12/2019 | 12/2018 | 12/2017 | 12/2016 | 12/2015 | |||
Accounts Payable | (16,539) | (17,705) | (18,163) | (3,276) | (21,651) | ||
Short Term Debt | 61,520 | 69,087 | 41,613 | 50,772 | 62,481 | ||
Notes Payable | - | - | - | - | - | ||
Accrued Expenses | - | - | - | - | - | ||
Accrued Liabilities | - | - | - | - | - | ||
Deferred Revenues | - | - | - | - | - | ||
Current Deferred Income Taxes | - | - | - | - | - | ||
Other Current Liabilities | 256,718 | 278,124 | 272,458 | 220,490 | 213,562 | ||
Total Current Liabilities | 301,698 | 329,506 | 295,908 | 267,987 | 254,392 | ||
Long Term Debt | 45,820 | 61,352 | 101,395 | 87,996 | 52,600 | ||
Deferred Income Tax | 341 | 483 | 652 | 788 | 764 | ||
Other Non-Current Liabilities | 59,858 | 53,344 | 53,592 | 31,908 | 27,300 | ||
Minority Interest | 2,350 | 1,713 | 1,178 | 747 | 471 | ||
Capital Lease Obligations | 17,015 | - | - | - | - | ||
Preferred Securities of Subsidiary Trust | - | - | - | - | - | ||
Preferred Equity Outside Shareholders' Equity | - | - | - | - | - | ||
Total Non-Current Liabilities | 125,383 | 116,892 | 156,817 | 121,440 | 81,135 | ||
Total Liabilities | 427,081 | 446,398 | 452,725 | 389,427 | 335,527 | ||
Preferred Shareholder's Equity | - | - | - | - | - | ||
Common Shareholder's Equity | 289,509 | 238,778 | 158,565 | 90,013 | 46,641 | ||
Total Equity | 289,509 | 238,778 | 158,565 | 90,013 | 46,641 | ||
Total Liabilities & Shareholder's Equity | 716,590 | 685,177 | 611,289 | 479,440 | 382,168 |
Income statement:
| |||||||
12/2019 | 12/2018 | 12/2017 | 12/2016 | 12/2015 | |||
Operating Revenue | 750,641 | 728,723 | 704,714 | 584,410 | 555,474 | ||
Adjustments to Revenue | N/A | N/A | N/A | N/A | N/A | ||
Cost of Revenue | 394,784 | 391,874 | 373,405 | 329,512 | 315,163 | ||
Gross Operating Profit | 321,020 | 311,576 | 302,604 | 230,593 | 219,170 | ||
Selling/General/Admin Expense | (12,851) | (9,999) | (13,466) | (11,317) | (8,094) | ||
Research & Development | - | - | - | - | - | ||
EBITDA (Operating Income Before Depreciation) | 155,192 | 149,987 | 133,488 | 95,814 | 82,308 | ||
Depreciation & Amortization | (34,837) | (25,272) | (28,706) | (24,305) | (21,142) | ||
Operating Income | 120,355 | 124,714 | 104,783 | 71,509 | 61,166 | ||
Interest Income | 534 | 665 | 450 | 204 | 139 | ||
Other Income, Net | - | - | - | - | - | ||
Total Income Before Interest Expense (EBIT) | 120,355 | 124,714 | 104,783 | 71,509 | 61,166 | ||
Interest Expense | (954) | (1,231) | (1,657) | (2,329) | (1,492) | ||
Income Before Tax | 119,401 | 123,484 | 103,126 | 69,180 | 59,675 | ||
Income Taxes | (25,427) | (16,074) | (29,607) | (23,698) | (28,896) | ||
Minority Interest | 607 | 503 | 352 | 141 | 202 | ||
Net Income from Continuing Operations | 93,974 | 107,409 | 73,519 | 45,482 | 30,779 | ||
Net Income from Discontinued Operations | - | - | - | - | - | ||
Net Income from Total Operations | 93,974 | 107,409 | 73,519 | 45,482 | 30,779 | ||
Normalized Income | 94,052 | 107,421 | 74,242 | 45,548 | 31,370 | ||
Extraordinary Income/Loss | - | - | - | - | - | ||
Special Income/Charges | (77) | (11) | (723) | (65) | (591) | ||
Income from Cum. Effect of Acct Change | - | - | - | - | - | ||
Income from Tax Loss Carryforward | - | - | - | - | - | ||
Other Gains | (607) | (503) | (352) | (142) | (202) | ||
Total Net Income | 93,367 | 106,906 | 73,167 | 45,340 | 30,577 |
Step 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