Billing > Tax Collection > Parameters > Exemption Schedule

Recent Changes: 6.130 - Changes for levy selection (include tax districts in the display of the drop down).  Changed the search criteria fields to Tax Years, Levies, Tax Districts, and Exemptions to improve the ability to find schedules.
6.84 - Ability to denote if an exemption is subject to under appeal has been added.

6.24 - Added functionality to be able to enter an additional amount on the schedule so it only affects 1 levy

Introduction

Property tax exemptions deduct from the assessment value of a property to reduce the net total assessment value. The net total assessment value is what is used to determine how much a customer owes on their property tax bill.

Explanation

Tax Exemption Process and Calculate

SmartFusion offers a number of tax exemption options. Exemption schedules are comprised of a tax transaction code, tax year levy, and exemption. Examples of exemption schedule types are found below. An exemption can be used for as many exemption schedules as neeed.

Fields

Exemption - Exemption for the schedule

Tax Year Levy - The combination of the tax year and the levy
Transaction Code - The transaction code used by the schedule and which is used when generating the transactions associated with the exemption schedule

Type - This is the schedule type. All types are explained in the section below

Amount - This will be a percent or an actual amount based on the type. Explained below

Limit - This is the limit used when calculating the exemption. How t is used for each type is explained below

Additional Amount - Additional amount added to the exemption calculation

Subject to under appeal percent - If the exemption is calculated at the under appeal percent specified in the system file

There is also a field to enter an additional amount for a schedule if you need an exemption with a certain calculation type and you also get extra and it applies to only 1 levy. The same exemption can be used on different exemption schedules created for each new tax year. The exemption parameter is what the user sees when adding exemptions on a property's Yearly Detail form, on the Eligible Exemptions tab. If the exemption has an exemption schedule and that schedule's tax year levy matches the tax year of the bill, the assessment amount changes for the bill during a tax calculation. The exemption discounts the total charges that the customer will pay depending on the exemption schedule type calculation.

Tax Exemption Schedule Type Calculations

All tax exemptions are compromised of an exemption value, calculated in a variety of ways, combined with the tax year levy's millage rate times the per unit value (set in Tax System Settings). The expectation is that an exemption will be a negative value since its purpose is to reduce the total amount owed on a tax property bill. In Smart Fusion, the exemption value is determined by the exemption schedule configuration. Every calculation uses rounding when applicable and rounds up when the halfway point of a non-significant digit is reached. If the total of a levy charge that the exemption is tied to reaches zero because of other exemptions the exemption will not push it to a negative amount. Exemptions are calculated in order by sequence and then alphabetically by exemption code if sequences match.

Any exemption can have an additional exemption amount. This amount would be added on to any exemption calculation directly before multiplying by the millage and dividing by the per unit value.

All exemptions have the ability to set a limit both on the schedule and by the tax district which overrides the schedule if the item with the exemption is associated with the tax district.

Additional

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Limit = District Limit (if available) or Limit

ExemptionValue = The lower value AdditionalAmount or Limit

AssessedValue = ExemptionValue * percent of the schedule  (this value is rounded)

ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

Additional exemption is a combination of the variable and percent exemptions. A specific value is multiplied by the percent amount listed on the exemption schedule. The additional exemption field is found on the tax property's yearly detail page on the exemptions tab. If an additional amount is on the exemption schedule it will also be added into the additional exemption amount. Without a value in the additional exemption field the resulting exemption will be zero. The amount of the additional exemption also can be limited by either providing a limit in the schedule or by providing a limit on the district.

Example 1: additional

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 100000
  • No district limits have been added or match
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill  = 50000

Limit = District Limit (if available) or Limit = 100000

ExemptionValue = The lower value AdditionalAmount or Limit = 50000

AssessedValue = 50000 * (20/100)  (this value is rounded)

ExemptionAmount = 10000 * (6.5 / 1000)  - This value is rounded  

= $65.00

