|
|
|
Calculation of liquidity ratio | Formula | 2017 | 2016 | change | |
Current ratio | CA/CL | CA | |||
Cash | 72,000 | 69,000 | |||
Short term investment | 54,000 | 39,000 | |||
A/R | 1,07,000 | 90,000 | |||
Inventory | 2,36,000 | 1,62,000 | |||
Pre-Paid expenses | 30,000 | 27,000 | |||
4,99,000 | 3,87,000 | ||||
CL | |||||
Notes payable | 1,70,000 | 1,06,000 | |||
Accounts payable | 65,000 | 54,000 | |||
Accrued liabilities | 42,000 | 42,000 | |||
2,77,000 | 2,02,000 | ||||
Current ratio | 1.80 | 1.92 | -5.97% | ||
1.8:1 | 1.92:1 | ||||
Calculation of liquidity ratio | Formula | 2017 | 2016 | change | |
Accounts receivable turn over ratio (ARTOR) | Net credit sales/average accounts receivable | Oening Receivalbe | 90,000 | 89000 | |
Closing Receivable | 1,07,000 | 90,000 | |||
Average A/R | 98500 | 89500 | |||
Sales | 8,98,000 | 7,89,000 | |||
ARTOR | 9.1 | 8.8 | 0.3 | ||
Calculation of liquidity ratio | Formula | 2017 | 2016 | change | |
Inventroy Turn over ratio | Cost of goods sold/Average Inventory | Cost of goods sold | 6,47,000 | 5,75,000 | |
Oening Inventory | 1,62,000 | 1,15,000 | |||
Closing Inventory | 2,36,000 | 1,62,000 | |||
Average inventory | 199000 | 138500 | |||
Inventroy Turn over ratio | 3.3 | 4.2 | -0.9 |
Calculation of Profitablility ratio | Formula | 2017 | 2016 | change | |
Profit margin | GP/Sales | GP | 2,51,000 | 2,14,000 | |
Sales | 8,98,000 | 7,89,000 | |||
Profit margin | 28.0% | 27.1% | 0.8% | ||
Asset turn over ratio (ATOR) | Total sales/Average assets | Sales | 8,98,000 | 7,89,000 | |
Opening assets | 7,08,000 | 6,33,000 | |||
Closing assets | 8,92,000 | 7,08,000 | |||
Average assets | 800000 | 670500 | |||
ATOR | 1.12 | 1.18 | -0.05 | ||
Return on assets | Net Income/Total Assets | Net Income | 57,000 | 54,000 | |
Total Assets | 8,92,000 | 7,08,000 | |||
Return on assets | 6.4% | 7.6% | -1.2% | ||
Earning per share | Net Income/No. of shares | Net Income | 57,000 | 54,000 | |
No. of shares | 20,900 | 20,900 | |||
Earning per share | 2.7 | 2.6 | 0.1 |
The following financial information is for Pharoah Company. PHAROAH COMPANY Balance Sheets December 31...
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 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...
The following financial information is for Ivanhoe Company. IVANHOE COMPANY Balance Sheets December 31 Assets 2017 2016 Cash $ 71,000 $66,000 Debt investments (short-term) Accounts receivable 52,000 110,000 233.000 25,000 40,000 91,000 165,000 27,000 Inventory Prepaid expenses Land 130,000 130,000 Building and equipment (net) 259.000 184,000 Total assets $880,000 $703,000 Liabilities and Stockholders' Equity Notes payable $171,000 $110,000 Accounts payable 68,000 53,000 Accrued liabilities Bonds payable, due 2017 39,000 249,000 207,000 146,000 39,000 169,000 207,000 125,000 Common stock, $10 par...
The following financial information is for Priscoll Company. PRISCOLL COMPANY Balance Sheets December 31 Assets 2017 2016 Cash $ 70,000 $ 65,000 Debt investments (short-term) 55,000 40,000 Accounts receivable 104,000 90,000 Inventory 230,000 165,000 Prepaid expenses 25,000 23,000 Land 130,000 130,000 Building and equipment (net) 260,000 185,000 Total assets $874,000 $698,000 Liabilities and Stockholders’ Equity Notes payable $170,000 $120,000 Accounts payable 65,000 52,000 Accrued liabilities 40,000 40,000 Bonds payable, due 2017 250,000 170,000 Common stock, $10 par 200,000 200,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...
The following financial information is for Sunland Company. Sunland Company Balance Sheets December 31 2020 2019 ssets 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 $ 70,000 65,000 40,000 90,000 237,000 168,000 27,000 134,000 134,000 263,000 186,000 $891,000 $710,000 51,000 109,000 27,000 $169,000 $104,000 53,000 39,000 250,000...
Problem 13-04A The following financial information is for Blossom Company. BLOSSOM COMPANY Balance Sheets December 31 Assets 2022 Cash $ 72,000 Debt investments (short-term) 54,000 Accounts receivable 109,000 Inventory 235,000 Prepaid expenses 26,000 Land 134,000 Building and equipment (net) 259,000 Total assets $889,000 Liabilities and Stockholders' Equity Notes payable $170,000 Accounts payable 66,000 Accrued liabilities 41,000 Bonds payable, due 2025 249,000 Common stock, $10 par 198,000 Retained earnings 165,000 Total liabilities and stockholders' equity $889,000 2021 $ 67,000 39,000 92,000...
CULLUMBER COMPANY Balance Sheets December 31 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 2017 Common stock, $10 par Retained earnings 2017 2016 69,000 69,000 41,000 103,000 92,000 239,000 164,000 25,000 29,000 132,000 132,000 263,000 188,000 $884,000 $715,000 53,000 $170,000 $101,000 66,000 54,000 42,000 251,000 170,000 205,000 205,000 150,000 143,000 Total liabilities and stockholders' equity $884,000 $715,000 42,000...
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...