|
10/29/2018Tax Increment Cashflow - Page 3Project Surf Redevelopment Project - New TIF DistrictCity of Little Canada, MinnesotaProposed Office/Production/Warehouse/Storage/Distribution FacilityTAX INCREMENT CASH FLOWProject Original Fiscal Captured Local Annual Semi-Annual State Admin. Semi-Annual Semi-Annual PERIOD% ofTax Tax Disparities Tax Tax Gross Tax Gross Tax Auditorat Net Tax Present ENDING Tax PaymentOTC CapacityCapacityIncremental CapacityRate Increment Increment 0.36% 10% IncrementValueYrs.YearDate- - - - 08/01/20- - - - 02/01/21100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 13,470 0.52021 08/01/21100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 26,580 12021 02/01/22100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 39,339 1.52022 08/01/22100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 51,756 22022 02/01/23100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 63,841 2.52023 08/01/23100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 75,602 32023 02/01/24100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 87,049 3.52024 08/01/24100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 98,189 42024 02/01/25100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 109,032 4.52025 08/01/25100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 119,584 52025 02/01/26100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 129,853 5.52026 08/01/26100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 139,848 62026 02/01/27100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 149,575 6.52027 08/01/27100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 159,042 72027 02/01/28100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 168,256 7.52028 08/01/28100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 177,223 82028 02/01/29100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 185,950 8.52029 08/01/29100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 194,443 92029 02/01/30 Total293,302 (1,056) (29,225) 263,021 Present Value From 02/01/2020 Present Value Rate 5.50% 216,829 (781) (21,605) 194,443 Prepared by Ehlers & Associates, Inc. - Estimates Only N:\Minnsota\Little Canada\Housing - Economic - Redevelopment\TIF\TIF Districts\TIF 7-2 - 2018\TIF Plan Documents\TIF cashflow no inflation - PLAN 10.29.2018
|