|
E
<br />EHLERS
<br />PUBLIC FINANCE ADVISORS
<br />Trident/LifeSpark
<br />City of Ramsey, MN
<br />24 Memory Care Units and 78 Assisted Living Units
<br />TAX INCREMENT CASH FLOW
<br />Project Original
<br />% of Tax Tax
<br />OTC Capacity Capacity
<br />100% 140,250 (15,256)
<br />100% 140,250 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />100% 280,500 (15,256)
<br />Semi -Annual State Semi -Annual Semi -Annual
<br />Gross Tax Auditor Net Tax Present
<br />Increment 0.36% Increment Value
<br />124,994 94 558% 118,192 59,096 (213) (2,944) 55,939 52,600
<br />124,994 94 558% 118,192 59,096 (213) (2,944) 55,939 103,606
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 208,564
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 310,342
<br />265,244 94 558 % 250,809 125,405 (451) (6,248) 118,706 409,035
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 504,738
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 597,540
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 687,530
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 774,794
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 859,413
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 941,468
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,021,036
<br />265,244 94558% 250,809 125,405 (451) (6,248) 118,706 1,098,193
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,173,012
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,245,564
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,315,917
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,384,138
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,450,292
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,514,441
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,576,647
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,636,967
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,695,460
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,752,180
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,807,181
<br />265,244 94558% 250,809 125,405 (451) (6,248) 118,706 1,860,515
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 1,912,234
<br />265,244 94558% 250,809 125,405 (451) (6,248) 118,706 1,962,385
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,011,016
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,058,174
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,103,903
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,148,246
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,191,245
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,232,941
<br />265,244 94 558% 250,809 125,405 (451) (6,248) 118,706 2,273,374
<br />265,244 94 558% 250,809 125,405 (451)
<br />(6,248) 118,706 2,312,581
<br />265,244 94 558% 250,809 125,405 i() 118,706
<br />4 381 953 (15,775) (2 8,309) 4,147,8692,350,600
<br />Total
<br />Fiscal
<br />Disparities
<br />Incremental
<br />Captured
<br />Tax
<br />Capacity
<br />Local
<br />Tax
<br />Rate
<br />Present Value From 08/01/2022 Present Value Rate 6.25%
<br />Annual
<br />Gross Tax
<br />Increment
<br />2,483,256 (8,940)
<br />Admin.
<br />at
<br />5%
<br />(123,716) 2,350,600
<br />PERIOD
<br />ENDING
<br />Yrs.
<br />Tax Payment
<br />Year Date
<br />02/01/28
<br />05 2028 08/01/28
<br />1 2028 02/01/29
<br />15 2029 08/01/29
<br />2 2029 02/01/30
<br />25 2030 08/01/30
<br />3 2030 02/01/31
<br />35 2031 08/01/31
<br />4 2031 02/01/32
<br />45 2032 08/01/32
<br />5 2032 02/01/33
<br />55 2033 08/01/33
<br />6 2033 02/01/34
<br />65 2034 08/01/34
<br />7 2034 02/01/35
<br />75 2035 08/01/35
<br />8 2035 02/01/36
<br />85 2036 08/01/36
<br />9 2036 02/01/37
<br />95 2037 08/01/37
<br />10 2037 02/01/38
<br />105 2038 08/01/38
<br />11 2038 02/01/39
<br />115 2039 08/01/39
<br />12 2039 02/01/40
<br />125 2040 08/01/40
<br />13 2040 02/01/41
<br />135 2041 08/01/41
<br />14 2041 02/01/42
<br />145 2042 08/01/42
<br />15 2042 02/01/43
<br />155 2043 08/01/43
<br />16 2043 02/01/44
<br />165 2044 08/01/44
<br />17 2044 02/01/45
<br />175 2045 08/01/45
<br />18 2045 02/01/46
<br />
|