Question

In: Accounting

Comparative balance sheet accounts of Pina Company are presented below. PINA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...

Comparative balance sheet accounts of Pina Company are presented below. PINA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2017 2016 Cash $69,500 $50,900 Accounts Receivable 153,400 131,000 Inventory 75,300 60,900 Debt investments (available-for-sale) 54,800 85,600 Equipment 70,300 48,300 Buildings 143,900 143,900 Land 40,000 24,900 Totals $607,200 $545,500 Credit Balances Allowance for Doubtful Accounts $10,100 $7,900 Accumulated Depreciation—Equipment 20,800 14,000 Accumulated Depreciation—Buildings 36,900 27,700 Accounts Payable 66,500 59,600 Income Taxes Payable 11,900 10,100 Long-Term Notes Payable 62,000 70,000 Common Stock 310,000 260,000 Retained Earnings 89,000 96,200 Totals $607,200 $545,500

Additional data: 1. Equipment that cost $10,000 and was 60% depreciated was sold in 2017. 2. Cash dividends were declared and paid during the year. 3. Common stock was issued in exchange for land. 4. Investments that cost $34,700 were sold during the year. 5. There were no write-offs of uncollectible accounts during the year. Pina’s 2017 income statement is as follows. Sales revenue $946,900 Less: Cost of goods sold 602,300 Gross profit 344,600 Less: Operating expenses (includes depreciation expense and bad debt expense) 248,400 Income from operations 96,200 Other revenues and expenses Gain on sale of investments $14,900 Loss on sale of equipment (3,000 ) 11,900 Income before taxes 108,100 Income taxes 45,100 Net income $63,000

(a) Compute net cash provided by operating activities under the direct method. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Net cash flow from operating activities $

(b) Prepare a statement of cash flows using the indirect method.

Solutions

Expert Solution

STATEMENT OF CASH FLOWS (INDIRECT METHOD)
Cash flows from operating activities:
Net income $     63,000
Adjustments to net income to net cash provided by operating activities:
Depreciation Expense-Equipment [20800-14000+6000] $       12,800
Depreciation Expense-Building [36900-27700] $          9,200
Gain on sale of investments $      -14,900
Loss on sale of equipment $          3,000
Increase in accounts receivable (153400-10100-131000+7900) $      -20,200
Increase in inventory =75300-60900 = $      -14,400
Increase in accounts payable = 66500-59600 = $          6,900
Decrease in income tax payable = 11900-10100 = $          1,800 $   -15,800
Net cash provided by operating activities $     47,200
Cash flows from investing activities:
Purchase of investments (available for sale) = 54800-85600+34700 = $        -3,900
Sale of investments (available for sale)=34700+14900 = $       49,600
Purchase of equipment = 70300-48300+10000 = $      -32,000
Sale of equipment = 4000-3000 = $          1,000
Net cash used for investing activities $     14,700
Cash flows from financing activities:
Redemption of long term notes payable =70000-62000 = $        -8,000
Issuance of common stock =310000-260000-15100 = $       34,900
Payment of cash dividends =96200-89000+63000 = $      -70,200
Net cash provided by financing activities $   -43,300
Net increase in cash $     18,600
Beginning cash balance $     50,900
Ending cash balance $     69,500
Non-cash transactions:
Issue of common stock for purchase of land $       15,100
STATEMENT OF CASH FLOWS (DIRECT METHOD)
Cash flow from operating activities:
Collections from customers (946900+131000-153400) 924500
Payments to suppliers (602300+59600-66500+75300-60900) -609800
Operating expenses paid (248400-22000-2200) -224200
Income tax paid (45100+10100-11900) -43300
Net cash provided by operating activities 47200

Related Solutions

