hi, please post answers in chart format for each transaction listed in the transaction list - thank you!

please no spam answers

The City of Waterman established a capital projects fund for the construction of an access ramp from the parking garage to the city's office building to be used by individuals with disabilities. The estimated cost of the ramp is $229,000. On January 1,202, a 10 percent, $155,000 bond issue was sold at 103 with the premium transferred to the debt service fund. At that date, the county board provided a $74,000 grant. After a period of negotiation, the city council awarded a construction contract for $181,000 on April 5, 202. The ramp was completed on August 8,202; its actual cost was $187,000. The city council approved payment of the total actual cost of $187,000. In addition to the $187,000, the ramp was carpeted with all-weather material at a cost of $7,500. On November 3,202, the city council gave the final approval to pay for the ramp and the carpeting. After all bills were paid, the remaining fund balance was transferred to the debt service fund. The City of Waterman established a debt service fund to account for the financial resources used to service the bonds issued to finance the ramp is $229,000. The 10 percent, $155,000 bond issue was sold at 103 on January 1,202. It is a 10-year serial bond issue. The resources to pay the interest and annual principal will be from a property tax levy. Additional Information: 1. The operating budget for 202 included estimated revenue of $38,100, Budgeted appropriations included $15,500 for principal, $15,500 for interest, and $5,200 for other items. The budget also included an estimated transfer in of $7,100 from the capital projects fund. 2. The property tax levy was for $42,700 and an allowance for uncollectibles of $5,600 was established. Collections totaled $35,400. The remaining taxes were reclassified as delinquent and the allowance was reduced to $1,700. The bond premium was received from the capital projects fund. 3. The current portion of the serial bonds and the interest due this year were recorded and paid. Other expenses charged to the debt service fund totaled $1,800, of which $1,400 was paid. 4. The nominal accounts were closed. Required: a, Prepare entries for the debt service fund for 202. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Journal entry worksheet fecord the budget: Irom tne capita projects runa. 3. The current portion of the serial bonds and the interest due this year we service fund totaled $1,800, of which $1,400 was paid. 4. The nominal accounts were closed. Required: a. Prepare entries for the debt service fund for 202. (If no entry is require required" in the first account field.) A Record the budget. B Record the tax levy. C Record the tax collections. D Record the entry for the revised estimates of the uncollectibles and reclassify the remaining receivables. E Record the receipt of bond premium. F Record the matured principal and interest. G Record the payment of the matured principal and interest. Note : = journal entry has been entered F Record the matured principal and interest. G Record the payment of the matured principal and interest. H Record the other expenditures. I Record the payment of the approved vouchers. 3 Record the transfer of the unspent funds in the capital projects fund to the debt service fund. K Record the entry to close the budgetary accounts. L Record the entry to close the nominal accounts. Note : = journal entry has been entered b. Prepare a balance sheet for the debt service fund as of December 31,202. \begin{tabular}{|l|l|} \multicolumn{2}{c|}{CITYOFWATERMANDebtServiceFundBalanceSheetDecember31,20X2} \\ \hline Assets: & \\ \hline & \\ \hline & \\ \hline Total Assets & \\ \hline Liabilities: & \\ \hline Fund Balance: \\ \hline Spendable: \\ \hline Assigned to: \\ \hline Total Liabilities and Fund Balance & \\ \hline \end{tabular} c. Prepare a statement of revenues, expenditures, and changes in fund balance for the debt service fund for 202