Question
Data for Cary Company and its industry average follow. Provide your answers with solutions. Balance Sheet as of Dec. 31 Assets Liabilities and Owner's Equity
- Data for Cary Company and its industry average follow. Provide your answers with solutions.
Balance Sheet as of Dec. 31 | |||
Assets | Liabilities and Owner's Equity | ||
2019 | 2019 | ||
Current Assets | Current Liabilities | ||
Cash | 75,500 | Accts payable | 127,000 |
A/R | 330,000 | Notes payable | 84,000 |
Inventories | 251,500 | Other current liabilities | 115,000 |
Total CA | 657,000 | Total CL | 326,000 |
Net fixed assets | Long-term debt | 266,500 | |
Net plant and equipment | 282,500 | Total Liabilities | 592,500 |
Common Equity | 347,000 | ||
Total Assets | 939,500 | Total Liabilities and Equity | 939,500 |
Income statement for the year ending December 31 | |
2019 | |
Sales | 1,600,500 |
COGS | (1,353,000) |
Gross profit | 247,500 |
Fixed operating expenses except depreciation | (140,000) |
Earnings before interest, taxes, depre and amort (EBITDA) | 107,500 |
Depreciation | (40,000) |
EBIT (Opering income) | 67,500 |
Interest expense | (24,000) |
EBT (Taxable income) | 43,500 |
Taxes (40%) | (17,400) |
Net income | 26,100 |
- Calculate the indicated ratios for Cary.
Ratio | Cary | Industry Average | |
Current ratio | _____________ | 2.0 X | |
Days sales outstanding | _____________ | 35 days | |
Inventory turnover | _____________ | 5.6 X | |
Total assets turnover | _____________ | 3.0 X | |
Net profit margin | _____________ | 1.2% | |
Return on assets (ROA) | _____________ | 3.60% | |
Return on equity (ROE) | _____________ | 9.00% | |
Debt ratio | _____________ | 60% |
- Construct the DuPont equation for both Cary and the industry (Only construct DuPont ROA for Cary and the industry)
DuPont ROA (Cary) =
DuPont ROA (Industry) =
- Outline Carys strengths and weaknesses as revealed by your analysis.
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