|
TAX INCREMENT CASH FLOW'
<br />PERIOD BEGINNING
<br />Mth.
<br />Yr.
<br />Original
<br />Tax
<br />Capacity
<br />Project Captured Semi-AnnualState Auditor
<br />Tax Tax Gross Tax at
<br />Capacity Capacity Increment -0.50%
<br />Admin
<br />at
<br />- 10.00%
<br />Semi - Annual Cumul.
<br />Net Tax NPV
<br />Increment 6.50%
<br />Annual
<br />Net Tax
<br />Increment
<br />PAYMENT DATE/
<br />PERIOD ENDING
<br />Yrs. Mlh.
<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 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 110,33
<br />55,79
<br />(27)
<br />(5,55.)
<br />49,96
<br />83,823
<br />99,931
<br />2.0 02 -01
<br />2006
<br />02 -01
<br />2006
<br />33,655
<br />143,988 110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49.96
<br />123,765
<br />2.5 08 -01
<br />2006
<br />06 -01
<br />2006
<br />33,655
<br />143,988 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 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 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 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 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 110,33
<br />55,79
<br />(27)
<br />(5,55.)
<br />49,96
<br />338,363
<br />5.5 08 -01
<br />2009
<br />08 -01
<br />2009
<br />33,655
<br />143,988 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 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 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 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 110,33
<br />55,79
<br />(27)
<br />(5,55.)
<br />4996
<br />488,277
<br />99,931
<br />8.0 02-01
<br />2012
<br />02 -01
<br />2012
<br />33,655
<br />143,988 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 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 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 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 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 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 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 110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />683,441
<br />99,931
<br />12.002 -01
<br />2016
<br />02 -01
<br />2016
<br />33,655
<br />143,988 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 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 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 110,33
<br />55,79
<br />(27)
<br />(555)
<br />49,96
<br />763,820
<br />99,931
<br />140 02 -01
<br />2018
<br />02 -01
<br />2018
<br />33,655
<br />143,988 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 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 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 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 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 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 110,33
<br />55,79
<br />(27)
<br />(5,55)
<br />49,96
<br />881,959
<br />178 08 -01
<br />2021
<br />08 -01
<br />2021
<br />33,655
<br />143,988 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 110,33
<br />55.79
<br />(27)
<br />(5,55)
<br />49,96
<br />911,133
<br />18.508 -01
<br />2022
<br />08-01
<br />2022
<br />33,655
<br />143,988 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 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 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 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 110,33
<br />55,79
<br />(27
<br />)
<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 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 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 110,33
<br />55,79
<br />(27
<br />)
<br />(5,55)
<br />49,96
<br />1,010,836
<br />22.5 08 -01
<br />2026
<br />08 -01
<br />2026
<br />33,655
<br />143,988 110,33
<br />55,79
<br />(27
<br />)
<br />(5,55)
<br />49,96
<br />1.021,599
<br />99,931
<br />23.0 02 -01
<br />2027
<br />02-01
<br />2027
<br />33,655
<br />143,988 110,33
<br />55,79
<br />(27
<br />)
<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 110,33
<br />55,79
<br />(27
<br />)
<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 110,33
<br />55,79
<br />(27
<br />)
<br />(5,55)
<br />49,96
<br />1,051,899
<br />24.5 00 -01
<br />2028
<br />08 -01
<br />2028
<br />33,655
<br />143,988 110,33
<br />55,79
<br />(27
<br />)
<br />(5.55)
<br />49,56
<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 110,33
<br />55,79
<br />(27
<br />)
<br />(5,55)
<br />49,96
<br />1,070,542
<br />25.5 08 -01
<br />2029
<br />08 -01
<br />2029
<br />33,655
<br />143.968 110,33
<br />55,79
<br />(27
<br />)
<br />(5,55)
<br />49,96
<br />1,079,426
<br />99,931
<br />26.002 -01
<br />2030
<br />Totals 2,789,81
<br />(13,94
<br />)
<br />(277,50)
<br />2,498,27
<br />Present Values from 8 /1/03 1,244.565
<br />1,114,50
<br />"ThRe proiectima are menmtm only u:aed upon aurae alOnaa for .0 ne anti bwlnoul. The projections will van depar
<br />pen Menem to the property taxsysten
<br />Mavnllml total incmnan is 26 yetis. If any steal ,mtaa 03 of increment are received in2003 or 2001, One tern of the disena will be shortened
<br />NIVAtiasot-alLit le CenaMOTIF 3-3 mt & 3-2 amd4tiiplaccmhfowl YLS11irun0201
<br />BUT / FOR ANALYSIS
<br />Current tomcat Valve - Esl.
<br />New Market Value - Est.
<br />Difference
<br />Present Value of Tax Increment
<br />Difference
<br />Valve Jittery 0 Occur Vathot11 TIE is Less Than:
<br />2.692.400
<br />12,003,000
<br />9310500
<br />1.244665
<br />8,066,05
<br />8066,035
<br />he actual developmentsche,hde
<br />
|