Example 2: additional - Additional amount on schedule as well as bill

  • Additional Exemption Amount on Bill: 50000
  • Additional Exemption Amount on Schedule: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 100000
  • No district limits have been added or match
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = (50000 + 50000 = 100000)

Limit = District Limit (if available) or Limit = 10000

ExemptionValue = The lower value AdditionalAmount or Limit = 100000

AssessedValue = 100000 * (20/100)  (this value is rounded) = 20000

ExemptionAmount = 20000 * (6.5 / 1000)  - This value is rounded  

= $130.00

Example 3: additional with a limit that is exceeded

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 5000
  • No district limits have been added or match
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000

Limit = District Limit (if available) or Limit = 5000

ExemptionValue = The lower value AdditionalAmount or Limit = 5000

AssessedValue = 5000 * (20/100)  (this value is rounded) = 1000

ExemptionAmount = 1000 * (6.5 / 1000)  - This value is rounded  

= $6.50

Example 4: additional with district limit available

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 99999999
  • District Limit of 3000 for the property
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill  = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 3000

AssessedValue = 3000 * (20/100)  (this value is rounded) = 600

ExemptionAmount = 600 * (6.5 / 1000)  - This value is rounded  

= $3.90

Example 5: additional with a limit and district limit available

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 5000
  • District Limit of 3000 for the property
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill  = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 3000

AssessedValue = 3000 * (20/100)  (this value is rounded) = 600

ExemptionAmount = 600 * (6.5 / 1000)  - This value is rounded  

= $3.90

Example 6: additional with zero limit

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 0
  • No district limits have been added or match
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill  = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 0

AssessedValue = 0 * (20/100)  (this value is rounded) = 0

ExemptionAmount = 0 * (6.5 / 1000)  - This value is rounded  

= $0.00

Example 7: additional with zero limit and available district limit

  • Additional Exemption Amount: 50,000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 0
  • District Limit: 3,000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill  = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 3000

AssessedValue = 3000 * (20/100)  (this value is rounded) = 600

ExemptionAmount = 600 * (6.5 / 1000)  - This value is rounded  

= $3.90

Additional - Land Only

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Limit = District Limit (if available) or Limit

ExemptionValue = The lower value AdditionalAmount or Limit

LandAssessment = Lot assessment from bill

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) 

ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

Additional - Land Only exemption is calculated the same was as an additional exemption. The only difference between land only and normal additional exemption type is that Land Only is limited by and only pertains to the land assessment of the property

Example 1: additional with limit under land value

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 999999999
  • No district limits have been added
  • Land Assessment of 200000

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000

Limit = District Limit (if available) or Limit = 999999999

ExemptionValue = The lower value AdditionalAmount or Limit = 50000

LandAssessment = Lot assessment from bill = 200000

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) = 10000

ExemptionAmount = 10000 * (6.5 / 1000)  - This value is rounded

= $65.00

Example 2: additional with a limit under land assessment

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 5000
  • No district limits have been added
  • Land Assessment of 200000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000

Limit = District Limit (if available) or Limit = 5000

ExemptionValue = The lower value AdditionalAmount or Limit = 5000

LandAssessment = Lot assessment from bill = 200000

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) = 1000

ExemptionAmount = 1000 * (6.5 / 1000)  - This value is rounded

= $6.50

Example 3: additional with district limit available under land assessment

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 999999999
  • District Limit of 3000 for the property
  • Land Assessment of 200000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 3000

LandAssessment = Lot assessment from bill = 200000

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) = 600

ExemptionAmount = 600 * (6.5 / 1000)  - This value is rounded

= $3.90

Example 4: additional with a limit and district limit available under land assessment

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 5000
  • District Limit of 3000 for the property
  • Land Assessment of 200000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 3000

LandAssessment = Lot assessment from bill = 200000

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) = 600

ExemptionAmount = 600 * (6.5 / 1000)  - This value is rounded

= $3.90

Example 5: additional with a limit and district limit available limited by land assessment

  • Additional Exemption Amount: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 5000
  • District Limit of 3000 for the property
  • Land Assessment of 200
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000

