Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 3: Financial Ratios Review (32 marks) The following table presents the data for CanDo Inc. as of December 31, 2018: Accounts payable $126,000 Accounts
Part 3: Financial Ratios Review (32 marks)
The following table presents the data for CanDo Inc. as of December 31, 2018:
Accounts payable | $126,000 |
Accounts receivable | $165,000 |
Cash and cash equivalents | $106,000 |
CoGS | $271,600 |
Common stock | $1,090,000 |
Depreciation | $42,000 |
Dividend payout ratio | 40% |
Interest paid | $38,596 |
Inventory | $175,000 |
Long-term debt | $1,856,000 |
Net fixed assets | $2,932,000 |
Sales | $440,000 |
Short-term debt | $142,872 |
Tax rate | 31% |
Calculate the following financial ratios for CanDo Inc. in the fiscal year of 2018 (round all answers to six decimal places):
- Current ratio (1 mark)
- Quick ratio (1 mark)
- Cash ratio (1 mark)
- Net working capital ratio (1 mark)
- Interval measure (1 mark)
- Total debt ratio (1 mark)
- Debt-equity ratio (1 mark)
- Equity multiplier (1 mark)
- Long-term debt ratio (1 mark)
- Times interest earned (1 mark)
- Cash coverage ratio (1 mark)
- Inventory turnover (using avg. inventory from 2018 & 2019) (2 marks)
- Days sales in inventory (1 mark)
- Receivables turnover (using avg. accounts receivable from 2018 & 2019) (2 marks)
- Days sales in receivables (1 mark)
- Payables turnover (using avg. accounts payable from 2018 & 2019) (2 marks)
- Days sales in payables (1 mark)
- NWC turnover (1 mark)
- Fixed assets turnover (1 mark)
- Total asset turnover (1 mark)
- Profit margin (1 mark)
- Return on assets (ROA) (1 mark)
- Return on equity (ROE) (1 mark)
- Price-earnings (P/E) ratio (using price per share provided in Part 2) (3 marks)
- Market-to-book ratio (using price per share provided in Part 2) (3 marks)
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