7)372003
<br />EHLERS
<br />CITY OF LITTLE CANADA
<br />Page 2 0l2
<br />NOTES:
<br />1. Inflation on lax rates cannot he captured,
<br />2. TIF does not capture slate wide property taxes or market value properly taxes
<br />FOR'ANAGY
<br />Current MaMOl Value • Est.
<br />Now Markel Value - Est.
<br />Difference
<br />Present Value of Tax Increment
<br />Oittemnce
<br />Value Likely to Occur Without Tax Increment is Lass Thom
<br />2.800.000
<br />0,990,000
<br />9.190,000
<br />030.700
<br />7,259,300
<br />1,290,386
<br />Prepared by Ehlers
<br />plani
<br />a TAX INCREMENT CASH FLOW
<br />Base Project
<br />PERIOD BEGINNING Tax Tax
<br />Yrs, Mth, Yr. Capacity Capacity
<br />Fiscal Captured Semiannual State
<br />mspannas Tax Gross Tax Auditor
<br />Rodecu.n Capacity Increment 0.35%
<br />Admin.
<br />at
<br />10.00%
<br />Seml-Annual
<br />Net Tax
<br />Incrolnent
<br />Sem•Annual
<br />Present
<br />Value
<br />PAYMENT DATE
<br />PERIOD ENDING
<br />Yrs. Mth.
<br />Yr.
<br />0.0 02-01 2001
<br />55,250
<br />55250
<br />0.0
<br />0001
<br />2001
<br />0.0 08-01 2001
<br />55.250
<br />55.250
<br />0.0
<br />0201
<br />2002
<br />0.0 02-01 2002
<br />55,250
<br />55250
<br />0.0
<br />0801
<br />2002
<br />0.0 08-01 2002
<br />55,250
<br />55,250
<br />00
<br />02.01
<br />2003
<br />0.0 02-01 2003
<br />55,250
<br />55,250
<br />Present Value Date - 5.01.03
<br />0-0
<br />08-01
<br />2003
<br />0-0 0801 2003
<br />55,250
<br />55,250
<br />0
<br />0
<br />0
<br />0.0
<br />02.01
<br />2004
<br />0.0 0201 2004
<br />55,250
<br />55.250
<br />0
<br />0
<br />0
<br />0.0
<br />08-01
<br />2004
<br />0,0 08-01 2004
<br />55,250
<br />55.250
<br />0
<br />0
<br />0
<br />0.0
<br />02-01
<br />2005
<br />00 = 02 -01 2005 '
<br />55r250
<br />107,075,
<br />2542
<br />2620
<br />14,87
<br />(54)
<br />(1,482)
<br />13,342
<br />11,9
<br />0.5,
<br />9801
<br />2005.'.
<br />0.5 08-01 2005
<br />55,250
<br />107,876
<br />2642
<br />26.20
<br />14,87
<br />(54)
<br />(1,482)
<br />13.342
<br />23.62
<br />1.0
<br />02.01
<br />2006
<br />1.0 02 -01 2006
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51.14
<br />(184)
<br />(5,097)
<br />45,869
<br />62.59
<br />1.5
<br />08-01
<br />2006
<br />1.5 08-01 2006
<br />55250
<br />218,300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />95,869
<br />100.53
<br />2.0
<br />02-01
<br />2007
<br />2.0 02 -01 2007
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45.869
<br />137.45
<br />2.5
<br />08-01
<br />2007
<br />2.5 0801 2007
<br />55,250
<br />218.300
<br />7297
<br />90,08
<br />51.14
<br />(184)
<br />(5,097)
<br />45,869
<br />173.38
<br />3.0
<br />02-01
<br />2008
<br />3.0 02 -01 2008
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51.14
<br />(184)
<br />(5,097)
<br />95.869
<br />208,35
<br />3.5
<br />08-01
<br />2008
<br />3.5 08-01 2008
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45.869
<br />242,39
<br />4.0
<br />0201
<br />2009
<br />4.0 02 -01 2009
<br />55,250
<br />218,300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45.869
<br />275,51
<br />4.5
<br />08.01
<br />2009
<br />4.5 08-01 2009
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />307,75
<br />5.0
<br />0201
<br />2010
<br />5.0 02 -01 2010
<br />55,250
<br />218,300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45.869
<br />339,12
<br />5.5
<br />0801
<br />2010
<br />5.5 08.01 2010
<br />55,250
<br />218,300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45.869
<br />369,66
<br />6.0
<br />02 -01
<br />2011
<br />6.0 02 -01 2011
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51,19
<br />(184)
<br />(5,097)
<br />45,869
<br />399,37
<br />6.5
<br />0801
<br />2011
<br />6.5 08-01 2011
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />428,29
<br />7.0
<br />0201
<br />2012
<br />7.0 02 -01 2012
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />456.44
<br />7.5
<br />0601
<br />2012
<br />7.5 08-01 2012
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />483.84
<br />8.0
<br />02 -01
<br />2013
<br />8.0 02 -01 2013
<br />55,250
<br />218.300
<br />72,97
<br />90.08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />510.50
<br />8.5
<br />0801
<br />2013
<br />8.5 08-01 2013
<br />55.250
<br />218.300
<br />72,97
<br />90.06
<br />51,14
<br />(189)
<br />(5.097)
<br />45,869
<br />536.44
<br />9.0
<br />02 -01
<br />2014
<br />9.0 0201 2014
<br />55,250
<br />218,300
<br />72.97
<br />90,08
<br />5114
<br />(184)
<br />(5.097)
<br />45,869
<br />561,70
<br />9.5
<br />08-01
<br />2014
<br />9.5 08 -01 2014
<br />55,250
<br />218000
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5.097)
<br />45.869
<br />58828
<br />10.0
<br />0201
<br />2015
<br />10.0 02 -01 2015
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />610,19
<br />10.5
<br />08 -01
<br />2015
<br />10.5 08 -01 2015
<br />55,250
<br />218,300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />633,47
<br />11.0
<br />02 -01
<br />2016
<br />11.0 02 -01 2016
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />656,13
<br />115
<br />08 -01
<br />2016
<br />11.5 08-01 2016
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />678,18
<br />12.0
<br />0201
<br />2017
<br />12.0 02-01 2017
<br />55,250
<br />218.300
<br />72,97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,069
<br />699,64
<br />12.5
<br />08-01
<br />2017
<br />12.5 0801 2017
<br />55,250
<br />218,300
<br />72,97
<br />90,08
<br />51,19
<br />(184)
<br />(5.097)
<br />45,869
<br />720.53
<br />13.0
<br />0201
<br />2018
<br />13.0 02 -01 2010
<br />55,250
<br />218,300
<br />72,97
<br />90,08
<br />51,19
<br />(184)
<br />(5.097)
<br />45,860
<br />740,85
<br />13.5
<br />08-01
<br />2018
<br />13.5 0801 2018
<br />55,250
<br />218,300
<br />72,97
<br />90,8
<br />51.14
<br />(184)
<br />(5.097)
<br />45,869
<br />760,63
<br />14.0
<br />02 -01
<br />2019
<br />14.0 02-01 2019
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />779,89
<br />14.5
<br />08-01
<br />2019
<br />14.5 08-01 2019
<br />55,250
<br />218,300
<br />72,97
<br />90.08
<br />51,14
<br />(184)
<br />(5,097)
<br />95,869
<br />798,63
<br />15.0
<br />02 -01
<br />2020
<br />15.0 02-01 2020
<br />55,250
<br />218,300
<br />7097
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />816,86
<br />15.5
<br />0801
<br />2020
<br />15.5 0801 2020
<br />55,250
<br />218,300
<br />72.97
<br />90,08
<br />51,14
<br />(184)
<br />(5,097)
<br />45,869
<br />83461
<br />16.0
<br />0201
<br />2021
<br />Totals
<br />1,564,239 (5,631)
<br />(155.881)
<br />1,402,747
<br />Present Value Date • 8.01 -03
<br />930.700 (3.351)
<br />(92,735)
<br />834,614
<br />NOTES:
<br />1. Inflation on lax rates cannot he captured,
<br />2. TIF does not capture slate wide property taxes or market value properly taxes
<br />FOR'ANAGY
<br />Current MaMOl Value • Est.
<br />Now Markel Value - Est.
<br />Difference
<br />Present Value of Tax Increment
<br />Oittemnce
<br />Value Likely to Occur Without Tax Increment is Lass Thom
<br />2.800.000
<br />0,990,000
<br />9.190,000
<br />030.700
<br />7,259,300
<br />1,290,386
<br />Prepared by Ehlers
<br />plani
<br />
|