Pronghorn Company’s condensed financial statements provide the following information.
PRONGHORN COMPANY |
||||||
Dec. 31, 2017 |
Dec. 31, 2016 |
|||||
Cash | $ 52,400 | $ 60,600 | ||||
Accounts receivable (net) | 197,600 | 79,200 | ||||
Short-term investments | 79,200 | 40,000 | ||||
Inventory | 437,500 | 361,900 | ||||
Prepaid expenses | 3,000 | 7,000 | ||||
Total current assets | $ 769,700 | $ 548,700 | ||||
Property, plant, and equipment (net) | 854,600 | 858,900 | ||||
Total assets | $1,624,300 | $1,407,600 | ||||
Current liabilities | 233,500 | 167,200 | ||||
Bonds payable | 404,000 | 404,000 | ||||
Common stockholders’ equity | 986,800 | 836,400 | ||||
Total liabilities and stockholders’ equity | $1,624,300 | $1,407,600 |
INCOME STATEMENT |
|||
Sales | $1,649,400 | ||
Cost of goods sold | (799,700) | ||
Gross profit | 849,700 | ||
Selling and administrative expenses | (444,100) | ||
Interest expense | (39,600) | ||
Net income | $ 366,000 |
Determine the following for 2017. (Round answers to 2
decimal places, e.g. 1.59 or 45.87%.)
(1) | Current ratio at December 31 | ||||
(2) | Acid-test ratio at December 31 | ||||
(3) | Accounts receivable turnover | ||||
(4) | Inventory turnover | ||||
(5) | Return on assets | ||||
(6) | Profit margin on sales |
Answer-
1)- Current Ratio=Current Assets/ Current Liabilities
= $769700/$233500
= 3.30 times
2)- Acid-test (Quick ratio):- Current assets-Inventory-Prepaid expenses/Current Liabilities
= ($769700-$437500-$3000)/$233500
= $329200/$233500
= 1.41 times
3)- Accounts receivable turnover ratio = Net credit sales/Average accounts receivable
= $1649400/($79200+$197600)/2
= $1649400/$138400
= 11.92 times
4)- Inventory turnover ratio= Cost of goods sold/Average inventory
= $799700/($361900+$437500)/2
= $799700/$399700
= 2.00 times
5)- Return on assets =(Net income/Average total assets)*100
= {($366000/($1407600+$1624300)/2}*100
= ($366000/$1515950)*100
= 24.14%
6)- Profit margin on sales = (Net income/Sales)*100
= ($366000/$1649400)*100
= 22.19%
Pronghorn Company’s condensed financial statements provide the following information. PRONGHORN COMPANY BALANCE SHEET Dec. 31, 2017...
Exercise 13-18 a Martinez Company's condensed financial statements provide the following information. MARTINEZ COMPANY BALANCE SHEET Dec. 31, 2020 Dec. 31, 2019 Cash $60,600 $52,400 Accounts receivable (net) 197,600 79,200 Short-term investments 40,000 79,200 361,900 Inventory 437,500 Prepaid expenses 3,000 7,000 Total current assets $769,700 $548,700 858,900 Property, plant, and equipment (net) 854,600 Total assets $1,624,300 $1,407,600 Current liabilities 233,500 167,200 Bonds payable 404,000 404,000 Common stockholders' equity 986,800 836,400 $1,407,600 Total liabilities and stockholders' equity $1,624,300 INCOME STATEMENT FOR...
Grouper Company's condensed financial statements provide the following information. GROUPER COMPANY BALANCE SHEET Dec. 31, 2017 Dec. 31, 2016 Cash $51,900 $59,800 Accounts receivable (net) 199,900 79,300 Short-term investments 79,300 39,600 Inventory 442,700 359,900 Prepaid expenses 3,000 7,000 Total current assets $776,800 $545,600 Property, plant, and equipment (net) 850,400 845,400 Total assets $1,627,200 $1,391,000 Current liabilities 237,700 156,300 Bonds payable 398,800 398,800 Common stockhol ders' equity 990,700 835,900 Total liabilities and stockholders' equity $1,627,200 $1,391,000 INCOME STATEMENT FOR THE YEAR...
Marin Company's condensed financial statements provide the following information. MARIN COMPANY BALANCE SHEET Dec. 31, Dec. 31, 2019 2020 $ 52,500 $ 59,500 Cash Accounts recelvable (net) 199,800 80,000 Short-term investments 80,000 39,800 Inventory 439,400 363,300 Prepaid expenses 3,000 6,900 $ 774,700 $ 549,500 Total current assets Property, plant, and equipment (net) 854,900 849,200 $1,629,600 $1,398,700 Total assets Current liabilities 233,500 154,600 Bonds payable 402,000 402,000 Common stockholders' equity 994,100 842,100 $1,629,600 $1,398,700 Total liabilities and stockholders' equity INCOME STATEMENT...
Marin Company's condensed financial statements provide the following information. Dec 31, 2019 WO MARIN COMPANY BALANCE SHEET Dec. 31, 2020 Cash $ 52,500 Accounts receivable (net) 199,800 Short-term investments 80,000 Inventory 439,400 Prepaid expenses 3,000 Total current assets $ 774,700 Property, plant, and equipment (net) 854,900 Total assets $1,629,600 Current liabilities 233,500 Bonds payable 402,000 Common stockholders' equity 994,100 Total liabilities and stockholders' equity $1,629,600 $59,500 80,000 39,800 363,300 6,900 $549,500 849,200 $1,398,700 154,600 402,000 8 42,100 $1,398,700 233.50 INCOME...
E 13-18 Prior Company's condensed financial statements provide the following information PRIOR COMPANY BALANCE SHEET Cash Accounts Receivables (net) Short Term Investments Inventory Prepaid expenses Total Current Assets Property. Plant and Equipment (net) Total Assets Current Liabilities Bonds Payable Common stockholder's equity Total liabilities and stockholder's equity Dec. 31 2017 $ 52,000 198,000 80,000 440,000 3,000 $ 773,000 857,000 $ 1,630,000 240,000 400,000 990,000 $ 1,630,000 Dec. 31 2016 $ 60,000 80,000 40.000 360,000 7,000 $ 547,000 853,000 $ 1,400,000...
The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) IVANHOE COMPANY Balance Sheets December 31 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 550 Inventory 530 460 Prepaid expenses 160 120 1,530 Total current assets 1,460 Investments Property, plant, and equipment (net) Intangibles and other assets Total assets 420 380 530 510 $2,570 $2,440 $980 $870 480 450 1,110 1,120 Current liabilities Long-term liabilities...
Presented below is information related to Pronghorn Inc. PRONGHORN INC. BALANCE SHEET DECEMBER 31, 2020 Cash $44,900 Notes payable (short-term) $50,000 Receivables $109,800 Accounts payable 32,000 Less: Allowance 15,100 94,700 Accrued liabilities 5,100 Inventory 171,200 Common stock (par $5) 261,800 Prepaid insurance 8,100 Retained earnings 141,000 Land 20,200 Equipment (net) 150,800 $489,900 $489,900 PRONGHORN INC. INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $1,401,600 Cost of goods sold Inventory, Jan. 1, 2020 $199,600 Purchases 796,000 Cost...
The condensed financial statements of Crane Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) CRANE COMPANY Balance Sheets December 31 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 570 500 Inventory 580 510 Prepaid expenses 120 160 Total current assets 1,600 1,530 Investments 110 110 Property, plant, and equipment (net) 380 420 530 510 Intangibles and other assets $2,660 $2,530 Total assets $890 $1,000 Current liabilities 500 530 Long-term...
Plankton Company Balance Sheet as of Dec 31, 2017 (in $) Cash 112,500 Accounts Payable 150,000 Receivables 336,000 Notes payable 84,000 Inventories 241,500 Other Current Liabilities 117,000 Total CA 690,000 Total CL 351,000 L-T debt 256,500 Net Fixed Assets 292,500 Common Equity 375,000 Total Assets 982,500 Total L+E 982,500 Plankton Company Income Statement (year ended Dec 31, 2017—in $) Sales 1,607,000 Cost of Goods Sold Materials 717,000 Labor 453,000 Heat, Light, and Power 68,000...
The condensed financial statements of Crane Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) CRANE COMPANY Balance Sheets December 31 2017 2016 Current assets Cash and cash equivalents Accounts receivable (net) Inventory Prepaid expenses Total current assets Investments $330 $360 570 500 580 510 120 160 1,600 1,530 110 110 420 380 530 510 $2,660 $2,530 $1,000 $890 530 500 Property, plant, and equipment (net) Intangibles and other assets Total assets Current liabilities Long-term...