|
5/22/2017
<br />EHLERS
<br />Bunker Lake Industrial Park
<br />City of Ramsey
<br />60,000 sq. ft. Industrial
<br />TAX INCREMENT CASH FLOW
<br />Tax Increment Cashflow - Page 3
<br />Project Original Fiscal Captured Local Annual Semi -Annual State Admin. Semi -Annual Semi -Annual
<br />of Tax Tax Disparities Tax Tax Gross Tax Gross Tax Auditor at Net Tax Present
<br />OTC Capacity Capacity Incremental Capacity Rate Increment Increment 0.36% 10% Increment Value
<br />100% 16,313 (1,311) (5,675) 9,326 103404% 9,644 4,822 (17) (480) 4,324
<br />4,822 (17) (480) 4,324
<br />100% 65,250 (1,311) (24,188) 39,750 103404% 41,103 20,552 (74) (2,048) 18,430
<br />20,552 (74) (2,048) 18,430
<br />100% 67,208 (1,311) (24,929) 40,967 103 404% 42,362 21,181 (76) (2,110) 18,994
<br />21,181 (76) (2,110) 18,994
<br />100% 69,224 (1,311) (25,692) 42,221 103 404% 43,658 21,829 (79) (2,175) 19,575
<br />21,829 (79) (2,175) 19,575
<br />100% 71,300 (1,311) (26,477) 43,512 103404% 44,993 22,496 (81) (2,242) 20,174
<br />22,496 (81) (2,242) 20,174
<br />100% 73,439 (1,311) (27,286) 44,842 103 404% 46,368 23,184 (83) (2,310) 20,790
<br />23,184 (83) (2,310) 20,790
<br />100% 75,643 (1,311) (28,120) 46,211 103404% 47,784 23,892 (86) (2,381) 21,426
<br />23,892 (86) (2,381) 21,426
<br />100% 77,912 (1,311) (28,978) 47,622 103 404% 49,243 24,622 (89) (2,453) 22,080
<br />24,622 (89) (2,453) 22,080
<br />100% 80,249 (1,311) (29,863) 49,075 103404% 50,746 25,373 (91) (2,528) 22,753
<br />25,373 (91) (2,528) 22,753
<br />Total 375,901 (1,353) (37,455) 337,093
<br />Present Value From 08/01/2018 Present Value Rate 4.00% 300,234 (1,0811 (29,9151 269,237
<br />4,156
<br />8,231
<br />25,257
<br />41,950
<br />58,816
<br />75,351
<br />92,059
<br />108,439
<br />124,988
<br />141,213
<br />157,606
<br />173,678
<br />189,916
<br />205,836
<br />221,919
<br />237,688
<br />253,619
<br />269,237
<br />PERIOD
<br />ENDING Tax Payment
<br />Yrs. Year Date
<br />02/01/19
<br />0 5 2019 08/01/19
<br />1 2019 02/01/20
<br />15 2020 08/01/20
<br />2 2020 02/01/21
<br />2 5 2021 08/01/21
<br />3 2021 02/01/22
<br />3 5 2022 08/01/22
<br />4 2022 02/01/23
<br />4 5 2023 08/01/23
<br />5 2023 02/01/24
<br />5 5 2024 08/01/24
<br />6 2024 02/01/25
<br />6 5 2025 08/01/25
<br />7 2025 02/01/26
<br />7 5 2026 08/01/26
<br />8 2026 02/01/27
<br />8 5 2027 08/01/27
<br />9 2027 02/01/28
<br />Prepared by Ehlers &Associates, Inc - Estimates Only N Annsota\RamseytHousing - Economic- Redevelopment \TIF\TIF Distracts\TIF District No 16- PSD\TIF Runs\TIF Plan Run 5-22-17
<br />
|