|
TIF District No. 7 (Villas of Mounds View)
<br />- 3% Inflation
<br />E'Q'FREERS
<br />01 PUBLIC FINANCE ADVISOPS
<br />City of Mounds View, MN
<br />120 Senior Apartmerus
<br />TAX INCRFMFNTa
<br />Project Original Fiscal
<br />Captured Local Annual Se'Annual State
<br />Admin. Semi -Annual Semi -Annual PERIOD
<br />%of Tax Tax Disparities
<br />Tax Tax Grass Tax Gross Tax Auditor
<br />at Net Tax Present ENDING Tax Payment
<br />OTC Capacity Capacity Incremental
<br />Capacity Rate Increment Increment 0.361A
<br />10% Increment Value Yrs. Year Date
<br />100%
<br />13,225
<br />(5,249) -
<br />12,977
<br />115.015%
<br />14,925
<br />7,462
<br />(27)
<br />(744}
<br />6,692
<br />6,560
<br />0.5
<br />2024
<br />08I01/24
<br />7,462
<br />(27)
<br />(744}
<br />6,692
<br />13,055
<br />1
<br />2024
<br />02101/25
<br />100%
<br />121,500
<br />(5,249) -
<br />116,252
<br />115.015%
<br />133.706
<br />66,853
<br />(241)
<br />(6.661)
<br />59,951
<br />70,667
<br />1.5
<br />2025
<br />0810125
<br />66,853
<br />(241)
<br />(6,661)
<br />59,951
<br />127,7D9
<br />2
<br />2025
<br />02101/26
<br />100%
<br />125,145
<br />(5,249) -
<br />119,897
<br />115.015%
<br />137,899
<br />68,949
<br />(248)
<br />(6,87D)
<br />61,831
<br />1115.956
<br />2.5
<br />2026
<br />OMI26
<br />68,949
<br />(248)
<br />(6,87D)
<br />61,831
<br />243.624'
<br />3
<br />2026
<br />02101/27
<br />100%
<br />128,899
<br />(5,249) -
<br />123,651
<br />115.015%
<br />142.217
<br />71,108
<br />(256)
<br />(7,085)
<br />63,767
<br />302.515
<br />3.5
<br />2027
<br />0810127
<br />71,108
<br />(256)
<br />(7,085)
<br />63,767
<br />360820
<br />4
<br />2027
<br />0210128
<br />100%
<br />132.766
<br />(5,249) -
<br />127,518
<br />115015%
<br />146.664
<br />73,332
<br />(264)
<br />(7,307)
<br />65,761
<br />420353
<br />4.5
<br />2028
<br />0810128
<br />73,332
<br />(264)
<br />(7,307)
<br />65,761
<br />479.296
<br />5
<br />2028
<br />0210129
<br />100%
<br />136,749
<br />(5,249) -
<br />131,501
<br />115.015%
<br />151.245
<br />15,623
<br />(272)
<br />(7535)
<br />67,815
<br />539.479
<br />5.5
<br />2029
<br />0810129
<br />75,623
<br />(272)
<br />(7,535)
<br />67,815
<br />599,D66
<br />6
<br />2029
<br />02101730
<br />100%
<br />140852
<br />(5,249) -
<br />135,603
<br />115015%
<br />155,964
<br />T7,962
<br />(281)
<br />(7,770)
<br />69,931
<br />659,903
<br />65
<br />2030
<br />00101730
<br />T7,982
<br />(281)
<br />(7,77D)
<br />69931
<br />720,138
<br />7
<br />2030
<br />02101 l31
<br />100%
<br />145,1177
<br />(5,249) -
<br />139,829
<br />115015%
<br />160824
<br />80,412
<br />(289)
<br />(8,012)
<br />72,110
<br />781635
<br />75
<br />2031
<br />OMIP31
<br />80,412
<br />(289)
<br />(8,012)
<br />72,110
<br />842.523
<br />8
<br />2031
<br />OMV32
<br />100%
<br />149,430
<br />(5,249) -
<br />144,181
<br />115.015%
<br />165.829
<br />82,915
<br />(298)
<br />(8,262)
<br />74, 355
<br />904,685
<br />8.5
<br />2032
<br />0MV32
<br />82,915
<br />(298)
<br />(8,262)
<br />74,355
<br />966.231
<br />9
<br />2032
<br />02101/33
<br />100%
<br />153,913
<br />(5,249) -
<br />148,664
<br />115.015%
<br />170,985
<br />85,493
<br />(308)
<br />(8,518)
<br />76, 666
<br />1.029.063
<br />9.5
<br />2033
<br />0MV33
<br />85,493
<br />(308)
<br />(8,518)
<br />76,666
<br />1.091.272
<br />10
<br />2033
<br />020M l34
<br />100%
<br />158,530
<br />(5,249) -
<br />153,281
<br />115.015%
<br />116.295
<br />88,148
<br />(317)
<br />(8,783)
<br />79,D48
<br />1.154.779
<br />10.5
<br />2034
<br />OB1C1134
<br />88,148
<br />(317)
<br />(8,783)
<br />79,D48
<br />1.217.654'
<br />11
<br />2034
<br />021C1135
<br />100%
<br />163,286
<br />(5,249) -
<br />158,037
<br />115.015%
<br />181.766
<br />90,883
<br />(327)
<br />(9,056)
<br />81,5CO
<br />1.281.844
<br />11.5
<br />2035
<br />01MI35
<br />90,883
<br />(327)
<br />(9,056)
<br />81,5CO
<br />1.345.395
<br />12
<br />2035
<br />02101/36
<br />100%
<br />168,184
<br />(5,249) -
<br />162,936
<br />115015%
<br />187,400
<br />93,700
<br />(337)
<br />(9,336)
<br />84, D27
<br />1,410267
<br />125
<br />2036
<br />0610V M
<br />93,700
<br />(337)
<br />(9,336)
<br />84, D27
<br />1.474.498
<br />13
<br />2036
<br />02OV37
<br />100%
<br />173,230
<br />(5,249) -
<br />167,9B1
<br />115.015%
<br />193.203
<br />96,602
<br />(348)
<br />(9,625)
<br />86,62E
<br />1.540.061
<br />13.5
<br />2037
<br />0810VI37
<br />96,602
<br />(348)
<br />(9,625)
<br />86,1
<br />1.604.976
<br />14
<br />2037
<br />021C1138
<br />100%
<br />178,427
<br />(5,249) -
<br />173,178
<br />115.015%
<br />199.180
<br />139,590
<br />(359)
<br />(9,923)
<br />89,309
<br />1.671.236
<br />14.5
<br />2038
<br />081 VM
<br />99,590
<br />(359)
<br />(9,923)
<br />09,309
<br />1,736,840
<br />15
<br />2038
<br />02101M
<br />100%
<br />183,780
<br />(5,249) -
<br />178,531
<br />115015%
<br />205.337
<br />102,669
<br />(370)
<br />(10,23D)
<br />92,D69
<br />1803,6D2
<br />155
<br />2039
<br />OMIP39
<br />102,669
<br />(370)
<br />(10,23D)
<br />92,069
<br />1870.1 D1
<br />16
<br />2039
<br />02101 l40
<br />100%
<br />189,293
<br />(5,249) -
<br />184,045
<br />115.015%
<br />211.678
<br />105,839
<br />(381)
<br />(10.546)
<br />94,912
<br />1.931.771
<br />16.5
<br />2040
<br />08 IAC
<br />105,839
<br />(381)
<br />(10.546)
<br />94,912
<br />2,0134,771
<br />17
<br />2040
<br />02101I41
<br />100%
<br />194972
<br />(5,249) -
<br />189,723
<br />115015%
<br />218.210
<br />109,105
<br />(393)
<br />(10.871)
<br />97,M1
<br />2.073.154
<br />175
<br />2041
<br />081
<br />109,105
<br />(393)
<br />(10,871)
<br />97 B41
<br />2,140861
<br />18
<br />2041
<br />02101 A2
<br />100%
<br />200,821
<br />(5,249) -
<br />195,572
<br />115.015%
<br />224.937
<br />112,469
<br />(405)
<br />(11.206)
<br />100,957
<br />2.209.963
<br />18.5
<br />2042
<br />0MIA2
<br />112,469
<br />(405)
<br />(11.206)
<br />100,B57
<br />2,278,382
<br />19
<br />2042
<br />021CV43
<br />100%
<br />206,046
<br />(5,249) -
<br />201,597
<br />115.015%
<br />231,866
<br />115,933
<br />(417)
<br />(11.552)
<br />103,964
<br />2,348.210
<br />19.5
<br />2043
<br />06/01/43
<br />115,933
<br />(417)
<br />(11552)
<br />103,964
<br />2.417.346
<br />20
<br />2043
<br />02101M
<br />100%
<br />213,051
<br />(5,249) -
<br />207,802
<br />115015%
<br />239,003
<br />119,502
<br />(430)
<br />(11907)
<br />107,114
<br />2,487,9115
<br />2D5
<br />2044
<br />0WIA4
<br />119,502
<br />(430)
<br />(11907)
<br />107,114
<br />2.557.766
<br />21
<br />2044
<br />02101I45
<br />100%
<br />219,443
<br />(5,249) -
<br />214,194
<br />115.015%
<br />246.355
<br />123,177
<br />(443)
<br />(12.273)
<br />11g460
<br />2.629.062
<br />21.5
<br />2045
<br />0MIA5
<br />123,177
<br />(443)
<br />(12,273)
<br />110,460
<br />2,699.652
<br />22
<br />2045
<br />02101 A6
<br />100%
<br />226,026
<br />(5,249) -
<br />220,T77
<br />115.015%
<br />253.926
<br />126,963
<br />(457)
<br />(12.651}
<br />113,855
<br />2.771.692
<br />22.5
<br />2046
<br />08/01/46
<br />126,963
<br />(457)
<br />(12,651}
<br />119855
<br />2,843,018
<br />23
<br />2046
<br />021011 A7
<br />100%
<br />232,607
<br />(5,249) -
<br />227,558
<br />115.015%
<br />261.725
<br />130,863
<br />(471)
<br />(13,039}
<br />117,352
<br />2.915.807
<br />23.5
<br />2047
<br />08/01/47
<br />130,863
<br />(471)
<br />(13.039)
<br />117,352
<br />2,987,875
<br />24
<br />2047
<br />02OIA8
<br />100%
<br />239791
<br />(5,249) -
<br />234,542
<br />115.015%
<br />269,758
<br />134,879
<br />(486)
<br />(13,439)
<br />120,954
<br />3.061.420
<br />24.5
<br />2048
<br />0MIA8
<br />134,879
<br />(486)
<br />(13.439)
<br />120,954
<br />3,134,237
<br />25
<br />2048
<br />02101I49
<br />100%
<br />246,984
<br />(5,249) -
<br />241,136
<br />115.015%
<br />278,032
<br />139,016
<br />(500)
<br />(13,852)
<br />124,664
<br />3,208,543
<br />25.5
<br />2049
<br />08101 l49
<br />139,016
<br />p3n)
<br />(13,852)
<br />124, 664
<br />3,282,115
<br />26
<br />2049
<br />02OV50
<br />Total
<br />4,958,932
<br />(17,352)
<br />(494,1011)
<br />4,446,972
<br />Present Value From 0810V2023
<br />Present Value Rate
<br />2.001A
<br />3,659,970
<br />(13,176)
<br />(364,679)
<br />3,282,115
<br />Prepared by Elders 8 Aas d ta., Inc- Eafi. h Ody N Emmmic - Red-.1.pmadlTIF1TIF nehirblTlF 1-7 ('ill -if 14 a 1d Vi )1Caeh flvxlCash Fbn 10.7-21
<br />DOC SOPEN\MU205\52\763645.v2-11 / 18/21
<br />
|