I need a cash flow statement prepared for the following problem?
Using the data provided in the sheet labeled "Cash Flows" prepare:
Statement of Cash Flows for fiscal year 2016 in proper format.
Use a separate sheet, appropriately named, for the Statement of Cash Flows.
| Cash and Cash Equivalents, January 1, 2016 |
66,200 |
| Cash and Cash Equivalents, December 31, 2016 |
57,870 |
| increase in accrued expenses |
500 |
| decrease in prepaid expenses |
960 |
| increase in inventories |
21,350 |
| decrease in income taxes payable |
3,500 |
| increase in accounts payable |
6,840 |
| gain on sale of investment |
11,000 |
| increase in accounts receivable |
19,380 |
| gain on sale of land |
20,500 |
| dividend payments |
32,840 |
| depreciation expense |
39,990 |
| payments for purchase of investments |
40,500 |
| payments for purchase of equipment |
56,200 |
| payments for ppuchase of land |
62,500 |
| proceeds from sale of land |
80,750 |
| proceeds from the issuance of stock |
81,000 |
| proceeds from sale of investments |
100,500 |
| net income |
111,400 |
| payments made to retire bonds payable |
150,000 |
| proceeds from the issueance of a mortgage |
175,000 |
| payments for purchase of building |
187,500
|
Let me know if you can complete this and how long it will take. also how much?