Page 245 - 2018 Village Ordinance Book 122818

Cash Flow

Village of Sturtevant, WI

Tax Increment District #4

Cash Flow Projection

Projected Revenues

Year 2018 Land Sale State Trust Fund Loan G.O. Notes G.O. Bond G.O. Bond G.O. B
2,475,000
Premium Land Sale Revenue 800,000 3,280,000 3,280,000 3,280,0
04/19/18
Tax Deposit to Revenue Loumos Total DD: 02/06/18 DD: DD: 04/01/19 DD: 04/01/21 DD:

Increments D/S Fund U.S. Bank Heights Revenues Prin. Rate Interest Prin. Rate Interest Prin. Interest1 Prin. Interest1 Prin.

2016 6,477 300,000 910,000 0 28,007
2017 60,940 1,312,488 62,238
2018 96,011 74,691 3.50% 30,838 4.00% 58,238 57,244
2019 208,736 269,676 80,074 3.50% 25,455 200,000 4.00% 50,238 165,000 114,488 165,000 65,041 250,000
2020 569,892 569,892 82,947 3.50% 22,583 200,000 4.00% 42,238 240,000 114,488 260,000 127,319 375,000
2021 685,900 685,900 85,850 3.50% 19,680 200,000 4.00% 34,238 200,000 112,136 260,000 120,135 300,000
2022 1,068,946 1,068,946 88,854 3.50% 16,675 200,000 4.00% 26,138 250,000 106,305 300,000 111,230 385,000
2023 1,287,829 1,287,829 91,927 3.50% 13,603 205,000 2.55% 19,424 250,000 99,875 215,000 101,345 255,000
2024 1,550,488 1,550,488 95,182 3.50% 10,348 205,000 2.65% 14,094 300,000 93,050 300,000 91,914 265,000
2025 1,813,148 1,813,148 98,513 3.50% 7,017 205,000 2.75% 8,559 200,000 85,113 200,000 82,183 300,000
2026 2,075,807 2,075,807 101,961 3.50% 3,569 205,000 2.80% 2,870 200,000 76,100 200,000 72,633 170,000
2027 2,266,235 2,266,235 205,000 200,000 67,800 200,000 64,833 170,000
2028 2,266,235 2,266,235 200,000 61,000 150,000 56,833 170,000
2029 2,266,235 2,266,235 200,000 54,000 150,000 49,633 170,000
2030 2,266,235 2,266,235 175,000 46,750 175,000 43,220 170,000
2031 2,266,235 2,266,235 175,000 39,200 175,000 36,108 170,000
2032 2,266,235 2,266,235 175,000 31,938 175,000 28,320 130,000
2033 2,266,235 2,266,235 175,000 25,025 175,000 20,401
2034 2,266,235 2,266,235 175,000 17,981 180,000 12,395
2035 2,266,235 2,266,235 10,850
2036 2,266,235 2,266,235 4,185
2037 2,266,235 2,266,235 3,631

Total 34,285,345 67,417 300,000 910,000 35,562,762 799,999 149,768 1,825,000 346,278 3,280,000 1,216,973 3,280,000 1,087,725 3,280,000

Notes:
1. Assumes 5/7/2018 BQ A1 Interest Rate Scale in the following years:
2019 +0.5%
2021 +1%
2023 +1.5%
2025 +2%
2027 +2.5%
2028 +3%
2. Ashley capital receives $70,000 for 10 years.
3. Grand Appliance receives 50% of increment for up to 8 years not to exceed $450,000.

____________________________________________________________________________________________

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