In: Accounting
Problem 23-04
Sarasota Company had the following information available at the end of 2020.
SARASOTACOMPANY |
||||||
2020 |
2019 |
|||||
Cash |
$9,950 |
$4,010 |
||||
Accounts receivable |
20,550 |
12,960 |
||||
Short-term investments |
21,830 |
29,800 |
||||
Inventory |
42,340 |
35,030 |
||||
Prepaid rent |
2,990 |
12,090 |
||||
Prepaid insurance |
2,090 |
91 |
||||
Supplies |
990 |
75 |
||||
Land |
124,970 |
174,030 |
||||
Buildings |
353,000 |
353,000 |
||||
Accumulated depreciation—buildings |
(104,980 |
) |
(86,810 |
) |
||
Equipment |
522,130 |
396,610 |
||||
Accumulated depreciation—equipment |
(128,890 |
) |
(111,580 |
) |
||
Patents |
44,790 |
49,520 |
||||
Total assets |
$911,760 |
$868,826 |
||||
Accounts payable |
$21,970 |
$31,740 |
||||
Income taxes payable |
5,030 |
3,980 |
||||
Salaries and wages payable |
4,980 |
3,020 |
||||
Short-term notes payable |
10,080 |
10,080 |
||||
Long-term notes payable |
60,150 |
70,050 |
||||
Bonds payable |
396,540 |
396,540 |
||||
Premium on bonds payable |
23,170 |
27,926 |
||||
Common stock |
241,390 |
218,640 |
||||
Paid-in capital in excess of par—common stock |
25,100 |
17,500 |
||||
Retained earnings |
123,350 |
89,350 |
||||
Total liabilities and stockholders’ equity |
$911,760 |
$868,826 |
SARASOTA COMPANY |
||||||
Sales revenue |
$1,170,900 |
|||||
Cost of goods sold |
752,630 |
|||||
418,270 |
||||||
Gross margin | ||||||
Operating expenses | ||||||
Selling expenses |
$78,540 |
|||||
Administrative expenses |
156,760 |
|||||
Depreciation/Amortization expense |
40,210 |
|||||
Total operating expenses |
275,510 |
|||||
Income from operations |
142,760 |
|||||
Other revenues/expenses | ||||||
Gain on sale of land |
7,960 |
|||||
Gain on sale of short-term investment |
4,000 |
|||||
Dividend revenue |
2,380 |
|||||
Interest expense |
(51,710 |
) |
(37,370 |
) |
||
Income before taxes |
105,390 |
|||||
Income tax expense |
39,370 |
|||||
Net income |
66,020 |
|||||
Dividends to common stockholders |
(32,020 |
) |
||||
To retained earnings |
$34,000 |
Prepare a statement of cash flows for Sarasota Company using the
direct method accompanied by a reconciliation schedule. Assume the
short-term investments are debt securities, classified as
available-for-sale.
Cash Flow Statement | |||
Direct Method | |||
Cash flow from Operating Activities | |||
Cash Receipts | |||
Cash Collected from customers | $ 1,163,310 | =1170900+12960-20550 | |
Dividend Revenue | $ 2,380 | ||
$ 1,165,690 | |||
Cash Payments | |||
Cash paid to Suppliers | $ 769,710 | =752630+31740-21970+42340-35030 | |
Cash paid for Selling & Admin expenses | $ 227,154 | =78540+156760+3020-4980+2990-12090+2090-91+990-75 | |
Cash paid for Interest | $ 56,466 | =51710+27926-23170 | |
Cash paid for Income tax | $ 38,320 | =39370+3980-5030 | |
Total Cash Outflows | $ 1,091,650 | ||
Cash from operating activities | $ 74,040 | ||
Cash flow from Investing Activities | |||
Sale of Short term Investments | $ 11,970 | =29800-21830+4000 | |
Sale of Land | $ 57,020 | =174030-124970+7960 | |
Purchase of Equipment | $ (125,520) | =396610-522130 | |
Cash from investing activities | $ (56,530) | ||
Cash flow from Financing Activities | |||
Issue of common stock | $ 30,350 | =241390+25100-218640-17500 | |
Repayment of Notes payable | $ (9,900) | =60150-70050 | |
Dividend Paid | $ (32,020) | ||
Cash used in financing activities | $ (11,570) | ||
Net Increase in cash | $ 5,940 | ||
Cash balance, prior year | $ 4,010 | ||
Cash balance, current year | $ 9,950 |
Cash Flow Statement | ||
Indirect Method | ||
Cash flow from Operating Activities | ||
Net Income | $ 66,020 | |
Adjustments | ||
Depreciation / Amortization | $ 40,210 | |
Gain on sale of investment | $ (4,000) | |
Gain on sale of land | $ (7,960) | |
Change In current assets & Liabilities | ||
Increase in Accounts Receivable | $ (7,590) | |
Increase in Inventory | $ (7,310) | |
Decrease in Prepaid Rent | $ 9,100 | |
Increase in Prepaid Insurance | $ (1,999) | |
Increase in Supplies | $ (915) | |
Decrease in Accounts payable | $ (9,770) | |
Increase in Income Tax payable | $ 1,050 | |
Increase in Salaries and Wages payable | $ 1,960 | |
Decrease in Premium on Bonds payable | $ (4,756) | |
Total Adjustments | $ 8,020 | |
Net Cash from operating activities | $ 74,040 |