CLICK THE TITLES TO ACCESS THE EXCEL FILES
18 Mill Calculator (Flex-Fund Grant Requirement)
Used to calculate required budget expenditures to satisfy the 18 Mill requirement for the Flex-Fund Set Aside Grants. (Excel File)
Enter first year beginning balance, then history from the annual reports for the years listed and the budget from the current year. Enter the total taxable value of the township (available from auditor or tax director).
Use the several years of history to predict future needs and adjust for changes anticipated.
Set the desired reserve percentage from 0% to 75%
Set allowance for delinquent taxes (maximum 5%)
MAKE ENTRIES IN GREEN CELLS ONLY!