|
TAX INCREMENT CASH FLOW
<br />PERIOD BEGINNING
<br />Mth. Yr.
<br />Original
<br />Tax
<br />Capacity
<br />Project
<br />Tax
<br />Capacity
<br />Captured Semi - Annual State Auditor
<br />Tax Gross Tax at
<br />Capacity Increment -0.50%
<br />Admin Semi- Annual Cumul.
<br />at Net Tax NPV
<br />- 10.00% Increment 6.50%
<br />Annual
<br />Net Tax
<br />Increment
<br />PAYMENT DATE/
<br />PERIOD ENDING
<br />Yrs. Mth.
<br />Yr.
<br />08 -01
<br />2002
<br />0
<br />0
<br />02 -01
<br />2003
<br />02-01
<br />2003
<br />0
<br />0
<br />0
<br />08 -01
<br />2003
<br />08-01
<br />2003
<br />33,655
<br />33,655
<br />0
<br />0
<br />02 -01
<br />2004
<br />02 -01
<br />2004
<br />33,655
<br />33,655
<br />0
<br />0.5 08 -01
<br />2004
<br />08 -01
<br />2004
<br />33,655
<br />33,655
<br />0
<br />0
<br />1.0 02 -01
<br />2005
<br />02 -01
<br />2005
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />42,581
<br />1.5 08 -01
<br />2005
<br />08 -01
<br />2005
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />83,823
<br />99,931
<br />2.002 -01
<br />2006
<br />02-01
<br />2006
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />123,765
<br />2.5 08 -01
<br />2006
<br />08-01
<br />2006
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96)
<br />162,451
<br />99,931
<br />3.0 02 -01
<br />2007
<br />02 -01
<br />2007
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />199,919
<br />3.5 08 -01
<br />2007
<br />08 -01
<br />2007
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />236,208
<br />99.931
<br />4.0 02 -01
<br />2008
<br />02 -01
<br />2008
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />271,354
<br />4.5 08 -01
<br />2008
<br />08 -01
<br />2008
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />305,394
<br />99,931
<br />5.0 02 -01
<br />2009
<br />02-01
<br />2009
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />338,363
<br />5.5 08 -01
<br />2009
<br />0801
<br />2009
<br />33.655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49.96
<br />370,293
<br />99,931
<br />6.0 02 -01
<br />2010
<br />02 -01
<br />2010
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />401,219
<br />6.5 08 -01
<br />2010
<br />08 -01
<br />2010
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />431,171
<br />99.931
<br />7.0 02 -01
<br />2011
<br />02 -01
<br />2011
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />460,181
<br />7.5 08 -01
<br />2011
<br />08-01
<br />2011
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />488,277
<br />99,931
<br />8.0 02 -01
<br />2012
<br />02.01
<br />2012
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />515,489
<br />8.5 08 -01
<br />2012
<br />08 -01
<br />2012
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />541,844
<br />99,931
<br />9.0 02 -01
<br />2013
<br />02-01
<br />2013
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />567,370
<br />9.5 08 -01
<br />2013
<br />08-01
<br />2013
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />592,093
<br />99,931
<br />10.0 02 -01
<br />2014
<br />02 -01
<br />2014
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />616,037
<br />10.5 08 -01
<br />2014
<br />08 -01
<br />2014
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />639,227
<br />99,931
<br />11.0 02 -01
<br />2015
<br />02 -01
<br />2015
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />661,688
<br />11.5 08 -01
<br />2015
<br />08-01
<br />2015
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />683,441
<br />99,931
<br />12.0 02 -01
<br />2016
<br />0201
<br />2016
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />704,510
<br />12.5 08 -01
<br />2016
<br />08 -01
<br />2016
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49.96
<br />724,915
<br />99,931
<br />13.0 02 -01
<br />2017
<br />02 -01
<br />2017
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />744,679
<br />13.5 08 -01
<br />2017
<br />08 -01
<br />2017
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />763,820
<br />99,931
<br />14.0 02 -01
<br />2018
<br />02 -01
<br />2018
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />782,359
<br />14.5 08 -01
<br />2018
<br />08 -01
<br />2018
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55)
<br />49,96
<br />800,314
<br />99,931
<br />15.0 02 -01
<br />2019
<br />02 -01
<br />2019
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55
<br />) 49,96
<br />817,704
<br />15.5 08 -01
<br />2019
<br />08 -01
<br />2019
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55
<br />) 49,96
<br />834,546
<br />99,931
<br />16.0 02.01
<br />2020
<br />02 -01
<br />2020
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55
<br />) 49,96
<br />850,859
<br />16.5 08 -01
<br />2020
<br />08 -01
<br />2020
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55
<br />) 49,96
<br />866,658
<br />99,931
<br />17.0 02 -01
<br />2021
<br />02 -01
<br />2021
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27 )
<br />(5,55
<br />) 49,96
<br />881,959
<br />17.5 08 -01
<br />2021
<br />08 -01
<br />2021
<br />33.655
<br />143,988
<br />110.33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />896,779
<br />99,931
<br />18.0 02-01
<br />2022
<br />02 -01
<br />2022
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />911,133
<br />18.5 08 -01
<br />2022
<br />08 -01
<br />2022
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />925,035
<br />99,931
<br />19.0 02 -01
<br />2023
<br />02 -01
<br />2023
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />938,499
<br />19.5 08.01
<br />2023
<br />08 -01
<br />2023
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />951,539
<br />99,931
<br />20.0 02 -01
<br />2024
<br />02 -01
<br />2024
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />964,169
<br />20.5 08 -01
<br />2024
<br />08 -01
<br />2024
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49.96
<br />976,401
<br />99,931
<br />21.0 02 -01
<br />2025
<br />02 -01
<br />2025
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />988,248
<br />21.5 08 -01
<br />2025
<br />08 -01
<br />2025
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />999,723
<br />99,931
<br />22.0 02 -01
<br />2026
<br />02 -01
<br />2026
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,010,836
<br />22.508 -01
<br />2026
<br />08 -01
<br />2026
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,021,599
<br />99,931
<br />23.0 02 -01
<br />2027
<br />0201
<br />2027
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,032,024
<br />23.5 08 -01
<br />2027
<br />08 -01
<br />2027
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,042,120
<br />99,931
<br />24.0 02 -01
<br />2028
<br />02 -01
<br />2028
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,051,899
<br />24.5 08 -01
<br />2028
<br />08 -01
<br />2028
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,061,370
<br />99,931
<br />25.0 02 -01
<br />2029
<br />02 -01
<br />2029
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49,96
<br />1,070,542
<br />25.5 0801
<br />2029
<br />08 -01
<br />2029
<br />33,655
<br />143,988
<br />110,33
<br />55,79
<br />(27)
<br />(5,55
<br />) 49.96
<br />1,079,426
<br />99,931
<br />26.0 02 -01
<br />2030
<br />Totals 2,789,812 (13.949)
<br />(277.586) 2,498.277
<br />Present Values from 8/1/03 1,244.565
<br />1.114.508
<br />mats oNy 6000 uponrnrten estimates tor value aa a -out. TIzepmjmions wilt not even mg
<br />pen cha geu to We properly ra system and the actual development schedule
<br />Maximum total increment is 26 ycare. Ifaty small :m0111113 of increment are received in 2003 or 2004, the tens of the district will be shortened
<br />N\Miutsot9Littlo Canada \ TIE 3 -3 est & 3-2 mod4Iifptan .casldlowl.XLSttifmn02o1
<br />BUT / FOR ANALYSIS
<br />Current Market Value - Est.
<br />NeW Market Value - Est.
<br />Difference
<br />Present Value of Tax Increment
<br />Difference
<br />Value Likely 10 Occur tAdthout TIF Is Less Than'
<br />2,692.400
<br />12.003.000
<br />9,310,600
<br />1.244.565
<br />8,066,035
<br />8,066,035
<br />
|