Limit = District Limit (if available) or Limit = 3000

ExemptionValue = The lower value AdditionalAmount or Limit = 3000

LandAssessment = Lot assessment from bill = 2000

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) = 200

ExemptionAmount = 200 * (6.5 / 1000)  - This value is rounded

= $1.30

Example 6: additional under land value - additional on schedule as well as bill

  • Additional Exemption Amount on bill: 50000
  • Additional Exemption Amount on schedule: 50000
  • Amount Value (percentage): 20
  • Millage: 6.500
  • Per Unit Value: 1000
  • Limit : 999999999
  • No district limits have been added
  • Land Assessment of 200000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 50000+50000 = 100000

Limit = District Limit (if available) or Limit = 999999999

ExemptionValue = The lower value AdditionalAmount or Limit = 999999999

LandAssessment = Lot assessment from bill = 200000

AssessedValue = The smaller value of LandAssessment or  (ExemptionValue * percent of the schedule)  (this value is rounded) = 20000

ExemptionAmount = 20000 * (6.5 / 1000)  - This value is rounded

= $130.00

Ceiling

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Limit = District Limit (if available) or Limit (this is the ceiling amount

AssessmentAmount = This is the calculated assessment amount for the bill (need to see if there is another wiki for this)

ExemptionValue = If AssessmentAmount <= Limit then AssessmentAmount else 0

AssessedValue = (ExemptionValue * percent of the schedule) + AdditionalAmount  (this value is rounded) 

ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

The ceiling type exemption will give you an exemption of some kind if your assessment value is under or equal to a certain level. If the assessment is over you receive no exemption. If it is under then you will get a percentage of the assessment as an exemption. The limit is always the ceiling. If a district limit is available it will be used as the ceiling.

Example 1: ceiling with no additional and no limits

  • Assessment: 7500
  • Amount Value (percentage): 100
  • Additional Exemption Amount: 0
  • Limit: 0
  • Millage: 6.500
  • Per Unit Value: 1000
  • No district limits
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit (this is the ceiling amount = 0

AssessmentAmount = 7500

ExemptionValue = 0

AssessedValue = (0 * 100/100) + 0  (this value is rounded) 

ExemptionAmount = 0 * (6.5 / 1000)  - This value is rounded

= $0.00

Example 2: ceiling with a limit no district limit

  • Assessment: 7500
  • Amount Value (percentage): 100
  • Additional Exemption Amount: 0
  • Limit: 8000
  • Millage: 6.500
  • Per Unit Value: 1000
  • No district limits
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit (this is the ceiling amount = 8000

AssessmentAmount = 7500

ExemptionValue = 7500 <= 8000 = 7500

AssessedValue = (7500 * 100/100) + 0  (this value is rounded) = 7500

ExemptionAmount = 7500 * (6.5 / 1000)  - This value is rounded

= $48.75

Example 3: ceiling with no additional amount and a limit no district limit

  • Assessment: 7500
  • Amount Value (percentage): 100
  • Additional Exemption Amount: 0
  • Limit: 6000
  • Millage: 6.500
  • Per Unit Value: 1000
  • No district limits
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit (this is the ceiling amount = 6000

AssessmentAmount = 7500

ExemptionValue = 7500 <= 6000 not true so = 0

AssessedValue = (0 * 100/100) + 0  (this value is rounded) = 0

ExemptionAmount = 0 * (6.5 / 1000)  - This value is rounded

= $0.00

Example 4: ceiling with a limit with an additional amount and no district limit

  • Assessment: 7500
  • Amount Value (percentage): 100
  • Additional Exemption Amount: 1000
  • Limit: 6000
  • Millage: 6.500
  • Per Unit Value: 1000
  • No district limits
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

Limit = District Limit (if available) or Limit (this is the ceiling amount = 6000

AssessmentAmount = 7500

ExemptionValue = 7500 <= 6000 not true so = 0 

AssessedValue = (0 * 100/100) + 1000  (this value is rounded) = 1000

ExemptionAmount = 1000 * (6.5 / 1000)  - This value is rounded

= $6.50

Example 5: ceiling with a limit with an additional amount and district limits

  • Assessment: 7500
  • Amount Value (percentage): 20
  • Additional Exemption Amount: 1000
  • Limit: 6000
  • Millage: 6.500
  • Per Unit Value: 1000
  • District limit of 8000

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

Limit = District Limit (if available) or Limit (this is the ceiling amount = 6000

AssessmentAmount = 7500

ExemptionValue = 7500 <= 8000 not true so = 7500 

AssessedValue = (7500 * 20/100) + 1000  (this value is rounded) = 2500

ExemptionAmount = 2500 * (6.5 / 1000)  - This value is rounded

= $16.25

Fair Market Value (FMV)

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Limit = District Limit (if available) or Limit (this is the ceiling amount

BuildingLotValue = sum of building value and lot value

ExemptionValue = The lower value BuildingLotValue or Limit

AssessedValue = (ExemptionValue * percent of the schedule) + AdditionalAmount  (this value is rounded) 

ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

The Fair Market Value exemption is calculated by combining the building value and lot value found on the tax property's yearly detail page and then taking the specified percentage of that combined value. The result is the exempted amount. If a limit is in place either on the schedule or via a district this will limit the value of building and lot.

Example 1: No additional amount

  • Building Value: 40000
  • Lot Value: 20000
  • Amount Value (percentage): 10
  • Additional Exemption Amount: 0
  • Millage: 5.000
  • Per Unit Value: 1000
  • Limit: 200000
  • No tax district limit
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit  = 200000

BuildingLotValue = 60000

ExemptionValue = 60000 < 200000 = 60000

AssessedValue = (60000 * 10/100) + 0  (this value is rounded) = 6000

ExemptionAmount = 6000 * (5 / 1000)  - This value is rounded

= $30.00

Example 2: With additional amount

  • Building Value: 40000
  • Lot Value: 20000
  • Amount Value (percentage): 10
  • Additional Exemption Amount: 1000
  • Millage: 5.000
  • Per Unit Value: 1000
  • Limit: 200000
  • No tax district limit
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit = 200000

BuildingLotValue = 60000

ExemptionValue = 60000 < 200000 = 60000

AssessedValue = (60000 * 10/100) + 1000  (this value is rounded) = 7000

ExemptionAmount = 7000 * (5 / 1000)  - This value is rounded

= $35.00


((40000 + 20000) * (10 / 100) + 1000) * (5 / 1000) = $35 exemption

Example 3: with additional amount and a limit

  • Building Value: 40000
  • Lot Value: 20000
  • Amount Value (percentage): 10
  • Additional Exemption Amount: 1000
  • Millage: 5.000
  • Per Unit Value: 1000
  • Limit: 50000
  • No tax district limit
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit  = 50000

BuildingLotValue = 60000

ExemptionValue = 60000 < 50000 IS NOT TRUE USE 50000

AssessedValue = (50000 * 10/100) + 1000  (this value is rounded) = 6000

ExemptionAmount = 6000 * (5 / 1000)  - This value is rounded

= $30.00

Example 4: with additional amount and a limit and a tax district limit

  • Building Value: 40000
  • Lot Value: 20000
  • Amount Value (percentage): 10
  • Additional Exemption Amount: 1000
  • Millage: 5.000
  • Per Unit Value: 1000
  • Limit: 50000
  • Tax District Limit:40000

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit  = 40000

BuildingLotValue = 60000

ExemptionValue = 60000 < 40000 IS NOT TRUE USE 40000

AssessedValue = (40000 * 10/100) + 1000  (this value is rounded) = 5000

ExemptionAmount = 5000 * (5 / 1000)  - This value is rounded

= $25.00

Since a tax district limit is available it is used.  (40000+ 20000) which is 60000 is greater than limit of 40000 the value used is 40000

((40000) * (10 / 100) + 1000) * (5 / 1000) = $20 exemption

Fixed Amount

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

FixedAmount = Amount on the exemption schedule

Limit = District Limit (if available) or Limit

ExemptionValue = The lower value FixedAmount or Limit + AdditionalAmount


ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

The Fixed Amount exemption is a specified flat dollar value that is granted to any property tax bill assigned to that exemption schedule. If a limit is available it will be used instead of the amount provided.

Example 1: no additional amounts

  • Amount Value: $10,000
  • Millage: 6.500
  • Additional Exemption Amount: 0
  • Per Unit Value: 1000
  • Limit: 100,000
  • Tax District Limit: no district limits
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

FixedAmount = Amount on the exemption schedule = 10000

Limit = District Limit (if available) or Limit = 100000

ExemptionValue = 10000 < 100000 use 10000 + 0

ExemptionAmount = 10000 * (6.5 / 1000)  - This value is rounded 

= $65 exemption

Example 2: Additional amount

  • Amount Value: $10,000
  • Millage: 6.500
  • Additional Exemption Amount: 1000
  • Per Unit Value: 1000
  • Limit: 100,000
  • Tax District Limit: 0
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

FixedAmount = Amount on the exemption schedule = 10000

Limit = District Limit (if available) or Limit = 100000

ExemptionValue = 10000 < 100000 use 10000 + 1000 = 11000

ExemptionAmount = 110000 * (6.5 / 1000)  - This value is rounded 

= $71.50

Example 3: Additional amount and a limit

  • Amount Value: $10,000
  • Millage: 6.500
  • Additional Exemption Amount: 1000
  • Per Unit Value: 1000
  • Limit: 8000
  • Tax District Limit: 0
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

FixedAmount = Amount on the exemption schedule = 10000

Limit = District Limit (if available) or Limit = 8000

ExemptionValue = 8000 < 100000 use 8000 + 1000 = 9000

ExemptionAmount = 9000 * (6.5 / 1000)  - This value is rounded 

= $58.50

Example 4: Additional Amount and a district limit is provided

  • Amount Value: $10,000
  • Millage: 6.500
  • Additional Exemption Amount: 1000
  • Per Unit Value: 1000
  • Limit: 8000
  • Tax District Limit: 5000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

FixedAmount = Amount on the exemption schedule = 10000

Limit = District Limit (if available) or Limit = 5000

ExemptionValue = 5000 < 100000 use 5000 + 1000 = 6000

ExemptionAmount = 6000 * (6.5 / 1000)  - This value is rounded 

= $39.00

Floating Acres

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Acres = number of acres on the bill (if zero it will be set to 1)

Limit = District Limit (if available) or Limit 

LimitCalc possible values are in this order
- Acres = 0 Limit = 1
- Limit > Acres = Acres
- Limit  

BuildingValue = value of the building entered on the bill

LotValue = value of the lot entered on bill

ExemptionValue = (((LotValue/Acres) * LimitCalc) + BuildingValue)

AssessedValue = (ExemptionValue * percent of the schedule) + AdditionalAmount  (this value is rounded) 

ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

The Floating Acres exemption amount is a combination of the property's building value and the value of a limited number of acres on the property, multiplied by the specified percent amount. To determine the exemptable amount, the per acre taxable value is found and then multiplied by the limit (or the total acreage, whichever is the smaller number). That value is then multiplied by the specified amount percentage.

Note: If multiple building class strata entries exist for the property the highest value one will be used for the calculation assuming that is the home entry. Also be aware that Additional - Land Only exemptions will lessen the land assessment used in this calculation if those exemptions are calculated before the floating acre exemption type

Example 1: Additional amount under the limit

  • Building Assessment: 40000
  • Lot Assessment: 20000
  • Additional Exemption: 5000
  • Limit: 10
  • Amount Value (percentage): 20
  • Millage: 6.5.000
  • Per Unit Value: 1000
  • District limit: None provided
  • Acres: 5
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 5000

Acres = number of acres on the bill (if zero it will be set to 1) = 5

Limit = District Limit (if available) or Limit = 10

LimitCalc possible values are in this order
- Acres = 0 -no
- Limit > Acres = Acres yes so = 5
- Limit  no

BuildingValue = value of the building entered on the bill = 40000

LotValue = value of the lot entered on bill = 20000

ExemptionValue = (((20000/5) * 5) + 40000) = 60000

AssessedValue = (60000 * 20/100) + 5000  (this value is rounded) = 17000

ExemptionAmount = 17000 * (6.5 / 1000)  - This value is rounded 

= $110.50

Example 2: (multiple building strata and acres under the limit)

  • Building Assessment 1: 5000
  • Building Assessment 2: 25000
  • Lot Assessment: 70000
  • Additional Exemption: 1000
  • Acres: 5
  • Limit: 10
  • Amount Value (percentage): 20
  • Millage: 6.5
  • District limit: None provided
  • Per Unit Value: 1000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

Acres = number of acres on the bill (if zero it will be set to 1) = 5

Limit = District Limit (if available) or Limit = 10

LimitCalc possible values are in this order
- Acres = 0 Limit = 1 no
- Limit > Acres = Acres yes = 5
- Limit  no

BuildingValue = 25000

LotValue = 70000

ExemptionValue = (((70000/5) * 5) + 25000) = 95000

AssessedValue = (95000 * 20/100) + 1000  (this value is rounded) = 20000

ExemptionAmount = 20000 * (6.5 / 1000)  - This value is rounded

=$130.00

Example 3: Additional Amount and limit which is less than acres

  • Building Assessment: 40000
  • Lot Assessment: 20000
  • Additional Exemption: 5000
  • Limit: 7
  • Amount Value (percentage): 20
  • Millage: 6.5.000
  • Per Unit Value: 1000
  • District limit: none provided
  • Acres: 15
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 5000

Acres = number of acres on the bill (if zero it will be set to 1) = 15

Limit = District Limit (if available) or Limit  = 7

LimitCalc possible values are in this order
- Acres = 0 Limit = 1 no
- Limit > Acres = Acres no
- Limit  yes = 7

BuildingValue = value of the building entered on the bill = 40000

LotValue = value of the lot entered on bill = 20000

ExemptionValue = (((20000/15) * 7) + 40000) = 49,333.33333333333333333333

AssessedValue = (49,333.33333333333333333333 * 20/100) + 5000  (this value is rounded) = 14866.666666666666666666666666667

ExemptionAmount = 14866.666666666666666666666666667 * (6.5 / 1000)  - This value is rounded

= $96.63


Amount used for limit is 7 as that is the limit and less than acres

(((((20000 / 15) *7) + 40000) * (20 / 100)) + 5000) * (6.5 / 1000) = $96.63 exemption

Example 4: Additional Amount and limit which is less than acres

  • Building Assessment: 40000
  • Lot Assessment: 20000
  • Additional Exemption: 5000
  • Limit: 5
  • Amount Value (percentage): 20
  • Millage: 6.5.000
  • Per Unit Value: 1000
  • District limit: 20
  • Acres: 10

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 5000

Acres = number of acres on the bill (if zero it will be set to 1) = 10

Limit = District Limit (if available) or Limit  = 20

LimitCalc possible values are in this order
- Acres = 0 Limit = 1 no
- Limit > Acres = Acres n yes = 10
- Limit  yes = no

BuildingValue = value of the building entered on the bill = 40000

LotValue = value of the lot entered on bill = 20000

ExemptionValue = (((20000/10) * 10) + 40000) = 60000

AssessedValue = (60000 * 20/100) + 5000  (this value is rounded) = 17000

ExemptionAmount = 17000 * (6.5 / 1000)  - This value is rounded

= $110.50

Example 5: Additional amount under the limit

  • Building Assessment: 40000
  • Lot Assessment: 20000
  • Additional Exemption: 5000
  • Additional Land Only Exemption calculated already had assessment of 10000
  • Limit: 10
  • Amount Value (percentage): 20
  • Millage: 6.5.000
  • Per Unit Value: 1000
  • District limit: None provided
  • Acres: 5
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 5000

Acres = number of acres on the bill (if zero it will be set to 1) = 5

Limit = District Limit (if available) or Limit  = 10

LimitCalc possible values are in this order
- Acres = 0 Limit = 1
- Limit > Acres = Acres yes = 5
- Limit  

BuildingValue = value of the building entered on the bill = 40000

LotValue = value of the lot entered on bill = 20000 (need to subtract the land only exemption based on criteria of 10000) = 10000

ExemptionValue = (((10000/5) * 5) + 40000) = 50000

AssessedValue = (50000 * 20/100) + 5000  (this value is rounded)  = 15000

ExemptionAmount = 15000 * (6.5 / 1000)  - This value is rounded

= $97.50


>  ((((((20000 - 10000)  / 5) * 5) + 40000) * (20 / 100)) + 5000) * (6.5 / 1000) = $97.50 exemption

Percentage

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Limit = District Limit (if available) or Limit

Assessment = Total Assessment of the bill 

ExemptionValue = The lower value AdditionalAmount or Limit 

AssessedValue = ExemptionValue * percent of the schedule + AdditionalAmount  (this value is rounded)

ExemptionAmount = AssessedValue * (millage / Per Unit Value)  - This value is rounded

The Percentage with Limit exemption compares the total assessed value of the tax property to a chosen limit value. The lesser of the two values is then multiplied by a chosen percent to get the exemption amount.

Example 1: No additional amount

  • Total Assessed Value: 100,000
  • Limit: 80,000
  • Additional Exemption: 0
  • Amount Value (percentage): 10
  • Millage: 6.50
  • Per Unit Value: 1000
  • Tax District Limit: none
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 0

Limit = District Limit (if available) or Limit = 80000

Assessment = Total Assessment of the bill = 100000

ExemptionValue = 80000

AssessedValue = 80000 * 10/100  (this value is rounded) = 8000

ExemptionAmount = 8000 * (6.5 / 1000)  - This value is rounded  

= $52

Example 2: Additional amount

  • Total Assessed Value: 100,000
  • Limit: 80,000
  • Additional Exemption: 1000
  • Amount Value (percentage): 10
  • Millage: 6.5
  • Per Unit Value: 1000
  • Tax District Limit: none
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

Limit = District Limit (if available) or Limit = 80000

Assessment = Total Assessment of the bill = 100000

ExemptionValue = 80000

AssessedValue = 80000 * 10/100  + 1000 (this value is rounded) = 9000

ExemptionAmount = 9000 * (6.5 / 1000)   - This value is rounded  

= $58.50

Example 3: Additional amount with district limit

  • Total Assessed Value: 100,000
  • Limit: 80,000
  • Additional Exemption: 1000
  • Amount Value (percentage): 10
  • Millage: 6.50
  • Per Unit Value: 1000
  • Tax District Limit: 120000
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 1000

Limit = District Limit (if available) or Limit = 120000

Assessment = Total Assessment of the bill = 100000

ExemptionValue = 100000

AssessedValue = 100000 * 10/100  + 1000 (this value is rounded) = 11000

ExemptionAmount = 11000 * (6.5 / 1000)   - This value is rounded  

= $71.50

Example 4: Additional amount on bill and schedule with a limit

  • Total Assessed Value: 100,000
  • Limit: 80,000
  • Additional Exemption on bill: 1000
  • Additional Exemption on schedule: 1000
  • Amount Value (percentage): 10
  • Millage: 6.5
  • Per Unit Value: 1000
  • Tax District Limit: none
AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill = 2000

Limit = District Limit (if available) or Limit = 80000

Assessment = Total Assessment of the bill = 100000

ExemptionValue = 80000

AssessedValue = 80000 * 10/100  + 2000 (this value is rounded) = 10000

ExemptionAmount = 10000 * (6.5 / 1000)   - This value is rounded  

= $65.00

Rate Table

AdditionalAmount = Additional Amount on the schedule + Additional Amount on the bill

Limit = District Limit (if available) or Limit

AssessmentToSearch = Total Assessment of the bill or limit whichever is lower

ExemptionValue = Amount from the rate table where the AssessmentToSearch is <= rate table limit

AdditionalCalculatedAmount = Additional  * (millage / Per Unit Value) - This value is rounded

AssessedValue = (ExemptionValue + AdditionalCalculatedAmount ) * Per Unit Value / millage  - this is rounded

ExemptionAmount = ExemptionValue + AdditionalCalculatedAmount  - This value is rounded

The Rate Table exemption compares the total assessed value of the tax property to a rate table with rows containing assessment limits and exemption amounts. When in ascending limit order, the first rate table "step" where the total assessment is less than or equal to the step's limit field should be chosen to determine the exemption amount.

Rate Table Exemption = (Amount field from first Rate Table step where Property Tax Bill's Total Assessment is <= the step's Limit)

If a limit is provided it will replace the total assessment

Rate table has with the following entries:

  1. Limit: 10,000 | Amount: $50.00
  2. Limit: 20,000 | Amount: $55.00
  3. Limit: 30,000 | Amount: $60.00
  4. Limit: 40,000 | Amount: $65.00
  5. Limit: 99,999 | Amount: $100.00
  • Limit: 9999999999
  • District Limit: none provided
  1. Total Assessed Value: $9000 | Exempted Amount: $50.00
  2. Total Assessed Value: $30,000 | Exempted Amount: $60.00
  3. Total Assessed Value: $30,001 | Exempted Amount: $65.00
  4. Total Assessed Value: $11,000 | Exempted Amount: $55.00
  5. Total Assessed Value: $100,000 (Above maximum limit) | Exempted Amount: $0
  • Limit : 1000
  • District Limit: 2000
  1. Total Assessed Value: $9000 | Exempted Amount: $50.00
  2. Total Assessed Value: $30,000 | Exempted Amount: $50.00
  3. Total Assessed Value: $30,001 | Exempted Amount: $50.00
  4. Total Assessed Value: $11,000 | Exempted Amount: $50.00
  5. Total Assessed Value: $100,000| Exempted Amount: $50.00

  • Limit: 99999999
  • District Limit: none
  • Additional: 1000
  • Millage: 6.50
  • Per Unit Value: 1000

Need to calculate the additional amount = 1000 * (6.5/1000) = 6.50

  1. Total Assessed Value: $9000 | Exempted Amount: $50.00 + 6.50= 56.50
  2. Total Assessed Value: $30,000 | Exempted Amount: $60.00 + 6.50= 66.50
  3. Total Assessed Value: $30,001 | Exempted Amount: $65.00+ 6.50= 71.50
  4. Total Assessed Value: $11,000 | Exempted Amount: $55.00+ 6.50= 61.50
  5. Total Assessed Value: $100,000 (Above maximum limit) | Exempted Amount: $0+ 6.50= 6.50
  • Limit: 2000
  • District Limit: 5000
  • Additional on bill: 500
  • Additional on schedule: 500
  • Millage: 6.50
  • Per Unit Value: 1000

Need to calculate the additional amount = (500+500) * (6.50/1000) = 6.50

  1. Total Assessed Value: $9000 | Exempted Amount: $50.00 + 6.50 = 56.50
  2. Total Assessed Value: $30,000 | Exempted Amount: $50.00 + 6.50 = 56.50
  3. Total Assessed Value: $30,001 | Exempted Amount: $50.00 + 6.50 = 56.50
  4. Total Assessed Value: $11,000 | Exempted Amount: $50.00 + 6.50 = 56.50
  5. Total Assessed Value: $100,000| Exempted Amount: $50.00 + 6.50 = 56.50