Need help with part D only please! Part D here, the information to solve it is below.
The City of Castletons General Fund had the following post-closing trial balance at June 30, 2022, the end of its fiscal year:
DebitsCreditsCash$438,000Sales Taxes Receivable19,000Taxes ReceivableDelinquent591,000Allowance for Uncollectible Delinquent Taxes$197,000Interest and Penalties Receivable27,080Allowance for Uncollectible Interest and Penalties11,960Inventory of Supplies16,900Vouchers Payable156,500Due to Federal Government67,490Deferred Inflows of ResourcesUnavailable Revenues438,000Fund BalanceNonspendableInventory of Supplies16,900Fund BalanceUnassigned204,130$1,091,980$1,091,980
- Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2023.
- Record in general journal form entries to close the budgetary and operating statement accounts in the General Fund only.
- Prepare a General Fund balance sheet as of June 30, 2023.
- Part D. Prepare a General Fund statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 2023.
Prepare a General Fund statement of revenues, expenditures CITY OF CASTLETON General Fund Statement of Revenues, Expenditures, and Changes in Fund Balance For the Year Ended June 30, 2023 \begin{tabular}{|l|c|} \hline Revenues & \\ \hline Taxes & \\ \hline Interest and Penalties on Taxes & \\ \hline Other Sources & \\ \hline \multicolumn{1}{|c|}{ Total Revenues } & 0 \\ \hline Expenditures & \\ \hline Salaries and Wages & \\ \hline Interest on Notes Payable & \\ \hline Other & $ \\ \hline Total Expenditures & \\ \hline Excess of Revenues over Expenditures & \\ \hline Other Financing Uses & \\ \hline Change In Fund Balance & \\ \hline Increase in Inventory of Supplies & \\ \hline Fund Balances, July 1,2022 & \\ \hline Fund Balances, June 30,2023 & $ \\ \hline \end{tabular} 2. The city council authorized temporary borrowing of $580,000 in the form of a 120-day tax anticipation note obtained from a local bank. 3. The property tax levy for FY 2023 was recorded. Net assessed valuation of taxable property for the year was $45,900,000, and the tax rate was $5 per $100. It was estimated that 2 percent of the levy would be uncollectible. 4. Purchase orders and contracts were issued to vendors and others in the amount of $2,140,000. 5. $2,090,000 of current taxes, $391,270 of delinquent taxes, $21,370 of interest and penalties, and $19,000 of accrued sales taxes were collected. The delinquent taxes and associated interest and penalties were collected more than 60 days after the prior year-end. 6. Additional interest and penalties on delinquent taxes were accrued in the amount of $39,230, of which 30 percent was estimated to be uncollectible. \begin{tabular}{|l|l|l|l|l|} \hline 6 & General Fund & Interest and Penalties Receivable & 39,230 & \\ \hline & & Allowance for Uncollectible Interest and Penalties & 11,769 \\ \hline \end{tabular} 12. Amounts due to the federal government as of June 30,2023 , and amounts due for FICA taxes and state and federal withholding taxes during the year were vouchered. 13. Purchase orders and contracts encumbered in the amount of $2,068,040 were filled at a net cost of $2,067,570, which was vouchered. 14. Vouchers payable totaling $2,381,660 were paid after deducting a credit for purchases discount of $8,830 (credit Expenditures). 17. All unpaid current year's property taxes became delinquent. The balances of the current taxes receivable and related uncollectibles were transferred to delinquent accounts. The City uses the 60-day rule for all revenues and does not expect to collect any delinquent property taxes or interest and penalties Prepare a General Fund statement of revenues, expenditures CITY OF CASTLETON General Fund Statement of Revenues, Expenditures, and Changes in Fund Balance For the Year Ended June 30, 2023 \begin{tabular}{|l|c|} \hline Revenues & \\ \hline Taxes & \\ \hline Interest and Penalties on Taxes & \\ \hline Other Sources & \\ \hline \multicolumn{1}{|c|}{ Total Revenues } & 0 \\ \hline Expenditures & \\ \hline Salaries and Wages & \\ \hline Interest on Notes Payable & \\ \hline Other & $ \\ \hline Total Expenditures & \\ \hline Excess of Revenues over Expenditures & \\ \hline Other Financing Uses & \\ \hline Change In Fund Balance & \\ \hline Increase in Inventory of Supplies & \\ \hline Fund Balances, July 1,2022 & \\ \hline Fund Balances, June 30,2023 & $ \\ \hline \end{tabular} 2. The city council authorized temporary borrowing of $580,000 in the form of a 120-day tax anticipation note obtained from a local bank. 3. The property tax levy for FY 2023 was recorded. Net assessed valuation of taxable property for the year was $45,900,000, and the tax rate was $5 per $100. It was estimated that 2 percent of the levy would be uncollectible. 4. Purchase orders and contracts were issued to vendors and others in the amount of $2,140,000. 5. $2,090,000 of current taxes, $391,270 of delinquent taxes, $21,370 of interest and penalties, and $19,000 of accrued sales taxes were collected. The delinquent taxes and associated interest and penalties were collected more than 60 days after the prior year-end. 6. Additional interest and penalties on delinquent taxes were accrued in the amount of $39,230, of which 30 percent was estimated to be uncollectible. \begin{tabular}{|l|l|l|l|l|} \hline 6 & General Fund & Interest and Penalties Receivable & 39,230 & \\ \hline & & Allowance for Uncollectible Interest and Penalties & 11,769 \\ \hline \end{tabular} 12. Amounts due to the federal government as of June 30,2023 , and amounts due for FICA taxes and state and federal withholding taxes during the year were vouchered. 13. Purchase orders and contracts encumbered in the amount of $2,068,040 were filled at a net cost of $2,067,570, which was vouchered. 14. Vouchers payable totaling $2,381,660 were paid after deducting a credit for purchases discount of $8,830 (credit Expenditures). 17. All unpaid current year's property taxes became delinquent. The balances of the current taxes receivable and related uncollectibles were transferred to delinquent accounts. The City uses the 60-day rule for all revenues and does not expect to collect any delinquent property taxes or interest and penalties