In: Accounting
The following information (presented in thousands) is available for the Cumberland County Utility Enterprise Fund during the current year:
The beginning balance for cash and cash equivalents was $86,810 and for restricted cash was $12,438.
The utility collected $2,500 in customer deposits throughout the year. Deposits of $1,100 were returned, and accounts of $200 were written off.
Cash paid to vendors totaled $20,269, while cash paid to employees was $35,230.
The utility repaid revenue bonds restricted for capital acquisitions in the amount of $17,450 and issued new debt of $15,510 to acquire new equipment. Equipment costing $8,120 was purchased for cash during the year.
Cash receipts came from customers, $112,913; interest on investments, $930; a transfer from the General Fund, $5,000; and interest on customer deposits, $625. (Assume that interest on customer deposits is not restricted.)
Required
Prepare a statement of cash flows for the Cumberland County Utility
Enterprise Fund. (Ignore the reconciliation of operating income to
net cash provided by operating activities because insufficient
information is provided to complete the reconciliation.)
(Negative amounts should be indicated by a minus
sign.)
Below is a skelton of what the statement of cash flows should look like, it is missing amounts and some lines
CUMBERLAND COUNTY
Enterprise Fund
Statement of Cash FlowsFor the Current Year Ended
Cash Flows from Operating Activities:
Cash Received From Customers
Cash Provided From Customer Deposits
Cash Paid To:Employees
Vendors
?___________
Net Cash Provided by Operations
Cash Flows from Noncapital Financing Activities
:Transfer From General Fund
Net Cash Provided by Noncapital Financing Activites
Cash Flows from Capital Financing Activities:
Purchase of New Equipment
________?____________
_____________?__________
______________?__________
Net Cash Used by Capital Financing Activities
Cash Flows from Investing Activities:
Interest Received
___________?__________
Net Cash Provided by Investing Activities
Net Increase in Cash and Cash Equivalents
Cash and Cash Equivalents,
BeginningCash and Cash Equivalents,
Ending
Cash flow from operating activities : | |
Cash received from customer | 112913 |
Cash provided from customer deposits (2500-1100) | 1400 |
Cash paid to employees | (35230) |
Cash paid to vendors | (20269) |
Net cash provided by operations | 58814 |
Cash flow from non capital financing activities | |
Transfer from general fund | 5000 |
Net cash provided by non capital financing activities | 5000 |
Cash flow from capital financing activities | |
Purchase of new equipment | (8120) |
Utility repaid | (17450) |
Issued new debt | 15510 |
Net cash used by capital financing activities | (10060) |
Cash flow from investing activities | |
Interest received on investment | 930 |
Interest received on customer deposits | 625 |
Net cash provided by investing activities | 1555 |
Net increase in Cash and cash equivalents | 55309 |
Beginning Cash and cash equivalents (86810+12438) | 99248 |
Ending Cash and cash equivalents | $154557 |