|
11/12/2020Tax Increment Cashflow - Page 3TIF 3-3City of Little Canada, MN The Lodge/Garden TerraceTAX 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- - - - 02/01/21100% 287,468 (18,448) - 269,021 103.145% 277,481 138,741 (499) (13,824) 124,417 118,134 0.52021 08/01/21100% 287,468 (18,448) - 269,021 103.145% 277,481 138,741 (499) (13,824) 124,417 233,246 12021 02/01/22100% 293,218 (18,448) - 274,770 103.145% 283,412 141,706 (510) (14,120) 127,076 347,810 1.52022 08/01/22100% 293,218 (18,448) - 274,770 103.145% 283,412 141,706 (510) (14,120) 127,076 459,445 22022 02/01/23100% 299,082 (18,448) - 280,634 103.145% 289,460 144,730 (521) (14,421) 129,788 570,545 2.52023 08/01/23100% 299,082 (18,448) - 280,634 103.145% 289,460 144,730 (521) (14,421) 129,788 678,804 32023 02/01/24100% 305,064 (18,448) - 286,616 103.145% 295,630 147,815 (532) (14,728) 132,555 786,542 3.52024 08/01/24100% 305,064 (18,448) - 286,616 103.145% 295,630 147,815 (532) (14,728) 132,555 891,525 42024 02/01/25100% 311,165 (18,448) - 292,717 103.145% 301,923 150,962 (543) (15,042) 135,376 995,999 4.52025 08/01/25100% 311,165 (18,448) - 292,717 103.145% 301,923 150,962 (543) (15,042) 135,376 1,097,802 52025 02/01/26100% 317,388 (18,448) - 298,941 103.145% 308,342 154,171 (555) (15,362) 138,254 1,199,109 5.52026 08/01/26100% 317,388 (18,448) - 298,941 103.145% 308,342 154,171 (555) (15,362) 138,254 1,297,825 62026 02/01/27100% 323,736 (18,448) - 305,288 103.145% 314,890 157,445 (567) (15,688) 141,190 1,396,059 6.52027 08/01/27100% 323,736 (18,448) - 305,288 103.145% 314,890 157,445 (567) (15,688) 141,190 1,491,780 72027 02/01/28100% 330,211 (18,448) - 311,763 103.145% 321,568 160,784 (579) (16,021) 144,185 1,587,030 7.52028 08/01/28100% 330,211 (18,448) - 311,763 103.145% 321,568 160,784 (579) (16,021) 144,185 1,679,845 82028 02/01/29100% 336,815 (18,448) - 318,367 103.145% 328,380 164,190 (591) (16,360) 147,239 1,772,201 8.52029 08/01/29100% 336,815 (18,448) - 318,367 103.145% 328,380 164,190 (591) (16,360) 147,239 1,862,195 92029 02/01/30 Total2,721,086 (9,796) (271,129) 2,440,161 Present Value From 08/01/2020Present Value Rate5.25%2,076,581 (7,476) (206,911) 1,862,195 Prepared by Ehlers & Associates, Inc. - Estimates Only N:\Minnsota\Little Canada\Housing - Economic - Redevelopment\TIF\TIF Districts\TIF 3-3 est & 3-2 mod\Modification - 2020\TIF Run - TIF 3-3 - Little Canada.xlsm
|