|
3/8/2021Tax Increment Cashflow - Page 3Lowry Grove TIF District City of St. Anthony, MN 264-Units of Senior Living/Care and 225-Market Rate UnitsTAX INCREMENT CASH FLOWProject Original Fiscal CapturedLocal Annual Semi-Annual State Admin.Semi-Annual Semi-Annual PERIOD% of TaxTax Disparities TaxTax Gross Tax Gross Tax AuditoratNet Tax Present ENDING Tax PaymentOTC Capacity Capacity Incremental CapacityRate Increment Increment 0.36%10% Increment Value Yrs. Year Date- - - - 02/01/23100% 151,875 (91,925) - 59,950 144.645% 86,715 43,357 (156) (4,320) 38,881 37,371 0.52023 08/01/23100% 151,875 (91,925) - 59,950 144.645% 86,715 43,357 (156) (4,320) 38,881 74,010 12023 02/01/24100% 448,875 (91,925) - 356,950 144.645% 516,310 258,155 (929) (25,723) 231,503 287,883 1.52024 08/01/24100% 448,875 (91,925) - 356,950 144.645% 516,310 258,155 (929) (25,723) 231,503 497,563 22024 02/01/25100% 856,238 (91,925) - 764,313 144.645% 1,105,540 552,770 (1,990) (55,078) 495,702 937,732 2.52025 08/01/25100% 856,238 (91,925) - 764,313 144.645% 1,105,540 552,770 (1,990) (55,078) 495,702 1,369,270 32025 02/01/26100% 1,127,456 (91,925) - 1,035,531 144.645% 1,497,844 748,922 (2,696) (74,623) 671,603 1,942,477 3.52026 08/01/26100% 1,127,456 (91,925) - 1,035,531 144.645% 1,497,844 748,922 (2,696) (74,623) 671,603 2,504,444 42026 02/01/27100% 1,161,280 (91,925) - 1,069,355 144.645% 1,546,768 773,384 (2,784) (77,060) 693,540 3,073,389 4.52027 08/01/27100% 1,161,280 (91,925) - 1,069,355 144.645% 1,546,768 773,384 (2,784) (77,060) 693,540 3,631,177 5202702/01/28100% 1,196,118 (91,925) - 1,104,193 144.645% 1,597,160 798,580 (2,875) (79,571) 716,135 4,195,844 5.52028 08/01/28100% 1,196,118 (91,925) - 1,104,193 144.645% 1,597,160 798,580 (2,875) (79,571) 716,135 4,749,440 62028 02/01/29100% 1,232,001 (91,925) - 1,140,076 144.645% 1,649,064 824,532 (2,968) (82,156) 739,407 5,309,818 6.52029 08/01/29100% 1,232,001 (91,925) - 1,140,076 144.645% 1,649,064 824,532 (2,968) (82,156) 739,407 5,859,208 72029 02/01/30100% 1,268,962 (91,925) - 1,177,037 144.645% 1,702,524 851,262 (3,065) (84,820) 763,378 6,415,288 7.52030 08/01/30100%1,268,962 (91,925) - 1,177,037 144.645% 1,702,524 851,262 (3,065) (84,820) 763,378 6,960,464 82030 02/01/31100% 1,307,030 (91,925) - 1,215,105 144.645% 1,757,589 878,795 (3,164) (87,563) 788,068 7,512,237 8.52031 08/01/31100% 1,307,030 (91,925) - 1,215,105 144.645% 1,757,589 878,795 (3,164) (87,563) 788,068 8,053,191 92031 02/01/32100% 1,346,241 (91,925) - 1,254,316 144.645% 1,814,306 907,153 (3,266) (90,389) 813,498 8,600,652 9.52032 08/01/32100% 1,346,241 (91,925) - 1,254,316 144.645% 1,814,306 907,153 (3,266) (90,389) 813,498 9,137,378 102032 02/01/33100% 1,386,629 (91,925) - 1,294,704 144.645% 1,872,724 936,362 (3,371) (93,299) 839,692 9,680,524 10.52033 08/01/33100% 1,386,629 (91,925) - 1,294,704 144.645% 1,872,724 936,362 (3,371) (93,299) 839,692 10,213,019 112033 02/01/34100% 1,428,227 (91,925) - 1,336,302 144.645% 1,932,895 966,447 (3,479) (96,297) 866,671 10,751,848 11.52034 08/01/34100% 1,428,227 (91,925) - 1,336,302 144.645% 1,932,895 966,447 (3,479) (96,297) 866,671 11,280,111 122034 02/01/35100% 1,471,074 (91,925) - 1,379,149 144.645% 1,994,870 997,435 (3,591) (99,384) 894,460 11,814,621 12.52035 08/01/35100% 1,471,074 (91,925) - 1,379,149 144.645% 1,994,870 997,435 (3,591) (99,384) 894,460 12,338,651 132035 02/01/36100% 1,515,206 (91,925) - 1,423,281 144.645% 2,058,705 1,029,353 (3,706) (102,565) 923,082 12,868,846 13.52036 08/01/36100% 1,515,206 (91,925) - 1,423,281 144.645% 2,058,705 1,029,353 (3,706) (102,565) 923,082 13,388,645 142036 02/01/37100% 1,560,663 (91,925) - 1,468,738 144.645% 2,124,456 1,062,228 (3,824) (105,840) 952,563 13,914,528 14.52037 08/01/37100% 1,560,663 (91,925) - 1,468,738 144.645% 2,124,456 1,062,228 (3,824) (105,840) 952,563 14,430,099 152037 02/01/38100% 1,607,482 (91,925) - 1,515,557 144.645% 2,192,178 1,096,089 (3,946) (109,214) 982,929 14,951,674 15.52038 08/01/38100% 1,607,482 (91,925) - 1,515,557 144.645% 2,192,178 1,096,089 (3,946) (109,214) 982,929 15,463,022 162038 02/01/39100% 1,655,707 (91,925) - 1,563,782 144.645% 2,261,932 1,130,966 (4,071) (112,689) 1,014,205 15,980,295 16.52039 08/01/39100% 1,655,707 (91,925) - 1,563,782 144.645% 2,261,932 1,130,966 (4,071) (112,689) 1,014,205 16,487,425 172039 02/01/40100% 1,705,378 (91,925) - 1,613,453 144.645% 2,333,779 1,166,890 (4,201) (116,269) 1,046,420 17,000,405 17.52040 08/01/40100% 1,705,378 (91,925) - 1,613,453 144.645% 2,333,779 1,166,890 (4,201) (116,269) 1,046,420 17,503,326 182040 02/01/41100% 1,756,540 (91,925) - 1,664,615 144.645% 2,407,782 1,203,891 (4,334) (119,956) 1,079,601 18,012,020 18.52041 08/01/41100% 1,756,540 (91,925) - 1,664,615 144.645% 2,407,782 1,203,891 (4,334) (119,956) 1,079,601 18,510,740 192041 02/01/42100% 1,809,236 (91,925) - 1,717,311 144.645% 2,484,004 1,242,002 (4,471) (123,753) 1,113,778 19,015,159 19.52042 08/01/42100% 1,809,236 (91,925) - 1,717,311 144.645% 2,484,004 1,242,002 (4,471) (123,753) 1,113,778 19,509,688 202042 02/01/43100% 1,863,513 (91,925) - 1,771,588 144.645% 2,562,513 1,281,257 (4,613) (127,664) 1,148,980 20,009,843 20.52043 08/01/43100% 1,863,513 (91,925) - 1,771,588 144.645% 2,562,513 1,281,257 (4,613) (127,664) 1,148,980 20,500,192 212043 02/01/44100% 1,919,418 (91,925) - 1,827,493 144.645% 2,643,377 1,321,689 (4,758) (131,693) 1,185,238 20,996,096 21.52044 08/01/44100% 1,919,418 (91,925) - 1,827,493 144.645% 2,643,377 1,321,689 (4,758) (131,693) 1,185,238 21,482,277 222044 02/01/45100% 1,977,001 (91,925) - 1,885,076 144.645% 2,726,668 1,363,334 (4,908) (135,843) 1,222,583 21,973,943 22.52045 08/01/45100% 1,977,001 (91,925) - 1,885,076 144.645% 2,726,668 1,363,334 (4,908) (135,843) 1,222,583 22,455,969 232045 02/01/46100% 2,036,311 (91,925) - 1,944,386 144.645% 2,812,457 1,406,228 (5,062) (140,117) 1,261,049 22,943,412 23.52046 08/01/46100% 2,036,311 (91,925) - 1,944,386 144.645% 2,812,457 1,406,228 (5,062) (140,117) 1,261,049 23,421,297 242046 02/01/47100% 2,097,400 (91,925) - 2,005,475 144.645% 2,900,819 1,450,410 (5,221) (144,519) 1,300,669 23,904,532 24.52047 08/01/47100% 2,097,400 (91,925) - 2,005,475 144.645% 2,900,819 1,450,410 (5,221) (144,519) 1,300,669 24,378,292 252047 02/01/48100% 2,160,322 (91,925) - 2,068,397 144.645% 2,991,833 1,495,916 (5,385) (149,053) 1,341,478 24,857,335 25.52048 08/01/48100% 2,160,322 (91,925) - 2,068,397 144.645% 2,991,833 1,495,916 (5,385) (149,053) 1,341,478 25,326,985 262048 02/01/49 Total51,574,812 (185,669) (5,138,914) 46,250,228 Present Value From 08/01/2022 Present Value Rate 4.00%28,242,769 (101,674) (2,814,109) 25,326,985 Prepared by Ehlers & Associates, Inc. - Estimates OnlyN:\Minnsota\St. Anthony\Housing - Economic - Redevelopment\TIF\TIF Districts\Lowry Grove (2021)\Cash flows\Cashflow 1-18-21 FINAL.xls21
|