|
3/19/2019Tax Increment Cashflow - Page 3New Brighton Elementary RedevelopmentCity of New Brighton, MN 354 apartments and 53 town homesTAX INCREMENT CASH FLOWProject OriginalFiscal CapturedLocalAnnual Semi-Annual StateAdmin. Semi-Annual Semi-Annual PERIOD% of Tax Tax Disparities Tax Tax Gross Tax Gross TaxAuditoratNet Tax Present ENDING Tax PaymentOTC Capacity Capacity Incremental CapacityRate Increment Increment 0.36%10%IncrementValue Yrs. Year Date-- --02/01/21-- --08/01/21-- --02/01/22100% 256,159(40,821) - 215,338124.538% 268,178 134,089(483) (13,361) 120,246111,0880.5 2022 08/01/22100% 256,159(40,821) - 215,338124.538% 268,178134,089(483) (13,361) 120,246219,9991 2022 02/01/23100% 512,318(40,821) - 471,497124.538% 587,193 293,597(1,057)(29,254)263,286453,7891.5 2023 08/01/23100% 512,318(40,821) - 471,497124.538% 587,193293,597(1,057)(29,254)263,286682,9952 2023 02/01/24100% 527,687(40,821) - 486,867124.538% 606,334 303,167(1,091)(30,208)271,868915,0312.5 2024 08/01/24100% 527,687(40,821) - 486,867124.538% 606,334303,167(1,091)(30,208)271,8681,142,5183 2024 02/01/25100% 543,518(40,821) - 502,697124.538% 626,049 313,025(1,127)(31,190)280,7081,372,7973.5 2025 08/01/25100% 543,518(40,821) - 502,697124.538% 626,049313,025(1,127)(31,190)280,7081,598,5604 2025 02/01/26100% 559,823(40,821) - 519,003124.538% 646,356 323,178(1,163)(32,201)289,8131,827,0754.5 2026 08/01/26100% 559,823(40,821) - 519,003124.538% 646,356323,178(1,163)(32,201)289,8132,051,1105 2026 02/01/27100% 576,618(40,821) - 535,798124.538% 667,272 333,636(1,201)(33,243)299,1912,277,8605.5 2027 08/01/27100% 576,618(40,821) - 535,798124.538% 667,272333,636(1,201)(33,243)299,1912,500,1636 2027 02/01/28100% 593,917(40,821) - 553,096124.538% 688,815 344,407(1,240)(34,317)308,8512,725,1446.5 2028 08/01/28100% 593,917(40,821) - 553,096124.538% 688,815344,407(1,240)(34,317)308,8512,945,7147 2028 02/01/29100% 611,734(40,821) - 570,914124.538% 711,004 355,502(1,280)(35,422)318,8003,168,9257.5 2029 08/01/29100% 611,734(40,821) - 570,914124.538% 711,004355,502(1,280)(35,422)318,8003,387,7598 2029 02/01/30100% 630,086(40,821) - 589,266124.538% 733,860 366,930(1,321)(36,561)329,0483,609,1998.5 2030 08/01/30100% 630,086(40,821) - 589,266124.538% 733,860366,930(1,321)(36,561)329,0483,826,2979 2030 02/01/31100% 648,989(40,821) - 608,168124.538% 757,401 378,700(1,363)(37,734)339,6034,045,9659.5 2031 08/01/31100% 648,989(40,821) - 608,168124.538% 757,401378,700(1,363)(37,734)339,6034,261,32710 2031 02/01/32100% 668,459(40,821) - 627,638124.538% 781,648 390,824(1,407)(38,942)350,4754,479,22510.5 2032 08/01/32100% 668,459(40,821) - 627,638124.538% 781,648390,824(1,407)(38,942)350,4754,692,85011 2032 02/01/33100% 688,512(40,821) - 647,692124.538% 806,622 403,311(1,452)(40,186)361,6734,908,97911.5 2033 08/01/33100% 688,512(40,821) - 647,692124.538% 806,622403,311(1,452)(40,186)361,6735,120,86912 2033 02/01/34100% 709,168(40,821) - 668,347124.538% 832,346 416,173(1,498)(41,467)373,2075,335,23012.5 2034 08/01/34100% 709,168(40,821) - 668,347124.538% 832,346416,173(1,498)(41,467)373,2075,545,38813 2034 02/01/35100% 730,443(40,821) - 689,622124.538% 858,841 429,421(1,546)(42,787)385,0875,757,98313.5 2035 08/01/35100% 730,443(40,821) - 689,622 124.538% 858,841 429,421 (1,546) (42,787) 385,087 5,966,410 14 2035 02/01/36100% 752,356(40,821) - 711,535 124.538% 886,132 443,066 (1,595) (44,147) 397,324 6,177,243 14.5 2036 08/01/36100% 752,356(40,821) - 711,535 124.538% 886,132 443,066 (1,595) (44,147) 397,324 6,383,943 15 2036 02/01/37100% 774,927(40,821) - 734,106 124.538% 914,241 457,120 (1,646) (45,547) 409,927 6,593,017 15.5 2037 08/01/37100% 774,927(40,821) - 734,106 124.538% 914,241 457,120 (1,646) (45,547) 409,927 6,797,992 16 2037 02/01/38100% 798,174(40,821) - 757,354 124.538% 943,193 471,597 (1,698) (46,990) 422,909 7,005,312 16.5 2038 08/01/38100% 798,174(40,821) - 757,354 124.538% 943,193 471,597 (1,698) (46,990) 422,909 7,208,567 17 2038 02/01/39100% 822,120(40,821) - 781,299 124.538% 973,014 486,507 (1,751) (48,476) 436,280 7,414,136 17.5 2039 08/01/39100% 822,120(40,821) - 781,299 124.538% 973,014 486,507 (1,751) (48,476) 436,280 7,615,675 18 2039 02/01/40100% 846,783(40,821) - 805,963 124.538% 1,003,730 501,865 (1,807) (50,006) 450,052 7,819,499 18.5 2040 08/01/40100% 846,783(40,821) - 805,963 124.538% 1,003,730 501,865 (1,807) (50,006) 450,052 8,019,327 19 2040 02/01/41100% 872,187(40,821) - 831,366 124.538% 1,035,367 517,683 (1,864) (51,582) 464,238 8,221,412 19.5 2041 08/01/41100% 872,187(40,821) - 831,366 124.538% 1,035,367 517,683 (1,864) (51,582) 464,238 8,419,534 20 2041 02/01/42100% 898,352(40,821) - 857,532 124.538% 1,067,953 533,976 (1,922) (53,205) 478,849 8,619,885 20.5 2042 08/01/42100% 898,352(40,821) - 857,532 124.538% 1,067,953 533,976 (1,922) (53,205) 478,849 8,816,307 21 2042 02/01/43100% 925,303(40,821) - 884,482 124.538% 1,101,517 550,758 (1,983) (54,878) 493,898 9,014,930 21.5 2043 08/01/43100% 925,303(40,821) - 884,482 124.538% 1,101,517 550,758 (1,983) (54,878) 493,898 9,209,658 22 2043 02/01/44100% 953,062(40,821) - 912,241 124.538% 1,136,087 568,044 (2,045) (56,600) 509,399 9,406,560 22.5 2044 08/01/44100% 953,062(40,821) - 912,241 124.538% 1,136,087 568,044 (2,045) (56,600) 509,399 9,599,601 23 2044 02/01/45100% 981,654(40,821) - 940,833 124.538% 1,171,695 585,847 (2,109) (58,374) 525,365 9,794,789 23.5 2045 08/01/45100% 981,654(40,821) - 940,833 124.538% 1,171,695 585,847 (2,109) (58,374) 525,365 9,986,149 24 2045 02/01/46100% 1,011,103(40,821) - 970,283 124.538% 1,208,371 604,185 (2,175) (60,201) 541,809 10,179,630 24.5 2046 08/01/46100% 1,011,103(40,821) - 970,283 124.538% 1,208,371 604,185 (2,175) (60,201) 541,809 10,369,316 25 2046 02/01/47100% 1,041,437(40,821) - 1,000,616 124.538% 1,246,147 623,074 (2,243) (62,083) 558,747 10,561,098 25.5 2047 08/01/47100% 1,041,437(40,821) - 1,000,616 124.538% 1,246,147 623,074 (2,243) (62,083) 558,747 10,749,119 26 2047 02/01/48 Total22,259,364 (80,134) (2,217,923) 19,961,308 Present Value From 08/01/2016 Present Value Rate 4.00%11,986,617 (43,152) (1,194,347) 10,749,119 Prepared by Ehlers & Associates, Inc. - Estimates OnlyN:\Minnsota\New Brighton\Housing - Economic - Redevelopment\TIF\TIF Districts\TIF 34 - New Brighton Elementarty Redevelopment\TIF Plan Documents\TIF Plan Run - FINAL Revised
|