The following information was available for the General Fund of
the City of San Dimas for the Year Ended December 31, 2018:
- Revenues for the year included property taxes in the amount of
$6,612,000, fines and forfeits in the amount of $ 700,000, and
miscellaneous in the amount of $400,000.
- Expenditures from current appropriations included: general
government, $4,847,000; public safety, $1,884,000; culture and
recreation, 812,000.
- In addition to (b) above, expenditures related to prior year
appropriations (encumbered last year) amounted to $40,000 (public
safety). Encumbrances issued this year but not filled amounted to
$60,000 (general government).
- A transfer was made from the General Fund to a debt service
fund in the amount of $500,000. A transfer was made from an
enterprise fund to the General Fund in the amount of $450,000.
- Beginning balances included Fund Balance in the amount of
$222,000.
Required: Prepare a Statement of Revenues, Expenditures, and
Changes in Fund Balances for the General Fund for the City of San
Dimas for the Year Ended December 31, 2018. Prepare your statement
in excel or google sheet and upload your document.