Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

answer the following on excel, not sure if mine is right so far CITY OF Grafton Schedule of Revenues, Expenditures and Changes in Fund Balance

answer the following on excel, not sure if mine is right so far
CITY OF Grafton
Schedule of Revenues, Expenditures and Changes in Fund Balance -
\table[[Budget and Actual: General Fund,(Non-GAAP Budgetary Basis),,],[For The Year Ended December 31,2020,,,,],[,Budgeted Amounts,\table[[Actual Amounts],[Budgetary Basis]],\table[[Variance with Final],[Budget]]],[REVENUES,Original,Final],[Property Taxes,3,220,000,$,3,220,000,3,225,500,5,500],[Licenses and permits,790,000,,790,000,792,000,2,000],[Miscellaneous,200,000,,200,000,212,000,12,000],[TOTAL REVENUES,4,520,000,,4,510,000,4,259,400,(250,600)]]
EXPENDITURES AND ENCUMBRANCES
\table[[EXPENDITURES AND ENCUMBRANCES],[Current],[General Government],[Public Safety],[Health and Welfare,,,,=],[TOTAL EXPENDITURES,-,=,-],[OTHER FINANCING SOURCES (USES):],[Transfers (to) other funds,,,,-],[TOTAL OTHER FINANCING SOURCES (USES),=,-,-],[Excess of revenues and other sources over,]]3-15. The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal year ended June
30,2024:
Estimated revenues:
Taxes (property)
$3,220,000
Licenses and permits
790,000
Intergovernmental revenues
310,000
Miscellaneous revenues
200,000
Revenues:
Taxes (property)
$3,225,500
Licenses and permits
792,000
Intergovernmental revenues
299,000
Miscellaneous revenues
212,000
Appropriations:
General government
$920,000
Public safety
2,090,000
Health and welfare
1,400,000
Expenditures:
General government
$878,000
Public safety
2,005,000
Health and welfare
1,399,000
Encumbrances outstanding as of June 30,2019:
General government
$33,000
Public safety
82,000
Transfer to debt service fund:
Budget
$120,000
Actual
120,000
Budget revisions approved by the city council:
Estimated revenues:
Decrease intergovernmental revenues
$10,000
Increase miscellaneous revenues
3,000
Appropriations:
Decrease general government
Total fund balance at July 1,2023, was $695,000.
Required: Use the Excel file provided to prepare a Budgetary Comparison Schedule for the City of Grafton for the fiscal year ended
June 30,2024. Include outstanding encumbrances with expenditures.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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