Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Is conflict always unhealthy? Why or why not? (Objective 4)

Answered: 1 week ago