|
7/17/03
<br />EHLERS
<br />CITY OF LITTLE CANADA
<br />Page 2 of 2
<br />TAX INCREMENT: CASH FLOW
<br />Base Project
<br />PER100 BEGINNING Tax Tax
<br />Yrs. Mth. Yr. Capacity Capacity
<br />0.0 02 -01 2001 7,868 7,868
<br />0.0 08 -01 2001 7,868 7,868
<br />0.0 02 -01 2002 7,868 7,868
<br />0.0 08 -01 2002 7,868 7,868
<br />0.0 02 -01 2003 7,868 7,868
<br />0,0 08-01 2003 7,868 7,868
<br />0.0 02-01 2004 7,868 7,868
<br />00 0801 2004
<br />7,868
<br />7,668
<br />00,,,,0$ -01 2005 �„ S 7866 79,290f
<br />0.5 0801 2005 7,868
<br />1.0 02 -01 2006
<br />1.5 08-01 2006
<br />2.0 02 -01 2007
<br />2.5 08 -01 2007
<br />3.0 02 -01 2008
<br />3.5 08-01 2008
<br />4.0 02-01 2009
<br />4.5 08 -01 2009
<br />5.0 02 -01
<br />5.5 08-01
<br />6.0 02-01
<br />6.5 08-01
<br />7.0 02-01
<br />7.5 08-01
<br />8.0 02-01
<br />8.5 08-01
<br />9.0 02 -01
<br />9.5 08.01
<br />10.0 02 -01
<br />10.5 08-01
<br />11,0 02 -01
<br />11.5 08-01
<br />12.0 02 -01
<br />12.5 08 -01
<br />13.0 02 -01
<br />08 -01
<br />02 -01
<br />08 -01
<br />10.0 02-01
<br />15.5 08 -01
<br />2010
<br />2010
<br />2011
<br />2011
<br />2012
<br />2012
<br />2013
<br />2013
<br />2014
<br />2014
<br />2015
<br />2015
<br />2016
<br />2018
<br />2017
<br />2017
<br />2018
<br />2018
<br />2019
<br />2019
<br />2020
<br />2020
<br />7,668
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />7,868
<br />Totals
<br />79,290
<br />79,290
<br />79,290
<br />81,272
<br />81,272
<br />83,304
<br />83,304
<br />85,387
<br />85,387
<br />87,521
<br />87,521
<br />89,709
<br />89,709
<br />91,952
<br />91,952
<br />94,251
<br />94,251
<br />96,607
<br />96,607
<br />99,022
<br />99,022
<br />101,498
<br />101,498
<br />104,035
<br />104,035
<br />106,636
<br />106,636
<br />109,302
<br />109,302
<br />112,035
<br />112,035
<br />Fiscal Captured
<br />Disparities Tax
<br />Reduction Capacity
<br />Semi- Annual
<br />Gross Tax
<br />increment
<br />Slate
<br />Auditor
<br />0.36%
<br />Admin. Semi - Annual Semi - Annual
<br />at Net Tax Present
<br />10.00% Increment Value
<br />PAYMENT DATE
<br />PERIOD ENDING
<br />Yrs. Mth. Yr.
<br />26.50
<br />26,50
<br />26,50
<br />26,50
<br />27,16
<br />27,16
<br />27,84
<br />27,84
<br />28,54
<br />28,54
<br />29,25
<br />29,25
<br />29,98
<br />29,98
<br />30,73
<br />30,73
<br />31,50
<br />31,50
<br />32,29
<br />32,29
<br />33,10
<br />33,10
<br />33,92
<br />33,92
<br />34,77
<br />34,77
<br />35,64
<br />35,64
<br />36,53
<br />36.53
<br />37.45
<br />37,45
<br />Present Va
<br />44.91
<br />44,91
<br />44,91
<br />44.91
<br />46,23
<br />46,23
<br />47,59
<br />47,59
<br />48,97
<br />48,97
<br />50,39
<br />50.39
<br />51,85
<br />51,85
<br />53,34
<br />53,34
<br />54.87
<br />54,87
<br />56,44
<br />56,44
<br />58,05
<br />58,05
<br />59,70
<br />59,70
<br />61,39
<br />61,39
<br />63,12
<br />63,12
<br />64,89
<br />64,89
<br />66,71
<br />66,71
<br />e Date - 8 -01 -03
<br />Present Value Date - 8,01,03
<br />23,16
<br />23,16
<br />23,16
<br />23,16
<br />23,84
<br />23,84
<br />24,54
<br />24,54
<br />25,25
<br />25,25
<br />25,99
<br />25,99
<br />26,74
<br />26,74
<br />27,51
<br />27,51
<br />28,30
<br />28,30
<br />29,11
<br />29,11
<br />29,94
<br />29,94
<br />30,79
<br />30,79
<br />31,66
<br />31,66
<br />32,55
<br />32,55
<br />33,46
<br />33,46
<br />34,40
<br />34.40
<br />900,91
<br />530,53
<br />0
<br />0
<br />0
<br />(83)
<br />(83)
<br />(83)
<br />(83)
<br />(86)
<br />(86)
<br />(88)
<br />(88)
<br />(91)
<br />(91)
<br />(94)
<br />(94)
<br />(96)
<br />(96)
<br />(99)
<br />(99)
<br />(102)
<br />(102)
<br />(105)
<br />(105)
<br />(108)
<br />(108)
<br />(111)
<br />(111)
<br />(114)
<br />(114)
<br />(117)
<br />(117)
<br />(120)
<br />(120)
<br />(124)
<br />(124)
<br />(3,243)
<br />(1,910)
<br />0
<br />0
<br />0
<br />(2,308)
<br />(2,308)
<br />(2,308)
<br />(2,308)
<br />(2,376)
<br />(2,376)
<br />(2,446)
<br />(2,446)
<br />(2,517)
<br />(2,517)
<br />(2,590)
<br />(2,590)
<br />(2,665)
<br />(2,665)
<br />(2,741)
<br />(2,741)
<br />(2,820)
<br />(2,820)
<br />(2,901)
<br />(2,901)
<br />(2,983)
<br />(2,983)
<br />(3,068)
<br />(3,068)
<br />(3,155)
<br />(3,155)
<br />(3,244)
<br />(3,244)
<br />(3,335)
<br />(3,335)
<br />(3,428)
<br />(3,428)
<br />(89,768)
<br />(52,863)
<br />0
<br />0
<br />0
<br />20,774
<br />20,774
<br />20,774
<br />20,774
<br />21,304
<br />21,384
<br />22,010
<br />22,010
<br />22,651
<br />22,651
<br />23,308
<br />23,308
<br />23,982
<br />23,902
<br />24,672
<br />24,672
<br />25,380
<br />25,380
<br />26,105
<br />26,105
<br />26,849
<br />26,849
<br />27,611
<br />27,611
<br />28,392
<br />28,392
<br />29,193
<br />29,193
<br />30,014
<br />30,014
<br />30,855
<br />30,855
<br />807,908
<br />475,765
<br />0
<br />0
<br />0
<br />18,637
<br />36,]]6
<br />54,429
<br />71,610
<br />88,522
<br />105,573
<br />122,353
<br />136,684
<br />155,041
<br />170,960
<br />186,903
<br />202,419
<br />217,956
<br />233,077
<br />248,217
<br />262,952
<br />277,704
<br />292,062
<br />306,434
<br />320.422
<br />334,423
<br />348,050
<br />361,668
<br />3]4,961
<br />388,244
<br />401,1]2
<br />414,109
<br />426,700
<br />439,298
<br />451,559
<br />463,826
<br />475,765
<br />0.0
<br />0.0
<br />0.0
<br />0.0
<br />0.0
<br />0,0
<br />0,0
<br />0.0
<br />05
<br />08-01
<br />02 -01
<br />08-01
<br />02 -01
<br />08 -01
<br />02 -01
<br />08-01
<br />02-01
<br />1.0 02 -01
<br />1.5 08-01
<br />2.0 02 -01
<br />2.5 08-01
<br />3.0 0201
<br />3.5 08-01
<br />4.0 02 -01
<br />4.5 08.01
<br />5.0 02 -01
<br />5.5 08 -01
<br />6.0 02 -01
<br />6.5 08 -01
<br />7.0 02 -01
<br />7.5 08 -01
<br />8.0 02 -01
<br />8.5 08-01
<br />9.0 02-01
<br />9.5 08-01
<br />10.0 02-01
<br />10.5 08-01
<br />11.0 02 -01
<br />11.5 0801
<br />12.0 02 -01
<br />12.5 08 -01
<br />13.0 02-01
<br />13,5 08-01
<br />140 02-01
<br />14,5 08 -01
<br />15,0 02 -01
<br />15.5 08 -01
<br />16.0 02 -01
<br />2001
<br />2002
<br />2002
<br />2003
<br />2003
<br />2004
<br />2004
<br />2005
<br />1440.0Z:
<br />2006
<br />2006
<br />2007
<br />2007
<br />2608
<br />2008
<br />2009
<br />2009
<br />2010
<br />2010
<br />2011
<br />2011
<br />2012
<br />2012
<br />2013
<br />2013
<br />2014
<br />2014
<br />2015
<br />2015
<br />2016
<br />2016
<br />2017
<br />2017
<br />2018
<br />2018
<br />2019
<br />2019
<br />2020
<br />2020
<br />2021
<br />NOTES:
<br />1. Inflation on tax rates cannot be captured.
<br />2. TIF does not capture state wide property taxes or market value property taxes
<br />Prepared by Ehiers
<br />3-
<br />run higher my and Inwnon.xls
<br />
|