Question
The financial statements for Royale and Cavalier companies are summarized here: Royale Co Cavalier Co Balance Sheet Cash 20,000 63,000 Accounts Receivable, Net 50,000 11,000
The financial statements for Royale and Cavalier companies are summarized here:
| Royale Co | Cavalier Co |
Balance Sheet |
|
|
Cash | 20,000 | 63,000 |
Accounts Receivable, Net | 50,000 | 11,000 |
Inventory | 100,000 | 15,000 |
Equipment, Net | 540,000 | 150,000 |
Other Assets | 135,000 | 41,000 |
Total Assets | 845,000 | 280,000 |
Current Liabilities | 110,000 | 15,000 |
Note Payable (long-term) | 180,000 | 45,000 |
Common Stock (par $20) | 475,000 | 205,000 |
Additional Paid-in Capital | 45,000 | 6,000 |
Retained Earnings | 35,000 | 9,000 |
Total Liabilities and Stockholders' Equity | 845,000 | 280,000 |
Income Statement |
|
|
Sales Revenue | 785,000 | 265,000 |
Cost of Goods Sold | 475,000 | 145,000 |
Other Expenses | 235,000 | 90,000 |
Net Income | 75,000 | 30,000 |
Other Data |
|
|
Per share price at the end of year | 18 | 14 |
Selected Data from Previous Year |
|
|
Accounts Receivable, Net | 42,000 | 9,000 |
Note Payable (long-term) | 180,000 | 45,000 |
Equipment, Net | 540,000 | 150,000 |
Inventory | 90,000 | 33,000 |
Total Stockholders' Equity | 555,000 | 220,000 |
These two companies are in the same business and state but different cities. Each company has been in operation for about 10 years. Both companies received an unqualified audit opinion on the financial statements. Royale Company wants to borrow $70,000 cash and Cavalier Company is asking for $25,000. The loans will be for a two-year period. Both companies estimate bad debts based on an aging analysis, but Cavalier has estimated slightly higher uncollectible rates than Royale. Neither company issued stock in the current year. Assume the end-of-year total assets and net equipment balances approximate the years average and all sales are on account.
Required:
1. Calculate the following ratios (Use 365 days in a year. Round your intermediate calculations and final answers to 2 decimal places.)
Ratio | Royale Co | Cavalier Co |
Tests of Profitability: |
|
|
1. Net Profit Margin | 9.55% | 11.32% |
2. Gross Profit Percentage | 39.49% | 45.28% |
3. Fixed Asset Turnover | 1.45 | 1.77 |
4. Return on Equity | 13.51% | 13.64% |
5. Earnings per Share |
|
|
6. Price/Earnings Ratio |
|
|
Tests of Liquidity: |
|
|
7. Receivables Turnover |
|
|
Days to Collect |
|
|
8. Inventory Turnover |
|
|
Days to Sell |
|
|
9. Current Ratio |
|
|
Tests of Solvency: |
|
|
10. Debt-to-Assets |
|
|
Need help with the chart, numbered 5-10 on the chart. Thanks so much.
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