1. Please help me with the red boxes, on the last part of the question.
The following financial information is for Cullumber Company. CULLUMBER COMPANY Balance Sheets December 31 Assets 2022 Cash $ 70,000 Debt investments (short-term) 53,000 Accounts receivable 108,000 Inventory 229,000 Prepaid expenses 30,000 Land 130,000 Building and equipment (net) 264,000 Total assets $884,000 Liabilities and Stockholders' Equity Notes payable $172,000 Accounts payable 65,000 Accrued liabilities 41,000 Bonds payable, due 2025 250,000 Common stock, $10 par 202,000 Retained earnings 154,000 Total liabilities and stockholders' equity $884,000 2021 $ 64,000 39,000 90,000 162,000 25,000 130,000 185.000 $695,000 $102,000 51,000 41,000 172,000 202.000 127,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. 2. 3. Inventory at the beginning of 2021 was $116,000. Accounts receivable (net) at the beginning of 2021 were $90,000. Total assets at the beginning of 2021 were $642,000. No common stock transactions occurred during 2021 or 2022. All sales were on account. 4. 5. (91) 2021 2022 % Change LIQUIDITY Current ratio 1.96 :1 1.76 :1 -10 % 8.80 times 8.99 times 3 % Accounts receivables turnover Inventory turnover 41 times 3.30 times -20 % 2021 2022 % Change PROFITABILITY Profit margin 6.60 % 6.20 % % Asset turnover 1.18 times 1.13 times % Return on assets 7.78 % 7.0 % -10 % Earnings per share $ 2.57 $ 2.72 6 % (b) 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 O decimal places, e.g. 15 and round all other answers to 1 decimal place, e.g. 15.5. Round % change to O decimal places, for e.g. 1% and if % change is a decrease show the numbers as negative, e.g. -1% or (1%).) Ratio 1. Situation 18,000 shares of common stock were sold at par on July 1, 2023. Net income for 2023 was $53.000. 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. The market price of common stock was $9 and $13 on December 31, 2022 and 2023, respectively Return on common stockholders' equity Debt to assets ratio 2. 3. Price-earnings ratio 2022 2023 % Change 16 % 11.88 % -26.00 % Return on common stockholders' equity Debt to assets ratio Price earnings ratio 59.73 % 39.38 % -34.07 % 3.3 times 4.4 times 33 % e Textbook and Media Assistance Used The following financial information is for Cullumber Company. CULLUMBER COMPANY Balance Sheets December 31 Assets 2022 Cash $ 70,000 Debt investments (short-term) 53,000 Accounts receivable 108,000 Inventory 229,000 Prepaid expenses 30,000 Land 130,000 Building and equipment (net) 264,000 Total assets $884,000 Liabilities and Stockholders' Equity Notes payable $172,000 Accounts payable 65,000 Accrued liabilities 41,000 Bonds payable, due 2025 250,000 Common stock, $10 par 202,000 Retained earnings 154,000 Total liabilities and stockholders' equity $884,000 2021 $ 64,000 39,000 90,000 162,000 25,000 130,000 185.000 $695,000 $102,000 51,000 41,000 172,000 202.000 127,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. 2. 3. Inventory at the beginning of 2021 was $116,000. Accounts receivable (net) at the beginning of 2021 were $90,000. Total assets at the beginning of 2021 were $642,000. No common stock transactions occurred during 2021 or 2022. All sales were on account. 4. 5. (91) 2021 2022 % Change LIQUIDITY Current ratio 1.96 :1 1.76 :1 -10 % 8.80 times 8.99 times 3 % Accounts receivables turnover Inventory turnover 41 times 3.30 times -20 % 2021 2022 % Change PROFITABILITY Profit margin 6.60 % 6.20 % % Asset turnover 1.18 times 1.13 times % Return on assets 7.78 % 7.0 % -10 % Earnings per share $ 2.57 $ 2.72 6 % (b) 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 O decimal places, e.g. 15 and round all other answers to 1 decimal place, e.g. 15.5. Round % change to O decimal places, for e.g. 1% and if % change is a decrease show the numbers as negative, e.g. -1% or (1%).) Ratio 1. Situation 18,000 shares of common stock were sold at par on July 1, 2023. Net income for 2023 was $53.000. 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. The market price of common stock was $9 and $13 on December 31, 2022 and 2023, respectively Return on common stockholders' equity Debt to assets ratio 2. 3. Price-earnings ratio 2022 2023 % Change 16 % 11.88 % -26.00 % Return on common stockholders' equity Debt to assets ratio Price earnings ratio 59.73 % 39.38 % -34.07 % 3.3 times 4.4 times 33 % e Textbook and Media Assistance Used
