Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Calculate liquidity ratios for 2019 and 2020 a. Current Ratio b. Quick Ratio c. Number of days in A/R d. Inventory turnover 2. Calculate
1. Calculate liquidity ratios for 2019 and 2020 a. Current Ratio b. Quick Ratio c. Number of days in A/R d. Inventory turnover
2. Calculate Solvency Ratio a. Owner's equity / total assets b. Current liability / Owner's equity c. Total liability / Owner's equity
Calibri General 11 A 29 Wrap Text EE Merge & Center Insert Delet Paste BIU $ - % 488 Conditional Format as Cell Formatting Table Styles Styles Number Alignment Clipboard Font Cells J51 X G H B 1 K 1 A 1 XYZ Corporation 2 D E F ANNUAL BALANCE SHEET ($ thousands) 3 3 4 12/31/2020 12/31/2019 12/31/2018 5 21/31/2017 24991 26388 13764 0 12864 29514 25606 13642 0 30240 22813 14039 0 14409 28096 14439 14714 0 12747 14908 78007 63750 12349 83670 44078 9275 81501 36679 7429 69996 31662 5817 6 ASSETS 7 Cash & Equivalents 8 Net Receivables 9 Inventories 10 Prepaid Expenses 11 Other Current Assets 12 13 Total Current Assets 14 Gross Plant Property & Equipment 15 Accumulated Depreciation 16 17 Net Plant Property & Equipment 18 Investments at Equity 19 Other Investments 20 Intangibles 21 Deferred Charges 22 Other Assets 22 24 TOTAL ASSETS XYZ Balance Sheet 51401 9201 18500 5947 0 34803 8350 16006 6410 0 28438 29250 8094 14354 7228 25845 6883 6954 8782 0 30962 0 31464 25917 177677 166344 149422 194520 XYZ Income Statement Search e B ce Wrap lext General Paste BIU C-A- Merge & Center $ - % - Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number 351 B C D E F G H 1 3 0 0 0 31464 28438 25917 0 30962 194520 177677 166344 149422 0 0 4629 889 14988 22529 14158 23621 0 19562 24062 0 5865 21977 25166 0 0 0 5726 22458 4844 19789 5063 18245 A 21 Deferred Charges 22 Other Assets 23 24 TOTAL ASSETS 25 LIABILITIES 26 Long Term Debt Due In One Year 27 Notes Payable 28 Accounts Payable 29 Taxes Payable 30 Accrued Expenses 31 Other Current Liabilities 32 33 Total Current Liabilities 34 Long Term Debt 35 Deferred Taxes 36 Investment Tax Credit 37 Other Liabilities 38 39 TOTAL LIABILITES 40 Redeemable Noncontrolling Int. 41 EQUITY 42 Preferred Stock - Redeemable 43 Preferred Stock - Nonredeemable 44 XYZ Balance Sheet 71466 43549 53992 65701 31853 62412 22025 0 10532 603 0 0 0 0 0 39182 0 38733 44099 47295 154197 0 141653 0 123170 0 112422 0 0 0 0 0 3109 0 10391 0 XYZ Income Statement + O Search o DI Home insert Page Layout Formulas Data Review View Add-ins Help Calibri 11 - ' ' A == Wrap Text General Feste BIU a a-A- Merge & Center - $ -% 48 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number 151 B D E F G H 1 K 0 0 0 0 10391 0 0 3109 0 0 41 EQUITY 42 Preferred Stock - Redeemable 43 Preferred Stock - Nonredeemable 44 45 Total Preferred Stock 46 Common Stock 47 Capital Surplus 48 Retained Earnings 49 Less: Treasury Stock 50 51 Common Equity 3109 15 15 27607 12249 0 16 28937 6504 10391 14 23834 2005 28780 10703 0 0 0 39871 35457 39498 25853 39871 452 35457 567 42607 567 36244 756 40323 36024 43174 37000 53 Stockholder's Equity - Parent 54 Nonredeemable Noncontrolling Int. 55 56 Stockholder's Equity - Total 57 58 TOTAL LIABILITIES & EQUITY 59 COMMON SHARES OUTSTANDING 60 61 166344 194520 1500 177677 1600 149422 1366.374 1500 62 63 + XYZ Balance Sheet XYZ Income Statement + 0 1 O Search 2 General . Calibri 11 A A A A == a A- 29 Wrap Text Merge & Center - Insert Delete Paste BIU $ -% ! Conditional Format as Cell Formatting Table Styles Styles IN Number Cells Alignment Clipboard 5 Font L17 B G H 1 K D F ANNUAL INCOME STATEMENT ($ Thous EXCEPT PER SHARE) 12/31/2020 12/31/2019 12/31/2018 21/31/2017 152256 152356 123800 155929 131657 155427 130909 132229 1 XYZ Corporations 2 3 4 5 6 Sales 7 Cost of Goods Sold 8 9 Gross Profit 10 Selling, General & 11 Administrative Expense 12 13 Operating Income Before Deprec. 14 Depreciation, Depletion & 15 Amortization 28556 24272 24518 20027 11530 11756 11910 13593 6434 17026 12608 12516 7219 6238 5908 5888 16 9807 17 Operating Profit 18 Interest Expense 19 Non-Operating income/Expense 20 Special Items 21 2160 2914 -2843 6278 1899 2987 -3120 6700 1130 2297 -409 546 889 2958 -31310 7718 -1897 4246 228 7458 2127 -28695 -34831 22 Pretax income 23 Total Income Taxes 24 XYZ Balance Sheet XYZ Income Statement Ready O Search O e AutoSave MYZ Financial Statements (1) File Home Page Layout Formulas Data Review View Add-ins Help X Calibri - 11 A A General Paste 28 Winport El Merge Center - BIU- A $ - % 98 99 Insert Delete Form Conditional Formatas Cell Formatting - Table - Styles Styles Clipboard Font 15 Alignment Number X B C D E F G H 1 A 21 22 Pretax Income 23 Total Income Taxes 7718 -1897 4246 228 7458 2127 28695 34831 9615 4018 69 5331 -15 6136 -52 9687 0 3949 1145 5346 1576 5188 359 25 Income Before Extraordinary Items 26 and Noncontrolling Interests 27 Noncontrolling interest - Inc ACC 28 29 Income Before Extraordinary 30 items & Discontinued Operations 31 Preferred Dividends 32 33 Available for common 34 Savings Due to Common 35 Stock Equivalents 36 37 Adjusted Available for Common 38 Extraordinary Items 39 Discontinued Operations 9687 2804 3770 0 0 0 9687 0 0 2804 0 0 3770 0 0 0 2804 3770 1859 41 Adjusted Net Income 9687 42 Income to Company incl Extraordinary 43 Items & Disc Ops 9615 24 XYZ Balance Sheet XYZ Income Statement 4018 5331 6136 Search e Home Insert File Page Layou Formulas Data Review View Add-ins Help Calibri -11-AA Wrap Text General Incert Delete Format Paste BIU- a A- Merge Center $ - %) *8.99 Conditional Format Call Formatting Table Styles Styles Font Clipboard Alignment Cells 117 D B H F 1 9587 2804 3770 9615 4018 5331 5136 6.11 1.75 2.71 6.11 1.75 2.71 41 Adjusted Net Income 42 Income to Company Incl Extraordinary 43 Items & Disc Ops 24 45 46 Earnings Per Share Basic 47 Excluding Extra Items & Disc Op 48 Earnings Per Share Basic 49 Including Extra Items & Disc Op 50 Earnings Per Share Diluted 51 Excluding Extra Items & Disc Op 52 Earnings Per Share Diluted 53 Including Extra Items & Discop 54 EPS Basic from Operations 55 EPS Diluted from Ops 56 Dividends Per Share 57 Com Shares for Basic EPS 58 Com Shares for Diluted EPS 59 5.91 1.65 2.38 292 2.38 2.88 0.13 5.91 5.01 4.87 1.38 1586 1640 1.65 3.06 2.9 1.2 1605 1687 0 2390 1676 156 60 61 63 54 Z Balance Sheet XYZ Income Statement Search
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