|
1/25/2018Tax Increment Cashflow - Page 3MWF Workforce HousingCity of Mounds View60 Unit Affordable Apartment BuildingTAX INCREMENT CASH FLOWProject Original Fiscal Captured Local Annual Semi-Annual State Admin.Semi-Annual Semi-Annual PERIOD% of Tax Tax Disparities Tax Tax Gross Tax Gross Tax Auditor at Net Tax Present ENDING Tax PaymentOTC Capacity Capacity Incremental Capacity Rate Increment Increment 0.36% 10% Increment Value Yrs. Year Date- - - - 02/01/20100% 11,160 (3,653) - 7,508 121.575% 9,127 4,564 (16) (455) 4,092 3,934 0.52020 08/01/20100% 11,160 (3,653) - 7,508 121.575% 9,127 4,564 (16) (455) 4,092 7,790 12020 02/01/21100% 55,800 (3,653) - 52,148 121.575% 63,398 31,699 (114) (3,158) 28,426 34,052 1.52021 08/01/21100% 55,800 (3,653) - 52,148 121.575% 63,398 31,699 (114) (3,158) 28,426 59,798 22021 02/01/22100% 57,474 (3,653) - 53,822 121.575% 65,433 32,717 (118) (3,260) 29,339 85,851 2.52022 08/01/22100% 57,474 (3,653) - 53,822 121.575% 65,433 32,717 (118) (3,260) 29,339 111,392 32022 02/01/23100% 59,198 (3,653) - 55,546 121.575% 67,530 33,765 (122) (3,364) 30,279 137,235 3.52023 08/01/23100% 59,198 (3,653) - 55,546 121.575% 67,530 33,765 (122) (3,364) 30,279 162,571 42023 02/01/24100% 60,974 (3,653) - 57,322 121.575% 69,689 34,844 (125) (3,472) 31,247 188,204 4.52024 08/01/24100% 60,974 (3,653) - 57,322 121.575% 69,689 34,844 (125) (3,472) 31,247 213,335 52024 02/01/25100% 62,803 (3,653) - 59,151 121.575% 71,913 35,956 (129) (3,583) 32,244 238,759 5.52025 08/01/25100% 62,803 (3,653) - 59,151 121.575% 71,913 35,956 (129) (3,583) 32,244 263,685 62025 02/01/26100% 64,687 (3,653) - 61,035 121.575% 74,203 37,102 (134) (3,697) 33,271 288,901 6.52026 08/01/26100% 64,687 (3,653) - 61,035 121.575% 74,203 37,102 (134) (3,697) 33,271 313,622 72026 02/01/27100% 66,628 (3,653) - 62,976 121.575% 76,562 38,281 (138) (3,814) 34,329 338,629 7.52027 08/01/27100% 66,628 (3,653) - 62,976 121.575% 76,562 38,281 (138) (3,814) 34,329 363,145 82027 02/01/28100% 68,627 (3,653) - 64,974 121.575% 78,993 39,496 (142) (3,935) 35,419 387,944 8.52028 08/01/28100% 68,627 (3,653) - 64,974 121.575% 78,993 39,496 (142) (3,935) 35,419 412,256 92028 02/01/29100% 70,686 (3,653) - 67,033 121.575% 81,496 40,748 (147) (4,060) 36,541 436,847 9.52029 08/01/29100% 70,686 (3,653) - 67,033 121.575% 81,496 40,748 (147) (4,060) 36,541 460,956 102029 02/01/30100% 72,806 (3,653) - 69,154 121.575% 84,074 42,037 (151) (4,189) 37,697 485,340 10.52030 08/01/30100% 72,806 (3,653) - 69,154 121.575% 84,074 42,037 (151) (4,189) 37,697 509,246 112030 02/01/31100% 74,991 (3,653) - 71,338 121.575% 86,729 43,365 (156) (4,321) 38,888 533,423 11.52031 08/01/31100% 74,991 (3,653) - 71,338 121.575% 86,729 43,365 (156) (4,321) 38,888 557,126 122031 02/01/32100% 77,240 (3,653) - 73,588 121.575% 89,464 44,732 (161) (4,457) 40,114 581,097 12.52032 08/01/32100% 77,240 (3,653) - 73,588 121.575% 89,464 44,732 (161) (4,457) 40,114 604,599 132032 02/01/33100% 79,557 (3,653) - 75,905 121.575% 92,281 46,141 (166) (4,597) 41,377 628,365 13.52033 08/01/33100% 79,557 (3,653) - 75,905 121.575% 92,281 46,141 (166) (4,597) 41,377 651,665 142033 02/01/34100% 81,944 (3,653) - 78,292 121.575% 95,183 47,591 (171) (4,742) 42,678 675,226 14.52034 08/01/34100% 81,944 (3,653) - 78,292 121.575% 95,183 47,591 (171) (4,742) 42,678 698,325 152034 02/01/35100% 84,403 (3,653) - 80,750 121.575% 98,172 49,086 (177) (4,891) 44,018 721,683 15.52035 08/01/35100% 84,403 (3,653) - 80,750 121.575% 98,172 49,086 (177) (4,891) 44,018 744,582 162035 02/01/36100% 86,935 (3,653) - 83,282 121.575% 101,250 50,625 (182) (5,044) 45,398 767,737 16.52036 08/01/36100% 86,935 (3,653) - 83,282 121.575% 101,250 50,625 (182) (5,044) 45,398 790,437 172036 02/01/37100% 89,543 (3,653) - 85,890 121.575% 104,421 52,210 (188) (5,202) 46,820 813,390 17.52037 08/01/37100% 89,543 (3,653) - 85,890 121.575% 104,421 52,210 (188) (5,202) 46,820 835,892 182037 02/01/38100% 92,229 (3,653) - 88,576 121.575% 107,687 53,843 (194) (5,365) 48,285 858,643 18.52038 08/01/38100% 92,229 (3,653) - 88,576 121.575% 107,687 53,843 (194) (5,365) 48,285 880,948 192038 02/01/39100% 94,996 (3,653) - 91,343 121.575% 111,050 55,525 (200) (5,533) 49,793 903,499 19.52039 08/01/39100% 94,996 (3,653) - 91,343 121.575% 111,050 55,525 (200) (5,533) 49,793 925,607 202039 02/01/40100% 97,846 (3,653) - 94,193 121.575% 114,515 57,258 (206) (5,705) 51,346 947,958 20.52040 08/01/40100% 97,846 (3,653) - 94,193 121.575% 114,515 57,258 (206) (5,705) 51,346 969,871 212040 02/01/41100% 100,781 (3,653) - 97,129 121.575% 118,084 59,042 (213) (5,883) 52,946 992,024 21.52041 08/01/41100% 100,781 (3,653) - 97,129 121.575% 118,084 59,042 (213) (5,883) 52,946 1,013,743 222041 02/01/42100% 103,804 (3,653) - 100,152 121.575% 121,760 60,880 (219) (6,066) 54,595 1,035,698 22.52042 08/01/42100% 103,804 (3,653) - 100,152 121.575% 121,760 60,880 (219) (6,066) 54,595 1,057,223 232042 02/01/43100% 106,919 (3,653) - 103,266 121.575% 125,546 62,773 (226) (6,255) 56,292 1,078,982 23.52043 08/01/43100% 106,919 (3,653) - 103,266 121.575% 125,546 62,773 (226) (6,255) 56,292 1,100,314 242043 02/01/44100% 110,126 (3,653) - 106,474 121.575% 129,445 64,723 (233) (6,449) 58,041 1,121,878 24.52044 08/01/44100% 110,126 (3,653) - 106,474 121.575% 129,445 64,723 (233) (6,449) 58,041 1,143,019 252044 02/01/45100% 113,430 (3,653) - 109,777 121.575% 133,462 66,731 (240) (6,649) 59,842 1,164,388 25.52045 08/01/45100% 113,430 (3,653) - 109,777 121.575% 133,462 66,731 (240) (6,649) 59,842 1,185,339 262045 02/01/46 Total2,371,465 (8,537) (236,293) 2,126,635 Present Value From 08/01/2019 Present Value Rate 4.00% 1,321,802 (4,758) (131,704) 1,185,339 Prepared by Ehlers & Associates, Inc. - Estimates OnlyN:\Minnsota\Mounds View\Housing - Economic - Redevelopment\TIF\TIF Districts\TIF 1-6\TIF Plan Run 1-18-18
|