Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Google Excel: https://docs.google.com/spreadsheets/d/17UXg_XHPtx2tU6a32IygCnr9n17cHPSRIYIvmFcN48I/edit?usp=sharing CompTech IBN Liquidity Measures 1 Current Ratio 2 Quick Ratio 3 Cash Ratio Long-Term Solvency Measures 4 Total Debt Ratio 5 Times
Google Excel: https://docs.google.com/spreadsheets/d/17UXg_XHPtx2tU6a32IygCnr9n17cHPSRIYIvmFcN48I/edit?usp=sharing
CompTech | IBN | ||
Liquidity Measures | |||
1 | Current Ratio | ||
2 | Quick Ratio | ||
3 | Cash Ratio | ||
Long-Term Solvency Measures | |||
4 | Total Debt Ratio | ||
5 | Times Interest Earned Ratio | ||
6 | Cash Coverage Ratio | ||
Cash and Asset Management Measures | |||
7 | Inventory Turnover | ||
8 | Inventory Period (days) | ||
9 | Receivables Turnover | ||
10 | Receivables Period (days) | ||
11 | Payables Turnover | ||
12 | Payables Period (days) | ||
13 | Cash Cycle (days) | ||
Market Value Measures | |||
14 | Price Earnings Ratio | ||
15 | Market to Book ratio | ||
16 | Enterprise Value ($000) | ||
17 | EBITDA ratio | ||
DuPont Analysis | |||
18 | Return on Equity | ||
19 | Return on Assets | ||
20 | Profit Margin | ||
21 | Total Asset Turnover | ||
22 | Equity Multiplier | ||
23 | Debt Equity Ratio | ||
Internal and Sustainable Growth | |||
24 | Dividend Payout Ratio | ||
25 | Retention Ratio | ||
26 | Internal Growth Rate | ||
27 | Sustainable Growth Rate |
CompTech $000 IBN $000 3 Current Assets 4 Cash and cash equivalents Accounts receivable Inventor Total current assets 4, 000 19, 136 20, 816 43, 952 4, 873 20, 655 18, 967 44, 495 8 Fixed Assets Property, plant and equipment Intangible assets (incl goodwi Total non-current assets 88, 480 10, 550 99,030 142, 982 54, 597 21.488 76, 085 120, 580 10 12 Total Assets 13 14 Current Liabilities 15 16 Accounts payable Short-term debt Current tax liabilities Other current liabilities Total current liabilities 31, 985 2, 670 500 800 35, 955 13, 068 3, 899 4, 155 1, 000 22, 122 18 19 20 Non-current Liabilities 21 Long-term debt Deffered revenues Other non-current 1iabilities Total non-current liabilities 17, 363 4, 953 3,611 25, 927 61, 882 53 5, 927 169 6, 149 28, 271 23 24 25 Total Liabilities 26 Shareholders Equity 27 28 29 Total equit 30 Total Liabilities andEquit 76, 352 4, 748 81, 100 142, 982 Common stock Retained Earnin 37, 890 54, 419 92, 309 120, 580 gS CompTech IBN $000 $000 3 Sales 4 Cost of goods sold 5 Other expenses 6 Administrative Expenses 7 Depreciation andAmortisatio 8 EBIT 9 Interest 10 e 24, 092 17, 982 1,878 1, 000 786 2, 446 434 2, 012 604 1, 408 182, 300 67, 823 2,878 92, 296 5, 230 14, 073 2, 502 11, 571 3, 471 8, 100 Taxable Incom 11 Tax 12 Net Income CompTechIBN 20 Pric pr sharc, $ 3 Number of shares COC 4 Dividend per share, $ 2 100() 0. 05 2,000 2
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