Current ratio=Current asset/Current liabilities | |||||||
2019 | 2020 | % change | |||||
Current assets | (Note:1) | 390000 | 494000 | ||||
Current liabilities | 94019 | 110020 | |||||
Current ratio | 4.15 | 4.49 | 8.19% | ||||
(4.49-4.15)/4.15 | |||||||
Note:1-Current assets | |||||||
2019 | 2020 | ||||||
Cash | 65000 | 70000 | |||||
Debt investments | 40000 | 51000 | |||||
Accounts receivable | 90000 | 109000 | |||||
Inventory | 168000 | 237000 | |||||
Prepaid expenses | 27000 | 27000 | |||||
Total current assets | 390000 | 494000 | |||||
Note:2- Current liabilities | |||||||
2019 | 2020 | ||||||
Accounts payable | 53000 | 69000 | |||||
Accrued liabilities | 39000 | 39000 | |||||
Total current liabilities | 94019 | 110020 | |||||
Accounts receivable turnover ratio=Sales/ Average accounts receivable | |||||||
Average accounts receivable= (Beginning accounts receivable+Ending accounts receivable)/2 | |||||||
2019 | 2020 | % change | |||||
Net sales | 784000 | 892000 | |||||
Beginning accounts receivable (a) | 90000 | 90000 | |||||
Ending accounts receivable (b) | 90000 | 109000 | |||||
Accounts receivable | (a+b)/2 | 90000 | 99500 | ||||
Receivable turnover ratio | 8.71 | 8.96 | 2.87% | ||||
(8.96-8.71)/8.71 | |||||||
Inventory turnover=Cost of goods sold/Average inventory | |||||||
Average inventory=(Beginning inventory+Ending inventory)/2 | |||||||
2019 | 2020 | % change | |||||
Cost of goods sold | 576000 | 644000 | |||||
Beginning inventory | (a) | 115000 | 168000 | ||||
Ending inventory | (b) | 168000 | 237000 | ||||
Average Inventory | (a+b)/2 | 141500 | 202500 | ||||
Inventory turnover ratio | 4.07 | 3.18 | -21.87% | ||||
(3.18-4.07)/4.07 | |||||||
profit margin=Net income/Sales revenue | |||||||
2019 | 2020 | % change | |||||
Net income (a) | 47000 | 50000 | |||||
Sales revenue (b) | 784000 | 892000 | |||||
profit margin (a)/(b) | 5.99% | 5.61% | -6.34% | ||||
(5.61-5.99)/5.99 | |||||||
Asset turnover=Net sales/Average Total assets | |||||||
Average total assets=(Beginning total assets+ Ending total assets)/2 | |||||||
2019 | 2020 | % change | |||||
Net sales | 784000 | 892000 | |||||
Beginning total assets | a | 640000 | 710000 | ||||
Ending total assets | b | 710000 | 891000 | ||||
Average Total assets | (a+b)/2 | 675000 | 800500 | ||||
Asset turnover | 1.16 | 1.11 | -4.31% | ||||
(1.11-1.16)/1.16 | |||||||
Return on assets=Net income/Average total assets | |||||||
2019 | 2020 | % change | |||||
Net income | 47000 | 50000 | |||||
Average Total assets | 675000 | 800500 | |||||
Return on assets | 6.96% | 6.25% | -11.36% | ||||
(6.25-6.96)/6.25 | |||||||
Earnings per share=Net income/Shares outstanding | |||||||
Shares outstanding=Common stock/Par value | |||||||
2019 | 2020 | % change | |||||
Net income | 47000 | 50000 | |||||
Common stock | 205000 | 205000 | |||||
Par value | 10 | 10 | |||||
Shares outstanding (b) | 20500 | 20500 | |||||
Earnings per share (a)/(b) | 2.29 | 2.44 | 6.55% | ||||
(2.44-2.29)/2.29 | |||||||
Return on common stockholder's equity=Net income/Average common stockholder's equity | |||||||
Average common stockholder's equity=(Beginning stockholder's equity+Ending stockholder's equity)/2 | |||||||
2019 | 2020 | 2021 | |||||
Common stock | 205000 | 205000 | 25000 | ||||
205000-(18000*10) | |||||||
Retained earnings | 137000 | 159000 | 211000 | ||||
(159000+52000) | |||||||
Stockholder's equity | 342000 | 364000 | 236000 | ||||
2020 | 2021 | % change | |||||
Net income | 47000 | 50000 | |||||
Beginning stockholder's equity | 342000 | 364000 | |||||
Ending stockholder's equity | 364000 | 236000 | |||||
Average common stockholder's equity | 353000 | 300000 | |||||
Return on common stockholder's equity | 13.31% | 16.67% | 25.24% | ||||
(16.67-13.31)/13.31 |
|
The following financial information is for Sunland Company. Sunland Company Balance Sheets December 31 2020 2019...
The following financial information is for Cullumber Company Cullumber Company Balance Sheets December 31 2020 2019 ASsels $ 70,000 $ 64,000 Cash Debt investments (short-term) 39,000 53,000 90,000 Accounts receivable 108,000 162,000 229,000 Inventory Prepaid expenses 25,000 30,000 130,000 Land 130,000 185,000 264,000 Building and equipment (net) $884,000 $695,000 Total assets Liabilities and Stockholders' Equity $172,000 $102,000 Notes payable 65,000 51,000 Accounts payable 41,000 41,000 Accrued liabilities 250,000 172,000 Bonds payable, due 2023 202,000 Common stock, $10 par 202,000 127,000...
Problem 13-04A a1,b (Video) The following financial information is for Oriole Company. Oriole Company Balance Sheets December 31 Assets Cash Debt investments (short-term) Accounts receivable Inventory Prepaid expenses Land 2020 $ 70,000 51,000 107,000 234,000 26,000 135,000 261,000 $884,000 2019 $ 69,000 40,000 92,000 167,000 23,000 135,000 184,000 $710,000 Building and equipment (net) Total assets Liabilities and Stockholders' Equity Notes payable Accounts payable Accrued liabilities Bonds payable, due 2023 Common stock, $10 par Retained earnings Total liabilities and stockholders' equity...
Problem 13-04A al,b (Video) The following financial information is for Oriole Company. Oriole Company Balance Sheets December 31 2020 2019 Assets Cash Debt investments (short-term) Accounts receivable Inventory Prepaid expenses Land Building and equipment (net) Total assets Liabilities and Stockholders' Equity Notes payable Accounts payable Accrued liabilities Bonds payable, due 2023 Common stock, $10 par Retained earnings Total liabilities and stockholders' equity $ 69,000 $65,000 40,000 89,000 239,000 168,000 26,000 129,000 264,000 186,000 $888,000 $703,000 55,000 109,000 23,000 129,000 $169,000...
Problem 13-04A a1,b (Video) The following financial information is for Oriole Company. Oriole Company Balance Sheets December 31 2019 Assets Cash Debt investments (short-term) Accounts receivable Inventory Prepaid expenses Land Building and equipment (net) Total assets Liabilities and Stockholders' Equity Notes payable Accounts payable Accrued liabilities Bonds payable, due 2023 Common stock, $10 par Retained earnings Total liabilities and stockholders' equity 2020 $ 69,000$65,000 40,000 89,000 239,000 168,000 26,000 129,000 129,000 264,000 186,000 $888,000 $703,000 55,000 109,000 23,000 $169,000 $109,000...
Question 4 The following financial information is for Priscoll Company. Priscoll Company Balance Sheets December 31 Assets 2020 Cash $ 135,800 Debt investments (short-term) 106,700 Accounts receivable 201,760 Inventory 446,200 Prepaid expenses 48,500 Land 252,200 Building and equipment (net) 504,400 Total assets $1,695,560 Liabilities and Stockholders' Equity Notes payable (short-term) $329,800 Accounts payable 126,100 Accrued liabilities 77,600 Bonds payable, due 2023 485,000 Common stock, $10 par 388,000 Retained earnings 289,060 Total liabilities and stockholders' equity $1,695,560 2019 $ 126,100 77,600...
*Problem 13-04A a1,b (Video) The following financial information is for Cullumber Company. Cullumber Company Balance Sheets December 31 Assets 2020 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 2023 250,000 Common stock, $10 par 202,000 Retained earnings 154,000 2019 $ 64,000 39,000 90,000 162,000 25,000 130,000 185,000...
The following financial information is for Cullumber Company. upport CULLUMBER COMPANY Balance Sheets December 31 Assets 2017 2016 Cash Debt investments (short-term) Accounts receivable Inventory $ 72,000 $68,000 51,000 42,000 109,000 92,000 237,000 169,000 28,000 25,000 131,000 131,000 259,000 186,000 $887,000 $713,000 Prepaid expenses Land Building and equipment (net) Total assets Liabilities and Stockholders' Equity Notes payable $169,000 $109,000 69,000 50,000 Accounts payable Accrued liabilities Bonds payable, due 2017 Common stock, $10 par 41,000 41,000 252,000 170,000 209,000 209,000 147,000...
Please Do everything in red CARLA VISTA COMPANY Balance Sheets December 31 Assets 2019 2018 Cash $ 70,000 $ 67,000 Debt investments (short-term) 51,000 41,000 Accounts receivable 104,000 90,000 Inventory 230,000 164,000 Prepaid expenses 22,000 23,000 Land 133,000 133,000 Building and equipment (net) 262,000 185,000 Total assets $872,000 $703,000 Liabilities and Stockholders' Equity Notes payable $172,000 $102,000 Accounts payable 66,000 51,000 Accrued liabilities 39,000 39,000 Bonds payable, due 2022 249,000 169,000 Common stock, $10 par 210,000 210,000 Retained earnings 136,000...
The following financial information is for Pharoah Company. PHAROAH COMPANY Balance Sheets December 31 Assets 2017 2016 Cash $ 72,000 $ 69,000 Debt investments (short-term) 54,000 39,000 Accounts receivable 107,000 90,000 Inventory 236,000 162,000 Prepaid expenses 30,000 27,000 Land 133,000 133,000 Building and equipment (net) 260,000 188,000 Total assets $892,000 $708,000 Liabilities and Stockholders’ Equity Notes payable $170,000 $106,000 Accounts payable 65,000 54,000 Accrued liabilities 42,000 42,000 Bonds payable, due 2020 250,000 171,000 Common stock, $10 par 209,000 209,000 Retained...
The following financial information is for Oriole Company. ORIOLE COMPANY Balance Sheets December 31 Assets 2017 2016 Cash $ 70,000 $ 69,000 Debt investments (short-term) 51,000 40,000 Accounts receivable 107,000 92,000 Inventory 234,000 167,000 Prepaid expenses 26,000 23,000 Land 135,000 135,000 Building and equipment (net) 261,000 184,000 Total assets $884,000 $710,000 Liabilities and Stockholders’ Equity Notes payable $172,000 $106,000 Accounts payable 66,000 52,000 Accrued liabilities 42,000 42,000 Bonds payable, due 2020 251,000 170,000 Common stock, $10 par 204,000 204,000 Retained...