|
r'
<br />Ice Arena Financial Forecast
<br />11/08/2012
<br />2011
<br />Budget
<br />Budget
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Forecast
<br />Actual
<br />2012
<br />2013
<br />2014
<br />2015
<br />2016
<br />2017
<br />2018
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />REVENUES
<br />Ice Rental
<br />493,698
<br />488,000
<br />493,000
<br />495,000
<br />510,250
<br />510,250
<br />522,125
<br />522,125
<br />537,375
<br />537,375
<br />549,250
<br />549,250
<br />564,500
<br />Other revenues
<br />-
<br />-
<br />-
<br />Hockey Programs
<br />35,445
<br />30,000
<br />36,000
<br />36,720
<br />37,454
<br />38,203
<br />38,967
<br />39,746
<br />40,541
<br />41,352
<br />42,179
<br />43,023
<br />43,883
<br />Skating Programs
<br />53,901
<br />65,800
<br />64,500
<br />65,790
<br />67,106
<br />68,448
<br />69,817
<br />71,213
<br />72,637
<br />74,090
<br />75,572
<br />77,083
<br />78,625
<br />Admissions
<br />25,630
<br />22,900
<br />25,500
<br />26,010
<br />26,530
<br />27,061
<br />27,602
<br />28,154
<br />28,717
<br />29,291
<br />29,877
<br />30,475
<br />31,085
<br />Admissions Surchage
<br />7,012
<br />7,300
<br />Sign Rental
<br />18,086
<br />17,500
<br />18.000
<br />18,000
<br />18,000
<br />20,000
<br />20,000
<br />20,000
<br />20,000
<br />20,000
<br />20,000
<br />20,000
<br />20,000
<br />Dry Floor Events
<br />19,518
<br />17,400
<br />19,500
<br />19,890
<br />20,288
<br />20,694
<br />21,108
<br />21,530
<br />21,961
<br />22,400
<br />22,848
<br />23,305
<br />23,771
<br />Other Dry Floor Events
<br />-
<br />-
<br />-
<br />Vending
<br />11,796
<br />14,000
<br />11,800
<br />12,036
<br />12,277
<br />12,523
<br />12,773
<br />13,028
<br />13,289
<br />13,555
<br />13,826
<br />14,103
<br />14,385
<br />Skate Sharpening
<br />4,223
<br />4,300
<br />4,300
<br />4,386
<br />4,474
<br />4,563
<br />4,654
<br />4,747
<br />4,842
<br />4,939
<br />5,038
<br />5,139
<br />5,242
<br />Building Rent
<br />2,600
<br />2,600
<br />2,600
<br />2,700
<br />2.700
<br />2.700
<br />2,700
<br />2,700
<br />2,800
<br />2,800
<br />2,800
<br />2,800
<br />2,800
<br />Other Building Rent
<br />-
<br />-
<br />Other Mdse Sales/Misc.
<br />2,849
<br />2,900
<br />3,050
<br />3,142
<br />3,236
<br />3,333
<br />3,433
<br />3,536
<br />3,642
<br />3,751
<br />3,864
<br />3,980
<br />4,099
<br />TOTAL
<br />674,758
<br />665,400
<br />685,5501
<br />683,674
<br />702,315
<br />707,775
<br />723,179
<br />726,779
<br />745,804
<br />749,553
<br />765,254
<br />769,158
<br />788,390
<br />EXPENDITURES
<br />Personal Service
<br />265,932
<br />294,450
<br />287,500
<br />293,250
<br />299,115
<br />305,097
<br />311,199
<br />317,423
<br />323,771
<br />330,246
<br />336,851
<br />343,588
<br />350,460
<br />Recreation Programs
<br />34,121
<br />53,750
<br />51 850
<br />53,406
<br />55,008
<br />56,658
<br />58,358
<br />60,109
<br />61,912
<br />63,769
<br />65,682
<br />67,652
<br />69,682
<br />Supplies
<br />47,209
<br />44,200
<br />48,950
<br />50,419
<br />51,932
<br />53,490
<br />55,095
<br />56,748
<br />58,450
<br />60,204
<br />62,010
<br />63,870
<br />65,786
<br />- Utilities
<br />145,824
<br />142,450
<br />149,050
<br />156,503
<br />164,328
<br />172,544
<br />181,171
<br />190,230
<br />199,742
<br />209,729
<br />220,215
<br />231,226
<br />242,787
<br />Other Services & Charges
<br />46,800
<br />41,950
<br />45,350
<br />46,711
<br />48,112
<br />49,555
<br />51,042
<br />52,573
<br />54,150
<br />55,775
<br />57,446
<br />59,171
<br />60,946
<br />TOTAL
<br />539,886
<br />576,800
<br />582,700
<br />600,289
<br />618,495
<br />637,344
<br />656,865
<br />677,083
<br />698,025
<br />719,723
<br />742,206
<br />765,507
<br />789,661
<br />CONCESSIONS
<br />Sales
<br />77,768
<br />69,000
<br />78,000
<br />80,340
<br />82,750
<br />85,233
<br />87,790
<br />90,424
<br />93,137
<br />95,931
<br />98,809
<br />101,773
<br />104,826
<br />Less: Product& Supplies
<br />32,990
<br />24,450
<br />26,900
<br />27,707
<br />28,538
<br />29,394
<br />30,276
<br />31,184
<br />32,120
<br />33,084
<br />34,077
<br />35,099
<br />36,152
<br />Salaries
<br />20,084
<br />22,700
<br />23,100
<br />23,793
<br />24,507
<br />25,242
<br />25,999
<br />26,779
<br />27,582
<br />28,409
<br />29,261
<br />30,139
<br />31,043
<br />Net Profit
<br />24,694
<br />21,850
<br />28,0001
<br />28,840
<br />29,705
<br />30,597
<br />31,515
<br />32,461
<br />33,435
<br />34.438
<br />35.471
<br />36,535
<br />37.631
<br />OPERATING INCOME (LOSS)
<br />159,566
<br />110,450
<br />130,850
<br />112,225
<br />113,525
<br />101,028
<br />97,829
<br />82,157
<br />81,214
<br />64,268
<br />58,519
<br />40,186
<br />36,360
<br />Bond Proceeds
<br />Inflated Dollars (3% -2012 year)
<br />357,300
<br />237,028
<br />2,254,034
<br />519,985
<br />33,851
<br />91,942
<br />1,193,470
<br />11,021
<br />29,917
<br />-
<br />-
<br />Capital Outlay
<br />42,143
<br />20,500
<br />357,300
<br />223,422
<br />2,062,760
<br />462,000
<br />29,200
<br />77,000
<br />970,400
<br />8,700
<br />22,929
<br />-
<br />-
<br />Barn condenser
<br />35,463
<br />Ice edger
<br />6,680
<br />Barn roof membrane
<br />11 3 300
<br />Barn dehumidifer
<br />180.000
<br />Desiccant wheel on Olympic dryer
<br />64,000
<br />Zamboni battery
<br />11,000
<br />Floor scrubber
<br />9,500
<br />Barn dehumidifier
<br />Front entrance doors
<br />12.000
<br />Barn locker rooms heating system
<br />45,000
<br />Electronic air monitor
<br />14.500
<br />Repair Vertical Cracks to Oly Precast
<br />9.500
<br />Freon Detector for Barn's Ice Plant
<br />25.000
<br />Replace rubber matting
<br />2.000
<br />2000 .
<br />2.000
<br />2.000
<br />2000
<br />2000
<br />2000 .
<br />2 000
<br />Barn Structure repairs
<br />50,000
<br />Replace co -ray vac heagngBarn
<br />20,000
<br />Maintenance /storage area
<br />75.000
<br />Expand locker room #5
<br />8.500
<br />Membrane Oly Locker Room Roof
<br />3.840
<br />Olympic roof repair
<br />22.320
<br />Exhaust System for make -up air
<br />30,000
<br />Dasher Boards
<br />140.000
<br />Door Replacement
<br />50,000
<br />Toilet Room Repairs & Upgrades
<br />80.000
<br />Replace HVAC in lobby
<br />15,000
<br />Replace water heaters
<br />7200 .
<br />Paint ceiling of barn
<br />35.000
<br />Replace co -ray vac heating /Oly
<br />30.000
<br />Ventilation unit for lockers 5-8
<br />9,500
<br />Repair Vertical Cracks to Oly Precast
<br />6,700
<br />Replacement of Refrigeration System
<br />1.771,100
<br />758,900
<br />Owner Costs
<br />Ice Resurfacer Replacement
<br />120.000
<br />120.000
<br />Replace Scoreboards
<br />19 5on
<br />Miscellaneous (audio)
<br />25.000
<br />Arch. /Engineering Fees
<br />40.422
<br />160.000
<br />40.000
<br />5,000
<br />10.000
<br />60.000
<br />-
<br />1 429
<br />TRANSFERSIN(OUT)
<br />Capital Outlay - Liquor Fund
<br />-
<br />137,500
<br />General Fund
<br />90,369
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Building Debt
<br />(200,780)
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />Grant Contribution
<br />-
<br />NET INCOME (LOSS) $
<br />7,012 5
<br />89,950 1
<br />$ (88,950)1
<br />(124,803) $ 2,140,509 $ 418,95
<br />$ 63,978 $
<br />9,785) $ 1,112,256 $
<br />53,247 $
<br />28,602 $
<br />40,186 $
<br />36,360
<br />Cumulative Excess (deficiency)
<br />13,755
<br />103,705
<br />14,755
<br />(110,048)
<br />(2,250,557) (2,669,514)
<br />(2,605,536) (2,615,321)
<br />(3,727,576)
<br />(3,674,329) (3,645,727) (3,605,541) (3,569,181)
<br />11/08/2012
<br />
|