In: Accounting
Problem 23-4
Crane Company had the following information available at the end of 2017.
| 
 CRANECOMPANY  | 
||||||
| 
 2017  | 
 2016  | 
|||||
| Cash | 
 $9,930  | 
 $4,010  | 
||||
| Accounts receivable | 
 20,450  | 
 12,910  | 
||||
| Short-term investments | 
 22,070  | 
 30,030  | 
||||
| Inventory | 
 42,300  | 
 35,310  | 
||||
| Prepaid rent | 
 3,020  | 
 12,090  | 
||||
| Prepaid insurance | 
 2,090  | 
 90  | 
||||
| Supplies | 
 1,010  | 
 75  | 
||||
| Land | 
 124,270  | 
 175,470  | 
||||
| Buildings | 
 353,500  | 
 353,500  | 
||||
| Accumulated depreciation—buildings | 
 (105,150  | 
 )  | 
 (87,890  | 
 )  | 
||
| Equipment | 
 526,140  | 
 396,090  | 
||||
| Accumulated depreciation—equipment | 
 (129,450  | 
 )  | 
 (111,310  | 
 )  | 
||
| Patents | 
 45,390  | 
 49,550  | 
||||
| Total assets | 
 $915,570  | 
 $869,925  | 
||||
| Accounts payable | 
 $21,800  | 
 $32,080  | 
||||
| Income taxes payable | 
 5,020  | 
 3,970  | 
||||
| Salaries and wages payable | 
 4,950  | 
 3,000  | 
||||
| Short-term notes payable | 
 10,060  | 
 10,060  | 
||||
| Long-term notes payable | 
 60,060  | 
 69,370  | 
||||
| Bonds payable | 
 397,380  | 
 397,380  | 
||||
| Premium on bonds payable | 
 30,200  | 
 32,145  | 
||||
| Common stock | 
 239,140  | 
 221,530  | 
||||
| Paid-in capital in excess of par—common stock | 
 24,850  | 
 17,400  | 
||||
| Retained earnings | 
 122,110  | 
 82,990  | 
||||
| Total liabilities and stockholders’ equity | 
 $915,570  | 
 $869,925  | 
||||
| 
 CRANE COMPANY  | 
||||||
| Sales revenue | 
 $1,157,060  | 
|||||
| Cost of goods sold | 
 748,200  | 
|||||
| 
 408,860  | 
||||||
| Gross margin | ||||||
| Operating expenses | ||||||
| Selling expenses | 
 $78,550  | 
|||||
| Administrative expenses | 
 156,290  | 
|||||
| Depreciation/Amortization expense | 
 39,560  | 
|||||
| Total operating expenses | 
 274,400  | 
|||||
| Income from operations | 
 134,460  | 
|||||
| Other revenues/expenses | ||||||
| Gain on sale of land | 
 7,950  | 
|||||
| Gain on sale of short-term investment | 
 3,980  | 
|||||
| Dividend revenue | 
 2,380  | 
|||||
| Interest expense | 
 (51,810  | 
 )  | 
 (37,500  | 
 )  | 
||
| Income before taxes | 
 96,960  | 
|||||
| Income tax expense | 
 39,460  | 
|||||
| Net income | 
 57,500  | 
|||||
| Dividends to common stockholders | 
 (18,380  | 
 )  | 
||||
| To retained earnings | 
 $39,120  | 
|||||
Prepare a statement of cash flows for Crane Company using the
direct method accompanied by a reconciliation
schedule. Assume the short-term investments are debt securities,
classified as available-for-sale. (Show amounts in the
investing and financing sections that decrease cash flow with
either a - sign e.g. -15,000 or in parenthesis e.g.
(15,000).)
| Crane Company | ||
| Statement of Cash Flows | ||
| For the year ended December 31, 2017 | ||
| Cash Flows from Operating Activities | ||
| Cash receipts from customers | $ 1,149,520.00 | |
| Cash paid to suppliers of inventory | $ -765,470.00 | |
| Cash paid for operating expenses | $ -226,755.00 | |
| Cash paid for income taxes | $ -38,410.00 | |
| Net Cash Flows from Operating Activities | $ 118,885.00 | |
| Cash Flows from Investing Activities | ||
| Dividend Revenue | $ 2,380.00 | |
| Cash received from sale of land | $ 59,150.00 | |
| Cash received from sale of short term investments | $ 11,940.00 | |
| Cash paid for acquiring equipment | $ -130,050.00 | |
| Net cash used in Investing Activities | $ -56,580.00 | |
| Cash Flows from Financing Activities | ||
| Cash received from the issuance of common stock | $ 25,060.00 | |
| Cash paid for retiring long term notes payable | $ -9,310.00 | |
| Cash paid for dividends | $ -18,380.00 | |
| Cash paid for interest | $ -53,755.00 | |
| Net cash used in Financing Activities | $ -56,385.00 | |
| Net increase in cash | $ 5,920.00 | |
| Cash, December 31, 2016 | $ 4,010.00 | |
| Cash, December 31, 2017 | $ 9,930.00 | |