Prepare a statement of net position for water utility fund

Assignment Help Financial Accounting
Reference no: EM131443007

Assignment

Complete the following problems and exercises, showing all work and submit in the classroom.

1. Long-term Liability Transactions. Following are a number of unrelated transactions for the Village of Centerville, some of which affect governmental activities at the government-wide level. None of the transactions have been recorded yet.

• The General Fund collected and transferred $750,000 in tax collections to the debt service fund; $600,000 of this amount was used to retire outstanding serial bonds and the remainder was used to make the interest payment on the outstanding serial bonds.

• A $5,000,000 issue of serial bonds to finance a capital project was sold at 102 plus accrued interest in the amount of $50,000. The accrued interest and the premium were recorded in the debt service fund. Accrued interest on bonds sold must be used for interest payments; the premium is designated by state law for eventual payment of bond principal.

• The debt service fund made a $110,000 capital lease payment, of which $15,809 was interest. Funds used to make the lease payment came from a capital grant received by the special revenue fund.

• Tax-supported serial bonds with a $2,800,000 par value were issued in cash to permit partial refunding of a $3,500,000 par value issue of term bonds. The difference was settled with $700,000 that had been accumulated in prior years in a debt service fund. Assume that the term bonds had been issued several years earlier at par.

• Four months prior to year-end, 6 percent special assessment bonds totaling $500,

• 000 were issued to fund a streetlight improvement project in a local subdivision. The bonds are secondarily backed by the village. The first $25,000 installment will be due from property owners six months after the initial bond issuance, but no debt payments are due in the first year.

• Marketable equity securities held by the debt service fund increased in value by $10,000 during the year.

Using this information

a. Prepare in general journal form the necessary entries in the governmental activities and appropriate fund journals for each transaction. Explanations may be omitted. For each entry you prepare, name the fund in which the entry should be made.

2. Serial Bond Debt Service Fund Journal Entries and Financial Statements. As of December 31, 2016, Sandy Beach had $9,500,000 in 4.5 percent serial bonds outstanding. Cash of $509,000 is the debt service fund's only asset as of December 31, 2016, and there are no liabilities. The serial bonds pay interest semiannually on January 1 and July 1, with $500,000 in bonds being retired on each interest payment date. Resources for payment of interest are transferred from the General Fund, and the debt service fund levies property taxes in an amount sufficient to cover principal payments.

a. Prepare debt service fund and government-wide entries in general journal form to reflect, as necessary, the following information and transactions for FY 2017.

i. The operating budget for FY 2017 consists of estimated revenues of $1,020,000 and estimated other financing sources equal to the amount of interest to be paid in FY 2017. Appropriations must be provided for interest payments and bond redemptions on January 1 and July 1.

ii. Cash was received from the General Fund and checks were written and mailed for the January 1 principal and interest payments.

iii. Property taxes in the amount of $1,020,000 were levied (no estimate for uncollectible accounts has been made).

iv. Property taxes in the amount of $1,019,000 were collected.

v. Cash was received from the General Fund and checks were written and mailed for the July 1 principal and interest payments.

vi. Adjusting entries were made and uncollected taxes receivable were reclassified as delinquent. At the fund level, entries were also made to close budgetary and operating statement accounts. (Ignore closing entries in the government activities journal.)

b. Prepare a statement of revenues, expenditures, and changes in fund balances for the debt service fund for the year ended December 31, 2017.

c. Prepare a balance sheet for the debt service fund as of December 31, 2017.

3. Central Garage Internal Service Fund. The City of Ashville operates an internal service fund to provide garage space and repairs for all city-owned-and-operated vehicles. The Central Garage Fund was established by a contribution of $300,000 from the General Fund on July 1, 2017, at which time the land and building were acquired. The post-closing trial balance at June 30, 2017, was as follows:

 

Debits

Credits

Cash

$110,000


Due from Other Funds

$9,000


Inventory of Supplies

$90,000


Land

$50,000


Building

$250,000


Allowance for Depreciation--Building


$20,000

Machinery and Equipment

$65,000


Allowance for Depreciation-- Machinery and Equipment


$12,000

Vouchers Payable


$31,000

Net Position--Net Investment in Capital Assets


$333,000

Nets Position--Unrestricted


$178,000

Total

$574,000

$574,000

The following information applies to the fiscal year ended June 30, 2017:

• Supplies were purchased on account for $92,000; the perpetual inventory method is used.

• The cost of supplies used during the year ended June 30, 2017, was $110,000. A physical count taken as of that date showed materials and supplies on hand totaled $72,000 at cost.

• Salaries and wages paid to employees totaled $235,000, including related costs.

• Billings totaling $30,000 were received from the enterprise fund for utility charges. The Central Garage Fund paid $27,000 of the amount owed.

• Depreciation of the building was recorded in the amount of $10,000; depreciation of the machinery and equipment amounted to $9,000.

• Billings to other departments for services provided to them were as follows:

General Fund

$270,000

Special Revenue Fund

127,000

• Unpaid interfund receivable balances were as follows:

 

6/30/16

6/30/17

General Fund

$2,500

$3,000

Special Revenue Fund

6,500

9,000

• Vouchers payable at June 30, 2017, were $16,000.

• For June 30, 2017, closing entries were prepared for the Central Garage Fund (ignore government-wide closing entry).

Using this information

a. Assume all expenses at the government-wide level are charged to the General Government function. Prepare journal entries to record all of the trans- actions for this period in the Central Garage Fund accounts and in the governmental activities accounts.

b. Prepare a statement of revenues, expenses, and changes in net position for the Central Garage Fund for the period ended June 30, 2017.

c. Prepare a statement of net position for the Central Garage Fund as of June 30, 2017.

d. Explain what the Central Garage Fund would need to report at the governmental activities level, and where the information would be reported.

4. Enterprise Fund Journal Entries and Financial Statements. Following is the June 30, 2017, statement of net position for the City of Bay Lake Water Utility Fund.

CITY OF BAY LAKE
Water Utility Fund
Statement of Fund Net Position
June 30, 2013

Assets



Current assets:



Cash and investments


$1,775,019

Accounts receivable (net of $13,367 provision for uncollectible accounts)     


$306,869

Accrued utility revenue


$500,000

Due from General Fund


$29,311

Interest receivable


$82,000

Total current assets


$2,693,199

Restricted assets:



Cash


$9,193

Capital assets:



Land

$1,780,945


Buildings (net of $3,420,000 in  accumulated depreciation)

$5,214,407


Machinery and equipment (net of $5,129,928 in accumulated depreciation)

$8,488,395


Total capital assets (net)


$15,483,747

Total Assets


$18,186,139

Liabilities



Current liabilities:



Accounts payable

$532,047


Interest payable

$131,772


Current portion of long-term debt

$400,000


Total current liabilities


$1,063,819

Liabilities payable from restricted assets:



Customer deposits


$9,193

Long-term liabilities:



Revenue bond payable


$11,600,000

Total Liabilities


$12,673,012

Net Position



Net investment in capital assets


$3,483,747

Unrestricted


$2,029,380

 


$5,513,127

a. For fiscal year 2017, prepare general journal entries for the Water Utility Fund using the following information.

o The amount in the Accrued Utility Revenue account was reversed.

o Billings to customers for water usage during fiscal year 2017 totaled $2,982,557; $193,866 of the total was billed to the General Fund.

o Cash in the amount of $260,000 was received. The cash was for interest earned on investments and $82,000 in accrued interest.

o Expenses accrued for the period were: management and administration, $360,408; maintenance and distribution, $689,103; and treatment plant, $695,237.

o Cash receipts for customer deposits totaled $2,427.

o Cash collections on customer accounts totaled $2,943,401, of which $209,531 was from the General Fund.

o Cash payments for the period were as follows: Accounts Payable, $1,462,596; interest (which includes the interest payable), $395,917; bond principal, $400,000; machinery and equipment, $583,425; and return of customer deposits, $912.

o A state grant amounting to $475,000 was received to help pay for new water treatment equipment.

o Accounts written off as uncollectible totaled $10,013.

o The utility fund transferred $800,000 in excess operating income to the General Fund.

o Adjusting entries for the period were recorded as follows: depreciation on buildings was $240,053 and on machinery and equipment was $360,079; the allowance for uncollectible accounts was increased by $14,913; an accrual for unbilled customer receivables was made for $700,000; accrued interest income was $15,849; and accrued interest expense was $61,406.

o The Revenue Bond Payable account was adjusted by $400,000 to record the current portion of the bond.

o Closing entries and necessary adjustments were made to the net position accounts.

o Prepare a statement of revenues, expenses, and changes in fund net position for the Water Utility Fund for the year ended June 30, 2017.

o Prepare a statement of net position for the Water Utility Fund as of June 30, 2017.

o Prepare a statement of cash flows for the Water Utility Fund as of June 30, 2017.

Reference no: EM131443007

Questions Cloud

Collapse of communism in eastern europe : What were the primary causes for the collapse of communism in Eastern Europe (Poland, Germany, Czechoslovakia, Hungary, Romania, etc) in 1989, and the USSR (Russia, Ukraine, Belarus, Georgia, etc) in 1991
Discuss the consumer price index : The Consumer Price Index (CPI) measures changes in the cost of living by comparing the cost of buying a certain bundle of goods and services over time.
Importance of american history towards : Discuss the importance of American History towards the economic needs of the nation?
Historical context and significance : Identify the following event listed below. In a brief paragraph, explain who or what it is, where and when it occurred-identifying the time period (be as specific as possible with the date)-and the historical context and significance.
Prepare a statement of net position for water utility fund : Prepare a statement of revenues, expenses, and changes in fund net position for the Water Utility Fund for the year ended June 30, 2017. Prepare a statement of net position for the Water Utility Fund as of June 30, 2017.
Americas in terms of culture-religion and technology : Explain the incredible impact that Spain's conquest had on Americas in terms of culture, religion and technology?
Federal troops and states started to pass black codes : What happened in the South after the US government began to remove federal troops and states started to pass black codes?
What should the manufacturing company set as its target : STAT3701 STATISTICAL SCIENCE and STAT8701 STATISTICAL SCIENCE GE HOMEWORK EXERCISE. What should the manufacturing company set as its target weight in order for 97.5% of its bags to have a weight of at least 100 kg
History channel documentary the rise of the third reich : History Channel Documentary The Rise of the Third Reich. After watching this video What shocked you? What was unexpected? In what ways did Hitler win over the German people?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd