|
6EHLERS
<br />PUBLIC FINANCE ADVISORS
<br />Zero Zone Refrigeration
<br />City of Ramsey, MN
<br />55,000 sq. ft. Expansion
<br />TAX INCREMENT CASH FLOW
<br />Project Original Fiscal Captured
<br />% of Tax Tax Disparities Tax
<br />OTC Capacity Capacity Incremental Capacity
<br />100% 253,044 (148,596) (40,055) 64,393
<br />Local
<br />Tax
<br />Rate
<br />Annual
<br />Gross Tax
<br />Increment
<br />Semi -Annual
<br />Gross Tax
<br />Increment
<br />State
<br />Auditor
<br />0.36%
<br />Admin.
<br />at
<br />10%
<br />Semi -Annual
<br />Net Tax
<br />Increment
<br />Semi -Annual
<br />Present
<br />Value
<br />93.647% 60,302 30,151 (109) (3,004) 27,038 25,735
<br />30,151 (109) (3,004) 27,038 50,843
<br />100% 260,635 (148,596) (42,966) 69,073 93.647% 64,685 32,343 (116) (3,223) 29,003 77,119
<br />32,343 (116) (3,223) 29,003 102,754
<br />100% 268,454 (148,596) (45,965) 73,894 93.647% 69,199 34,600 (125) (3,448) 31,028 129,509
<br />34,600 (125) (3,448) 31,028 155,611
<br />100% 276,508 (148,596) (49,053) 78,859 93.647% 73,849 36,924 (133) (3,679) 33,112 182,788
<br />36,924 (133) (3,679) 33,112 209,302
<br />100% 284,803 (148,596) (52,234) 83,973 93.647% 78,638 39,319 (142) (3,918) 35,260 236,847
<br />39,319 (142) (3,918) 35,260 263,720
<br />100% 293,347 (148,596) (55,511) 89,241 93.647% 83,571 41,786 (150) (4,164) 37,472 291,582
<br />41,786 (150) (4,164) 37,472 318,765
<br />100% 302,148 (148,596) (58,886) 94,666 93.647% 88,652 44,326 (160) (4,417) 39,750 346,897
<br />44,326 (160) (4,417) 39,750 374,343
<br />100% 311,212 (148,596) (62,362) 100,254 93.647% 93,885 46,943 (169) (4,677) 42,096 402,700
<br />46,943 (169) (4,677) 42,096 430,365
<br />100% 320,549 (148,596) (65,942) 106,010 93.647% 99,275 49,638 (179) (4,946) 44,513 458,906
<br />49,638 (179) (4,946) 44,513 486,750
<br />Total 712,057 (2,563) (70,949) 638,545 _
<br />Present Value From 08/01/2027 Present Value Rate 5.00% illi.542,787 (1,954) (54,083) 486,750
<br />PERIOD
<br />ENDING
<br />Yrs.
<br />0.51
<br />1.5
<br />2
<br />2.53
<br />3.5
<br />4
<br />4.5
<br />5
<br />5.5
<br />6
<br />6.57
<br />7.5
<br />8
<br />8.59
<br />Tax Payment
<br />Year Date
<br />02/01/28
<br />2028 08/01/28
<br />2028 02/01/29
<br />2029 08/01/29
<br />2029 02/01/30
<br />2030 08/01/30
<br />2030 02/01/31
<br />2031 08/01/31
<br />2031 02/01/32
<br />2032 08/01/32
<br />2032 02/01/33
<br />2033 08/01/33
<br />2033 02/01/34
<br />2034 08/01/34
<br />2034 02/01/35
<br />2035 08/01/35
<br />2035 02/01/36
<br />2036 08/01/36
<br />2036 02/01/37
<br />
|