Overview

Instructions
Data Input
Revenues
Expenditures
Position
Obligations


Sheet 1: Instructions

INSTRUCTIONS FOR THE CITIZEN'S GUIDE SPREADSHEET





Note: The years on a local unit's Citizen's Guide will be different than the years on the



local unit's Projected Budget Report.








The spreadsheet is organized by tabs. The first tab to the right of the "Instructions" tab is titled



"Data Input" and is the tab where the majority of the information will be entered. Each tab has a



Commentary box where supplemental information can be added. The next four tabs contain the



Citizen's Guide and is organized as follows:









1. Revenues


2. Expenditures


3. Position


4. Obligations






To enter information in the "Data Input" tab, you will need to have copies of your financial



statements, trial balances, or F-65 forms. To use the spreadsheet:









1. Rows 2 and 3 enter your Local Unit Name and Local Unit Code in the yellow highlighted



boxes.







2. Rows 8 through 33 present the revenues and expenditures from all governmental funds.









a. These rows should include the General Fund plus all special revenue, debt




service, capital project, and permanent funds (if you are using the F-65 forms, this




is the sum of columns (a) and (b)).








b. If you have any revenue or expenditure categories that are not being used by




your local unit, please "Hide" those rows on the "Data Input" tab. This will




remove them from the graphs so that the graphical presentation will be easier




for the citizen to understand.






3. Rows 34 through 41 present the financial position (fund balance) as of the balance sheet



date.









a. These rows should include the General Fund plus all special revenue, debt




service, capital project, and permanent funds (if you are using the F-65 forms, this




is the sum of columns (a) and (b)).








b. If you have any financial position (fund balance) categories that are not being




used by your local unit (i.e., you have no commitments or you have no




assignments etc.), please "Hide" those rows on the "Data Input" tab. This will




remove them from the graphs. The law does not require you to restate fund




balances for years prior to the implementation of GASB 54. It is optional, but




encouraged.






4. Rows 44 through 61 present the liabilities not counted on a modified-accrual basis. This



represents the funded status of all "defined benefit" employee benefit plans (pension



plans, retiree health care, or any other post-employment benefit (OPEB) plans).









a. If you do not have any unfunded pensions or unfunded OPEB, please




note that in the Commentary box on the "Obligations" tab.








b. Information for this section should be in the footnote disclosures of your




annual financial statements; it is also available in your actuarial valuations.








c. Many local units do not have annual information related to the actuarial accrued




liability (AAL) for retiree health care plans. For those communities, we




recommend estimating the information between valuations so that a fair picture




can still be obtained. For example: if the 2007 AAL was $5 million and the




2010 AAL was $8 million, you could estimate to $6 million for 2008 and




$7 million for 2009.






5. Rows 64 through 73 present the debt information. This represents all governmental



liabilities not already reported in the funds themselves.









a. If you do not have any debt, please note that in the Commentary box on




the "Obligations" tab.








b. Information for this section generally can be found in the footnote disclosures




of your financial statements.






6. Row 75 presents population information. This section is presented so that you can



compute measures on a per-capita basis, and will make it easier for comparisons with



other local units in the future. For 2010, the population count should agree with the U.S.



census figures. For all other years, estimates of population are generally available



through your regional council of governments.







7. Rows 78 and 79 enter the “Contact Information” in the yellow highlighted boxes.







8. Rows 85 through 89 are grayed out and should be ignored. This section is necessary in



order for the interactive revenue and expenditure charts to operate properly.






On the "Revenues" and "Expenditures" tabs, box number 4 has been built as an interactive



chart. When this is put on your website, the user can choose any revenue (expenditure) from



the drop-down list and see the historical trend for that particular revenue (expenditure).








Before publishing the Citizen’s Guide to your website, we highly recommend you "Hide"



the “Data Input” tab and the “Instructions” tab so that this document will be user-



friendly. To hide a tab (or row), right click on the tab (or row) and select "Hide".








Make sure when you print or save this document to a PDF, you use the “Print Entire Workbook”



option. Then the entire Citizen’s Guide will be in one document.




Sheet 2: Data Input

DATA INPUT PAGE FOR CITIZEN'S GUIDE TO LOCAL UNIT FINANCES









Local Unit Name:
Village of Colon







Local Unit Code:
753,030














Per capita information



2010-11 2011-12 2012-13 2013-14 2014-15 2013-14 2014-15























Statement of Revenues & Expenditures - All governmental funds








Revenues










Taxes 390,075 397,488 383,162 391,185 398,469 339 345


Licenses & Permits 5,473 5,436 3,974 7,921 9,522 7 8


Federal Government
8,000


- -


State Government 197,380 286,153 236,398 215,998 247,002 187 214


Charges for Services 57,432 58,807 62,271 60,058 61,154 52 53


Fines & Forfeitures 2,220 1,522 1,477 2,360 1,505 2 1


Interest & Rents 1,895 950 543 473 293 0 0


Other Revenues 5,333 56,966 19,195 27,983 21,562 24 19


Total Revenues 659,808 815,322 707,020 705,978 739,507 612 641

Expenditures










General Government 91,256 90,292 81,915 89,630 96,675 78 84


Police & Fire 298,367 315,846 303,541 298,348 339,213 259 294

