Question
Please prepare the journal entries and financial statements as governmental fund activities (i.e., fund accounting). Do not prepare or include government-wide activities (i.e., governmental activities).
Please prepare the journal entries and financial statements as governmental fund activities (i.e., fund accounting). Do not prepare or include government-wide activities (i.e., governmental activities).
Requirement Please finish 31-40 journal entries!
Transactions and events occurred during fiscal 2017:
The city council of Rapid City approved the following budgets for fiscal 2017:
General Fund:
Estimated Revenues | |
Property Taxes | $( $8,899,000 + 500,000) |
Sales Taxes | ($4,433,000 + 200,000) |
Intergovernmental Grants | (35% x $4,433,000) |
Licensing Fees and Fines | (20% x 889,000) |
Total Estimated Revenues | |
Appropriations | |
Food Inspection Program | $( $4,433,000 600,000) |
Salaries Food Inspection Program | ($8,899,000 400,000) |
Supplies Other Programs | 889,000 |
Other Program Costs | 685,000 |
Transfer to Debt Service Fund | 135,000 |
Total Appropriations | |
Budgeted Change in Fund Balance |
Capital Projects Fund:
Estimated Revenues | ||
Intergovernmental Grants | $ 600,000 | |
Investment Income | 100,000 | |
Total Estimated Revenues | $ 700,000 | |
Appropriations | ||
Park Construction | $5,400,000 | |
Park Equipment | 660,000 | |
Transfer to Debt Service Fund | 50,000 | |
Total Appropriations | 6,110,000 | |
Budgeted Change in Fund Balance | ($5,410,000) |
Debt Service Fund:
Estimated Revenues | ||
Special Tax Assessment | $ 460,000 | |
Investment Income | 4,000 | |
Total Estimated Revenues | $ 464,000 | |
Estimated Other Financing Sources | ||
Transfer in From General Fund | 135,000 | |
Transfer in From Capital Projects Fund | 50,000 | |
Total Estimated Other Financing Sources | $ 185,000 | |
Appropriations | ||
Interest | $225,000 | |
Principal | 280,000 | |
Total Appropriations | ( 505,000) | |
Budgeted Change in Fund Balance | $ 144,000
|
2. Purchase orders issued but not received by December 31, 2016 were received in January 2017 for $4,000. 3. The city collected 98% of the delinquent property taxes outstanding at the end of 2016 in the General Fund. The remaining delinquent amount was written off as uncollectible. All of the late payment penalties and interest (100%) were collected. Hint: Remember when writing off (eliminating) uncollectible reserves, revenue is recognized. Originally setting up uncollectible allowance amounts reduced revenue. 4. The state paid the amount owed to the city as of December 31, 2016. 5. In January 2017, the Capital Projects Fund invested the bonds issued in December 2016 in a 6-month CD bearing interest at 4.25% per annum. 6. The city paid the amount due to Federal government related to payroll taxes. 7. The city authorized temporary borrowing of $500,000 as a 120-day tax anticipation note. The loan was obtained from a local bank at 6%. (Record only the receipt of the loan at this time.) 8. The city received an advance of 80% of the budgeted intergovernmental grant in the General Fund from the state for the food inspection program. 9. The city levied property taxes at the budgeted amount and established an allowance for uncollectible taxes and discounts equal to 5% of the taxes levied. 10. The city levied the special tax assessment to service the bond issue for the new city park. The city levied $460,000 in anticipation of realizing net cash of $437,000, establishing a $23,000 allowance for uncollectible taxes and discounts. 11. Purchase orders for supplies were placed in the amount of $(889,000 + 10,000). 12. The city entered into two construction contracts for the new city park: (a) Hillside Construction Co. for $4,825,000 and (b) Palmer Engineering for $675,000. 13. The city collected 95% of the property taxes levied in 2017. Taxpayers deducted $(1% of levied property taxes JE #9) in discounts for early payment of bills. 14. The city repaid the tax anticipation loan, plus interest, to the bank. 15. The city approved encumbrances of $685,000 for Other program costs. 16. The General Fund transferred the $135,000 to the Debt Service Fund for principle payment on the Capital Project Fund bonds. 17. The city collected $410,000 of the special assessment tax bills, after taxpayers deducted $3,200 in discounts for early payment. 18. All remaining unpaid special assessment taxes were declared delinquent. The city comptroller concluded that a 1% allowance for uncollectible taxes is necessary for the delinquent special assessment taxes. 19. The city paid 65% of the budgeted amount to operate the food inspection program. 20. The city received $500,000 of the federal grant for the construction of the new city park. Based on the provisions of the grant, the city recognized the amount received as revenue. The grant stipulated that the park must be completed by the end of the fiscal year in order to receive the remaining $50,000 pledged to the project.
21. The Debt Service Fund paid the first installment payment plus interest on the bonds issued for the new city park. 22. The CD in the Capital Projects Fund matured and the city received the principle and interest from the CD. 23. The city vouchered $675,000 related to the encumbered Other Program Costs. (Journal entry #15) 24. During 2017, the city collected 97% of the budgeted amount of sales taxes. 25. Hillside Construction completed 70% of the work on the park and submitted an invoice for $3,400,000. Palmer Engineering also completed 80% of their work and submitted an invoice for $540,000. The city vouchered these invoices. 26. The city billed 80% of the budgeted amount of licensing fees and fines (through violation notices). There is no uncollectible allowance account for licensing fees and fines receivable. 27. The city received and vouchered invoices totaling 85% of the amount in journal entry #11 for payment. The amount encumbrances related to these invoices total 90% of the amount in journal entry #11 related to Supplies Other Programs. 28. The city canceled encumbrances totaling 3.5% of the amount in journal entry #11 related to Supplies Other Programs. 29. The city paid the vouchered construction contracts (journal entry #25), less 5% retainage. 30. The city ordered park equipment in the amount of $700,000 for the new city park.
31. The city paid the previously vouchered invoices related to the Other Program Costs. (journal entry #23) 32. Salaries of 95% of the budgeted salaries were recorded as Salaries Food Inspection Program during the year. Of this amount, the following were withheld from employees: 15% for federal income taxes, 5% for state income taxes, 7.65% for FICA taxes. The remaining amount was paid to employees. 33. The city recorded its share of FICA tax liability (7.65%) related to the food inspection program salaries. 34. The park equipment ordered in journal entry #30 was received and inspected. The city vouchered the invoice amount of $680,000. 35. The city collected 94% of the amount billed for license fees and fines in cash during the year and expects to collect the rest during the first 60 days of 2018. (Refer to journal entry #26) 36. The city paid 30% of the budgeted amount for the food inspection program. 37. The city filed a claim for the balance due from the state for the food inspection program and recognized the revenue from the grant since the program expenditures were now paid. (See journal entries #8) 38. The city paid for the vouchered supplies received earlier (journal entry #27). 39. The new city park was completed on time, but a little over budget. The federal government was billed for the remaining $50,000 grant, which is expected to be collected in the first 60 days of fiscal 2017. 40. The city received and vouchered the final invoices for the construction of the city park: (a) Hillside Construction for $1,540,000 and (b) Palmer Engineering for $140,000.
General Fund Postclosing Trial Balance December 31, 2016 Debits Credits Additional Information: Cash $295,600 1. Encunbrances lapse if they are outstanding at the close of a fisca year, however, the city honors all Property Taxes Receivable Deliquent 57.000 outstanding encumbrances, reported at the end of 2016 are reported as Fund Balance Assigned 2. The city uses the purchases method to record the acquisition of supplies. The year-end supplies inventory lowance for Uncollectible Deinquent Taxes Interest and Penalties Receivable llowance for Uncollectible Interest & Penalties Supplies Inventory Vauchers Payable Due to Federal Govemment Fund Balance Nonspendable Supplies Inventory Fund Balance Assigned Fund Balance Unassigned 500 ,200 is considered to be material and is reported in the city's financial statements 200 7,700 36 400 2 800 7,700 300 310 600 364,500 Rapid City Capital Projects Fund Postclosing Trial Balance December 31, 2016 Additional Information: 1. Rapid City sold bonds in the amounit of S5,400,000 in December 2016 to finance a new city park 2. In 2016, the State approved a grant for S250,000 to help furnd the city park. The grant is colectible within 3. Rapid City uses cncumbrance accounting in the Capital Projects Fund. Credits Debits $5,400,000 Cash Duc frorn State Government Fund Balance Restricted The bonds are payable semiannually (June 1 and December 1) over 20 years at 4% per year 250,000 $5,850,000 $5,850,000 60 days after year end The Federal govemment also approved a grant for $550,000, receivable June 1, 2016 S5,850,000 4. Construction of the park is expected to be completed by the cnd of 2017. Any aounts remaining in the Capital Projects Fund must be transferred to the Debt Service Fund on completion of the park Rapid City Debt Service Fund Postclosing Trial Balance December 31, 2016 Additional Information: Debits Credits 1. In December, $140,000 was transferred to the Debl Service Fund from the General Fund to pay the first cipal payment on the bonds issued in the Capital Projects Fund and provide a small cash balance in the Cash $140,000 Fund Balancc Restricted $140,000 deht service fund General Fund Postclosing Trial Balance December 31, 2016 Debits Credits Additional Information: Cash $295,600 1. Encunbrances lapse if they are outstanding at the close of a fisca year, however, the city honors all Property Taxes Receivable Deliquent 57.000 outstanding encumbrances, reported at the end of 2016 are reported as Fund Balance Assigned 2. The city uses the purchases method to record the acquisition of supplies. The year-end supplies inventory lowance for Uncollectible Deinquent Taxes Interest and Penalties Receivable llowance for Uncollectible Interest & Penalties Supplies Inventory Vauchers Payable Due to Federal Govemment Fund Balance Nonspendable Supplies Inventory Fund Balance Assigned Fund Balance Unassigned 500 ,200 is considered to be material and is reported in the city's financial statements 200 7,700 36 400 2 800 7,700 300 310 600 364,500 Rapid City Capital Projects Fund Postclosing Trial Balance December 31, 2016 Additional Information: 1. Rapid City sold bonds in the amounit of S5,400,000 in December 2016 to finance a new city park 2. In 2016, the State approved a grant for S250,000 to help furnd the city park. The grant is colectible within 3. Rapid City uses cncumbrance accounting in the Capital Projects Fund. Credits Debits $5,400,000 Cash Duc frorn State Government Fund Balance Restricted The bonds are payable semiannually (June 1 and December 1) over 20 years at 4% per year 250,000 $5,850,000 $5,850,000 60 days after year end The Federal govemment also approved a grant for $550,000, receivable June 1, 2016 S5,850,000 4. Construction of the park is expected to be completed by the cnd of 2017. Any aounts remaining in the Capital Projects Fund must be transferred to the Debt Service Fund on completion of the park Rapid City Debt Service Fund Postclosing Trial Balance December 31, 2016 Additional Information: Debits Credits 1. In December, $140,000 was transferred to the Debl Service Fund from the General Fund to pay the first cipal payment on the bonds issued in the Capital Projects Fund and provide a small cash balance in the Cash $140,000 Fund Balancc Restricted $140,000 deht service fund
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started