|
12/11/2019Tax Increment Cashflow - Page 3TCAAPCity of Arden HillsMixed Use DevelopmentTAX INCREMENT CASH FLOWProject Original Fiscal CapturedLocal 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/23100% 2,226,955 (2,012,442) - 214,513 113.030% 242,464 121,232 (436) (12,080) 108,716 103,477 0.5 2023 08/01/23100% 2,226,955 (2,012,442) - 214,513 113.030% 242,464 121,232 (436) (12,080) 108,716 204,431 1 2023 02/01/24100% 4,869,066 (2,012,442) (115,178) 2,741,446 113.030% 3,098,656 1,549,328 (5,578) (154,375) 1,389,376 1,463,137 1.5 2024 08/01/24100% 4,869,066 (2,012,442) (115,178) 2,741,446 113.030% 3,098,656 1,549,328 (5,578) (154,375) 1,389,376 2,691,142 2 2024 02/01/25100% 6,360,452 (2,012,442) (320,193) 4,027,817 113.030% 4,552,641 2,276,321 (8,195) (226,813) 2,041,313 4,451,360 2.5 2025 08/01/25100% 6,360,452 (2,012,442) (320,193) 4,027,817 113.030% 4,552,641 2,276,321 (8,195) (226,813) 2,041,313 6,168,646 3 2025 02/01/26100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 8,104,653 3.5 2026 08/01/26100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 9,993,439 4 2026 02/01/27100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 11,836,158 4.5 2027 08/01/27100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 13,633,932 5 2027 02/01/28100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 15,387,858 5.5 2028 08/01/28100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 17,099,006 6 2028 02/01/29100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 18,768,418 6.5 2029 08/01/29100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 20,397,113 7 2029 02/01/30100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 21,986,083 7.5 2030 08/01/30100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 23,536,299 8 2030 02/01/31100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 25,048,704 8.5 2031 08/01/31100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 26,524,221 9 2031 02/01/32100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 27,963,750 9.5 2032 08/01/32100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 29,368,168 10 2032 02/01/33100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 30,738,332 10.5 2033 08/01/33100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 32,075,078 11 2033 02/01/34100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 33,379,220 11.5 2034 08/01/34100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 34,651,554 12 2034 02/01/35100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 35,892,855 12.5 2035 08/01/35100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 37,103,881 13 2035 02/01/36100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 38,285,369 13.5 2036 08/01/36100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 39,438,041 14 2036 02/01/37100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 40,562,598 14.5 2037 08/01/37100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 41,659,728 15 2037 02/01/38100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 42,730,098 15.5 2038 08/01/38100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 43,774,362 16 2038 02/01/39100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 44,793,155 16.5 2039 08/01/39100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 45,787,100 17 2039 02/01/40100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 46,756,803 17.5 2040 08/01/40100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 47,702,854 18 2040 02/01/41100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 48,625,831 18.5 2041 08/01/41100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 49,526,296 19 2041 02/01/42100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 50,404,799 19.5 2042 08/01/42100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 51,261,875 20 2042 02/01/43100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 52,098,046 20.5 2043 08/01/43100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 52,913,823 21 2043 02/01/44100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 53,709,703 21.5 2044 08/01/44100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 54,486,172 22 2044 02/01/45100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 55,243,702 22.5 2045 08/01/45100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 55,982,756 23 2045 02/01/46100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 56,703,784 23.5 2046 08/01/46100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 57,407,226 24 2046 02/01/47100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 58,093,510 24.5 2047 08/01/47100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 58,763,057 25 2047 02/01/48100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 59,416,272 25.5 2048 08/01/48100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 60,053,556 26 2048 02/01/49100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 60,675,296 26.5 2049 08/01/49100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 61,281,872 27 2049 02/01/50100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 61,873,653 27.5 2050 08/01/50100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 62,451,001 28 2050 02/01/51100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 63,014,267 28.5 2051 08/01/51100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 63,563,795 29 2051 02/01/52100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 64,099,919 29.5 2052 08/01/52100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 64,622,968 30 2052 02/01/53100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 65,133,259 30.5 2053 08/01/53100% 7,171,832 (2,012,442) (505,054) 4,654,336 113.030% 5,260,796 2,630,398 (9,469) (262,093) 2,358,836 65,631,104 31 2053 02/01/54 Total155,196,049 (558,706) (15,463,734) 139,173,609 Present Value From 08/01/2022 Present Value Rate 5.00% 73,186,922 (263,473) (7,292,345) 65,631,104 Prepared by Ehlers & Associates, Inc. - Estimates OnlyN:\Minnsota\Arden Hills\Housing - Economic - Redevelopment\TIF\TIF Districts\TIF 5\TIF cashflows\TIF Plan Run - TIF 5 TCAAP - FINAL
|