In: Accounting
The City of Saltwater Beach established an enterprise fund in 2015 to construct and operate Tribute Aquatic Center, a public swimming pool. The pool was completed and began operations in 2016. All costs, including repayment of debt, are to be paid by user fees. The fund’s pre-closing trial balance as of December 31, 2017 is shown below. |
Debits | Credits | ||||||||
Cash and Cash Equivalents | $ | 182,640 | |||||||
Accounts Receivable | 5,240 | ||||||||
Supplies | 8,250 | ||||||||
Restricted Cash and Cash Equivalents | 944,860 | ||||||||
Land | 1,404,250 | ||||||||
Buildings and Equipment | 927,810 | ||||||||
Accumulated Depreciation—Buildings and Equipment | $ | 41,750 | |||||||
Improvements Other Than Buildings | 4,729,160 | ||||||||
Accumulated Depreciation—Improvements Other Than Buildings | 212,810 | ||||||||
Accounts and Accrued Payables | 22,210 | ||||||||
Current Portion of Long-Term Debt—Bonds | 282,370 | ||||||||
Bonds Payable | 6,212,140 | ||||||||
Net Position—Net Investment in Capital Assets | 174,490 | ||||||||
Net Position—Restricted | 869,390 | ||||||||
Net Position—Unrestricted | 84,260 | ||||||||
Charges for Services | 2,045,580 | ||||||||
Interest and Dividend Income | 92,750 | ||||||||
Personnel Expenses | 1,036,800 | ||||||||
Utilities Expense | 189,010 | ||||||||
Repairs and Maintenance | 82,320 | ||||||||
Supplies Expense | 67,380 | ||||||||
Depreciation Expense | 137,330 | ||||||||
Interest Expense | 322,700 | ||||||||
$ | 10,037,750 | $ | 10,037,750 | ||||||
Additional information concerning the Tribute Aquatic Center Fund follows. | |
1. | All bonds payable were used to acquire property, plant, and equipment. |
2. |
Each year a payment is required on January 1 to retire an equal portion of the bonds payable. The payment for the current year was paid on January 1, 2017. |
3. | Equipment was sold for cash at its carrying value of $9,270. |
4. |
Total cash received from customers was $2,042,720 and cash received for interest and dividends was $92,750; of this amount $75,470 was restricted cash. There were no other changes to restricted cash during the year. |
5. |
Cash payments included $1,041,020 for personnel expenses, $186,200 for utilities, $86,420 for repairs and maintenance, $322,700 for interest on bonds, and $66,040 for supplies. |
6. |
The beginning balance in Cash was $98,120, Accounts Receivable was $3,170, Supplies was $9,560 and Accounts and Accrued Payables was $28,480. Accrued Payables include personnel expenses, utilities, and repairs and maintenance. |
7. |
The net position categories shown on the pre-closing trial balance have not been updated to reflect correct balances as of the December 31, 2017 year end. |
Required |
2.
Required information
a. |
Prepare the statement of revenues, expenses and changes in fund net position for the Tribute Aquatic Center as of December 31, 2017. (Negative amounts should be indicated by a minus sign.) |
3.
Required information
b. | Prepare the statement of net position for the Tribute Aquatic Center as of December 31, 2017. |
Part A
Statement of revenues, expenses and changes in fund net position for the Tribute Aquatic Center
December 31, 2017
Operating income : | ||
Charges for services | 2045580 | |
Operating expenses : | ||
Personnel expense | 1036800 | |
Utilities expense | 189010 | |
Repairs and maintenance expense | 82320 | |
Supplies expense | 67380 | |
Depreciation expense | 137330 | |
Total operating expense | (1512840) | |
Operating income | 532740 | |
Non operating revenue /expense | ||
Interest income | 92750 | |
Interest expense | (322700) | |
Total non operating income (expense) | (229250) | |
Change in net position | 302790 | |
Net position, January 1 | 1128140 | |
Net position, December 31 | 1430930 | |
Part B
Statement of Net position
Assets: | |||
Current assets: | |||
Cash and cash equivalents | 182640 | ||
Accounts receivable | 5240 | ||
Supplies | 8250 | ||
Total current assets | 196130 | ||
Restricted cash and cash equivalents | 944860 | ||
Capital assets : | |||
Land | 1404250 | ||
Building and equipment | 927810 | ||
Less: allowance for depreciation | (41750) | 886060 | |
Improvements other than building | 4729160 | ||
Less: allowance for depreciation | (212810) | 4516350 | |
Total capital assets | 6806660 | ||
Total assets | 7947650 | ||
Liabilities: | |||
Current liabilities : | |||
Accounts and accrued payables | 22210 | ||
Current portfolio of long term debt | 282370 | ||
Total current liabilities | 304580 | ||
Non current liabilities | |||
Bonds payable | 6212140 | ||
Total liabilities | 6516720 | ||
Net position : | |||
Net investment in capital assets | 477280 | ||
Restricted | 869390 | ||
Unrestricted | 84260 | ||
Total net position | 1430930 | ||