|
Annual Revenues (TAXES)
<br />Valuation Calculation (County Data)
<br />Square Feet, Building
<br />Valuation, Per Square Foot
<br />Total Building Valuation (lines a*b)
<br />Land Valuation (2015 County)
<br />Total Market Valuation (lines D+E)
<br />Tax Capacity Calculation
<br />First $150,000
<br />Sub Total (line K*150,000)
<br />After $150,000
<br />Sub Total (lines M*(G-150,000))
<br />Tax Capacity (lines L+N)
<br />Property Tax Breakdown
<br />Fiscal Disparities*
<br />School Bonding
<br />State
<br />Local (City, School, County)
<br />City of Ramsey (line U*.3596)
<br />Total Property Taxes (lines R+S+T+U)
<br />Operating Expenses (public roads)
<br />Snow Removal
<br />Street Sweeping
<br />Seal Coating ($10,600/12yr)
<br />Future Overlay ($64,000/20yr)
<br />Total Annual Operating Expenses
<br />Soft Costs/City Services
<br />Police/Fire/Admin/P W/Other
<br />Revenues
<br />Total Property Taxes (line Z)
<br />City/Ramsey Only Property Taxes (V)
<br />Economic Impact/Consumer Spnd.
<br />Expenses
<br />Operations (public road)
<br />Soft Costs/City Services
<br />NET Annual Cash Flow
<br />Total Cash (lines KK-00)
<br />City/Ramsey Only (lines LL-00)
<br />10 Year Cash Flow (no inflation factor)
<br />Total Cash (lines SS*10)
<br />City/Ramsey Only (lines TT*10)
<br />20 Year Cash Flow (no inflation factor)
<br />Total Cash (lines SS*20)
<br />City/Ramsey Only (lines TT*20)
<br />30 Year Cash Flow (no inflation factor)
<br />Total Cash (lines SS*30)
<br />City/Ramsey Only (lines TT*30)
<br />Feasibility: Annual Cash Flows*
<br />Data Centerlil
<br />Single Data Center
<br />170000
<br />123.00
<br />20,910,000.00
<br />1,309,000.00
<br />22,219,000.00
<br />1.5%
<br />2,250.00
<br />2.0%
<br />441,380.00
<br />443,630.00
<br />293,508.51
<br />45,766.12
<br />231,405.75
<br />324,440.83
<br />116,668.92
<br />895,121.21
<br />NA/Private
<br />NA/Private
<br />NA/Private
<br />NA/Private
<br />NA/Private
<br />Low
<br />895,121.21
<br />116,668.92
<br />Variable (fair)
<br />0
<br />Low
<br />$
<br />$
<br />895,121.21
<br />116.668.92
<br />Single Data Center
<br />Data Center N2
<br />Two Data Centers
<br />110000
<br />$ 123.00
<br />$ 13,530,000.00
<br />$ 1,309,000.00
<br />$ 14,839,000.00
<br />1.5%
<br />2,250.00
<br />2.0%
<br />293,780.00
<br />296,030.00
<br />195,859.38
<br />30,565.54
<br />154,417.59
<br />216,499.75
<br />77,853.31
<br />597,342.26
<br />NA/Private
<br />NA/Private
<br />NA/Private
<br />NA/Private
<br />NA/Private
<br />Low
<br />597,342.26
<br />77,853.31
<br />Variable (fair)
<br />0
<br />Low
<br />597,342.26
<br />77.853.31
<br />Two Data Centers
<br />Annual Revenues (TAXES)
<br />Valuation Calculation (County Data)
<br />Average Land Value, Per Parcel
<br />Average Home Value, Per Parcel
<br />Market Value Exclusion, Per Parcel
<br />Number of Lots/Units
<br />Average Valuation (lines B+C+D)
<br />Total Market Valuation (lines E*F)
<br />Tax Capacity Calculation
<br />Property Tax Class Rate
<br />Tax Capacity, Per Parcel (lines F*K)
<br />Tax Capacity, Total/All Parcels (H*K)
<br />Property Tax Breakdown, Per Parcel
<br />Fiscal Disparities
<br />School Bonding
<br />State
<br />Local (City, School, County) (1.23327)
<br />City of Ramsey
<br />One Parcel (line U*.3596)
<br />All 47 Parcels (line W*47)
<br />Total Property Taxes (lines U*47+5*47)
<br />Operating Expenses (public roads)
<br />Snow Removal
<br />Street Sweeping
<br />Seal Coating ($10,600/12yr)
<br />Future Overlay ($64,000/20yr)
<br />Total Annual Operating Expenses
<br />Soft Costs/City Services
<br />Police/Fire/Admin/P W/Other
<br />Revenues
<br />Total Property Taxes (line Z)
<br />City/Ramsey Only Property Taxes (X)
<br />Economic Impact/Consumer Spnd.
<br />Expenses
<br />Operations (public road)
<br />Soft Costs/City Services
<br />NET Annual Cash Flow
<br />Total Cash (lines KK-00)
<br />City/Ramsey Only (lines LL-00)
<br />Long Term Cash Flows*
<br />•.
<br />$ 8,951,212.10
<br />$ 1,166,689.22
<br />17,902,424.20
<br />2,333,378.45
<br />26,853,636.30
<br />3,500,067.67
<br />$ 5,973,422.60
<br />$ 778,533.10
<br />$ 11,946,845.20
<br />$ 1,557,066.20
<br />17,920,267.80
<br />$ 2,335,599.30
<br />10 Year Cash Flow (no inflation factor)
<br />Total Cash (lines SS*10)
<br />City/Ramsey Only (lines TT*10)
<br />20 Year Cash Flow (no inflation factor)
<br />Total Cash (lines SS*20)
<br />City/Ramsey Only (lines TT*20)
<br />30 Year Cash Flow (no inflation factor)
<br />Total Cash (lines SS*30)
<br />City/Ramsey Only (lines TT*30)
<br />Residential
<br />47 Single Family Homes
<br />$ 49,000.00
<br />$ 151,000.00
<br />$ (20,000.00)
<br />47
<br />$ 180,000.00
<br />$ 8,460,000.00
<br />1.0%
<br />$ 1,800.00
<br />$ 84,600.00
<br />488.74
<br />$ 2,219.89
<br />$ 798.27
<br />$ 37,518.74
<br />$ 127,305.42
<br />1,000.00
<br />383.00
<br />883.00
<br />3,200.00
<br />5,466.00
<br />Moderate/High
<br />$ 127,305.42
<br />$ 37,518.74
<br />Variable (Significant)
<br />5,466.00
<br />Moderate/High
<br />121,839.42
<br />32.052.74
<br />47 Single Family Homes
<br />47 Single Family Homes
<br />1,218,394.22
<br />320,527.37
<br />2,436,788.44
<br />641,054.75
<br />3,655,182.66
<br />961,582.12
<br />*Fiscal Disparities
<br />Commercial & Industrial taxes are effected by a program known as "fiscal disparities." This program takes a portion of taxes collected from each property in the metro (about 40%), and places them into one pot. Then, said
<br />monies are redistributed by the State based on a complex formula. Ramsey typically is a beneficiary of this program. Meaning, the amount of money that is taken away from the City through fiscal disparities is returned (with
<br />additional monies). When issuing debt (or providing a feasibility analysis), cities are not allowed to include fiscal disparities as a revenue source for debt repayment as the amount annually received is undetermined from year
<br />to year and is not controlled by the City (it is controlled by the State). See line R above (fiscal disparities). In conclusion, if the City was able to count on fiscal disparities revenues, data center cash flows would be significantly
<br />City of Ramsey Taxes Only
<br />No fiscal dispa(0=5WW1 /ON:enter runs). No inflation.
<br />Assumed full build out at year one.
<br />$116,668.92
<br />$77,853.31
<br />$32,052.74 —
<br />1 Year
<br />2
<br />20 Years
<br />One Data Cener S fan., 0atu Centers SResidentia
<br />rigAll
<br />Total Taxes
<br />No inflation. Assumed full build out at year one.
<br />12
<br />23
<br />95,121.2
<br />$59
<br />12 -- . .42
<br />$1 ,424
<br />$2•. ,636
<br />$ 268
<br />83
<br />1Year to Years 20 Years 30 Years
<br />L
<br />One Data Cener Two Data Centers Residential
<br />dill
<br />
|