offered by

Financial Tools, Calculators and Templates

The Division has developed easy to use financial calculators and templates to assist local officials.

Financial Calculators

Easy to use calculators to assist local official in predicting the impact on property owners when considering a split tax rate, debt service for a new project, or Proposition 2½ ballot measure.

Financial Templates

Budget and Tax Rate Planning Tool

This Excel workbook can be used in tandem with DLS Gateway to analyze the impact of municipal finance decisions on the estimated property tax levy for any fiscal year. The file is unprotected and can be modified as needed, to facilitate “what-if” analysis and the sharing of data between officials. This workbook contains no jurisdiction-specific data, so it can be used by any city, town or district in any fiscal year

The Excel workbook contains six separate worksheets: Tax Rate Options and Shifts, Levy Limit and Recap Pages 1 through 4. Certain data is passed from one worksheet to another to reduce the amount of data entry. Please be aware that as the workbook is unprotected, it is possible to change the formulas either intentionally or accidently. 

It is important to note that the rounding of values in Microsoft Excel can vary slightly from the rounding in DLS Gateway. DLS Gateway must be used for final levy limit and tax rate calculation and submission. DLS provides the Budget Analysis Recap tool for planning and analysis purposes only, and will not accept data from this file for tax rate setting.

 

Download the Budget and Tax Rate Planning Tool

Feedback