City of Lino Lakes, Minnesota
<br />Legacy Project
<br />April 30, 2008
<br />Page 3
<br />Scenario 2
<br />Scenario 2 is a worst -case scenario using the same assumptions as in Scenario 1 with two exceptions:
<br />• No additional development occurs beyond what is currently existing
<br />• Utilizes the maximum term of the TIF District which is 26 years of collection
<br />o The bond issue and other financings were constructed around 17 years of tax increment
<br />collections, although the TIF Plan did not mandate that the district be decertified early. This
<br />scenario uses an additional nine years of tax increment, as is allowed by state law.
<br />Collect
<br />Year
<br />(1)
<br />2006
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />2013
<br />2014
<br />2015
<br />2016
<br />2017
<br />2018
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />2032
<br />1.22,109
<br />25,007
<br />28,967
<br />om_ !-348.;,
<br />Pooled MSA
<br />TIF Funds
<br />1 -10
<br />(3) (4)
<br />39,865 50,000
<br />37,336 245,500
<br />37,336 245,500
<br />37,336 245,500
<br />37,336 245,500
<br />O 245,500
<br />O 245,500
<br />O 245,500
<br />O 245,500
<br />O 245,500
<br />O 0
<br />O 0
<br />0 0
<br />O 0
<br />O 0
<br />O 0
<br />0 0
<br />O 0
<br />0 0
<br />O 0
<br />O 0
<br />O 0
<br />O 0
<br />0 0
<br />O 0
<br />O 0
<br />189,209 2,259,500
<br />GO TIF TIF
<br />TIF Interfund Developer
<br />Bonds Loan Note
<br />$4.215M $950K $1.0M
<br />(6) (7) (8)
<br />92,298 0 0
<br />334,526 0 0
<br />337,926 0 0
<br />370,926 0 0
<br />412,326 0 0
<br />421,726 0 0
<br />470,326 0 0
<br />471,526 0 0
<br />477,126 0 0
<br />481,926 0 0
<br />255,926 0 0
<br />258,326 0 0
<br />265,326 0 0
<br />271,726 0 0
<br />277,526 0 0
<br />287,481 0 0
<br />291,550 0 0
<br />O 0 0
<br />O 0 0
<br />0 0 0
<br />O 0 0
<br />O 0 0
<br />O 0 0
<br />O 0 0
<br />O 0 0
<br />O 0 0
<br />5,778,496 0 0
<br />Average Annual
<br />Investment Surplus
<br />Earnings (Deficit)
<br />0.00%
<br />(10) (11)
<br />O 3,198
<br />O 24,968
<br />O 21,568
<br />O (11,432)
<br />O (52,832)
<br />0 (97,578)
<br />O (144,148)
<br />O (143,278)
<br />O (146,766)
<br />O (149,412)
<br />O (166,715)
<br />O (166,874)
<br />0 (171,588)
<br />0 (175,657)
<br />O (179,079)
<br />0 (186,608)
<br />O (188,202)
<br />O 105,871
<br />O 108,445
<br />O 111,071
<br />O 113,749
<br />O 116,480
<br />0 119,266
<br />O 122,109
<br />O 125,007
<br />O 128,967
<br />O (879,471)
<br />This scenario results in a deficit at the end of the district of $879,471. In this worst -case scenario, the deficit would
<br />be covered through additional MSA dollars. It is unlikely that this is a realistic scenario; however, it is important to
<br />understand the impact of a worst -case scenario.
<br />
|