Tax Rate Analysis Tool

This is a prototype version of the Property Tax Rate Analysis Tool

Setting property tax rates is important.   This prototype tool is designed to help us (the Council) efficiently understand the implications of changing mil rates.   

The tool is currently set up with the mil rates and sector property values from 2023 with the draft 2024 revenue requirement for existing proper owners (which is $41.070M in the RTC for 17 Oct 2023) represented by the thick grey line.  The sliders (on the right) allow you to change the mil rates for each of the nine assessment sectors.  As you change the mil rate sliders, you will notice the 2024 revenue per sector changing (upper plot) along with the percentage change in taxation for that sector (lower plot).  The box on the bottom right tells you if your selected mil rates are within $10k of the required revenue for 2024.    Hovering your mouse over the sector will give you the numerical value that makes up that component of the plot.

Since we do not yet have the property assessment numbers, this will not give correct mil rates.  However (as we know) the numerical value of the mil rate is not actually the important number, it is the property tax increase per sector that is important.   This tool will allow you to get an idea of how our increased revenue requirements may be shared amongst our residents, businesses, and industries.  You may notice that the tool shows that we would need to increase property tax rates for residential, business, and light industries by around 11% to achieve the draft revenue requirements (assuming we keep the increases constant across sectors).  It is currently not clear to me why this is different from staff projections of 8.9%, but I am reasonably certain that it is more likely to be an error on my part than an error on their part. 

This is not a District of Squamish product.  I (Andrew Hamilton) take sole responsibility for any errors or omissions and provide no promise of absolute accuracy.  The source code is publically available on GitHub for anyone to verify the calculation and/or data.