The following is the comparative balance sheet as of December 31, 2019 and 2018 and the income statement for the year ended December 31, 2019 for Lynbrook Inc.:
Lynbrook Inc. |
|||||||
Comparative Balance Sheet |
|||||||
December 31, 2019 and 2018 |
|||||||
Assets: |
2019 |
2018 |
|||||
Cash |
$ 39 |
$ 81 |
|||||
Accounts receivable |
640 |
588 |
|||||
Inventory |
650 |
610 |
|||||
Total current assets |
1,329 |
1,279 |
|||||
Property, Plant & Equipment |
1,505 |
1484 |
|||||
Less: Accumulated depreciation |
(770) |
(651) |
|||||
Net Property, Plant & Equipment |
735 |
833 |
|||||
Total Assets |
$ 2,064 |
$ 2,112 |
|||||
Liabilities and Stockholders' |
|||||||
Equity |
|||||||
Current liabilities |
|||||||
Accounts payable |
$ 260 |
$ 160 |
|||||
Accrued liabilities |
180 |
170 |
|||||
Income tax payable |
77 |
72 |
|||||
Total current liabilities |
517 |
402 |
|||||
Bonds payable |
415 |
600 |
|||||
Total liabilities |
932 |
1,002 |
|||||
Shareholders' Equity: |
|||||||
Common stock |
145 |
145 |
|||||
Retained earnings |
987 |
965 |
|||||
Total stockholders' equity |
1,132 |
1,110 |
|||||
Total Liabilities and Stockholder's |
|||||||
Equity |
$ 2,064 |
$ 2,112 |
|||||
Lynbrook Inc. |
|||||||
Income Statement |
|||||||
For the year ended December 31, 2019 |
|||||||
Sales |
$ 3,700 |
||||||
Cost of goods sold |
2,540 |
||||||
Gross Margin |
1,160 |
||||||
Selling and administrative expenses |
880 |
||||||
Net operating income |
280 |
||||||
Other income and expenses |
|||||||
Gain on sale of equipment |
2 |
||||||
Income before taxes |
282 |
||||||
Income tax expense |
112 |
||||||
Net Income |
$ 170 |
The accounting department at Lynbrook provided the additional information for you on the next page.
The company sold equipment that had an original cost of $12 million and accumulated depreciation of $7 million. The cash proceeds from the sale were $7 million. The gain on the sale was $2 million.
The company purchased equipment for cash during the year.
The company did not issue any new bonds during the year.
The company paid a cash dividend during the year.
The company did not issue or repurchase any shares of common stock during the year.
Required:
Prepare a complete statement of cash flows for the year (operating, investing, and financing). Use the indirect method to prepare the operating activities section of the statement.
Reminder: Continue using the excel HW policies for preparing your solutions to the above questions, including the standard four line heading.
Lynbrook Inc. | ||
Statement of cash flow | ||
As at December 31 | ||
Particulars | Amount ($) | Amount ($) |
cash flow from operating activities | ||
Net income | 170 | |
Adjustments | ||
gain on sale of equipment | -2 | |
Depreciation | 126 | |
Increase in account receivable (640-588) | -52 | |
Increase in inventory (650-610) | -40 | |
Increase in account payable (260-160) | 100 | |
Increase in accrued liabilities (180-170) | 10 | |
Increase in income tax payable (77-72) | 5 | |
147 | ||
Net cash provided by operating activities | 317 | |
Cash flow from investing activities | ||
Purchase of equipment | -33 | |
sale of equipment | 7 | |
Net cash provided by investing activities | -26 | |
Cash flow from financing activities | ||
retirement of bonds payable (415-600) | -185 | |
payment of cash dividend (965+170-987) | -148 | |
Net cash provided by financing activities | -333 | |
Net increase in cash | -42 | |
Cash at the beginning | 81 | |
cash at end of period | 39 | |
Depreciation expense | ||
770-651+7 = 126 | ||
purchase of equipment | ||
1505-1484+12 = 33 | ||
The following is the comparative balance sheet as of December 31, 2019 and 2018 and the...
The following is the comparative balance sheet as of December 31, 2019 and 2018 and the income statement for the year ended December 31, 2019 for Lynbrook Inc.: Lynbrook Inc. Comparative Balance Sheet December 31, 2019 and 2018 Assets: 2019 2018 Cash $ 39 $ 81 Accounts receivable 640 588 Inventory 650 610 Total current assets 1,329 1,279 Property, Plant & Equipment 1,505 1484 Less: Accumulated depreciation (770) (651) Net Property, Plant & Equipment 735 833 Total Assets $ 2,064...
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 $ $...
Following is a partially completed balance sheet for Epsico Inc. at December 31, 2019, together with comparative data for the year ended December 31, 2018. From the statement of cash flows for the year ended December 31, 2019. you determine the following (amounts in thousands of dollars): Net income for the year ended December 31, 2019, was $104. Dividends paid during the year ended December 31, 2019, were $32. Cash increased $32 during the year ended December 31, 2019 The...
2018 CRUZ, INC. Comparative Balance Sheets December 31, 2019 2019 Assets Cash $ 62,800 Accounts receivable, net 27.000 Inventory 56,600 Prepaid expenses 3,500 Total current assets 149,900 Furniture 70,500 Accum. depreciation-Furniture (10,900) Total assets $209,500 Liabilities and Equity Accounts payable $ 9,900 Wages payable 5,900 Income taxes payable 1.000 Total current liabilities 16,800 Notes payable (long-term) 20,700 Total liabilities 37,500 Equity Common stock, $5 par value 150,000 Retained earnings 22.000 Total liabilities and equity $209,500 $ 15,700 33.300 62,500 2,900...
need to find the sale of equipment Veesperna Company Balance Sheet As at December 31 2018 2017 Assets Current Assets Cash Accounts Receivable Merchandise Inventory Total Current Assets Land Equipment Less: Accumulated Depreciation $-55,000 $-69,000 Total Assets $109,915 $75,100 $47,600 $29,900 $78,600 $46,500 $236,115 $151,500 $96,000 $103,000 $106,000 $139,000 $383,115 $324,500 Liabilities and Equity Liabilities Current Liabilities Accounts Payable Taxes Payable Total Current Liabilities Bonds Payable Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and...
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 $ $ $...
2018 CRUZ, INC. Comparative Balance Sheets December 31, 2019 2019 Assets Cash $ 99,300 Accounts receivable, net 42,600 Inventory 89, 100 Prepaid expenses 5,600 Total current assets 236,600 Furniture 113,000 Accum. depreciation-Furniture (17,500) Total assets $332,100 Liabilities and Equity Accounts payable $ 15,700 Wages payable 9,400 Income taxes payable 1,500 Total current liabilities 26,600 Notes payable (long-term) 30,900 Total liabilities 57,500 Equity Common stock, $5 par value 241,200 Retained earnings 33,400 Total liabilities and equity $332,100 $ 24,900 52,800 99,200...
Prepare a Cash Flow statement using indirect method Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 Assets 2019 2018 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...
Press Exercise Equipment, Inc. Comparative Balance Sheet December 31, 2018 and 2017 2018 2017 Assets Current Assets: Cash $ 19,000 $ 18,000 Accounts Receivable 52.000 49,000 Merchandise Inventory 81,000 85,000 Long-term Assets: Plant Assets 269,100 219,600 Accumulated Depreciation Plant Assets (45,100) 98,000 (36,600) 75,000 Investments Total Assets $ 474,000 $ 410,000 Liabilities Current Liabilities: Accounts Payable Salaries Payable Long-term Liabilities: $ 78,000 $ 2,500 72,000 3,500 60,000 71,000 Notes Payable Total Liabilities 140,500 146,500 Stockholders' Equity Common Stock, no par...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash $ 7 $ 11 Accounts receivable 309 229 Inventory 158 196 Prepaid expenses 9 5 Total current assets 483 441 Property, plant, and equipment 509 430 Less accumulated depreciation (86 ) (71 ) Net property, plant, and equipment 423 359 Long-term investments 27 33 Total assets $ 933 $ 833 Liabilities and Stockholders' Equity Accounts payable $ 304 $...