The balance sheet data of Naley Company at the end of 2019 and 2018 follow: 2019 2018 Cash $ 50,000 $ 70,000 Accounts receivable (net) 120,000 90,000 Merchandise inventory 140,000 90,000 Prepaid expenses 20,000 50,000 Buildings and equipment 180,000 150,000 Accumulated depreciation—buildings and equipment (36,000) (16,000) Land 180,000 80,000 Totals $654,000 $514,000 Accounts payable $136,000 $110,000 Accrued expenses 24,000 36,000 Notes payable—bank, long-term 80,000 Mortgage payable 60,000 Common stock, $10 par 418,000 318,000 Retained earnings (deficit) 16,000 (30,000) $654,000 $514,000 Land was acquired for $100,000 in exchange for common stock, par $100,000, during the year; all equipment purchased was for cash. Equipment costing $10,000 was sold for $4,000; book value of the equipment was $8,000 and the loss was reported as an ordinary item in net income. Cash dividends of $20,000 were charged to retained earnings and paid during the year; the transfer of net income to retained earnings was the only other entry in the Retained Earnings account. For the year ending December 31, 2019, calculate the following amounts:
a) The net cash provided (used) by operating activities
b) The net cash provided (used) by investing activities
c) The net cash provided (used) by financing activities
| Cash Flow Statement | ||
| Opening Balance | 70000 | |
| Cash flow from Operating Activities: | 56000 | |
| Net profit | 66000 | |
| Less : Increase in Current Assets: | ||
| Account Receivable | -30000 | |
| Inventory | -50000 | |
| Add : Decrease in Current Assets: | ||
| Prepaid Expenses | 30000 | |
| Add : Increase in Current Liabilities: | ||
| Accounts payables | 26000 | |
| Less : Decrease in Current Liabilities: | ||
| Accured Exp | -12000 | |
| Add: Loss on sale | 4000 | |
| Add: Depreciation | 22000 | |
| Cash flow from investing Activities: | -36000 | |
| Assets Sold | 4000 | |
| Assets Purchase | -40000 | |
| Cash flow from financing Activities: | -40000 | |
| Dividends Paid | -20000 | |
| Long Term Loan Paid | -80000 | |
| Mortage | 60000 | |
| Closing Balance | 50000 | |
| Working Note: | ||
| Calculation of Net Profit | ||
| Retained Earnings Opening Balance | -30000 | |
| Dividen Paid | 20000 | |
| Retained Earnings Closing Balance | 16000 | |
| Net Profit | 66000 | |
| Calculation of Loss on Fixed Assets | ||
| Book Value | 8000 | |
| Sale for | 4000 | |
| Loss on Sale | 4000 | |
| Calculation of Purchase of Fixed Assets | ||
| Opening Balance | 150000 | |
| Closing Balance | 180000 | |
| Cost of Asset Sold | 10000 | |
| Purchase amount | 40000 | |
| Calculation of Dep. For Current Year | ||
| Opening Accu. Dep. | 16000 | |
| Closing Accu. Dep. | 36000 | |
| Dep. Of asset sold | 2000 | |
| Current Year Dep. | 22000 |
The balance sheet data of Naley Company at the end of 2019 and 2018 follow: 2019...
Problem 8 The balance sheet data of Naley Company at the end of 2019 and 2018 follow: 2019 2018 $_50.000 Cash Accounts receivable (net) $ 70,000 90,000 120,000 Merchandise inventory 140,000 Prepaid expenses Buildings and equipment 90,000 50,000 150,000 180,000 (36,000) Accumulated depreciation-buildings and equipment Land Totals Accounts payable Accrued expenses Notes payable-bank, long-term Mortgage payable $654.000 $136,000 24,000 (16,000) 80,000 $514.000 $110,000 36,000 80,000 60,000 418,000 318,000 Common stock, $10 par Retained earnings (deficit) 16,000 $654.000 30,000) $514.000 Land...
The balance sheet data of Ke Company at the end of 2020 and 2019 follow: 2020 2019 Cash $100,000 $140,000 Accounts Receivable (net) 240,000 180,000 Inventory 280,000 180,000 Prepaid expenses 40,000 100,000 Buildings and equipment 360,000 300,000 Accumulated depreciation - buildings and equipment (72,000) (32,000) Land 360,000 160,000 Total Assets $1,308,000 $1,028,000 Accounts payable $272,000 $220,000 Accrued expenses 48,000 72,000 Mortgage payable 120,000 160,000 Common stock, $10 par 836,000 636,000 Retained earnings 32,000 (60,000) Total liabilities and equity $1,308,000 $1,028,000...
Prepare a Cash Flow Statement.
Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2018 2019 $ Assets Current Assets: Cash Accounts Receivable, net Merchandise Inventory Supplies Prepaid Insurance Total Current Assets 65,000 150,000 135,000 9,700 30,000 389,700 $ $ $ $ $ $ 80,000 100,000 70,000 500 10,000 260,500 $ Property, plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment Total Assets $ $ $ $ 500,000 (80,000) 420,000 809,700 $ $...
The balance sheet data of Pronghorn Company at the end of 2020 and 2019 are shown below. 2020 2019 Cash $29,800 $35,200 Accounts receivable (net) 55,300 45,200 Inventory 65,200 45,500 Prepaid expenses 15,000 25,200 Equipment 89,900 74,600 Accumulated depreciation—equipment (17,980 ) (7,900 ) Land 70,600 40,300 $307,820 $258,100 Accounts payable $65,500 $52,100 Accrued expenses 15,000 17,900 Notes payable—bank, long-term –0– 23,100 Bonds payable 30,300 –0– Common stock, $10 par 188,000 157,700 Retained earnings 9,020 7,300 $307,820 $258,100 Land was acquired...
he balance sheet data of Culver Company at the end of 2020 and 2019 are shown below. 2020 2019 Cash $30,100 $35,100 Accounts receivable (net) 55,000 44,900 Inventory 64,600 45,100 Prepaid expenses 15,000 24,700 Equipment 90,200 74,500 Accumulated depreciation—equipment (18,040 ) (8,000 ) Land 70,200 39,800 $307,060 $256,100 Accounts payable $64,600 $52,500 Accrued expenses 14,800 17,900 Notes payable—bank, long-term –0– 22,900 Bonds payable 30,300 –0– Common stock, $10 par 190,400 160,000 Retained earnings 6,960 2,800 $307,060 $256,100 Land was acquired...
Using horizontal analysis, perpare a Comparative Balance
Sheet.
Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, net Merchandise Inventory Supplies Prepaid Insurance Total Current Assets $ $ $ $ $ $ 65,000 150,000 135,000 9,700 30,000 389,700 $ $ $ $ $ $ 80,000 100,000 70,000 500 10,000 260,500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, plant, and Equipment Total Assets $ $ $...
Following are selected balance sheet accounts of Despacito Corp. at December 31, 2018 and 2017, and the increases or decreases in each account from 2017 to 2018. Also presented is selected income statement information for the year ended December 31, 2018, and additional information. Increase Selected balance sheet accounts 2018 2017 (Decrease) Assets: Accounts receivable $100,000 $ 94,000 6,000 Inventory 55,000 70,000 (15,000) Prepaid Expenses 30,000 25,000 5,000 Property, plant, and equipment 400,000 200,000 200,000 Accumulated depreciation (200,000) (180,000) 20,000 Deferred tax asset 30,000 40,000 (10,000) Liabilities and stockholders’ equity: Accounts payable 400,000 420,000 (20,000) Interest payable 8,000 6,000 2,000 Accrued expenses payable 10,000 7,000 3,000...
Following are selected balance sheet accounts of Despacito Corp. at December 31, 2018 and 2017, and the increases or decreases in each account from 2017 to 2018. Also presented is selected income statement information for the year ended December 31, 2018, and additional information. Selected balance sheet accounts 2018 2017 (Decrease) Assets: Accounts receivable $100,000 $ 94,000 6,000 Inventory 55,000 70,000 (15,000) Prepaid Expenses 30,000 25,000 5,000 Property, plant, and equipment 400,000 200,000 200,000...
Prepare Statement of cash flows for current year using indirect
method.
Dynamic Drones Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, Net Merchandise Inventory Prepaid Rent Total Current Assets $60,000 $140,000 $110,000 $20,000 $330,000 $80,000 $100,000 $70,000 $10,000 $260,000 Property, plant, and Equipment: Equipment $400,000 Less: Accumulated Depreciation - Equipment ($60,000) Total Property, Plant, and Equipment $340,000 Total Assets $670,000 $191,000 ($42,400) $148,600 $408,600 2019 2018 Liabilities and Stockholders' Equity Current Liabilities:...
Using horizontal analysis, prepare a Comparative Balance
Sheet. (all the information is given in the pictures)
Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, net Merchandise Inventory Supplies Prepaid Insurance Total Current Assets $ $ $ $ $ $ 65,000 150,000 135,000 9,700 30,000 389,700 $ $ $ $ $ $ 80,000 100,000 70,000 500 10,000 260,500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property,...