|
12/7/2005 Exhibit B
<br />CITY OF MOUNDS VIEW
<br />Medronic Project
<br />TAX INCREMENT CASH FLOW
<br />Base Project Fiscal Captured Semi-Annual State Admin. Semi-Annual Semi-Annual PAYMENT DATE
<br />PERIOD BEGINNING Tax Tax Disparities Tax Gross Tax Auditor at Net Tax Present PERIOD ENDING
<br />Yrs. Mth. Yr. Capacity Capacity Reduction Capacity Increment 0.36%5.00%Increment Value Yrs. Mth. Yr.
<br />0.0 02-01 2006 0 0 0 0.0 08-01 2006
<br />0.0 08-01 2006 0 0 0 0.0 02-01 2007
<br />0.0 02-01 2007 182,019 182,019 0 Present Value Date - 8-01-07 0.0 08-01 2007
<br />0.0 08-01 2007 182,019 182,019 0 0 0 0 0 0 0 0.0 02-01 2008
<br />0.0 02-01 2008 182,019 1,151,250 384,499 584,732 359,104 (1,293) (17,891) 339,921 323,542 0.5 08-01 2008
<br />0.5 08-01 2008 182,019 1,151,250 384,499 584,732 359,104 (1,293) (17,891) 339,921 639,192 1.0 02-01 2009
<br />1.0 02-01 2009 182,019 1,919,250 689,168 1,048,063 643,652 (2,317) (32,067) 609,268 1,191,159 1.5 08-01 2009
<br />1.5 08-01 2009 182,019 1,919,250 689,168 1,048,063 643,652 (2,317) (32,067) 609,268 1,729,664 2.0 02-01 2010
<br />2.0 02-01 2010 182,019 1,919,250 689,168 1,048,063 643,652 (2,317) (32,067) 609,268 2,255,034 2.5 08-01 2010
<br />2.5 08-01 2010 182,019 1,919,250 689,168 1,048,063 643,652 (2,317) (32,067) 609,268 2,767,590 3.0 02-01 2011
<br />3.0 02-01 2011 182,019 1,976,828 712,010 1,082,799 664,984 (2,394) (33,130) 629,461 3,284,218 3.5 08-01 2011
<br />3.5 08-01 2011 182,019 1,976,828 712,010 1,082,799 664,984 (2,394) (33,130) 629,461 3,788,245 4.0 02-01 2012
<br />4.0 02-01 2012 182,019 2,036,132 735,536 1,118,577 686,957 (2,473) (34,224) 650,260 4,296,227 4.5 08-01 2012
<br />4.5 08-01 2012 182,019 2,036,132 735,536 1,118,577 686,957 (2,473) (34,224) 650,260 4,791,820 5.0 02-01 2013
<br />5.0 02-01 2013 182,019 2,097,216 759,768 1,155,429 709,590 (2,555) (35,352) 671,683 5,291,254 5.5 08-01 2013
<br />5.5 08-01 2013 182,019 2,097,216 759,768 1,155,429 709,590 (2,555) (35,352) 671,683 5,778,507 6.0 02-01 2014
<br />6.0 02-01 2014 182,019 2,160,133 784,728 1,193,386 732,900 (2,638) (36,513) 693,748 6,269,491 6.5 08-01 2014
<br />6.5 08-01 2014 182,019 2,160,133 784,728 1,193,386 732,900 (2,638) (36,513) 693,748 6,748,501 7.0 02-01 2015
<br />7.0 02-01 2015 182,019 2,224,937 810,436 1,232,482 756,910 (2,725) (37,709) 716,476 7,231,137 7.5 08-01 2015
<br />7.5 08-01 2015 182,019 2,224,937 810,436 1,232,482 756,910 (2,725) (37,709) 716,476 7,702,001 8.0 02-01 2016
<br />8.0 02-01 2016 182,019 2,291,685 836,915 1,272,751 781,641 (2,814) (38,941) 739,886 8,176,391 8.5 08-01 2016
<br />8.5 08-01 2016 182,019 2,291,685 836,915 1,272,751 781,641 (2,814) (38,941) 739,886 8,639,210 9.0 02-01 2017
<br />9.0 02-01 2017 182,019 2,360,435 864,189 1,314,227 807,113 (2,906) (40,210) 763,997 9,105,455 9.5 08-01 2017
<br />9.5 08-01 2017 182,019 2,360,435 864,189 1,314,227 807,113 (2,906) (40,210) 763,997 9,560,328 10.0 02-01 2018
<br />10.0 02-01 2018 182,019 2,431,248 892,281 1,356,948 833,350 (3,000) (41,517) 788,832 10,018,533 10.5 08-01 2018
<br />10.5 08-01 2018 182,019 2,431,248 892,281 1,356,948 833,350 (3,000) (41,517) 788,832 10,465,562 11.0 02-01 2019
<br />11.0 02-01 2019 182,019 2,504,186 921,215 1,400,952 860,374 (3,097) (42,864) 814,412 10,915,830 11.5 08-01 2019
<br />11.5 08-01 2019 182,019 2,504,186 921,215 1,400,952 860,374 (3,097) (42,864) 814,412 11,355,117 12.0 02-01 2020
<br />12.0 02-01 2020 182,019 2,579,312 951,018 1,446,275 888,208 (3,198) (44,251) 840,760 11,797,554 12.5 08-01 2020
<br />12.5 08-01 2020 182,019 2,579,312 951,018 1,446,275 888,208 (3,198) (44,251) 840,760 12,229,200 13.0 02-01 2021
<br />13.0 02-01 2021 182,019 2,656,691 981,715 1,492,957 916,877 (3,301) (45,679) 867,897 12,663,910 13.5 08-01 2021
<br />13.5 08-01 2021 182,019 2,656,691 981,715 1,492,957 916,877 (3,301) (45,679) 867,897 13,088,018 14.0 02-01 2022
<br />14.0 02-01 2022 182,019 2,736,392 1,013,332 1,541,041 946,407 (3,407) (47,150) 895,850 13,515,108 14.5 08-01 2022
<br />14.5 08-01 2022 182,019 2,736,392 1,013,332 1,541,041 946,407 (3,407) (47,150) 895,850 13,931,781 15.0 02-01 2023
<br />15.0 02-01 2023 182,019 2,818,483 1,045,899 1,590,565 976,822 (3,517) (48,665) 924,640 14,351,355 15.5 08-01 2023
<br />15.5 08-01 2023 182,019 2,818,483 1,045,899 1,590,565 976,822 (3,517) (48,665) 924,640 14,760,696 16.0 02-01 2024
<br />16.0 02-01 2024 182,019 2,903,038 1,079,442 1,641,577 1,008,150 (3,629) (50,226) 954,294 15,172,861 16.5 08-01 2024
<br />16.5 08-01 2024 182,019 2,903,038 1,079,442 1,641,577 1,008,150 (3,629) (50,226) 954,294 15,574,973 17.0 02-01 2025
<br />17.0 02-01 2025 182,019 2,990,129 1,113,991 1,694,119 1,040,418 (3,746) (51,834) 984,839 15,979,834 17.5 08-01 2025
<br />17.5 08-01 2025 182,019 2,990,129 1,113,991 1,694,119 1,040,418 (3,746) (51,834) 984,839 16,374,821 18.0 02-01 2026
<br />18.0 02-01 2026 182,019 3,079,833 1,149,577 1,748,237 1,073,653 (3,865) (53,489) 1,016,299 16,772,483 18.5 08-01 2026
<br />18.5 08-01 2026 182,019 3,079,833 1,149,577 1,748,237 1,073,653 (3,865) (53,489) 1,016,299 17,160,446 19.0 02-01 2027
<br />19.0 02-01 2027 182,019 3,172,228 1,186,231 1,803,978 1,107,886 (3,988) (55,195) 1,048,703 17,551,015 19.5 08-01 2027
<br />19.5 08-01 2027 182,019 3,172,228 1,186,231 1,803,978 1,107,886 (3,988) (55,195) 1,048,703 17,932,058 20.0 02-01 2028
<br />20.0 02-01 2028 182,019 3,267,395 1,223,984 1,861,392 1,143,146 (4,115) (56,952) 1,082,079 18,315,639 20.5 08-01 2028
<br />20.5 08-01 2028 182,019 3,267,395 1,223,984 1,861,392 1,143,146 (4,115) (56,952) 1,082,079 18,689,864 21.0 02-01 2029
<br />21.0 02-01 2029 182,019 3,365,416 1,262,870 1,920,527 1,179,463 (4,246) (58,761) 1,116,456 19,066,560 21.5 08-01 2029
<br />21.5 08-01 2029 182,019 3,365,416 1,262,870 1,920,527 1,179,463 (4,246) (58,761) 1,116,456 19,434,069 22.0 02-01 2030
<br />22.0 02-01 2030 182,019 3,466,379 1,302,922 1,981,438 1,216,870 (4,381) (60,624) 1,151,865 19,803,986 22.5 08-01 2030
<br />22.5 08-01 2030 182,019 3,466,379 1,302,922 1,981,438 1,216,870 (4,381) (60,624) 1,151,865 20,164,880 23.0 02-01 2031
<br />23.0 02-01 2031 182,019 3,570,370 1,344,176 2,044,175 1,255,400 (4,519) (62,544) 1,188,336 20,528,120 23.5 08-01 2031
<br />23.5 08-01 2031 182,019 3,570,370 1,344,176 2,044,175 1,255,400 (4,519) (62,544) 1,188,336 20,882,501 24.0 02-01 2032
<br />24.0 02-01 2032 182,019 3,677,481 1,386,667 2,108,795 1,295,085 (4,662) (64,521) 1,225,902 21,239,167 24.5 08-01 2032
<br />24.5 08-01 2032 182,019 3,677,481 1,386,667 2,108,795 1,295,085 (4,662) (64,521) 1,225,902 21,587,135 25.0 02-01 2033
<br />25.0 02-01 2033 182,019 3,787,806 1,430,434 2,175,353 1,335,960 (4,809) (66,558) 1,264,593 21,937,329 25.5 08-01 2033
<br />25.5 08-01 2033 182,019 3,787,806 1,430,434 2,175,353 1,335,960 (4,809) (66,558) 1,264,593 22,278,983 26.0 02-01 2034
<br />Totals 47,729,145 (171,825) (2,377,866) 45,179,454
<br />Present Value Date - 8-01-07 23,536,292 (84,731) (1,172,578) 22,278,983
<br />14,869,617 Previous Phase I TIF run
<br />NOTES:7,409,366 Difference (Phase II TIF)
<br />1. Inflation has on tax rate has not been calculated.
<br />2. TIF does not capture state wide property taxes, fiscal disparities taxes or market value property taxes
<br /> Prepared by Ehlers and Associats, Inc. TIF Run 12-07-05 P2006TNT se.xls
|