Page 244 - 2018 Village Ordinance Book 122818

Increment Revenue Projections

Village of Sturtevant, WI

Tax Increment District #4

Tax Increment Projection Worksheet

Type of District Mixed Use Base Value 54,090,657
District Creation Date Appreciation Factor 0.00%
September 6, 2016 Apply to Base Value
Valuation Date Base Tax Rate $21.89
Max Life (Years) Jan 1, 2016 Rate Adjustment Factor
Expenditure Period/Termination 3.50%
Revenue Periods/Final Year 20 Tax Exempt Discount Rate 5.00%
Extension Eligibility/Years Taxable Discount Rate
Recipient District 15 9/6/2031

20 2037

Yes 3

No

Construction Valuation Inflation Total Revenue Tax Tax Exempt
Year Value Added Year Year Increment NPV Taxable NPV
Increment Increment Tax Rate
Calculation Calculation

1 2016 4,386,400 2017 0 4,386,400 2018 $21.89 96,011 92,764 91,439
2 2017 5,150,000 2018 0 9,536,400 2019 $21.89 208,736 287,621 280,768
3 2018 16,500,000 2019 0 26,036,400 2020 $21.89 569,892 801,631 773,063
4 2019 5,300,000 2020 0 31,336,400 2021 $21.89 685,900 1,399,354 1,337,355
5 2020 17,500,000 2021 0 48,836,400 2022 $21.89 1,068,946 2,299,377 2,174,901
6 2021 10,000,000 2022 0 58,836,400 2023 $21.89 1,287,829 3,347,027 3,135,899
7 2022 12,000,000 2023 0 70,836,400 2024 $21.89 1,550,488 4,565,696 4,237,802
8 2023 12,000,000 2024 0 82,836,400 2025 $21.89 1,813,148 5,942,622 5,465,012
9 2024 12,000,000 2025 0 94,836,400 2026 $21.89 2,075,807 7,465,706 6,803,095
10 2025 8,700,000 2026 0 103,536,400 2027 $21.89 2,266,235 9,072,282 8,194,367
11 2026 2027 0 103,536,400 2028 $21.89 2,266,235 10,624,531 9,519,388
12 2027 0 2028 0 103,536,400 2029 $21.89 2,266,235 12,124,287 10,781,313
13 2028 0 2029 0 103,536,400 2030 $21.89 2,266,235 13,573,328 11,983,146
14 2029 0 2030 0 103,536,400 2031 $21.89 2,266,235 14,973,367 13,127,749
15 2030 0 2031 0 103,536,400 2032 $21.89 2,266,235 16,326,061 14,217,847
16 2031 0 2032 0 103,536,400 2033 $21.89 2,266,235 17,633,013 15,256,035
17 2032 0 2033 0 103,536,400 2034 $21.89 2,266,235 18,895,768 16,244,786
18 2033 0 2034 0 103,536,400 2035 $21.89 2,266,235 20,115,821 17,186,454
19 2034 0 2035 0 103,536,400 2036 $21.89 2,266,235 21,294,616 18,083,280
20 2035 0 2036 0 103,536,400 2037 $21.89 2,266,235 22,433,548 18,937,400
0

Totals 103,536,400 0 Future Value of Increment 34,285,345

Notes:

Actual results will vary depending on development, inflation of overall tax rates.
NPV calculations represent estimated amount of funds that could be borrowed (including project cost, capitalized interest and issuance costs).

____________________________________________________________________________________________

Project Plan TID No. 4 Territory & Project Plan Amendment Village of Sturtevant
June 5, 2018
Submitted by Ehlers Page 27