|
6/30/2021
<br />Tax Increment Cashflow - Page 3
<br />�EHLERS
<br />PUPS- - INA.NCE. 4 DVISORS
<br />Oppidan Industrial - No Inflation
<br />City of Ramsey, MN
<br />405,300 sq. ft. Industrial
<br />TAX INCREMENT CASH FLOW
<br />of
<br />Project
<br />Tax
<br />OTC Capacity
<br />Original
<br />Tax
<br />Capacity
<br />Fiscal
<br />Disparities
<br />Incremental
<br />Captured
<br />Tax
<br />Capacity
<br />Local
<br />Tax
<br />Rate
<br />Annual
<br />Gross Tax
<br />Increment
<br />100% 100,125 (58,206) (15,745) 26,174 91.206% 23,872
<br />100% 457,812 (58,206) (150,096) 249,510 91.206% 227,568
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />100% 629,750 (58,206) (214,678) 356,866 91.206% 325,484
<br />Semi -Annual
<br />Gross Tax
<br />Increment
<br />Semi -Annual PERIOD
<br />Present ENDING Tax Payment
<br />Value Yrs. Year Date
<br />- 02/01/23
<br />11,936 (43) (4,757) 7,136 6,825 0.5 2023 08/01/23
<br />11,936 (43) (4,757) 7,136 13,500 1 2023 02/01/24
<br />113,784 (410) (45,350) 68,025 75,732 1.5 2024 08/01/24
<br />113,784 (410) (45,350) 68,025 136,595 2 2024 02/01/25
<br />162,742 (586) (64,862) 97,294 221,729 2.5 2025 08/01/25
<br />162,742 (586) (64,862) 97,294 304,990 3 2025 02/01/26
<br />162,742 (586) (64,862) 97,294 386,419 3.5 2026 08/01/26
<br />162,742 (586) (64,862) 97,294 466,055 4 2026 02/01/27
<br />162,742 (586) (64,862) 97,294 543,940 4.5 2027 08/01/27
<br />162,742 (586) (64,862) 97,294 620,111 5 2027 02/01/28
<br />162,742 (586) (64,862) 97,294 694,605 5.5 2028 08/01/28
<br />162,742 (586) (64,862) 97,294 767,460 6 2028 02/01/29
<br />162,742 (586) (64,862) 97,294 838,712 6.5 2029 08/01/29
<br />162,742 (586) (64,862) 97,294 908,397 7 2029 02/01/30
<br />162,742 (586) (64,862) 97,294 976,547 7.5 2030 08/01/30
<br />162,742 (586) (64,862) 97,294 1,043,199 8 2030 02/01/31
<br />162,742 (586) (64,862) 97,294 1,108,383 8.5 2031 08/01/31
<br />162,742 (586) (64,862) 97,294 1,172,133 9 2031 02/01/32
<br />State
<br />Auditor
<br />0.36%
<br />Admin.
<br />at
<br />40%
<br />Semi -Annual
<br />Net Tax
<br />Increment
<br />Total
<br />Present Value From 08/01/2022
<br />Present Value Rate 4.50%
<br />2,529,825 (9,107) (1,008,287) 1,512,431
<br />1,960,613 (7,058) (781,422) 1,172,133
<br />Prepared by Ehlers & Associates, Inc. - Estimates Only N:\Minnsota\Ramsey\Housing - Economic - Redevelopment\Pending Projects\Oppidan Industrial\TIF Run 6-30-21 60% Paygo
<br />
|