Other Public Safety 220,460 184,830 202,772 96,373 96,744 84 84


Roads


193,675 150,605 168 131


Health & Welfare 7,721 8,030 8,351 8,605 9,112 7 8


Community/Econ. Development 1,957 1,420 5,170 9,030 3,997 8 3


Recreation & Culture 19,030 182,203 24,326 27,706 41,041 24 36


Debt Service 17,414 20,869


- -


Total Expenditures 656,205 803,490 626,075 723,367 737,387 627 639


Surplus (Shortfall) 3,603 11,832 80,945 (17,389) 2,120 (15) 2

Financial Position - All governmental funds





















Nonspendable


31,949 11,775 28 10


Restricted 2,000 2,000 1,319 34,279 29,663 30 26


Unassigned 444,931 456,763 538,389 456,091 483,001 395 419


Total Fund Balance 446,931 458,763 539,708 522,319 524,439 453 454























Debt









Bonds & Contracts Payable
20,188







Capital Leases









Other Contractual Debt
20,000 20,000 20,000 20,000 20,000



Structured Debt
40,188 20,000 20,000 20,000 20,000 17 17

Employee Compensated Absences




44,104 - 38

Landfill Closure & Postclosure Care





- -

Uninsured Losses





- -

Other Claims & Contingencies





- -


Total Long Term Debt (Excluding Pension & OPEB) 40,188 20,000 20,000 20,000 64,104 17 56












Population Information
1,207 1,154 1,154 1,154 1,154














Contact Information









Contact Name:
Julie Hollister







Contact Phone Number:
269-432-2532






























































Graph data, pulled from above data: 10








Revenue: 1 2010-11 2011-12 2012-13 2013-14 2014-15




Taxes 390,075 397,488 383,162 391,185 398,469



Expenditures: 1









General Government 91,256 90,292 81,915 89,630 96,675




Sheet 3: Revenues

CITIZEN'S GUIDE TO LOCAL UNIT FINANCES - Village of Colon (753030)







REVENUES
1. Where our money comes from (all governmental funds)



2. Compared to the prior year









2013-14 2014-15 % change





Taxes $391,185 $398,469 1.86%





Licenses & Permits 7921 9522 20.21%





Federal Government 0 0 N/A





State Government 215998 247002 14.35%





Local Contributions 0 0 N/A





Charges for Services 60058 61154 1.82%





Fines & Forfeitures 2360 1505 -36.23%





Interest & Rents 473 293 -38.05%





Other Revenues 27,983 21,562 -22.95%





Total Revenues $705,978 $739,507 4.75%








































3. Revenue sources per capita - compared to the prior year



4. Historical trends of individual sources



























































































































































Commentary:
For more information on our unit's finances, contact Julie Hollister at 269-432-2532.










Sheet 4: Expenditures

CITIZEN'S GUIDE TO LOCAL UNIT FINANCES - Village of Colon (753030)







EXPENDITURES
1. Where we spend our money (all governmental funds)



2. Compared to the prior year






2013-14 2014-15 % change

General Government $89,630 $96,675 7.86%

Police & Fire 298348 339213 13.70%

Other Public Safety 96373 96744 0.38%

Roads 193675 150605 -22.24%

Other Public Works 0 0 N/A

Health & Welfare 8605 9112 5.89%

Community/Econ. Development 9030 3997 -55.74%

Recreation & Culture 27706 41041 48.13%

Capital Outlay 0 0 N/A

Debt Service 0 0 N/A

Other Expenditures - - N/A

Total Expenditures $723,367 $737,387 1.94%
























3. Spending per capita - compared to the prior year



4. Historical trends of individual departments:
















































































































































































































Commentary:


For more information on our unit's finances, contact Julie Hollister at 269-432-2532.











Sheet 5: Position

CITIZEN'S GUIDE TO LOCAL UNIT FINANCES - Village of Colon (753030)






FINANCIAL POSITION
1. How have we managed our governmental fund resources (fund balance)?



2. Compared to the prior year









2013-14 2014-15 % change





Revenue 705978 739507 4.75%





Expenditures 723367 737387 1.94%





Surplus (shortfall) (17,389) 2,120 -112.19%





Fund balance, by component:








Nonspendable 31949 11775 -63.14%





Restricted 34279 29663 -13.47%





Committed 0 0 N/A





Assigned 0 0 N/A





Unassigned 456091 483001 5.90%





total fund balance 522,319 524,439 0.41%




























































3. Fund balance per capita - compared to the prior year



4. Historical trends of individual components




















































































Commentary:


For more information on our unit's finances, contact Julie Hollister at 269-432-2532.










Sheet 6: Obligations

CITIZEN'S GUIDE TO LOCAL UNIT FINANCES - Village of Colon (753030)













OTHER LONG TERM OBLIGATIONS
1. Pension funding status



2. Retiree Health care funding status



3. Percent funded - compared to the prior year

















































































4. Long Term Debt obligations:






5. Debt & other long term obligations per capita - compared to the prior year























































































































































































































































































Commentary: The Village dosent have a retiree pension plan or any other plans for retirees, There are no unfunded pensions or unfunded OPEB. The Village does not have any debt.


For more information on our unit's finances, contact Julie Hollister at 269-432-2532.