In: Accounting
E7-23 Enterprise Fund Statement of Cash Flows [LO 7-5]
|
Inglis City had a beginning cash balance in its enterprise fund of $895,635. During 2017, the following transactions occurred: |
| 1. | Interest received on investments totaled $42,400. |
| 2. | The city acquired additional equity investments totaling $75,000. |
| 3. | A grant was received from the state in the amount of $50,000 for summer interns. |
| 4. | Receipts from sales of goods or services totaled $2,915,500. |
| 5. | Payments for supplies were made in the amount of $1,642,100. |
| 6. | Payments to employees for salaries amounted to $479,300. |
| 7. | Equipment was sold for $57,500. It had a book value of $56,625. |
| 8. | $25,000 was transferred to the General Fund. |
| 9. | Other cash expenses for operations were $89,200. |
| 10. | Long-term debt payments totaled $525,000. |
| Required |
|
Prepare a statement of cash flows for the Inglis City enterprise fund. |
Can you provide the reconciliation of operating income to net cash provided by operating activities
Solution
INGLIS CITYENTERPRISE FUND
STATEMENT OF CASH FLOWS
FOR THE YEAR ENDED DECEMBER 31, 2017
|
Particulars |
Amount ($) |
Amount ($) |
Amount ($) |
|
(A)Cash flows from operating activities: |
|||
|
Cash received from customers |
2,915,500 |
||
|
Cash paid to: |
|||
|
Suppliers |
(1,642,100) |
||
|
Employees |
(479,300) |
||
|
Other |
(89,200) |
(2,210,600) |
|
|
Net cash provided by operations |
704,900 |
||
|
(B) CASH FLOWS FROM NON-CAPITAL FINANCING ACTIVITIES: |
|||
|
Grant from state for summer interns |
50,000 |
||
|
Transfer to general fund |
(25,000) |
||
|
Net cash provided by noncapital financing activities |
25,000 |
||
|
(C) CASH FLOWS FROM CAPITAL FINANCING ACTIVITIES: |
|||
|
Proceeds from sale of capital assets |
57,500 |
||
|
Debt payment |
|
||
|
Net cash used by capital financing activities |
(467,500) |
||
|
(D) CASH FLOWS FROM INVESTING ACTIVITIES: |
|||
|
Purchase of investments |
(75,000) |
||
|
Interest received on investments |
42,400 |
||
|
Net cash provided by investing activities |
(32,600) |
||
|
NET INCREASE IN CASH AND CASH EQUIVALENTS (Total of A+ B+ C+D) |
229,800 |
||
|
Add: CASH AND CASH EQUIVALENTS, 1/1/2017 |
895,635 |
||
|
CASH AND CASH EQUIVALENTS, 12/31/2017 |
1,125,435 |