|
city of
<br /> ' vv
<br /> BRIGHTON
<br /> - _..tire clip eke. w.rAp twr rips
<br /> City of New Brighton DATA ENTRY SCREEN
<br /> TIF Cash Flow Analysis
<br /> As of 1 211 212 01 1
<br /> Delay Reduction
<br /> MINIMUM DEVELOPMENT SCENARIO 1 20%
<br /> Est.Annual SF or Base Finished Base Finished Base Finished Captured Total Present Value 1 SF or
<br /> Description 1st Year Completion #of Units Unit Value Unit Value Market Value Market Value NTC , NTC NTC Estimated TIF Estimated TIF let Year #of Units
<br /> BLOCK A: Office 2017 50% 48,000 $ 10 $ 125 $ 480,000 $ 6,000,000 $ 8,850 $ 119,250 $ 119,250 $ 2,086,790 $ 709,808 2016 60,000
<br /> 4.5 Acres $ (8,850)
<br /> 100%HSS Bu down
<br /> BLOCK B: Corporate Office 2018 50% 96,000 $ 20 $ 125 $ 1,920,000 $ 12,000,000 $ 37,650 $ 239,250 $ 239,250 $ 3,947,464 $ 1,297,293 ' 2017 120,000
<br /> 10.9 Acres $ (37,650)
<br /> 100%HSS Bu down _
<br /> BLOCK C: 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 2008 118,988
<br /> 21.30.23.32.0016 $ (30,196)
<br /> 100%HSS Bu down
<br /> BLOCK D: Office 2015 50% 50,400 $ 10 $ 125 $ 504,000 $ 6,300,000 $ 9,330 $ 125,250 $ 125,250 $ 2,442,275 $ 890,641 2014 63,000
<br /> 4.3 Acres $ (9,330)
<br /> 100%HSS Bu down
<br /> BLOCK E: Office 2015 50% 36,000 $ 10 $ 125 $ 360,000 $ 4,500,000 $ 6,450 $ 89,250 $ 89,250 $ 1,740,304 $ 634.649 2014 45,000
<br /> 3.8 Acres $ (6,450)
<br /> 100%HSS Buy down
<br /> BLOCK F: Office 2018 50% 80,000 $ 10 $ 125 $ 800,000 $ 10,000,000 $ 10,000 $ 199,250 $ 199,250 $ 3,287,491 $ 1,080,400 2017 100,000
<br /> $ (10,000)
<br /> 100%HSS Bu down
<br /> I3LOCKG: Residential 2014 50% 94 $ 10,000 $ 195,000 $ 564,000 $ 16,479,140 $ 5,640�$ 164,791 $ 161,971 $ 3,501,305 $ 1,354,234 2013 118
<br /> Senior Housing Reduced for MV Exclusion $ (2,820)
<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,034 $ 3,434,453 $ 1,504,044 2011 124
<br /> 20.30.23.42.0025 $ (12,891)l
<br /> 20.30.23.42.0027
<br /> 20.30.23.42.0028 70%HSS Buydown
<br /> BLOCK I: Residential
<br /> Townhomes 2017 20% 174 $ 15,000 $ 225,000 $ 1,566,000 $ 36,193,740 $ 15,660 $ 361,937 $ 346,277 $ 5,844,718 $ 1,946,382 2016 218
<br /> Reduced for MV Exclusion $ (15,660)
<br /> 100%HSS Buydown
<br /> BLOCKJ: APi Facility '015 50% 7,200 $ 150 $ 210,700 $ 1,080,000 $ 4,214 I $ 27,000 $ 22,786 $ 318,022 $ 118,307 2014 9,000
<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 2008 52,372
<br /> 0%HSS Buydown
<br /> SUBTOTAL Number of Units 392
<br /> Number of Square Feet 488,960
<br /> TOTALS S 10,356,000 S 121,090,280 $ 26,544 $ 1,859,947 $ 1.817.743 $ 34.484,900 $ 13,084,386
<br /> Assumptions: THE BOTTOM LINE:
<br /> 1) Assumes no future land sale proceeds Projected Interfund Loan Balances at end of districts TIF 31 $ 33,155,385
<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 $ 33,165,385
<br /> Projected Ending Cash Balances at end of districts Fund 460 $ 5,740,702
<br /> TIF 31 0
<br /> TIF 32 -
<br /> TOTAL ALL FUNDS $ 5,740,702
<br /> 2/14/2012 0 EHLERS
<br />
|