Question

In: Accounting

The following information (presented in thousands) is available for the Cumberland County Utility Enterprise Fund during...

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

Solutions

Expert Solution

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

Related Solutions

The following information (presented in thousands) is available for the Cumberland County Utility Enterprise Fund during...
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 $87,810 and for restricted cash was $12,954. 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,233, while cash paid to employees was $35,260. The utility repaid revenue bonds restricted for capital acquisitions in...
Major Funds Lenox County provides the following information on its governmental and enterprise funds: Fund Assets...
Major Funds Lenox County provides the following information on its governmental and enterprise funds: Fund Assets Liabilities Revenues Expenditures/ Expenses General fund $64,000 $57,600 $544,000 $626,400 Grants special revenue fund 44,000 34,800 160,000 77,600 Parks and recreation special revenue fund 1,600 1,040 32,000 33,600 Licensed gaming special revenue fund 6,400 5,600 52,000 49,600 Roads capital projects fund 11,200 9,600 160,000 162,400 Bridges capital projects fund 28,000 24,000 96,000 92,000 Buildings capital projects fund 32,000 24,000 80,000 78,400 Water enterprise fund...
Suppose at December 31 of a recent year, the following information (in thousands) was available for...
Suppose at December 31 of a recent year, the following information (in thousands) was available for sunglasses manufacturer Oakley Inc.: ending inventory $175,000; beginning inventory $119,000; cost of goods sold $414,540 and sales revenue $773,000. Calculate the inventory turnover for Oakley, Inc. (Round inventory turnover to 2 decimal places, e.g. 5.12.) Calculate the days in inventory for Oakley, Inc. (Round days in inventory to 0 decimal places, e.g. 125.)
Suppose at December 31 of a recent year, the following information (in thousands) was available for...
Suppose at December 31 of a recent year, the following information (in thousands) was available for sunglasses manufacturer Oakley Inc.: ending inventory $153,357; beginning inventory $122,003; cost of goods sold $350,824 and sales revenue $820,884. Calculate the inventory turnover for Oakley, Inc. (Round inventory turnover to 2 decimal places, e.g. 5.12.) Inventory turnover = Calculate the days in inventory for Oakley, Inc. (Round days in inventory to 0 decimal places, e.g. 125.) Days in inventory =
The following balance sheet information is available (amounts in thousands of dollars and duration in years)...
The following balance sheet information is available (amounts in thousands of dollars and duration in years) for a financial institution: AssetsLiabilities and Equity in millions T-bills $ 95.00,  0.5 year T-notes $ 125.00, 0.9 year T-bonds $ 100.00 Loans $2,724.00 Deposits $2,092.00, 1 year Federal funds $ 282.00 0.01 year Equity $ 670.00 Treasury bonds are five-year maturities paying 6 percent semiannually and quoted at 0.92. a. What is the duration of the T-bond portfolio? b. What is the average duration...
Question 1 The following balance sheet information is available (amounts in $ thousands and duration in...
Question 1 The following balance sheet information is available (amounts in $ thousands and duration in years) for a financial institution Amount Duration T-bills 90 0.5 T-notes 55 0.9 T-bonds 176 To be calculated Loans 2724 7 Deposits 2092 1 Federal Funds 238 0.01 Equity 715 Treasury bonds are 5-year maturities paying 6% semiannually and selling at par What is the duration of the T-Bond portfolio? What is the average duration of all the assets? What is the average duration...
The following financial information is available for Longmire Lumber Ltd. as at December 31 (in thousands,...
The following financial information is available for Longmire Lumber Ltd. as at December 31 (in thousands, except for per share amounts): 2021 2020 2019 Profit $1,978 $2,131 $2,663 Preferred share dividends (total) $73 $43 $30 Weighted average number of common shares 502 500 501 Dividends per common share $2.50 $2.25 $2.10 Market price per common share $43.00 $49.75 $56.25 (a) Calculate the earnings per share, price-earnings ratio, and payout ratio for the common shareholders for each of the three years....
which of the following funds is a governmental fund? a. enterprise fund b. debt service fund...
which of the following funds is a governmental fund? a. enterprise fund b. debt service fund c. internal service fund d. custodial fund
The following information is available with respect to the purchases and sales of merchandise during the...
The following information is available with respect to the purchases and sales of merchandise during the first part of January 2019: Jan. 1                   opening inventory          3,000 units at $25.00 each          Jan. 10                purchased                         4,500 units at $35.00 each Jan. 12                sold                                    3,500 units Jan. 15                purchased                        1,000 units at $32.50 each Jan. 21                sold                                    1,500 units   Required: Calculate the Cost of Goods Sold and Ending Inventory using FIFO and Moving Weighted Average Cost using the...
The following information is available with respect to the purchases and sales of merchandise during the...
The following information is available with respect to the purchases and sales of merchandise during the first part of January 2019: Jan. 1                   opening inventory          3,000 units at $25.00 each          Jan. 10                purchased                         4,500 units at $35.00 each Jan. 12                sold                                    3,500 units Jan. 15                purchased                        1,000 units at $32.50 each Jan. 21                sold                                    1,500 units   Required: Calculate the Cost of Goods Sold and Ending Inventory using FIFO and Moving Weighted Average Cost using the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT