Problem 17-45 (Static) (LO 17-7, 17-8, 17-9, 17-11)

The City of Pfeiffer starts the year of 2020 with the general fund and an enterprise fund. The general fund has two activities: education and parks/recreation. For convenience, assume that the general fund holds $123,000 cash and a new school building costing $1 million. The city utilizes straight-line depreciation. The building has a 20-year life and no residual value. The enterprise fund has $62,000 cash and a new $600,000 civic auditorium with a 30-year life and no residual value. The enterprise fund monitors one activity, the rental of the civic auditorium for entertainment and other cultural affairs.

The following transactions for the city take place during 2020. Assume that the citys fiscal year ends on December 31.

Decides to build a municipal park and transfers cash of $70,000 into a capital projects fund. Both the creation of this fund and the transfer were made by the highest level of government authority. The city immediately expends $20,000 to acquire three acres of land.

Borrows $110,000 cash on a long-term bond for use in creating the new municipal park.

Assesses property taxes on the first day of the year. The assessment, which is immediately enforceable, totals $600,000. Of this amount, $510,000 will be collected during 2020. Officials expect another $50,000 during the first month of 2021. They anticipate the remainder halfway through 2021.

Constructs a covered building in the new municipal park for $80,000 cash so that local citizens can play basketball when it rains. The building is put into service on July 1. It should last 10 years with no expected residual value.

Builds a sidewalk through the new park for $10,000 cash and puts it into service on July 1. The sidewalk should normally last for 10 years, but the city plans to keep it fixed up to a predetermined quality level so that it can last almost indefinitely.

Opens the park and charges an entrance fee of only a token amount. The city reports the park within its general fund. Collections during the first year of operations total $8,000.

Buys a new parking deck for $200,000, paying $20,000 cash and signing a long-term note for the rest. The parking deck, which goes into operation on July 1, is across the street from the civic auditorium and is considered part of that activity. It has a 20-year life and no residual value.

Receives a $100,000 cash grant for the city school system that must be spent for school lunches for children in low-income families. Officials view the appropriate spending of these funds as an eligibility requirement of this grant. During the current year, $37,000 of the amount received was spent for the intended purpose.

Charges students in the school system a total fee of $6,000 for books and the like. Of this amount, 90 percent is collected during 2020 with the remainder expected to be collected in the first few weeks of 2021.

Buys school supplies for $22,000 cash and uses $17,000 of them. The general fund applies the purchases method.

Receives a painting by a local artist to be displayed in the local school. It qualifies as a work of art, and officials have chosen not to capitalize it. The painting has a value of $80,000. Officials have set up security precautions so that the painting will be viewed as inexhaustible.

Transfers $20,000 cash from the general fund to the enterprise fund as a capital contribution.

Orders a school bus for $99,000.

Receives the school bus and pays an actual cost of $102,000, including transportation and other necessary costs. The bus goes into operation on October 1. It should last for five years with no residual value.

Pays salaries of $240,000 to school teachers. In addition, owes and will pay $30,000 during the first two weeks of 2021. Vacations worth $23,000 have also been earned by the teachers but will not be taken until July 2021.

Pays salaries of $42,000 to city auditorium workers. In addition, owes and will pay $3,000 in the first two weeks of 2021. Vacations worth $5,000 have also been earned by the workers but will not be taken until July 2021.

Charges customers $130,000 for short-term rental of the civic auditorium. Of this balance, collects $110,000 in cash and will collect the remainder in April 2021.

Pays $9,000 maintenance charges for the building and sidewalk in (d) and (e).

Pays $14,000 on the bond in (b) on the last day of 2020: $5,000 principal and $9,000 interest.

Accrues interest of $13,000 on the note in (g) as of the end of 2020, an amount the city will pay in June 2021.

Assumes a museum operating within the city is a component unit that will be discretely presented. The museum reports to city officials that it incurred $42,000 of direct expenses this past year and earned $50,000 in revenues from admission charges. The only assets held at year-end were cash of $24,000, building (net of depreciation) of $300,000, and a long-term liability of $210,000.

Prepare the 2020 fund financial statements for (a) the governmental funds and (b) the proprietary funds. A statement of cash flows is not required. Assume the city defines available as within 60 days and that all funds qualify as major. Assume that major funds are labeled as Special Revenue Fund and Capital Projects Fund. The general fund is used for debt repayment.

Complete this question by entering your answers in the tabs below.

Rev Ex Fund Bal

BALANCE SHEET

Rev Ex Net Pos

STMT OF NET POS

Prepare the 2020 statement of revenues, expenditures, and other changes in fund balance for Governmental Funds. Assume the city defines available as within 60 days and that all funds qualify as major. Assume that major funds are labeled as Special Revenue Fund and Capital Projects Fund. The general fund is used for debt repayment.

CITY OF PFEIFFER
Statement of Revenues, Expenditures, and Other Changes in Fund Balance
Fund Financial Statements Governmental Funds
Year ending December 31, 2020
	General Fund	Special Revenue Funds	Capital Projects Funds	Total Governmental Funds
Revenues:
Property taxes
Park
Operating grant
School fees
Total revenues
Expenditures:
Land
Buildings
Sidewalk
School lunches
Supplies
School bus
Salaries
Maintenance
Interest
Bond payment
Total expenditures
Excess (deficiency) of revenues over expenditures
Other financing sources (uses):
Other financing sources
Other financing uses
Total other financing sources (uses)
Change in fund balance
Fund balance-Beginning
Fund balance-Ending

Prepare the 2020 statements of balance sheet for Governmental Funds. Assume the city defines available as within 60 days and that all funds qualify as major. Assume that major funds are labeled as Special Revenue Fund and Capital Projects Fund. The general fund is used for debt repayment.

Prepare the 2020 statement of revenues, expenses, and other changes in net position for Proprietary funds. Assume the city defines available as within 60 days and that all funds qualify as major. Assume that major funds are labeled as Special Revenue Fund and Capital Projects Fund. The general fund is used for debt repayment.

Prepare the 2020 statement of net position for the Proprietary Funds. Assume the city defines available as within 60 days and that all funds qualify as major. Assume that major funds are labeled as Special Revenue Fund and Capital Projects Fund. The general fund is used for debt repayment.