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 $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 the amount of $18,680 and issued new debt of $16,620 to acquire new equipment. Equipment costing $8,650 was purchased for cash during the year. Cash receipts came from customers, $112,685; interest on investments, $985; 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.)

CUMBERLAND COUNTY
Enterprise Fund
Statement of Cash Flows
For the Current Year Ended
Cash Flows from Operating Activities:
Cash Received From Customers
Cash Provided From Customer Deposits
Cash Paid To:
Employees
Vendors
0
Net Cash Provided by Operations $0
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
Debt Payment
Proceeds from Issuance of Dept
Net Cash Used by Capital Financing Activities 0
Cash Flows from Investing Activities:
Interest Received
Net Cash Provided by Investing Activities 0
Net Increase in Cash and Cash Equivalents 0
Cash and Cash Equivalents, Beginning
Cash and Cash Equivalents, Ending $0

Solutions

Expert Solution

CUMBERLAND COUNTY
Enterprise Fund
Statement of Cash Flows
For the Current Year Ended

Cash Flows from Operating Activities:  

  
Cash Received From Customers 112,685      
Cash Provided From Customer Deposits 775
Cash Paid To:
Employees -35,260
Vendors -20,233
Net Cash Provided by Operations $57967

Cash Flows from Noncapital Financing Activities:

Transfer From General Fund 5,000
Net Cash Provided by Noncapital Financing Activites $5,000

Cash Flows from Capital Financing Activities:

Purchase of New Equipment -8,650
Debt Payment -18,680
Proceeds from Issuance of Dept 16,620
Net Cash Used by Capital Financing Activities $-10,710

Cash Flows from Investing Activities:

Interest Received 985
Net Cash Provided by Investing Activities $985
Net Increase in Cash and Cash Equivalents 53242
Cash and Cash Equivalents, Beginning 100764
Cash and Cash Equivalents, Ending $ 154006

Pl note interest paid on customer deposits has been reduced from the amount received from customer deposits as no specific head is appropriate for it.

Pl note following is the calculation for amount received from customer deposit:

Amount collected 2500

amount returned 1100

interest to customer 625

Net 775


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 $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...
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