Projected Tax Increment Report
<br />City of Roseville, Minnesota
<br />Tax Increment Financing (Redevelopment) District No. 17
<br />Twin Lakes Apartments Project - construction commences 2013
<br />Scenario 1- $90K per unit EMV with 0% annual MV inflator
<br />Annual Total Total
<br />Period Estimated Net Tax
<br />Ending Market Value Capacity
<br />12/31/12
<br />12/31/13
<br />12/31/14
<br />12/31/15
<br />12/31/16
<br />12/31/17
<br />12/31/18
<br />12/31/19
<br />12/31 /20
<br />12/31 /21
<br />12/31 /22
<br />12/31 /23
<br />12/31/24
<br />12/31 /25
<br />12/31/26
<br />12/31 /27
<br />12/31 /28
<br />12/31 /29
<br />12/31 /30
<br />12/31 /31
<br />2,463,900
<br />2,463,900
<br />7,86$400
<br />18,348,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />21,813,900
<br />46, 394
<br />46, 394
<br />46,394
<br />113,950
<br />244,957
<br />288,269
<br />288,269
<br />288,269
<br />288,269
<br />288, 269
<br />288,269
<br />288, 269
<br />288,269
<br />288, 269
<br />288,269
<br />288,269
<br />288,269
<br />288,269
<br />288,269
<br />288, 269
<br />Less: Less: Retained
<br />Original Fiscal Captured
<br />Net Tax Disp. @ Net Tax
<br />Capacity' 0.0000% Capacity
<br />(4) (5) (6)
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />46,394
<br />0
<br />0
<br />0
<br />67,556
<br />198,563
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />241,875
<br />Times:
<br />Tax
<br />Capacity
<br />Rate"�
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078°/a
<br />102.078%
<br />102.078°/a
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />102.078%
<br />Annual
<br />Gross Tax
<br />Increm ent
<br />0
<br />0
<br />0
<br />68,960
<br />202,689
<br />246,901
<br />246,901
<br />246,901
<br />246,901
<br />246, 901
<br />246, 901
<br />246,901
<br />246,901
<br />246,901
<br />246,901
<br />246,901
<br />246,901
<br />246,901
<br />246,901
<br />Less:
<br />State Aud.
<br />Deduction
<br />0.360%
<br />0
<br />0
<br />0
<br />248
<br />730
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />889
<br />Annual
<br />Net Tax
<br />Increment
<br />0
<br />0
<br />0
<br />68,712
<br />201,959
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246,012
<br />246.012
<br />Less:
<br />Adm./Pooling
<br />Retainage
<br />20.00°/a
<br />(11)
<br />0
<br />0
<br />0
<br />13,742
<br />40,392
<br />49,202
<br />49, 202
<br />49, 202
<br />49, 202
<br />49, 202
<br />49, 202
<br />49,202
<br />49, 202
<br />49, 202
<br />49,202
<br />49,202
<br />49, 202
<br />49, 202
<br />49, 202
<br />P.V. P.V.
<br />Annual Annual Annual
<br />Net Net Rev. To Retainage To
<br />Revenue 02/01/13 02/01/13
<br />12 4.50% 4.50%
<br />0
<br />0
<br />0
<br />54,970
<br />161,567
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196,810
<br />196.810
<br />� $3,975,164 � $14,313 $3,960,851 $792,164 $3,1
<br />`Base value assumed to be current land value - value captured as tax increment will be incremental new value of building(s) only. Estimated to be $90,000/unit for 215 units
<br />"'Frozen TIF total tax capacity rate per Ramsey County Records
<br />Proposed 2012 tax rate 134.912%
<br />0
<br />0
<br />0
<br />48,882
<br />137,486
<br />160,265
<br />153,363
<br />146,759
<br />140,439
<br />134,392
<br />128,605
<br />123,067
<br />117,767
<br />112,696
<br />107,843
<br />103,199
<br />98,755
<br />94,502
<br />90,433
<br />86,539
<br />$1,984,992
<br />0
<br />0
<br />0
<br />12,220
<br />34,372
<br />40,066
<br />38,340
<br />36,689
<br />35,109
<br />33, 598
<br />32,151
<br />30, 766
<br />29,441
<br />28,174
<br />26,960
<br />25,799
<br />24,688
<br />23,625
<br />22,608
<br />21,634
<br />$496, 240
<br />Public Sector Adviso�s
<br />
|