|
11 city of
<br /> 11)VICIti
<br /> t.i HTON
<br /> • ...MP enr rear sari./er yes
<br /> City of New Brighton DATA ENTRY SCREEN
<br /> TIF Cash Flow Analysis
<br /> As of 12/12/2011
<br /> CONCEPT PLAN 2
<br /> Est.Annual SF or Base Finished Base Finished Base Finished Captured Total Present Value
<br /> Description '1 1etYear Completion it of Units Unit Value Unit Value Market Value Market Value NTC NTC NTC Estimated TIF Estimated TIF
<br /> BLOCK A: Office 2016 50% 60.000 S ,,, - $ 600,000 $ 7,500,000 $ 11,250 $ 149,250 $ 149,250 $ 2,761,012 $ 972,284
<br /> 4.5 Acres $ (11,250)
<br /> 100%HSS Buydown
<br /> I3LOCK B: Corporate Office 2017 50% 120,000 $ 20 $ 125 $ 2,400,000 $ 15,000,000 $ 47,250 $ 299,250 $ 299,250 $ 5,236,661 $ 1,781,215
<br /> 10.9 Acres $ (47,250)
<br /> 100%HSS Bu down
<br /> 13LOCKC: Transoma Medical,Inc. 2008 100% 118,988 $ 1,547,300 $ 10,114,000 $ 30,196 $ 259,250 $ 259,250 $ 5,373,708 $ 2,457,596
<br /> 21.30.23.32.0016 $ (30,196)
<br /> 100%HSS Bu down
<br /> BLOCK D: Office 2014 50% 63,000 $ 10 $ $ 630,000 $ 7,875,000 $ 11,850 $ 156,750 $ 156,750 $ 3,213,244 $ 1,213,821
<br /> 4.3 Acres $ (11,850)
<br /> 100%HSS Bu down
<br /> l3LOCK E: Office 2014 50% 45,000 $ 10 $ $ 450,000 $ 5,625,000 $ 8,250 $ 111,750 $ 111,750 $ 2,290,781 $ 865,356
<br /> 3.8 Acres $ (8,250)
<br /> 100%HSS Bu down
<br /> BLOCK F: Office 2017 50% 100,000 $ 10 $ 125 $ 1,000,000 $ 12,500,000 $ 12,500 $ 249,250 $ 249,250 $ 4,361,697 $ 1,483,602
<br /> $ (12,500)
<br /> 100%HSS Bu down
<br /> BLOCK G: Residential 'n" 50% 118 $ 10,000 $ 195,000 $ 708,000 1 $ 20,686,580 $ 7,080 $ 206,866 $ 203,326 $ 4,654,368 $ 2,038,280
<br /> Senior Housing Reduced for MV Exclusion $ (3,540)
<br /> 50%HSS Buydown
<br /> BLOCK H: The View at Long Lake 2011 100% 124 $ 100,000 $ 1,428,600 $ 12,400,000 $ 17,858 1 $ 155,000 $ 150,033 $ 4,215,042 $ 1,845,887
<br /> 20.30.23.42.0025 $ (12,891)
<br /> 20.30.23.42.0027
<br /> 20.30.23.42.0028 70%HSS Buydown
<br /> BLOCK I: Residential
<br /> Townhomes 2016 20% 218 $ 15,000 $ 225,000 $ 1,962,000 $ 45,346,180 $ 19,620 $ 453,462 $ 453,462 $ 7,221,064 $ 2,487,352
<br /> Reduced for MV Exclusion $ (19,620)
<br /> 100%HSS Bu down
<br /> BLOCK J: APi Facility 2014 50% 9,000 $ 150 $ 210,700 $ 1,350,000 $ 4,214 $ 27,000 $ 22,786 $ 427,546 $ 160,488
<br /> 20.30 23.42 0018
<br /> 0%HSS Buydown
<br /> BLOCK K: APi Facility
<br /> 20.30.23.43.0065 2008 100% 52,372 $ 975,400 $ 6,023,400 $ 14,544 I $ 119,718 $ 105,174 $ 1,356,930 $ 767,117
<br /> ,0%HSS Buydown
<br /> SUBTOTAL Number of Units 460
<br /> Number of Square Feet 559,360
<br /> TOTALS '$ 11.912.000_$144,420,160 $ 27,266' 5 2,187,646-
<br /> $ 2,160,281 $ 41,112,063 $ 16,072,997
<br /> Assumptions: THE BOTTOM LINE:
<br /> 1) Assumes no future land sale proceeds Projected Interfund Loan Balances at end of districts TIF 31 $ 23,309,880
<br /> 2) Assumes no inflation on value in future years TIF 32 (1)
<br /> 3) Assumes no future expenditures other than 10%Admin Costs TOTAL TIF DISTRICTS $ 23,309,880
<br /> Projected Ending Cash Balances at end of districts Fund 460 $ 16.928,784
<br /> TIF 31 (0)
<br /> TIF 32 (0)
<br /> TOTAL ALL FUNDS $ 16,928,783
<br /> 1/11/2012 0 E H LE RS
<br />
|