{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.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 scheduleType - 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:
- Limit: 10,000 | Amount: $50.00
- Limit: 20,000 | Amount: $55.00
- Limit: 30,000 | Amount: $60.00
- Limit: 40,000 | Amount: $65.00
- Limit: 99,999 | Amount: $100.00
- Limit: 9999999999
- District Limit: none provided
- Total Assessed Value: $9000 | Exempted Amount: $50.00
- Total Assessed Value: $30,000 | Exempted Amount: $60.00
- Total Assessed Value: $30,001 | Exempted Amount: $65.00
- Total Assessed Value: $11,000 | Exempted Amount: $55.00
- Total Assessed Value: $100,000 (Above maximum limit) | Exempted Amount: $0
- Limit : 1000
- District Limit: 2000
- Total Assessed Value: $9000 | Exempted Amount: $50.00
- Total Assessed Value: $30,000 | Exempted Amount: $50.00
- Total Assessed Value: $30,001 | Exempted Amount: $50.00
- Total Assessed Value: $11,000 | Exempted Amount: $50.00
- 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
- Total Assessed Value: $9000 | Exempted Amount: $50.00 + 6.50= 56.50
- Total Assessed Value: $30,000 | Exempted Amount: $60.00 + 6.50= 66.50
- Total Assessed Value: $30,001 | Exempted Amount: $65.00+ 6.50= 71.50
- Total Assessed Value: $11,000 | Exempted Amount: $55.00+ 6.50= 61.50
- 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
- Total Assessed Value: $9000 | Exempted Amount: $50.00 + 6.50 = 56.50
- Total Assessed Value: $30,000 | Exempted Amount: $50.00 + 6.50 = 56.50
- Total Assessed Value: $30,001 | Exempted Amount: $50.00 + 6.50 = 56.50
- Total Assessed Value: $11,000 | Exempted Amount: $50.00 + 6.50 = 56.50
- Total Assessed Value: $100,000| Exempted Amount: $50.00 + 6.50 = 56.50