|
ik oily of
<br /> 41/VitIt
<br /> HTO N
<br /> ...rig etrr UM rrerOr/rr ftrr
<br /> City of New Brighton DATA ENTRY SCREEN
<br /> TIF Cash Flow Analysis
<br /> As of 12/12/2011
<br /> CONCEPT PLAN 1
<br /> Est.Annual SF or Base Finished Base Finished Base Finished Captured Total Present Value
<br /> Description 1st Year Completion #of Units Unit Value Unit Value Market Value Market Value NTC NTC NTC Estimated TIF Estimated TIF
<br /> BLOCK A: Office 2013 50% 73,000 $ 10 $ 125 $ 730,000 $ 9,125,000 $ 13,850 $ 181,750 $ 181,750 $ 3,907,465 $ 1,529,422
<br /> 4.5 Acres $ (13,850)
<br /> 100%HSS Bu down
<br /> BLOCK B: Corporate Office 2015 50% 215,000 $ 20 $ 125 $ 4,300,000 $ 26,875,000 $ 85,250 $ 536,750 $ 536,750 $ 10,466,197 $ 3,816,781
<br /> 10.9 Acres $ (85,250)
<br /> 100%HSS Bu down
<br /> BLOCK C: Transoma Medical,Inc. 2008 100% 118,988 $ 1,547,300 $ 10,114,000 $ 30,196 $ 201,530 $ 201,530 $ 5,373,708 $ 2,457,596
<br /> 21.30.23.32.0016 $ (30,196)
<br /> 100%HSS Buydown
<br /> BLOCK D: Office 2015 50% 81.000 $ 10 $ 125 $ 810,000 $ 10,125,000 $ 15,450 I $ 201,750 $ 201,750 $ 3,933,964 $ 1,434,626
<br /> 4.3 Acres $ (15,450)
<br /> 100%HSS Bu down
<br /> BLOCK E: Office 2015 50% 50,000 $ 10 $ 125 $ 500,000 $ 6,250,000 $ 9,250 $ 124,250 $ 124,250 $ 2,422,776 $ 883,531
<br /> 3.8 Acres $ (9,250)
<br /> 100%HSS Bu down
<br /> BLOCK F: Residential -14 50% 165 $ 10,000 $ 95,000 $ 1,650,000 $ 15,675,000 $ 20,625 $ 195,938 $ 195,938 $ 4,016,555 $ 1.517.276
<br /> Apartments $ (20,625)
<br /> 100%HSS Buydown
<br /> 13L0CKG: Residential 2013 50% 118 $ 10,000 $ 95,000 $ 1,180,000 $ 11,210,000 $ 14,750 $ 140,125 $ 132,750 $ 2,704,829 $ 1,082,924
<br /> Apartments $ (7,375)
<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 $ 155,000 $ 150,033 $ 3,434,453 $ 1,504,044
<br /> 20.30.23.42.0025 $ (12,891)i
<br /> 20.30.23.42.0027
<br /> 20.30.23.42.0028 70%HSS Buydown
<br /> BLOCK I: Residential
<br /> Townhomes 2016 17% 323 $ 15,000 $ 225,000 $ 2,907,000 $ 67,187,230 $ 29,070 $ 671,872 $ 642,802 $ 9,696,059 $ 3,184,034
<br /> Reduced for MV Exclusion $ (29,070)
<br /> 100%HSS Bu down
<br /> BLOCK.i: APi Facility 2014 50% 9,000 $ 150 $ 210,700 $ 1,350,000 $ 4,214 $ 27,000 $ 22,786 $ 440,128 $ 169,724
<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 $ 2,508,371 $ 1,091,032
<br /> 0%HSS Buydown
<br /> SUBTOTAL Number of Units 730
<br /> Number of Square Feet 590,360
<br /> TOTALS $ 16,239,000 $176,334,630 $ 31,100 $ 2,555,683 $ 2,495,513 $ 48,904,505 $ 18,670,990
<br /> Assumptions: THE BOTTOM LINE:
<br /> 1) Assumes no future land sale proceeds Projected Interfund Loan Balances at end of districts TIF 31 $ 13.869,670
<br /> 2) Assumes no inflation on value in future years TIF 32 (0)
<br /> 3) Assumes no future expenditures other than 10%Admin Costs TOTAL TIF DISTRICTS $ 13,869,670
<br /> Projected Ending Cash Balances at end of districts Fund 460 $ 28,094,107
<br /> TIF 31 0
<br /> TIF 32 0
<br /> TOTAL ALL FUNDS $ 28,094,107
<br /> 1/11/2012 al E H LE RS
<br />
|