Question: using excel,prepare in good form, a General Fund Statement of Revenues, Expenditures, and Changes in Fund Balances for the city of Eastern Shores General Fund
using excel,prepare in good form, a General Fund Statement of Revenues, Expenditures, and Changes in Fund Balances for the city of Eastern Shores General Fund for the Year Ended September 30, 2012.
The following General Fund information is available for the preparation of the financial statements for the city of Eastern Shores for the year ended September 30, 2015:
| Revenues: | |
| Property taxes | $28,120,000 |
| Sales taxes | 13,216,000 |
| Fees and fines | 1,124,000 |
| Licenses and permits | 1,921,000 |
| Intergovernmental | 1,368,000 |
| Investment earnings | 654,000 |
| Expenditures: | |
| Current: | |
| General government | 10,252,000 |
| Public safety | 24,444,000 |
| Public works | 6,211,000 |
| Health and sanitation | 1,163,000 |
| Culture and recreation | 2,154,000 |
| Debt serviceprincipal | 652,000 |
| Debt serviceinterest | 821,000 |
| Proceeds of long-term, capital-related debt | 2,210,000 |
| Transfer to special revenue fund | 1,119,000 |
| Special itemproceeds from sale of land | 821,000 |
| Fund balance, October 1, 2014 | 1,812,000 |
From the information given above, prepare, in good form, a General Fund Statement of Revenues, Expenditures, and Changes in Fund Balances for the city of Eastern Shores General Fund for the Year Ended September 30, 2015.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help