Comparative balance sheet accounts of Splish Company are presented below. SPLISH COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Splish Company are presented below. SPLISH COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $70,600 $50,500 Accounts Receivable 155,100 130,000 Inventory 75,600 61,100 Debt investments (available-for-sale) 55,100 84,300 Equipment 70,300 48,400 Buildings 144,400 144,400 Land 39,600 25,300      Totals $610,700 $544,000 Credit Balances Allowance for Doubtful Accounts $10,000 $7,900 Accumulated Depreciation—Equipment 21,000 14,100 Accumulated Depreciation—Buildings 37,300 28,200 Accounts Payable 66,400 60,600 Income Taxes Payable 11,900 9,900 Long-Term Notes Payable 62,000...
Comparative balance sheet accounts of Carla Company are presented below. CARLA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Carla Company are presented below. CARLA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $69,900 $50,600 Accounts Receivable 154,800 130,300 Inventory 75,700 61,400 Debt investments (available-for-sale) 55,100 84,600 Equipment 69,300 48,400 Buildings 145,700 145,700 Land 40,200 25,200      Totals $610,700 $546,200 Credit Balances Allowance for Doubtful Accounts $10,100 $7,900 Accumulated Depreciation—Equipment 21,000 14,000 Accumulated Depreciation—Buildings 36,800 28,100 Accounts Payable 65,600 59,500 Income Taxes Payable 12,000 10,100 Long-Term Notes Payable 62,000...
Comparative balance sheet accounts of Sweet Company are presented below. SWEET COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Sweet Company are presented below. SWEET COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $69,600 $51,100 Accounts Receivable 156,500 130,000 Inventory 75,700 60,800 Debt investments (available-for-sale) 55,000 85,300 Equipment 69,600 47,800 Buildings 144,900 144,900 Land 39,600 25,200      Totals $610,900 $545,100 Credit Balances Allowance for Doubtful Accounts $10,000 $8,000 Accumulated Depreciation—Equipment 20,800 14,100 Accumulated Depreciation—Buildings 37,000 27,900 Accounts Payable 66,500 59,800 Income Taxes Payable 11,900 10,000 Long-Term Notes Payable 62,000...
Comparative balance sheet accounts of Oriole Inc. are presented below. ORIOLE INC. COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Oriole Inc. are presented below. ORIOLE INC. COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31, 2020 AND 2019 December 31 Debit Accounts 2020 2019 Cash $42,200 $33,700 Accounts Receivable 70,800 60,200 Inventory 30,000 24,300 Equity investments 22,400 38,300 Machinery 30,100 18,800 Buildings 67,000 56,100 Land 7,500 7,500 $270,000 $238,900 Credit Accounts Allowance for Doubtful Accounts $2,200 $1,500 Accumulated Depreciation—Machinery 5,700 2,300 Accumulated Depreciation—Buildings 13,600 9,000 Accounts Payable 35,100 24,700 Accrued Payables 3,300 2,600 Long-Term Notes...
Comparative balance sheet accounts of Kingbird Inc. are presented below. KINGBIRD INC. COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Kingbird Inc. are presented below. KINGBIRD INC. COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31, 2020 AND 2019 December 31 Debit Accounts 2020 2019 Cash $42,200 $33,900 Accounts Receivable 71,100 59,600 Inventory 30,000 23,800 Equity investments 22,400 38,400 Machinery 30,200 18,600 Buildings 67,000 56,000 Land 7,500 7,500 $270,400 $237,800 Credit Accounts Allowance for Doubtful Accounts $2,300 $1,600 Accumulated Depreciation—Machinery 5,600 2,200 Accumulated Depreciation—Buildings 13,400 9,100 Accounts Payable 34,800 24,600 Accrued Payables 3,400 2,600 Long-Term Notes...
Comparative balance sheet accounts of Whispering Inc. are presented below. WHISPERING INC. COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Whispering Inc. are presented below. WHISPERING INC. COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31, 2017 AND 2016 December 31 Debit Accounts 2017 2016 Cash $42,400 $33,500 Accounts Receivable 70,200 59,800 Inventory 29,700 24,100 Equity investments 22,500 38,100 Machinery 30,100 18,900 Buildings 67,000 55,700 Land 7,400 7,400 $269,300 $237,500 Credit Accounts Allowance for Doubtful Accounts $2,200 $1,600 Accumulated Depreciation—Machinery 5,600 2,200 Accumulated Depreciation—Buildings 13,600 9,000 Accounts Payable 35,300 24,600 Accrued Payables 3,400 2,600 Long-Term Notes...
Comparative balance sheet accounts of Larkspur Inc. are presented below. LARKSPUR INC. COMPARATIVE BALANCE SHEET ACCOUNTS...
Comparative balance sheet accounts of Larkspur Inc. are presented below. LARKSPUR INC. COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31, 2017 AND 2016 December 31 Debit Accounts 2017 2016 Cash $42,300 $33,500 Accounts Receivable 70,600 59,900 Inventory 30,300 24,000 Equity investments 22,300 38,200 Machinery 29,900 18,700 Buildings 67,300 56,200 Land 7,600 7,600 $270,300 $238,100 Credit Accounts Allowance for Doubtful Accounts $2,300 $1,500 Accumulated Depreciation—Machinery 5,700 2,300 Accumulated Depreciation—Buildings 13,600 9,100 Accounts Payable 35,000 24,800 Accrued Payables 3,400 2,600 Long-Term Notes...
Presented below is the comparative balance sheet for Martinez Company. Martinez Company Comparative Balance Sheet As...
Presented below is the comparative balance sheet for Martinez Company. Martinez Company Comparative Balance Sheet As of December 31, 2021 and 2020 December 31 2021 2022 Assets Cash $181,000 $272,500 Accounts receivable (net) 218,100 155,200 Short-term investments 271,100 149,100 Inventories 1,066,900 978,500 Prepaid expenses 24,800 24,800 Plant & equipment 2,604,700 1,948,400 Accumulated depreciation (1,003,600) (743,000) $3,363,000 $2,785,500 Liabilities and Stockholders’ Equity Accounts payable $49,800 $74,700 Accrued expenses 168,900 200,700 Bonds payable 452,100 189,100 Capital stock 2,108,600 1,782,200 Retained earnings 583,600...
Presented below is the comparative balance sheet for Windsor Company. Windsor Company Comparative Balance Sheet As...
Presented below is the comparative balance sheet for Windsor Company. Windsor Company Comparative Balance Sheet As of December 31, 2021 and 2020 December 31 2021 2022 Assets Cash $178,300 $276,000 Accounts receivable (net) 219,900 154,300 Short-term investments 269,400 149,700 Inventories 1,069,600 982,200 Prepaid expenses 24,900 24,900 Plant & equipment 2,604,600 1,968,800 Accumulated depreciation (990,000) (752,100) $3,376,700 $2,803,800 Liabilities and Stockholders’ Equity Accounts payable $49,900 $74,700 Accrued expenses 170,100 198,600 Bonds payable 446,600 188,900 Capital stock 2,109,800 1,777,900 Retained earnings 600,300...
Problem 23-08 Comparative balance sheet accounts of Coronado Company are presented below. CORONADO COMPANY COMPARATIVE BALANCE...
Problem 23-08 Comparative balance sheet accounts of Coronado Company are presented below. CORONADO COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2020 2019 Cash $69,600 $51,100 Accounts Receivable 156,500 130,000 Inventory 75,700 60,800 Debt investments (available-for-sale) 55,000 85,300 Equipment 69,600 47,800 Buildings 144,900 144,900 Land 39,600 25,200      Totals $610,900 $545,100 Credit Balances Allowance for Doubtful Accounts $10,000 $8,000 Accumulated Depreciation—Equipment 20,800 14,100 Accumulated Depreciation—Buildings 37,000 27,900 Accounts Payable 66,500 59,800 Income Taxes Payable 11,900 10,000 Long-Term Notes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT