Question
The following financial information is for Cullumber Company. CULLUMBER COMPANY Balance Sheets December 31 Assets 2022 2021 Cash $ 70,000 $ 64,000 Debt investments (short-term)
The following financial information is for Cullumber Company.
CULLUMBER COMPANY Balance Sheets December 31 | ||||
---|---|---|---|---|
Assets | 2022 | 2021 | ||
Cash | $ 70,000 | $ 64,000 | ||
Debt investments (short-term) | 53,000 | 39,000 | ||
Accounts receivable | 108,000 | 90,000 | ||
Inventory | 229,000 | 162,000 | ||
Prepaid expenses | 30,000 | 25,000 | ||
Land | 130,000 | 130,000 | ||
Building and equipment (net) | 264,000 | 185,000 | ||
Total assets | $884,000 | $695,000 | ||
Liabilities and Stockholders Equity | ||||
Notes payable | $172,000 | $102,000 | ||
Accounts payable | 65,000 | 51,000 | ||
Accrued liabilities | 41,000 | 41,000 | ||
Bonds payable, due 2025 | 250,000 | 172,000 | ||
Common stock, $10 par | 202,000 | 202,000 | ||
Retained earnings | 154,000 | 127,000 | ||
Total liabilities and stockholders equity | $884,000 | $695,000 |
CULLUMBER COMPANY Income Statements For the Years Ended December 31 | ||||
---|---|---|---|---|
2022 | 2021 | |||
Sales revenue | $890,000 | $786,000 | ||
Cost of goods sold | 641,000 | 575,000 | ||
Gross profit | 249,000 | 211,000 | ||
Operating expenses | 194,000 | 159,000 | ||
Net income | $ 55,000 | $ 52,000 |
Additional information:
1. | Inventory at the beginning of 2021 was $116,000. | |
2. | Accounts receivable (net) at the beginning of 2021 were $90,000. | |
3. | Total assets at the beginning of 2021 were $642,000. | |
4. | No common stock transactions occurred during 2021 or 2022. | |
5. | All sales were on account. |
Compute the liquidity and profitability ratios of Cullumber Company for 2021 and 2022. (Round Curent ratio, Asset turnover and Earnings per share to 2 decimal places, e.g. 15.50 and round all other answers to 1 decimal place, e.g. 15.5. Round % change to 0 decimal places, for e.g. 1% and if % change is a decrease show the numbers as negative, e.g. -1% or (1%).)
2021 | 2022 | % Change | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
LIQUIDITY | ||||||||||
Current ratio | enter the current ratio | :1 | enter the current ratio | :1 | enter percentages | % | ||||
Accounts receivables turnover | enter accounts receivables turnover in times | times | enter accounts receivables turnover in times | times | enter percentages | % | ||||
Inventory turnover | enter inventory turnover in times | times | enter inventory turnover in times | times | enter percentages | % |
2021 | 2022 | % Change | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
PROFITABILITY | ||||||||||
Profit margin | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Asset turnover | enter asset turnover in times | times | enter asset turnover in times | times | enter percentages | % | ||||
Return on assets | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Earnings per share | $enter a dollar amount | $enter a dollar amount | enter percentages | % |
Given below are three independent situations and a ratio that may be affected. For each situation, compute the affected ratio (1) as of December 31, 2022, and (2) as of December 31, 2023, after giving effect to the situation. (Round Debt to assets ratio to 0 decimal places, e.g. 15 and round all other answers to 1 decimal place, e.g. 15.5. Round % change to 0 decimal places, for e.g. 1% and if % change is a decrease show the numbers as negative, e.g. -1% or (1%).)
Situation | Ratio | |||
---|---|---|---|---|
1. | 18,000 shares of common stock were sold at par on July 1, 2023. Net income for 2023 was $53,000. | Return on common stockholders equity | ||
2. | All of the notes payable were paid in 2023. All other liabilities remained at their December 31, 2022 levels. Total assets on December 31, 2023, were $904,000. | Debt to assets ratio | ||
3. | The market price of common stock was $9 and $13 on December 31, 2022 and 2023, respectively. | Price-earnings ratio |
2022 | 2023 | % Change | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
Return on common stockholders equity | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Debt to assets ratio | enter percentages | % | enter percentages | % | enter percentages | % | ||||
Price earnings ratio | enter a price earnings ratio in times | times | enter a price earnings ratio in times | times | enter percentages | % |
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