|
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
<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
<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 T *.3596)
<br />Total Property Taxes (lines R +S +T +U)
<br />Annual Expenses
<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 /Ad mi n/P W /Other
<br />NET Annual Cash Flow*
<br />Revenues
<br />Total Property Taxes (line Z)
<br />City /Ramsey Only Property Taxes (V)
<br />Economic lmpact/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 Center 81
<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 />895,121.21
<br />116,668.92
<br />Single Data Center
<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 />Data Center 82
<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 />Long Term Cash Flows*
<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 />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 +S *47)
<br />Annual Expenses
<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 /Ad mi n/P W /Other
<br />NET Annual Cash Flow
<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 />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 />$
<br />$
<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
<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 />$
<br />$
<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 />$ 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
<br />40 %), and places them into one pot. Then, said monies are redistributed by the State based on a complex formula. Ramsey typically is a beneficiary of this program. Meaning, the
<br />amount of money that is taken away from the City through fiscal disparities is returned (with additional monies).
<br />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
<br />undetermined from year 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
<br />fiscal disparities revenues, data center cash flows would nearly double.
<br />
|