In: Accounting
a comparative balance sheet for ALPHAinc at December 31,2017 is shown below.
2017 2016 Change
cash 30,000 35,000 -5,000
accounts receivable 55,000 45,000 10,000
inventory 65,000 45,000 20,000
preppaid expense 15,000 25,000 -10,000
land 70,000 40,000 30,000
right of use of asset 100,000 0 100,000
equipment 90,000 75,000 15,000
accumulated depreciation -18,000 -8,000 -10,000
total 407,000 257,000 150,000
Accounts payable 65,000 52,000 13,000
accrued expense 15,000 18,000 3,000
notes payable 0 23,000 -23,000
bonds payable 30,000 0 30,000
lease liability 100,000 0 100,000
common stock($10par) 189,000 159,000 30,000
retained earnings 8,000 5,000 3,000
Total Liabilities and equity 407,000 257,000 150,000
Additional information and events:
a. land was acquired for $30,000 in exchange for common stock
b. equipment purchase was for cash
c. equipment costing $13,000 was sold for $3,000 the book value of this equipment was $ 6,000
d. Alpha entered in to a financial lease for an office building on december 31,2017 that the fair value was equal to the lease liability. the initial payment is due in january of 2018
e. cash dividends of $2,000 were declared and paid during the year.
f. net income was $5,000
Please help me prepare the operating, investing, and financial cash flow ....
ALPHA Inc. | ||
Statement of Cash Flows | ||
For the Year Ended December 31, 2017 | ||
Cash Flows from Operating Activities | ||
Net income | 5000 | |
Adjustments to reconcile net income to net cash provided by operations: | ||
Depreciation expense [($18000 - ($8000 - $7000)] | 17000 | |
Loss on sale of equipment ($6000 - $3000) | 3000 | |
Increase in accounts receivable | -10000 | |
Increase in inventory | -20000 | |
Decrease in prepaid expenses | 10000 | |
Increase in accounts payable | 13000 | |
Decrease in accrued expenses payable | -3000 | 10000 |
Net cash provided by operating activities | 15000 | |
Cash Flows from Investing Activities | ||
Purchase of equipment [$90000 - ($75000 - $13000)] | -28000 | |
Sale proceeds from equipment | 3000 | |
Net cash used by investing activities | -25000 | |
Cash Flows from Financing Activities | ||
Repayment of notes payable | -23000 | |
Issuance of bonds payable | 30000 | |
Payment of cash dividends | -2000 | |
Net cash provided by financing activities | 5000 | |
Net decrease in cash | -5000 | |
Cash balance, December 31, 2016 | 35000 | |
Cash balance, December 31, 2017 | 30000 |