|
9/20/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 LocalAnnual Semi-Annual StateAdmin. 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.5 2021 08/01/21100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 26,580 1 2021 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.5 2022 08/01/22100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 51,756 2 2022 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.5 2023 08/01/23100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 75,602 3 2023 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.5 2024 08/01/24100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 98,189 4 2024 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.5 2025 08/01/25100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 119,584 5 2025 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.5 2026 08/01/26100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 139,848 6 2026 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.5 2027 08/01/27100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 159,042 7 2027 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.5 2028 08/01/28100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 177,223 8 2028 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.5 2029 08/01/29100% 227,780 (187,780) (13,969) 26,031 125.191% 32,589 16,295 (59) (1,624) 14,612 194,443 9 2029 02/01/30 Total293,302 (1,056) (29,225) 263,021 Present Value From 02/01/2020Present Value Rate5.50%216,829 (781) (21,605) 194,443 Prepared by Ehlers & Associates, Inc. - Estimates OnlyC:\Users\thagen\Desktop\2018TIFRunModel
|