HomeMy WebLinkAbout5.b. Armory / Community Center ProjectCITY OF ROSEKOUNT
EXECUTIVE SUMMARY FOR ACTION
CITY COUNCIL MEETING DATE: SEPTEMBER 1, 1992
AGENDA ITEM: ARMORY / COMMUNITY CENTER PROJECT
AGENDA SECTION:
OLD BUSINESS
PREPARED BY: STEPHAN JILK, CITY ADMINISTRATOR
AGENDI TEM # 5 B
ATTACHMENTS: MEMO, FINANCING INFORMATION
APPROVED BY:
As development of the Armory and Community Center project continues further
consideration of the components of the project has occurred and details of
the necessary financing and the "fundability' is becoming more clear.
The Armory Committee has met twice since the bids for the project have been
received to discuss the various bid items and their costs. On Monday,
August 24th, the Committee spent time in selecting those bid items they
feel should be included and those they felt could be excluded in an effort
to reduce the cost of the facility.
Through this effort they were able to reduce the combined cost of the
Armory and the Community Center by some $90,700..
Through this cost cutting the Armory and Community Center becomes
affordable using the two Armory levies and the approved referendum amount.
Extensive discussion on the cost of the Arena was also held and information
was presented by Ron Pederson on behalf of the group supporting the
development of the Arena to consider further cost reductions for the
construction of the Arena.
The Armory Committee then reached consensus to recommend to the Rosemount
Port Authority and the City Council to proceed with the construction of the
Armory and Community Center project using available levies and the approved
referendum financing and to proceed with the construction of the Arena
using financing available through the operating income from the project.
Further detail on bid items proposed to be included and the financing
options can be found on the attached memo.
RECOMMENDED ACTION: Motion to direct staff and city consultants to
prepare financial and contractual documents on the Armory/Community
Center Project for consideration by the Port Authority and City Council
on September 15th, 1992.
COUNCIL ACTION:
It
eity of (Rosemount
PHONE (612) 423.4411 2875 - 145th Street West, Rosemount, Minnesota
FAX (612) 423-5203 Mailing Address:
P.O. Box 510, Rosemount, Minnesota 55068-0510
TO: Mayor McMenomy
Councilmembers Klassen, Staats, Willcox
Port Authority Commissioners IL --
FROM: Stephan JIlk, City Administrato
DATE: August 28, 1992
RE: Armory and Community Center Project
ppe
MAYOR
Edward B. McMenomy
COUNCILMEMBERS
Sheila Klassen
James (Red) Steals
Harry Willcox
Dennis Wippermann
ADMINISTRATOR
Stephan Jilk
Several items of updated information of note on the
Armory/Community Center Project are provided here.
1) Armory Committee Report/Recommendation - The Armory
Committee met on Monday, August 24th, 1992 to discuss the
affordability of the project. A separate report of that
meeting is attached.
The results of that meeting were that the committee reduced
the cost of the Armory and Community Center by some'$90,700.
The Committee also provided a recommendation to the Port
Authority and City Council to proceed with the construction
of the Armory, Community Center and Arena utilizing
available levies and income from operations of the
facilities.
2) After additional meetings with the ICE ARENA SUPPORT GROUP,
and detailed discussion with Dan O'Neill of Springsted, Inc.
further financial information was drafted. The revised
financial analysis of the arena financing and cash flow
information is very positive in the sense that it shows that
the project can "cash flow" with very little or no subsidy
if.less than full depreciation is taken. Data sheets .
outlining how these new numbers relate is provided. I will
not go into any detail on this information here, but will do
so on Tuesday evening.
The main reasons this is possible are:
a) The contractor, PCL, has indicated that if they are
awarded the contract to construct the facility they
will commit to having the arena available for use by
Thanksgiving of 1993, a whole ice season ahead of the
previous schedule used.
l6verylhings (Poming (Up gosemounlY
N
Armory/Center Update
August 28,1992
b) in previous calculations depreciation costs were being
escalated along with income which caused an inaccurate
loss figure and a higher expenditure number.
c) principal payments have now been scheduled with lower
payments in the early years of the schedule, delaying
larger payments until later years when accumulated
reserves can assist in making them.
It is extremely important to note that this new, and I must
say, very positive position represented suggests that the
project could be built and financed with the operational
income providing sufficient cash to fund operations and debt
service. But, we must also understand that all assumptions
on income and expenditures must come true and any
significant change in either could cause a loss. I am not
trying to suggest that the project should not move ahead.
Just the opposite. I feel that with the new information and
changes indicated the Arena project should definitely move
ahead. I simply want to make sure that you clearly
understand that you are proceeding "with your eyes open" on
the assumptions made.
3) Overall Financing - In order to utilize all available funds
for the completion of the project(s) certain actions will
needed to be taken. That is, if the city utilizes the two
"armory levies", the approved referendum amount, and revenue
from the arena operation, we will need to "package" the deal
in a different than normal manner.
A memo from Mr. Dan O'Neill will be available on Tuesday
evening for discussion. I would provide the conceptual idea
of how this will come together here for your consideration.
There will be basically three bond issues:
a) the debt that the Minnesota State Armory Building
Commission issues for the Armory and to which the City
will make a debt payment for the City's share of the
Armory.
b) a separate issue for the approved referendum amount of
the Community Center Project which the City pays using
a new levy.
2
Armory/Center Update
August 28, 1992
c) a separate issue, sold by the Port Authority, to
finance the remaining portion of the Community Center,
the Arena and the acquisition and relocation costs for
the Highway 3 businesses.
The revenue for the repayment of this issue will come
from three sources. One will be the remaining levy
available from the two armory levies and made to the
Port Authority in the form of a lease payment. The
second would be the revenue from the operation of the
Arena and also made in the form of a lease payment. The
third would be excess increments from the tax increment
development district to pay for the relocation of the
businesses on Highway 3.
Utilizing these options the complete package can now be
financed.
4) One additional item of concern. I was advised today that
Knutson Construction Company, the original low bidder, is
contesting the fact that their bid was thrown out. The bid
was disqualified because the bidder did not include in their
bid proof of their compliance to minority hiring. The legal
people at MSABC are reviewing this and are keeping us
advised but at this time it is their recommendation that we
continue to complete all documents considering PCL the
successful bidder. If Knutson would be successful in
getting the bid the City's cost could go up appreciably.
3
Subject: Armory Committee Meeting of August 24, 1992
Time: 6:30 p.m., 8-24-92
Location: City Hall Council Chamber
Purpose: To discuss Armory/Community Center Project and
Financing of the project.
Present: Armory Committee - Greg Clausen, George Boomer,
Ray Knutson, Lee Knutson, Del Lorentzson, Ron
Carlson
National Guard - Terry Palmer, Craig Webber
Architect - Steve Belmont, Art Dickey
City Council - Dennis Wippermann, Harry Willcox
City Staff - Dave Bechtold, Steve Jilk
RAHA - Ron Pederson
Steve Belmont reviewed each separate Bid Item, #1 - #39.
Steve Jilk reviewed prepared data on the cost of each component,
i.e. Armory, Community Center, Park and Recreation Add -On and
Arena; and the financing options for them.
Ron Pederson presented information on the arena and ideas on
potential cost savings and volunteer assistance to reduce costs.
The group then worked on reducing costs to reach a fundable level
with present levies and approved referendum amounts.
Bid Items 14b, 17, 18, 20, 29, 31, 32 and 35a were considered for
cuts.
Bid Items 14b - $20,000, 20 - $15,000, 29 - $44,500 and 35a -
$6,000 were cut. Item 31 - was found to be in error as a added
cost of $2,600 and was actually a deduct of $2,600, so by leaving
it would allow for a $5,200 savings. These items amounted to a -
$90,700 potential savings. It was decided that if funds are
available that the City should attempt to negotiate the
reinstatement of items prioritized as #29, 14b and 20.
The committee then reached consensus that a recommendation should
be provided to the City Council to proceed with the construction
of the Armory and Community Center, Parks and Recreation and gym
upgrades using all approved and existing funding sources to
finance them as a package and to consider the construction of the
Arena using a funding package which includes revenue from
operations, contributions and necessary subsidies.
"g 888888888888 S C>iI 8 oi5-
Ln
� 8
A n n
W O S S S'S S S S O O O O O
1!7 S O O
N M
�� 8 888 8 8888 8 8 8 8
to r r
= M M
�� 8 88 S88 888888888 8'•- 8 88 8
N �; N c o o vi o vi o 0 o QQ vi c vi
o r r r r r r r r +•
Li
Yx9 O S p S pOo O o Oo O S S ,/p S'f 8 S gS S8 OO O O S S O
to .N-. N N� N h If'] n�� fV O ✓] N om^ \ ri n O h fv`+.
NO r r �. r w M r r` ^•. r M
b
8 S8 88p8 8OO.p88008p88888p �� pS 8 �g 8
11 O N 8 g S g 12 O �� rl - 1Ci] VO'1 vO•/
/
11'l V2 h h IA N N
N N G O O
N
W r
W r
J G
GIzM
CL r
G
V pp CC.. p p p pp pp pp p p p
D .••• G O O O O O O O G G O g g g g 0 0 0 0 0$$ 0 0 0 0 0 0 0$ S S G O G G O 0 0 0^ g G g O S O O O G O O
m a O 8 O O O S O O O Go p Opp Epp O8 pp S 8 pp p pp pp p p pp p p p •�ppp p
O G O G O O g g C tom. O O O G G g g? O G G. L G O G . G G G G G d
O n M ^• Y'1 O :^1 -0 O e-0 -• M O O O G N C•
�• l � L� r -� M tv M� �� �. M e't O-0' N M� M H r N � r O � M n
r r r 6 U r
b _
N N �
pp_ N
C zU D t� v d
G= O C J L1 r A I
N A r
tn
,,pp �
C e C m-0 C �y `~ Vl N v@ V 7 C d J J T J_ N b O E A
O O, $ J
V m +
•� b Of d 88 W tL IL CA Cb $ S $ OJ ^ Y W V1 •+ ,Dp N Yy Xy b N L, b 0C/ N
J J �C d A U Li
i O NI L y y N J J �d'1 •+ S O .T. 6 U ►b•• W m 6 to .b. mob••
_ C a b v l;, m _ c s �0�l CC o s o
V O C O O b T J N A b C T ..r A A A A A d 6 Q 6 L 0 6 d L W U U LL. A b
Zt b A C T C b V O C N b L� C C C C V •� C r
L ✓ A ` L b w C� O V tt Y � L _ b b b 61 b C r CC m b t A7
C CC T O C N Of ..L.. b r
A A Of N N C m L C y .-w y (`. t`, LL 4 kL i r r r 0✓ O 5 8
{/1 C y p. ry A N 0J u G C 6 Q¢ V w L1 �+ b •.C. A r L) tJ •"• (p. of ¢ "'� L r D •_ 0' 3 Ic
O .•• O Obi A of C V n u N �' W T. !• b Y¢ V Li�-
•..- L yV c =� `o T i L� v� W� �... c 5 5 5 5 �s � b> s L •V^ � '" c A v �n a'n
yL,� LL m oQ�'+
J J U Cl A Y bei w b Cl b b C@.J 5 b C Y b C C b A m 'O • A C A
A D>u O 0
zA=inma?l l7SJSui: W d¢cz¢z¢¢ 4.0=4 .L- -�rc¢ m4AuzRvi=
O rW. A
m .•• + ` A• �l 'O •. .
lN!a In V3 ON n ► h 1� m P ____
y� t4i N N N N N N. N N n n n n n n n n n n l
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
DESCRIPTION OF BID ITEMS
BID ITEM 1: Armory Building. The complete construction of the
National Guard Armory Building, including all General,
Mechanical, and Electrical work in connection with the
construction of Project. This will hT include any of
the work called for by Bid item 2 through Bid item 38.
1) Note that costs shall be based on a nominal
ceiling height of the Assembly Hall, Room B120, of
20 ft. 6 in. and East/West dimension of
approximately 92'-8° clear inside.
2) Costs shall be based on finishes as indicated on
Room Finish Schedule. Alternate finishes are to
be bid under separate bid items.
3) Utility costs shall be based on extension of lines
and services to a point S ft. 0 in. outside the
building perimeter and within. (Costs for
connection to services at the Property Line and
extension to 5 ft. 0 it -.outside building will be
supplied in Bid item 7.)
BID ITEM 2: inti' Ori Detection n Slvsr am r 7s , l Da 1 . Installation only
of the rough -in materials for the JSIIDS. Materials
(except wiring and conduit) shall be furnished by
Owner. Equipment will be furnished and installed by
Owner. Boxes will be furnished by Owner, installed by
Contractor.
1) Light fixtures, switches, receptacles, conduit,
rough -in boxes (applicable), wiring, dehumidifier,
etc., not specifically a part of the JSIIDS, or as
specifically indicated, shall be included in Bid
item 1, (furnished and installed by the
Contractor).
2) The Owner will order and purchase the JSIIDS,
remove the 'technical' equipment and supply
Contractor with rough -in boxes for installation.
Conduit, wiring, phone line, and connectors
specifically for the JSIIDS shall be furnished and
installed by the Contractor. At the completion of
the Project, the Owner will install the
'technical' equipment.
STATEMENT OF WORK
00600 - 2
STATEMENT OF WORK
SW.01 DESCRIPTION OF WORK
Work To Be Done: The work consists of furnishing all plant, labor, materials
and equipment and performing all work in strict accordance with these specifica-
tions, schedules and drawings forming parts thereof for:
a. PROJECT TITLE: National Guard Armory, Rosemount, Minnesota
b. LOCATION OF PROJECT: The above work is to be accomplished at:
ADDRESS: State Highway 3 at Dodd Road
Rosemount, Minnesota
SW.02 PRINCIPAL FEATURES
The work to be performed includes the following principal features. It is to be
understood. that the general description of these features does not in any way
limit or diminish the responsibility of the Contractor to accomalish the
complete work under the contract in accordance with the provisions of SW.01
above.
a. 2 -Story National Guard Armory Building.
b. Masonry bearing walls with steel joists and deck.
c. Insulated masonry cavity wall construction at all exterior walls.
d. General, Mechanical and Electrical work to be included in one
General Contract.
e. Community Center and additional sitework by Alternate Bid.
f. (See also, attached DESCRIPTION OF BID ITEMS.)
SW.03 PRE-BID ON-SITE INSPECTIONS
a. It is the Contractor's responsibility that he inspect the sites, ascer-
taining for himself the work to be performed and the conditions under which it
will be accomplished. Failure to do so will in no way relieve the successful
bidder (Contractor) of the responsibility of accomplishing the work as described
in these specifications and drawings for the agreed upon contract price.
b. Arrangements for site inspections shall be coordinated with Arthur
Dickey Architects, Inc. The pre-bid inspections will be conducted between the
hours of 8:00 a.m. and 4:00 p.m., Monday through Friday. A minimum advance
notice of 24 hours is required.
SW. 04
Refer all questions relative to the work to:
Arthur Dickey Architects, Inc.
4930 France Avenue South
Minneapolis, Minnesota 55410
(612) 920-3993
STATEMENT OF WORK
8909.64 00600 - 1
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
Description of Bid Items
BID ITEM 3: Site Prenarations. All work in connection with the
preparation of the project site (within the limits of
the Property Lines) to the subgrade elevations rewired
for the construction of facilities to the elevations
specified on the Plans, including clearing, grubbing,
excavation and embankment earthwork, drainage
channels/system, and final grading/compaction of site
soils to subgrade levels. The bid will = include
excavation and backfilling recuired for ioundat-on
walls and footings nor the finish shaping and proof
rolling of the subgrade under pavements and floor slab
construction.
1) Subgrade elevation '_s to be within 2 in. of finish
grades as indicated on the Drawings.
2) Site preparation should only be recuired for those
areas indicated or disturbed by the construction.
3) Note that 'Engineered fill, is recuired for some
portions of the site as indicated.
BID iTal 4: Grad na and SeedinCr. ,,!!.work In connection with
grading and seeding of unpaved areas disturbed by
construction, including placement of top soil from
existing stock piles on the prepared subgrade, finisz
grading the topsoil, and the sowing oz grass seed
together with fertilizing, watering, cutting and
general maintenance operations required to establish a
healthy stand of grass. This bid will Q include
sodding, sprigging, mulching, plants, planting, nor the
grading and preparation of the subgrade.
BID ITEM 5: Planting. All work in connection with the furnishing
and planting of new trees, shrubs, bushes and vines at
locations specified, including fertilizing, mulching,
staking, erection of temporary barriers to prevent
damage, watering and general maintenance operations
required to establish healthy .growth after transplant.
BID ITEM 6: Access Roads and Parking Pavement. All work in
connection with the furnishing, placing and compaction
of base and surface courses of pavements for access
roads and parking areas, including the finish shaping
and proof rolling of the prepared subgrade. This bid
will NOT include the construction of the prepared
subgrade, drainage structures, nor other items
STATEMENT OF WORK
nnann - I
NATIONAL GUARD ARMORY, ROSEMOUNT, MN,
Description of Bid items
designated as site preparation work. The costs for
each type parking area and the pavement designated
access road are to be indicated separately as listed.
The costs associated with 'rdditional Off-street
Parking, shall be indicated in Bid item 16 and s�Sj
included in this Bid Item. The subtotal
l SLDtOia pr_Ce Si:a11 be
for al the work of Bid Item o.
BiD iTEM %.
jet'iliyonnecti n All
C O r _ Work in CCP^+`c:iOn w.th
i_ installing
furnis:-: ng'?d a: water, gas end sanizar-,r sewer
serVice 1 -Jr. --s from themains to a poi. - -- . -
�.. 1. s � e
� Our
,. , _
t: -:e .ru_1ciP.ff line and trenchinc f0 `"ec` u -4
f d-- b a1
el a -cmc and telephone ca e i �
_ b S, ::C uC_..y backf i l i i Pc
-
r
and cOT,pac,.l0n 0_ earth after Cables ::ave been
installed by local utility companies. . Thi S b4 d wi l l
Aj •T include the Construction of any main lines for
water, gas or sanitary sewer systems no: any work for
the installation of any primary electric lines and
..r-=nsfox-niers. The cost for each type of utility work
is to be indicated separately as listed.
_-� IT`S a :
� _
=en i nC7 All work connection with the iurni $'-i.na
�Iyn
and erection of outdoor chain link fencing comolece
with all posts, fabric, barbed wire barrier, gates and
accessories in place and ready for service.
BID iTEM 9:
Security Lighting. All work in connection with the
furnishing and installation of the exterior Dole -
mounted lighting system, including trenching and
backfilling, cable and accessory item to a 5 ft.
point
outside the building line; complete and ready for
service. This bid will OT include work inside the
building (5 ft. line) nor any building -mounted exterior
lighting fixtures.
BID ITF-M 10:
Concre*P walks. All work in connection with the
construction of concrete walks, including the finish
shaping and proof rolling of the prepared subgrade.
This bid item will NoT_ include the construction of the
prepared subgrade, drainage structures, nor other items
designated as site preparation work. This bid item
will not include concrete walks associated with the
Community Center, which shall be included in Bid Item
lo'.
1) Cost shall include subgrade preparation, formwork,
accessories, materials, labor, finishing, etc.
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
Description of Bid Items
BID IT'M 11: Flacroole. All work in connection with the furnishing
and installation of the flagpole, including rope,
foundation and all accessories; complete and ready for
service.
BID ITEM 12: =nla-up AssemblY Hall, Raises Roof an
d Add
C1 eros zo, v windows. x.11 work, including Mechanical and
Electrical, but not including air conditioning,
re = sired to increase the long dimension of Assembly
.all (Room No. B120) from 92'-0" to 112'-0• (20 feet)
(See Drawing No. k -o'), increase the heicht of the roof
structure from 20'-6" to 26—o'" clear heicht to
u-:dersldA of structural beams (See Detail 7/,1.18), and
add Clerestory window `(See Drawing 4/.,1.2'-,) as sped fi ed
in Section 08410.
BID ITS 13: Park and Recreation p` -i P soace. All work, including
_M_echanical and Electrical, required to add space and
comolete the Park and Recreation Department Offices
(Rooms Nos. B114, 3115, 8116, B117, 3118, and B119 at'
the lower level.) See Drawing Sheet No. A6.
BID ITEM 14a: Rosemount Community Center. A_il work, including
Mechanical and Electrical, required to add space and
complete the Rosemount Community Center. (Rooms Nos.
H2O1 through H2O9, EXPANDED Room No. H210, EXPANDED
Room No. H211, and Rooms Nos. x:212 through H219.) See
Drawing Sheet No. All and all corresponding sections,
elevations, details, schedules, and Mechanical and
Electrical Drawings.
BID ITEM 14b: amazed C M U at Audiori,m provide glazed C.M.U.
color 'B' in lieu of brick type C where indicated on
Drawing Sheets Nos. A-11 and A-29.
BID ITEM 15a: Rosemount Arena. All work, including Mechanical and
Electrical, required to add space and complete the
Rosemount Arena. See Drawing Sheets Nos. P.31 through
A33 and all corresponding sections, elevations,
details, schedules, sitework, landscaping, and
Mechanical and Electrical Drawings. Include Mechanical
and Electrical rough -ins for future toilets at Room
Nos. 1126 and I207.
STATEMENT OF WORK
00600 - 5
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
Description of Bid Items
BID ITEM 15D: RosemounT Arena • 1 pam �OCm O; 1 `S Snn rcr >
.._ u S 1•'11
work, including Mechanical and -lectrical, recur=d to
add: Team Rooms Nos. 7107, 7108 T100, and 110•
Toilets Nos. 1126, I129, -206, and 07 ^�.- T
I2 Showers Nos.
7-27 and _128 • _ '
Figure Skaters Rooms Nos. _ 12 4 and 1-1-24-1;
and Concessions Room No. 1204. See Drawing No. '32 and
Corresponding Mechan4 cal and Electrical Drawi.nas
EID IT`S 15C: FQ em tint Arpra 71= -,rat -or. 1 l Work, in-c-luding
MeC-^-a^ i cal and Blect= _cal required -
c � - � - t0 GCC .VCraL' � '_C
1 cVatOr. See Spec? t- Cat'_C?•: Sects c_'? 111,2 0 and
nd
comes-oond:.nQ Mec.'?anti-cal and Electrical Drawings and
Specifications. ,zoi stw v ;S -ad
a - c ua in Bid .Iter 15a.
BID :mom 15d: Eoaemcu-'t Arena 31 cnc^ltar
G C nrcnn? r'� -tom Snttrn
C✓slaT.. --1'1 Arena
requJLred to add bI eac^e"S where S:?O'v�?:
on D rawi naS NOS. A31 through :33 , and all work,
including, Electrical, required to add Scoreboard and
Sound Svstem. See Specification Section 12750-=R`\A
EL' C"ES, and Electrical SDeci'icacic s coi?cern4n^
Scoreboard and Sound system. -y
3ID -TEM 15e: ROcnTOun- ='" "= Al tArrt^ro Tra VSi crn 1
-1 .work,
n-cludi g Mechanical and Electrical, to provide
reciprocating refrigeration system With steel Dine
floor in lieu of hermetic multiple compressor system
with plastic pipe floor as indicated in Mechanical
Specifications and Drawings and in Division 13
Specifications.
BiD IT�.'y1 16: �OTPm nj ty n�cr i tawny !t nd p V martt All Work
required to provide bituminous paving, concrete walks,
flagpoles, seeding, sod, and planting for the Community
Center. See Drawing Sheets Nos. A2, G1, and Ll.
BID ITEM 17: Assembly Hall Athletic Ern,;pment. All work required to
provide and install two rectangular glass basketball
backstops; four fan shaped metal basketball backstops;
three sets of volleyball standards, floor inserts and
nets; one dividing curtain; and twelve wall pads. See
Drawing Sheet A28 and Specification Section 1150
ATHLETIC EQUIPI�NT .
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
Description of Bid items
BID ITEM 18: Assembly Hall Athletic Surface All work recn:ired to
provide and install athletic floor and floor markings.
(See Drawing Sheet No. A28. ) This item applies only to
the enlarged Assembly hall. (See Bid Item 12.)
BID TTS 1-9ssemb y Hall LCOuSt? Cal Treatment. All wort{ recuired
to Drovide acoustical panels on t_^.e kssembiv :all
walls. See Drawing Sheet No. A.28.
BID IT -M. 20: . i -,r, -,.i shod concrete Block in -.sse7bl V -Hall. All work
recuired to Drovidescored burnished concrete block
full height of exposed walls in lieu of epot:v painted
and painted scored regular concrete block in Room No.
3120.
BiD IT=`! 21. C1 aze Dar` i ": on at L-6bb;y All work re -.u4 ----d to
Drovide Glazed Lites in lieu of Dainted scored concrete
block between Stair. A and the Assembly ::all and between
a portion of corridor G225 and the -.sse.*abiv :all. See
hollow metal frame Type D on Sheet No.. c21..
3=D I'I'^M 22. Trorhy CaCes All work required to provide two Trophy
cases in Lobby. (Room No. 3202.) See Detail 2/A9.
BID ITEM 23: Skvliahts in Armory. All work, including structural,
mechanical, and electrical, required to provide and
install a structural skylight in Room -7202 and two unit
skylights in Rooms Nos. 1201 and E205, including
finished drywall ceiling openings and structural
framing, in lieu of roofing, roof insulation, steel
deck, bar joists and suspended ceiling. See details on
Drawing Sheet No. Al2, and Specification Sections 07700
and 07850, and Structural, Mechanical and Electrical
Drawings and Specifications.
BiD ITEM 24: Locker Room Benches. All work required to provide and
install Locker Room Benches in Rooms Nos. B109 and B113.
See Drawing Sheet A6 and specification Section 10990.
BID ITEM 25: Recessed PaDQr Towel Dispensers. All work required to
provide and install recessed paper towel dispensers in
Rooms B1007, B111, C105, C1060 E229, E230, G222, a a
G224, in lieu of surface mounted paper towel dispensers.
See Specification Section 10800 Toilet & Bath Accessories.
SiA7i FE 0600 ORS
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
Description of Bid items
BiD IT=M 26. udin-Visual Bc*uinment A11 work required to provide
and;nstall Audio -Visual "Equipment 11Sted under
Specification Section 11950.
BID IT=?M 27: Burni cn-d COn.C='e` 31 O .lt in Lower T.c,;c1 Lcbhv. r 1 i
work requ=red to provide and install scored bllrni shed
concrete block full height in Roos i No. : 1`01 n 1 i C,� C.L.
painted scored regular concrete block. -
BID I' ±'! 28: rn Ic' ori C nC, o:A 31 o { in r
work required to provide and install scored burnis e^_
concre_e block in Room No. B101 a-, at J- wails,
=��1 1 l e i .
- -S.t Oexposed wal 1 , in 1-eu o_- painter
Score'', concrete block.
✓=D =?vf 2 ace � t in U
_ C{ ^nprT,:,;cl T %7y anG', V^c`i^t to :_11
work required to provide and install -face :rick On the
wails of Rooms Nos F201 and F202 f4'-06"ro4'-06" above
floor, to ceiling, in lieu o= painted, scored, cors_---
block. (Face brick from floor to 4 ' -6" a'Zove fl oor is
_::eluded in Bid _tem l Base Bid.)
B 7 -,' 30 : Gema„- C Tile Floor ; n T'rar Levelcl pbh•J r.nri ticc•, ^t�� �
'.11 work required to provide and install Porcelain
Ceramic Tile on the floors in Rooms Nos. F201 and F202,
in lieu of Vinv1 Composition Tile.
BID i=4 31 Maul e Floor- ani'+ Base at n ';tor;un/classroom �raae
All work required to provide and install maple flooring
and base in Room No. F205 in lieu of carpet floor and
base. Provide maple treads and risers at the steps
from Auditorium/Classroom to the Stage in lieu or
carpet. See Specification Section 09550.
BID ITEM 32: Corian window `oois. All work required to provide and
install Corian window stools at all Aluminum clad wood
windows except those in Room Nos. E213, E214, 7'215, and
7'216. See Detail 21/A21.
BID ITEC! 33: 12 Burner Rancre. All work required to provide -and
install a 12 burner -as range/oven in lieu of a four
burner gas range/ en, and gas griddle/oven in Food
Preparation Room No. B125. See Section 11900 - FOCD
SERVICE EQUIP=.
STATEMENT OF WORK
00600 - 8
NATIONAL GUARD ARMORY, ROSEMOUNT, MN.
Description of Bid Items
BID ITEM 34:
landscaped TS!ard r Drive Lar.- ' . .A_ll work recruired to
provide and install concrete cubs and landscaping, in
I
I
lieu of bituminous paving, at the island in the main
entry drive lane. See Drawing Sheets Nos. A2, G1, and
L1.
BID TT—" -:'M. 35a:
iod. All work required to provide and install 80,000
sq. ft. of sod in lieu of seeding in areas indicated on
Zne Landscape Plan. See Drawing Sheet No. L1.
BID IT=IM 35b.
5; to -r„Yi car i on All work r ecl_red to and
provide
install site irrigation in areas indicated on the
I_rigation Plan. See •Specification Section 02810.
BID ITEM 36:
VO'y Counters in -men's Roams . .111 work .equired to
provide and install laminated plastic countertop and
lavatories in lieu of wall mounted lavatories, and all
work required to provide Tull mirrors in lieu of
_n^.dividual framed mirrors, in Men Is Rooms Nos. B107,
-229, and G222. See Details 11/h7 and 12/97.
BiD ITEM 37:
A i r Condit i oni nc in t_*hp AS em ) i V HE!!r.11 work
required to provide and install chilled water coils in
the air handling units that serve the Assembly hall.
Room No. 3120. See Division 15 - Mechanical -and
Division 16 - Electrical.
B -D IT ---'M 38: Bronze Placrue. All work required to provide and
install a bronze plaque in the F_7-morv. See
Specification Section 10425 -SIGNS.
Definition: Including means including, but not limited to.
STATEMENT OF WORK
00600 - 9
08/28/92 14:33 FAX 612 223 3002 SPRINGSTED INC.
CITY OF ROSEMOUNT
ARMORY CENTER COMPLEX
- SUMMARY
August 2T, 1992
Ia 002/006
08/28/92 11:33 FAX 612 223 3002 SPRINGSTED INC.
CITY OF ROSEMOUNT
ARMORY CENTER COMPLEX
Use of Funds (Estimated)
Armory
Community Center
Business Relocation
Ice Arena
Total Construction Costs
Capitalized Interest
Underwriters Discount
Other Cost of Issuance
Total Project Costs (Estimated)
$1,150,000
1,619,000
400,000
2,127,000
$5,296,000
205,000
52,000
52.000
$5,605,000
0003/006
08/28%82 11:33 FU 612 223 3002 SPRINGSTED INC.
CITY OF ROSEMOUNT
ARM019Y CENTER COMPLEX
Sources of Funds (Estimated)
Debt Contract - State of Minnesota
G.O. Bonds - City of Rosemount
G.O. Bonds - Port of Rosemount
Investment Earnings
Cash
$1,150,000
1,065,000
3,080,000
130,000
180.000
Total Sources of Funds $6,605,000
[a 0041/006
08/28/92 14:34 FAX 612 223 3002 SPRINGSTED INC. Q005/006
CITY OF ROSEMOUNT
ARMORY CENTER COMPLEX
Source of Revenue (Estimated)
Armory Levy - Special Legislation
- Special Levy
Debt Levy - G.O. Bonds City
Debt Levy - G.O. Bonds Port
Ice Arena income - G.O. Bonds Port
$ 95,000
30,000
87,600
80,000
180,000
081128/92 14:34 F_�IX 612 223 3002 SPRINGSTED INC. 0061006
M
CITY OF ROSEMOUNT
ARMORY CENTER COMPLEX
Ice Time Rates
Base Case
Est.
Est.
Rate
Hours
Income
Peak
$115
1,176
$135,240
Off -Peak
94
721
67,774
District #196
94
650
_ 61,100
Total Ice Rental Income
$264,114
Alternative #1
Esta
Est.
Rate
Hours
Income
Peak
$120
1,176
$141,120
Off -Peak
100
721
72,100
District #196
100
650
65,000
Total Ice Rental Income
$278,220
City of Rosemount, Minnesota
3% Escalation for all yrs, No Other Income
$2,100,000
Bond Issue
Ice Arena Pro-Forma
Operating Year
Income Escalation
1993
1994
1995
1996
1997
1998
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 3.00%
$22,010
$254,114
$272,037
$280,199
$288,604
$297,263
Services 3.00% 3.00%
6,750_
81,0_00
-
83,430
85,933
88,511
91,166
Total Operating income
$28,780
$345,114
$355,467
$366,131
$377,115
4 $388,429
Other Income:
Banquet Facility
0
0
0
0
0
0
Excess Tax increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.00%
0
0
00
0
0
Total Other Income
$0
$0
$0
- �$0-
$0
$0
Total income
$28,760
$845,114
$355,467
$3+66,131
__ q 7115
$388,429
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00.%
8,077
96,920
99,828
102,822
105,907
109,084
Insurance 3.009'° 3.00%
833
10,000
10,300
10,609
10,927
11,255
utilities 3.000/0 3.00%
5,417
65,000
66,950
68,959
71,027
73,158
Gen & Admin 3.00% 3.00%
833
10,000
10,300_
---$187,378
10,609
10,927
11,255
Total Operating Expense
$15,160
$181,920
$192,999
$198,789
$204,753
Depreciation: Cost life
Building 1,947,000 50
6,490
38,940
38,940
38,940
38,940
38,940
Equipment 437,000 20
3,842
21,850
21,850
21,850
21,850
21,850
Total Depreciation
$10,132
$60,790
$60,790
$60,790
$60,790
$60,790
Total Operating Expense & Depre
$25,292
$242,710
$248,168
$253,789
$259,579
$265,543
Net Income Before Debt Service
$3,468
$102,404
$107,300
$112,343
$117,536
$122,886
Debt Service
$0
$103,830
$123,830
$123,830
$123,830
$133,830
Net Income
$3,468
f$ 426
($11,487
($6,294)
{$10,944)
Cumulative Depreciation
$10,132
$70,922
$131,712
$192,502
$253,292
$314,082
Cumulative ProfitiLoss
$3,468
$2,042
($14,488)
($25,976)
($32,269)
($43,213)
City of Rosemount, Minnesota
0
3% Escalation for all yrs, No Other Income
$2,100,000
Bond Issue
Ice Arena Pro -Forma
0
Excess Tax Increment (Through 1999)
Operating Year
0
0
0
Income Escalation
1999
2000
2001
2002
2003
2084
Yr 95-04 Yr 05+
0
Building Depreciation 0.00%
0
- 0
0
0
Operating Income:
0
Tota3 Other Income
$0
$0
_
-$0
$0
Ice Time 3.00% 3.00%
$306,181
$315,366
$324,827
$334,572
$344,609
$354,947
Services 3.00% 3.000/0
93,901
_ 96,718
99,620
102,608
105,687108,857
_
Total Operating Income
$400,082
$412,084
$424,447
$437,180
$450,295
$463,604
Cather Income:
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.00%
0
- 0
0
0
0
0
Tota3 Other Income
$0
$0
_
-$0
$0
$0
$0
Total Income
$400,082
$412,084
$424,447
$437,180
$450,295
$463,804
Expenses Escalation
Yr 95-04 Yr05+
Operating Expense:
Personnel 3.00% 3.00%
112,357
115,728
119,199
122,775
126,459
130,252
Insurance 3.00% 3.DO%
11,593
11,941
12,299
12,668
13,048
13,439
Utilities 3.00% 3.00%
75,353
77,613
79,942
82,340
84,610
87,355
Gen & Admin 3.00% 3.00%
11,593
11,941
12,299
12,668
13,048
13,439
Total ('operating Expense
$210,895
$217,222
$223,739
$230,451
--$237,364
$244,485
Depreciation: Cost Life
Building 1,947,000 50
38,940
38,940
38,940
38,940
38,940
38,940
Equipment 437,000 20
21,850
21,850
21,850
21,850
21,850
21,850
Total Depreciation
$60,790
$60,790
$60,790
$60,790
$60,790
$60,790
Total Operating Expense & Depre
$271,685
$278012
$284,529
_$291,241
$298,154
$305,275
Net Income Before Debt Service
$128,397
$134,072
$139,918
$145,939
$152,141
$158,529
Debt Service
$133,380
$137,900
$147,150
$150,863
$164,288
$166,880
Net Income
($4,983)
t$3,828�
$7 2321
-$4 923
_($123146)
x$8,351
Cumulative Depreciation
$374,872
$435,662
$496,452
$557,242
$618,032
$678,822
Cumulative Profit/Loss
($48,196)
($52,024)
($59,256)
($64,180)
($76,326)
($84,677)
City of Rosemount, Minnesota
3% Escalation for ail yrs, No Other Income
$2,100,000
Bond Issue
Ice Arena Pro -Forma
Operating Year
Income Escalation
2005
2006
2007
2008
2009
2010
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.009'0 3.00%
$365,596
$376,563
$387,860
$399,496
$411,481
$423,825
Services 3.00% 3.00%
112,123
115,487
118,951
_ 122,520
126,195
129,981
Total Operating Income
$477,718
$492,050
$506,812$522,016
$537,676
$553,807
Other Income:
Banquet Facility
0
a
0
0
0
0
Excess Tax Increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.00%
0
0
0
0
_ 0
0
Total Other Income
$0
$0
$0
$0
$0
$0
Total Income
$477,718
$492,050
$506,8 2
_ $522,416
$537,676
$553,807
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.001yo
134,160
138,185
142,330
146,600
150,998
155,528
Insurance 3.000/0 3.00%
13,842
14,258
14,685
15,126
15,580
16,047
Utilities 3.009`0 3.00%
89,975
92,674
95,455
98,318
101,268
104,346
Gen & Admin 3.00% 3.00%
13,842
14,258
14,685
15,126
15,580
16,047
Total Operating Expense
$251,820
$259,374
$267,156
$275,170
_
$283,425
$291,928
Depreciation: Cost Life
Building 1,947,000 50
38,940
38,940
38,940
38,940
38,940
38,940
Equipment 437,000 20
21,850
21,850
21,850
21,650
21,850
21,850
Total Depreciation
$60,790
$60,790
$60,790
$60,790
$60,790
$60,790
Total Operating Expense & Depre
$312,610
$320,164
$327,946
$335,960
$344,215
$352,718
Net Income Before Debt Service
$165,109
$171,886
$178,866
$186,056
$193,461
$201,088
Debt Service
$174,155
$180,825
$186,870
$197,270
$201,713
$210,518
Net Income
($9,046)
($8,939)
($8,004)
_____ ($11 1,214)
�$8 252$9,429!
Cumulative Depreciation
$739,612
$800,402
$861,192
$921,982
$982,772
$1,043,562
Cumulative ProfiV oss
($93,723)
($102,662)
($110,667)
($121,881)
($130,133)
($139,562)
City of Rosemount, Minnesota
Ice Arena Pro- Forma
Income Escalation
2011
Yr 95-04 Yr fly+
Yr 05+
Operating Income:
Operating Expense:
Ice Time 3.00% 3.00%
$436,540
Services 3.00% 3.00%
133,881
Total Operating Income
$570,421
Other Income:
16,528
Banquet Facility
0
Excess Tax Increment (Through 1999)
0
Cost Reduction Contribution
0
Building Depreciation 0.0096
0
Total Other Income
$0
Total Income $570,421
Expenses Escalation
Operating Year
Yr 95-04
Yr 05+
Operating Expense:
2013
2014
Personnel 3.00%
3.00%
160,194
Insurance 3.00%
3.00%
16,528
Utilities 3.00%
3.00%
107,435
Gen & Admin 3.0cr/o
3.00%
16,528
Total Operating Expense
$605,159
$300,686
Depreciation: Cost
Life
0
Building 1,947,000
50
38,940
Equipment 437,000
20
21,850
Total Depreciation
0
$60,790
Total Operating Expense & Depre $381,476
Net Income Before Debt Service $208,945
Debt Service $218,438
Net Income ($9,493)
Cumulative Depreciation $1,104,352
3% Escalation for all yrs, No Other income
$2,100,000 Bond Issue
165,000
17,024
110,658
17,024
$309,707
38,940
21,850
$60,790
$370,437
$217,037
$225,405
($8,368)
$1,165,142
169,850
17,535
113,978
17,535
$318,998
38,940
18,208
$67,148
$376146
$229,013
$241,480
$1246
$1,222,290
Cumulative Profit/Loss ($149,054) ($157,422) ($169,889)
175,048
18,061
117,397
18,061
$328,568
38,940
0-
$38,940
$367,508
$255,807
$265,980
_ ..L$1Q, L73
$1,261,230
($180,063)
180,300
18,603
120,919
'18,603
38,940
0
$38,940
$377,365
$264,649
$273,380
-- ($8,731).
$1,300,170
($188,794)
185,709
19,161
124,547
19,161
$348,578
•a•
$387,518
$273,757
$269,465
$4,292
$1,339,110
($184,502)
Operating Year
2012
2013
2014
2015
2016
$449,636
$463,125
$477,019
$491,330
$506,070
137,897
142,034
146,295
150,684
155,204
$587,533
$605,159
$623,314
$642,014
$661,274
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
$0
$0
-
$0
-
$0
$0
$587,533
$605,159
$623,314
$642,014
$651,274
165,000
17,024
110,658
17,024
$309,707
38,940
21,850
$60,790
$370,437
$217,037
$225,405
($8,368)
$1,165,142
169,850
17,535
113,978
17,535
$318,998
38,940
18,208
$67,148
$376146
$229,013
$241,480
$1246
$1,222,290
Cumulative Profit/Loss ($149,054) ($157,422) ($169,889)
175,048
18,061
117,397
18,061
$328,568
38,940
0-
$38,940
$367,508
$255,807
$265,980
_ ..L$1Q, L73
$1,261,230
($180,063)
180,300
18,603
120,919
'18,603
38,940
0
$38,940
$377,365
$264,649
$273,380
-- ($8,731).
$1,300,170
($188,794)
185,709
19,161
124,547
19,161
$348,578
•a•
$387,518
$273,757
$269,465
$4,292
$1,339,110
($184,502)
City of Rosemount, Minnesota
Ice Arena Pro -Forma
Income Escalation
2017
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 3.00%
$521,252
Services 3.00% 3.00%
159,861
Total Operating Income
$681,112
Other Income:
Banquet Facility
0
Excess Tax Increment (Through 1999)
0
Cost Reduction Contribution
0
Building Depreciation 0.00%
0
Total Other Income
$0
Total Income
$681,112
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
191,280
Insurance 3.00% 3.00%
19,736
Utilities 3.00% 3.00%
128,283
Gen & Admin 3.00% 3.00%
19,736
Total Operating Expense
$359,035
Depreciation: Cost Life
Building 1,947,000 50
38,940
Equipment 437,000 20
0
Total Depreciation
$38,940
Total Operating Expense $ Depre
$397,9751
Net Income Before Debt Service
$283,137
Debt Service
$259,945
Net Income
$23,192
Cumulative Depreciation
$1,378,050
Cumulative Profit/Loss
($161,310)
3% Escalation for all yrs, No Other Income $2,100,000 Bond issue
Operating Year
2018
$536,889
164,656
$701,546
0
0
0
0
$701,546
197,016
20,328
132,132
20,328
$408,746
$292,800
EEO
$292,800
$1,416,990
$131,490
2019
$552,996
169,596
$722,592
0
0
0
0
$0
$722,592
202,929
20,938
136,096
20,936
38,940
0
$38,940
$419,M
$342,752
$302,75.2
$1,455,930
$434,242
City of Rosemount, Minnesota 3% Escalation through 2004, No Other Income $2,100,000 Bond Issue
Ice Arena Pro -Forma Operating Year
Income Escalation
1993
1994
1995
1996
1997
1998
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 0.00%
$22,010
$264,114
$272,037
$280,199
$288,604
$297,263
Services 3.0036 0.00°%
6,750
81,000
83,430
85,933
88,511
91,166
Total Operating Income
$28,760
$345,114
$355,467
$356,131
$377,115
$388,429
Other Income:
Banquet facility
0
0
0
0
0
0
Excess Tax Increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.000
0
0
0
0
D
0
Total Other Income
$0
$0
$0
$0
$0
$0
Total Income
$28,760
$345,114
$355,467
$366131$377,115
$388,429
Expenses Escalation
Yr95-04 Yr05+
Operating Expense:
Personnel 3.00°/6 3.009'0
8,077
96,920
99,828
102,822
105,907
109,084
Insurance 3.00% 3.00%
833
10,000
10,300
10,609
10,927
11,255
utilities 3.00% 3.00%
5,417
65,000
66,950
68,959
71,027
73,158
Gen & Admin 3.00% 3.00%
833
10,000
10,300
10,609
10,927
11,255
Total Operating Expense
$15,160
$181,920
$187,378
$192,999
$198,789
$204,753
Depreciation: Cost fife
Building 1,947,000 50
6,490
38,940
38,940
38,940
38,940
38,940
Equipment 437,000 20
3,642
21,850
21,850
21,850
21,85D
21,850
Total Depreciation
$10,132
$60,790
$60,790
$60,790
$60,790
$60,790
Total Operating Expense & Depre
$251292
$242,710
$248,168
$2.531789
$259,579
$265,543
_
Net Income Before Debt Service
$3,468
$102,4104
$107,300
$112,343
$117,536
$122,886
Debt Service
$0
$103,830
$123,830
$123,830
$123,830
$133,830
Net Income
$3,468
_($1,426)$16
530
$11,447)
$6 294
($10,944)
Cumulative Depreciation
$10,132
$70,922
$131,712
$192,502
$253,292
$314,082
Cumulative Profit/Loss
$3,468
$2,042
($14,488)
($25,976)
($32,269)
($43,213)
City of Rosemount, Minnesota
Ice Arena Pro -Forma
3% Escalation through 2004, No Other Income $2,100,000 Bond Issue
Operating Year
Income Escalation
1999
2000
2001
2002
2003
2004
Yr 95-04 Yr 05+
0
0
0
0
0
0
Operating Income:
0
0
0
0
0
0
Ice Time 3.00% 0.00°!0
$306,181
$315,366
$324,827
$334,572
$344,809
$354,947
Services 3.00% 0.009'0
93,901
96,718
----
99,620
102,608
105,687
108,857
Total Operating Income
$400,082
$412,084
$424,447
$437,180
--------
$450,295
$463,804
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.00%
0
0
0
0
0
0
Total tither Income
$0
- $0
- $0
$0
-- $0
$0
Total Income
$440 082
-_-_-�
$412,084
$424,447$437,184
$450,295
$463,804
Expenses Escalation
Yr 95-04 Yr 1}5+
Operating Expense:
Personnel 3.00% 3.00%
112,357
115,728
119,199
122,775
126,459
130,252
Insurance 3.00% 3.00%
11,593
11,941
12,299
12,666
13,048
13,439
Utilities 3.00% 3.000/a
75,353
77,613
79,942
82,340
84,810
87,355
Gen &Admin 3.00% 3.00%
11,593
11,941
12,299
12,668
13,048
13,439
Total Operating Expense
$210,695
$217,222
$223,739
$230,451
$237,364
$244,485
Depreciation: Cost Life
Building 1,947,000 50
38,940
38,940
38,940
38,940
38,940
38,940
Equipment 437,000 20
21,850
21,850
21,850
21,850
21,850
21,854
Total Depreciation
$60,790
$60,790
$60,790
$60,790
$60,790
$60,790
Total Operaling Expense & Depre
$271,685
$278,012
$284,529
$291,241
$298,154
$305,275
Net Income Before Debt Service
$128,397
$134,072
$139,918
$145,939
$152,141
$158,529
Debt Service
$133,380
$137,900
$147,150
$150,863
$164,288
$166,880
Net Income
($4,983)
($3 828
($7,232)($4,923)
($1g, 1461
$B,3511
Cumulative Depreciation
$374,872
$435,662
$496,452
$557,242
$518,032
$678,822
Cumulative Profit/Loss
($48,196)
($52,024)
($59,256)
($64,180)
($76,326)
($84,677)
City of Rosemount, Minnesota
Life
3% Escalation through 2004, No Other Income
$2,100,000
Bond Issue
Ice Arena Pro -Forma
0
0
Operating Year
0
0
0
Income Escalation
2005
2006
2007
2008
2009
2010
Yr95-04 Yr 051 -
0
0
0
Building Depreciation
0.00%-
0
Operating Income:
0
0
0
0
Total Other Income
Ice Time 3.00% 0.00%
$354,947
$354,947
$354,947
$354,947
$354,947
$354,947
Services 3.00% 0.00%
108,857
108,857
108,857
108,857_
108,857
108,857
Total Operating Income 1
$463,804
$463,804
$463,804
$463,804
$463,804
$463,804
Other Income:
Banquet Facility
Life
0
0
0
0
0
0
Excess Tax Increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
Net Income Before Debt Service
0
0
0
0
0
0
Building Depreciation
0.00%-
0
0
0
0
0
0
Total Other Income
$0
$Q
$0
$0
$0
$0
Total Income
$463,804
$463,804
4463,804
$463,804_
$463,804
$463,804
Expenses Escalation
Yr 95-04
Yr 05+
Operating Expense:
Personnel 3.00%
3.00%
134,160
138,185
142,330
146,600
150,998
155,528
Insurance 3.00%
3.00%
13,842
14,258
14,685
15,126
15,580
16,047
Utilities 3.00%
3.00%
89,975
92,674
95,455
98,318
101,268
104,306
Gen & Admin 3.00%
3.00%
13,642
14,258
14,685
15,126
15'sw
16,047
Total Operating Expense
$251,820
$259,374
$267,156
_
$275,170
$283,425
$291,928
Depreciation: Cost
Life
Building 1,947,000
50 38,940
38,940
Equipment 437,000
20 21,854
21,850
Tota.] Depreciation
$60,790
$60,790
Total Operating Expense & Depre
$312,610
$320,164
Net Income Before Debt Service
$151,195
$143,640
Debt Service
$174,155
$180,825
Net Income
($22,960)
($37,1851
Cumulative Depreciation
$739,612
$800,402
Cumulative Profit/Loss
($107,637)
($144,822)
38,940
21,850
$60,790
$327,946
$135,859
$186,870
-----x$51,01.
$861,192
($195,834)
38,940
21,850
$60,790
--
$127,844
$197,270
($69,426)
$921,982
($265,260)
38,940
21,850
$60,790
$344215
$119,589
$201,713
--($82:124)
$982,772
($347,383)
38,940
21,850
$60,790
$352,718
$111,086
$210,518
($99,431)
$1,043,562
($446,814)
City of Rosemount, Minnesota
Ice Arena Pro -Forma
Income Escalation 2011
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 0.00% $354,947
Services 3.00% 0.00°/0 _ 108,857
Total Operating Income $463,804
Other Income:
3% Escalation through 2004, No Other Income
Operating Year
2012 2013 2014
$354,947
108,857
$463,804
$354,947
108,857
$463,804
$354,947
108,857
$463,804
$2,100,000 Bond Issue
2015
$354,947
108,857
$463,804
2016
$354,947
108,857
$463,804
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment (Through 1999)
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.00%
0
`____ 0
0
fl
0
0
Total Other Income
$0
$0
$0
$0
$0
$0
Total income
$463,804
$463,804_
$463,804
$463,804
$463,804
$463,804
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
160,194
165,000
169,950
175,048
180,300
185,709
Insurance 3.00% 3.00%
16,528
17,024
17,535
18,061
18,603
19,161
Utilities 3.00% 3.00%
107,435
110,658
113,978
117,397
120,919
124,547
Gen & Admin 3.00% 3.00%
16,520
17,024
17,535
18,061
18,6013
14,161
Total Operating Expense
$300,686
$309,707
$318,998
$328,568
$338,425
$348,578
Depreciation: Cost Life
Building 1,947,000 50
38,940
38,940
38,940
38,940
38,940
38,940
Equipment 437,404 20
21,850
21,850
18,208
0
0
0
Total Depreciation
$60,790
$60,790
$57,148
$38,940
$38,940
$38,940
Total Operating Expense & Depre
$361,476
$370,497
$376,146
$367 508
$377,3fi5
$387,518
Net Income Before Debt Service
$102,328
$93,308
$87,658
$96,297
$86,440
$76,287
Debt Service
$218,438
$225,405
_$241,460
$2+65,980
$273,380
$269,465
_
Net tncome
($116,1091
($132,097)
_!$153,822)
($169,683)
($186,940)_
x$193 178
-
Cumulative Depreciation
$1,104,352
$1,165,142
.$1,222.290
$1,261,230
$1,300,170
$1,339,110
Cumulative Profit/Loss
($562,924)
($695,021)
($848,843)
($1,018,526)
($1,205,457)
($1,398,645)
City of Rosemount, Minnesota
Ice Arena Pro -Forma
Income Escalation
2017
Yr 95-04
Yr05+
$463,804
Operating Income:
0
0
Ice Time 3.00%
0.00%
$ 4,947
Services 3.00%
0.00%
108,857
Total Operating Income
$0
$463,804
Other Income:
Banquet Facility
0
Excess Tax Increment (Through 1999)
0
Cost Reduction Contribution
0
Building Depreciation
0.00
0
Total Other Income
- - $0
Total Income
$463,804
Expenses Escalation
Yr 95-04
Yr 05+
Operating Expense:
Personnel 3.00'0
3.00%
191,280
Insurance 3.00%
3.00%
19,736
Utilities 3.00%
3.00%
128,283
Gen & Admin 3.00%
3.W%
t9,736
Total Operating Expense
$359,035
Depreciation: Cost
Life
Building 1,947,000
50
38,940
Equipment 437,000
20
0
Total Depreciation
$38,940
Total Operating Expense $ Depre $397,975
Net Income Before Debt Service $65,829
Debt Service $259,945
Net Income ($194,11 P)
Cumulative Depreciation $1,378,050
Cumulative Profit/Loss ($1,592,760)
3% Escalation through 2004, No Other Income
Operating Year
2018 2019
$354,947
$354,947
108,85_7
108,857
$463,804
$463,804
0
0
0
0
0
0
0
0
_ $0
$0
$463,804
$463804
197,018
202,929
20,328
20,938
132,132
136,096
20,321
20.,933
$369,806
$380,900
38,940
38,940
0
0
$38,940
$38,940
$408,746
$419,840
$55,058
$43,964
$0
$0
$65,058
$43964
$1,416,990
$1,455,930
($1,537,702)
($1,493,737)
$2,100,000 Bond Issue
City of Rosemount, Minnesota
lee Arena Pro -Forma
Cap.
Interest
(7)
103,192
20,000
Net
Debt
Payabfe
(8)
0
103,830
123,830
123,830
123,830
133,830
133,380
137,900
147,150
150,863
164,288
166,880
174,155
180,825
186,870
197,270
201,713
210,518
218,438
225,405
241,480
265,980
273,380
269,465
259,945
0
Totals: 2,100,000 2,438,244 4,538,244 123,192 41415,053
Total
Levy
Mat
Interest
Principal &
Year
Year
Principal
Rate
Interest
Interest
(1)
(2)
(3)
(4)
(5)
(6)
1991
1993
0
3.10%
103,192
103,192
1992
1994
0
3.50%
123,830
123,830
1993
1995
0
3.70%
123,830
123,830
1994
1996
0
3.90%
123.830
123,830
1995
1997
0
4.20%
123,830
123,B30
1996
1998
10,000
4.50%
123,830
133,830
1997
1999
10,000
4.80%
123,380
133,380
1998
2000
15,000
5.00%
122,900
137,900
1999
2001
25,000
5.15%
122,150
147,150
2000
2002
30,000
5.2510/0
120,863
150,663
2001
2003
45,000
5.350/6
119,288
164,288
2002
2004
50,000
5.45%
116,880
166,880
2003
2005
60,000
5.55%
114,155
174,155
2004
2006
70,000
5.6596
110,82.5
180,825
2005
2007
80,000
5.75%
106,670
186,870
2006
2008
95,000
5.85%
102,270
197,270
2007
2009
105,000
5.90%
96,713
201,713
2008
2010
120,000
5.90%
90,518
210,518
2009
2011
135,000
5.95%
83,438
218,438
2010
2012
150,000
5.95%
75,405
225,405
2011
2013
175,000
6.00%
66,480
241,480
2012
2014
210,000
6.00%
55,980
265,980
2013
2015
230,000
6,050/,
43,380
273,380
2014
2016
240,000
6.050/6
29,465
269,465
2015
2017
245,000
6.10%
14,945
259,945
2016
2018
0
6.10%
0
0
Cap.
Interest
(7)
103,192
20,000
Net
Debt
Payabfe
(8)
0
103,830
123,830
123,830
123,830
133,830
133,380
137,900
147,150
150,863
164,288
166,880
174,155
180,825
186,870
197,270
201,713
210,518
218,438
225,405
241,480
265,980
273,380
269,465
259,945
0
Totals: 2,100,000 2,438,244 4,538,244 123,192 41415,053
City of Rosemount, Minnesota
Ice Arena Pro -Forma
Income Escalation 1993
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 3.0096 $22,010
Services 3.00% 3.00% 6,750
Total Operating Income $28,760
3% Escalation all years, No Cather Income
Operating Year
1994 1995 1996
$264,114
$272,037
$280,199
81,000
63,430
85,933
$345,114
_
$365,467
$366,131
$2,310,000 Bond Issue ,
1997
$2.88,604
88,511
$377,115
1998
$297,263
91,166
$388,429
Other Income:
0
0
0
0
0
0
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
0
Cost Reduction Contribution
20
0
0
0
0
0
Building Depreciation 0.00%
0
�
$0
-
$0
-
$0
$0
$0
Total Other Income
Total income
$28,766
$345,114
$355,467
$366,131
_ $377,115
$358,429
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00%
3.00%
8,077
Insurance 3.00°
3.00%
833
Uflittles 3.00%
3.00%
5,417
Gen & Admin 3.00%
3.00%
833
Total Operating Expense
$15,160
Depreciation: Cost
We
Building 2,044,000
50
6,813
Equipment 520,000
20
4,333
Total Depreciation
$11,147
Total Operating Expense & Depre
Net Income Before Debt Service $2,453
Debt Service $0
Net Income $2,453
Cumulative Depreciation $11,147
Cumulative Profit/Loss $2,453
$181,920
40,^88 0
$248,600
$96,314
$134,765
_($38 ,�§Jl-
$78,027
($35,998)
99,828
10,300
66,950
10,300
$187,378
$254,258
$101,210
102,822
10,609
68,959,
10,609
$192,999
$259,879
$106,253
$134,765
$134,765
`x$33 L55
A$28,512)
$144,907
$211,787
($69,553)
($98,066)
105,907
10,927
71,027
10,927
$198,789
40,880
26,000
$66,880
$265,669
$111,446
A,J r • yrnc
-- _L9-�
$278,667
($141,384)
109,084
11,255
73,158
11,255
$204,753
$271,£33
$116,796
$153,925
($37,129
$345,547
($178,513)
City of Rosemount, Minnesota
Ice Arena Pro- Forma
Income Escalation
Yr 95-04 Yr 05+
Operating Income:
3% Escalation all years, No Other Income
Operating Year
Ice Time 3.0096 3.009`0 $306,181
Services 3.00% 3.00% 93,901
Total Operating Income $400,082
$315,366
96,718
$412,084
2001
$324,827
_ 99,620
$424,447
��'
$334,572
102,608
$437,160
$2,310,000 Bond Issue
2003
$344,609
105,667
$450,295
2004
$354,947
108,857
$463,804
Other Income:
0
0
0
0
0
0
Banquet Facility
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
Cost Reduction Contribution
0
4
0
0
0
Building Depreciation 0.00%
0
$0
0
-
$0
--
$0
$0
$0
Total Other Income
Total Income
$400,082
$412,084
_$424 447
$437,180
$463,804_
__$_50,295
Expenses Escalation
Yr95-04 Yr05+
Operating Expense:
Personnel 3.0096 3.00%
112,357
115,728
1(9,199
122,775
126,459
13,048
130,252
13,439
Insurance 3.00% 3.00%
3.00% 3.00%
11,593
75,353
11,941
77,613
12,299
79,942
12,668
82,340
84,810
87,355
Utilities
Gen & Admin 3.00% 3.00%
11,593
11,941
12,299
$223,739
12,668
13,048
$237,364
13,439
$244,485
$230,451
$217,222
Total Operating Expense
$210,895
Depreciation: Cost Life
Building 2,044,000 50
40,880
40,880
40,880
40,880
44,880
26,000
40,880
26,000
Equipment 520,000 20
26,000
26,000
26,000
26,000
$66,880
_
$66,880
$66,880
$66,860
$66,880
$66,880
Total Depreciation
Total Operating Expense &Depre
$277,776
_$284,102
$290,619
$297,331_
$3044,244
$311,365
Net income Before Debt Service
$122,307
$127,982
$133,828
$139,849
$146,051
$152,439
Debt Service
$163,025
$171,585
$174,585
$177,268
$179,643
$186,700
{$40 718
($43,603
x$40,757)
_ �7,418�
x$33,551
{$34,261)
Net Income
Cumulative Depreciation
$412,427
$479,307
$546,187
$613,067
$679,947
$746,827
Cumulative ProfrtJLoss
($219,231)
($262,834)
($303,591)
($341,010)
($374,601)
($408,862)
4 ,
City of Rosemount, Minnesota
3% Escalation all years, No Other Income
$2,310,000
Bond Issue ,
Ice Arena Pro -Forma
Operating Year
Income Escalation
2005
2006
2007
2008
2009
2010
Yr 95-04 Yr05+
Operating Income:
Ice Time 3.00% 3.00%
$365,596
$376,563
$387,860
$399,49fi
$411, 481
$423,825
Services 3.000/ 3.00%
112,123
$477,718
115,487
$492,050
118,951
122,520
$522,016
_ 126,195
129,981
$553,807
$537,676
$506,812
Total Operating Income
Other Income:
0
0
0
0
0
0
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
Building Depreciation 0.00%
0
0
$0
0
$0
$0
$0
$0
Total Other Income
$0
Total Income
$477,718
$482,0
$x,812
$522,016
$537,676
_$5531 807
_
Expenses Escalation
Yr95-04 Yr05+
Operating Expense:
Personnel 3.00% 3.00%
134,160
138,185
142,334
146,600
150,998
155,528
Insurance 3.00% 3.00%
3.00%
13,842
69,975
14,258
92,6674
14,685
95,455
15,126
98,318
15,580
101,268
16,047
104,306
Utilities 3.00%
Gen & Admin 3.00% 3.00%
13,842
14,258
14,685
$267,156
15,126
15,580
16,047
$291,928
$283,425
$275,170
$259,374
Total Operating Expense
$251,820
Depreciation; Cost Ufe
Building 2,044,000 50
40,880
40,880
40,880
44,880
40,880
40,880
Equipment 520,000 20
26,000
26,000
26,000
$66,880
26,000
26,000
26,000
$66,880
$66,880
$66,880
$66,880
$66,880
Total Depreciation
Total Operating Expense & Depre
_ $318,700
$326,254
$334,036 _
$342,050
$358,808
__$350,305
Net Income Before Debt Service
$159,019
$165,796
$172,776
$179,966
$187,371
$194,998
Debt Service
$193,158
$203,995
$203,910
$208,448
$212,305
$210,520
Net Income
_ ($34,139)
{$38,1991
--VIAP-41 34
_x$24,934
` 15,522)
`_428,482}
Cumulative Depreciation
$813,707
$680,587
$947,467
$1,014,347
$1,081,227
$1,148,107
Cumulative Profit/Loss
($443,001)
($481,200)
($512,334)
($540,816)
($565,750)
($581,272)
City of Rosemount, Minnesota
3% Escalation all years, No Other Income
$2,310,000
Bond Issue
Ice Arena Pro- Forma
Operating Year
Income Escalation
2011
2012
2013
2014
2015
2016
Yr 95-04 Yr 05+
Operating income:
Ice Time 3.00'/u 3.00%
$436,544
$449,636
$463,125
$477,019
$491,330
$506,070
Services 3.00% 3.00%
133,881
137,897
14_2,034
146,295
150,684
155,204
Total Operating Income
$570,421
$587,533
$605,159
$623,314
$642,014
$661,274
Other Income:
0
0
0
0
0
0
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
Building Depreciation 0.00%
0
$0
0
$0
0
$0
$0
$0
$0
Total Other Income
Total Income
$570,421
_$587,_533
__$6o5
6231314
$642..014
$661,274
Expenses Escalation
Yr95-04 Yr O5+
Operating Expense:
Personnel 3.00% 3.00%
160,194
165,000
169,950
175,048
180,300
185,709
Insurance 3.00% 3.00%
3.00% 3.00%
16,528
107,435
17,024
110,658
17,535
113,978
18,061
117,397
18,603
120,919
19,161
124,547
Utilities
Gen & Admin 3.00% 3.00%
16,528
17,024
17,535
18,061
18,603
19,161
Total Operating Expense
$300,686
$309,707
$318,998
$328,568
$338,425
$348,578
Depreciation: Cost Life
Building 2,044,000 50
40,880
40,880
40,880
40,880
40,880
40,880
Equipment 520,000 20
26,000
25,000
21,667
8
0
0
$40,880
$40,880
$40,880
$62,547
$66,880
$66,880
Total Depreciation
Total Operating Expense & Depre
$367,566
$376,587
$381,544
$369,448
_ $379,305
$389,458
_
Net Income Before Debt Service
$202,855
$210,947
$223,615
$253,867
$262,709
$271,817
Debt Service
$223,440
$235,110
$235,590
$250,390
$263,690
$270,380
Net Income
_L$20,585}
x$24,1631
-$( 11,MI
_ $3 477
l x$981
$1,437
Cumulative Depreciation
$1,214,987
$1,281,867
$1,344,413
$1,385,293
$1,426,173
$1,467,053
Cumulative Profit/Loss
{$£01,857}
($626,020)
($537,995)
($634,518)
($635,500)
($634,063)
City of Rosemount, Minnesota
Ice Arena Pro -Forma
Income Escalation 2017
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 3.00% $521,252
Services 3.00% 3.00% 159,861
Total Operating Income $661,112
Other Income:
3% Escalation all years, No Other Income $2,310,000 Bond Issue
Operating Year
Banquet Facility
0
Excess Tax Increment
0
Cost Reduction Contribution
0
Building pepreclation 0,00%
0
Total Other Income
$0
Total Income
2018
$536,889
164,656
$701,546
0
0
0
0
$0
$681,112 $701,646
2019
$552,996
169,596
$722,592
0
0
0
0
$722,592
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
191,280
197,018
202,929
Insurance 300% 3.00%
19,736
20,328
20,938
Utilities 3.00% 3.00%
128,283
132,132
136,0%
Gen & Admin 3.00% 3.00%
19,736
20,328
20,938
Total Operating Expense
$359,035
$369,806
$360,900
Depreciation: Cast Life
Building 2,044,000 50
40,880
40,860
40,880
Equipment 520,040 20
Total Depreciation
0
0
0
$40,880
$40,880
$40,880
Total Operating Expense & Depre
$399,915
$410,686
$421,780
-
Net Income Before Debt Service
$281,197
$290,860
$300,812
Debt Service
$275,860
$0
$0
Net Income
$5,337
$290,860
$300,812
Cumulative Depreciation
$1,507,933
$1,548,813
$1,589,693
Cumulative Prolt/Loss
($628,725)
($337,866)
($37,054)
R 1
City of Rosemount, Minnesota
0
3% Esc thru 04, No Other Income
0
$2,310,000
Bond Issue
Ice Arena Pro -Forma
Excess Tax Increment
0
Operating Year
0
0
0
Income Escalat€on
1993
1994
1995
1996
1997
1998
Yr 95-04 Yr 05+
Building Depreciation 0.003
0
0
0
0
0
Operating Income:
Total Other Income T
$0
$0
$0
$0
$0
Ice Time 3.00% 0.00%
$22,010
$264,114
$272,037
$280,199
$288,604
$297,263
Services 3.00% 0.00%
6,750
81,000
83,430
85,933
88,511
91,166
Total Operating Income
$28,760
$345,114
$355,467
$366,131
$377,115
$388,429
Other Income:
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.003
0
0
0
0
0
0
Total Other Income T
$0
$0
$0
$0
$0
$0
Total Income
�`$28L760
$345,114
_$355,467
$3661131
__$377 115
_ $388,429
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
8,077
96,920
99,828
102,822
105,907
109,084
Insurance 3.00% 3.00%
633
10,000
10,300
10,609
10,927
11,255
Utilities 3.00% 3.00%
5,417
65,000
66,950
68,959
71,027
73,158
Gen & Admin 3.00% 3.00%
833
10,000
10,300
10,609
10,927
11,255
Total Operating Expense
$15,160
$181,920
$187,378
$192,999
$198,789
$204,753
Depreciation: Cost € ife
Building 2,044,000 50
6,813
40,880
40,880
40,880
40,880
40,880
Equipment 520,000 20
4,333
26,000
26,000
26,000
26,000
26,000
Total Depreciation
$11,147
$66,880
$66,880
$66,880
$66,880
$66,880
Total Operating Expense & Depre
$26,307
$248,800
$254,258
_ $259,879
$265,669
$271,633
Net Income Before Debt Service
$2,453
$96,314
$101,210
$106,253
$111,446
$116,796
Debt Service
$0
$134,765
$134,765
$134,765
$154,765
$153,925
Net Income
$2,453
- ($38,451
($33,555)
_ _x$28,5121
($43,319)
($37,129)
Cumulative Depreciation
$11,147
$78,027
$144,907
$211,787
$278,667
$345,547
Cumulative Profit./Loss
$2,453
($35,998)
($69,553)
($98,066)
($141,384)
($178,513)
City of Rosemount, Minnesota
3% Esc thru 04, No Other Income
$2,310,000
Bond Issue
Ice Arena Pro -Forma
Operating Year
Income Escalation
1999
2000
2001
2002
2003
2004
Yr 95-04 Yr05+
Operating Income:
ice Time 3.00°% 0.0096
$306,181
$315,366
$324,827
$334,572
$344,609
$354,947
Services 3.00% 0.00%
93,901
96,718
99,620
102,808
#05,687
108,857
Total Operating Income
$400,082
$412,084
$424,447
_
$437,184
-
$450,295
$463,804
i
Other Income:
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.04°x'6
0
0
0
v 0
0
0
Total Other Income
$0
-$0
$0
$0
$0
$0
Total Income
$400,082
$412,084.
$424,447
$437,180
$450,295
$463,804
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
112,357
115;728
119,199
122,775
126,459
130,252
Insurance 3.00% 3.00%
11,593
11,941
12,299
12,668
13,048
13,439
Utilities 3.00°% 3.00%
75,353
77,613
79,942
82,340
84,810
87,355
Gen & Admin 3.00% 3.00%
11,593
11,941
12,299
12,668
13,048
13,439
Total Operating Expense
$210,895
$217,222
$223,739
$230,451
$237,364
$244,485
Depreciation: Cost Life
Building 2,044,000 50
40,880
40,880
40,880
40,880
40,880
40,880
Equipment 520,000 20
26,000
26,000
2+6,000
26,000
26,000
26,000
Total Depreciation
$66,880
$66,880
$66,880
$66,880
$66,880
$66,880
Total Operating Expense & Depre
$277,775
$284,102
$290,619
$297,331
$304,244
$311,365
Net Income Before Debt Service
$122,307
$127,982
$133,828
$139,849
$146,051
$152,439
Debt Service
$163,025
$171,585
$174,585
$177,268
$179,643
$186,700
Net Income
($40,718)
Y($43,603)
x$44 7 7y
($37,418)
($33,591)
($34,261)
Cumulative Depreciation
$412,427
$479,307
$546,187
$613,067
$679,947
$746,827
Cumulaiive Profit/Loss
($219,231)
($262,834)
($303,591)
{$341,010}
($374,601)
($408,862)
City of Rosemount, Minnesota
3% Esc thru 04, No Other Income
$2,310,000
Bond Issue
Ice Arena Pro -Forma
Operating Year
Income Escalation
2005
2006
2007
2008
2009
2010
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 0.00°16
$354,947
$354,947
$354,947
$354,947
$364,947
$354,947
Services 3.00% 0.00%
108,857
108,857
108,857
108,857
108,857
108,857
Total Operating Income
$463,804
$463,804
$463,804
$463,804
$463,804
$463,804
Other Income:
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
0
0
0
Building Depreciation 0.00%
0
00
0
0
0
Total Other Income
$0
_
$0
_ $0
$0
$0
$0
Tota! Income
$453,804
X463,804
$463,804
_ $463,804
_$463,804
$463,804
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
134,160
138,185
142,330
146,600
150,998
155,528
Insurance 3.00% 3.00%
13,842
14,258
14,685
15,126
15,580
16,047
Utilities 3.00% 3.00°la
89,975
92,674
95,455
98,318
101,268
104,306
Gen & Admin 3.00% 3.00%
13,842
14,258
14,685
15,126
15_,580
16,047
Total Operating Expense
$251,820
$259,374
$267,156
$275,170
$283,425
$291,928
Depreciation: Cost Life
Building 2,044,000 50
40,880
40,880
40,880
40,880
40,880
40,880
Equipment 520,000 20
26,000
26,000
26,000
26,000
26,000
26,000
Total Depreciation
$66,880
$66,880
$66,880
$66,880
$6£,880
$66,880
Total Operating Expense & Depre
$318,700
$326,254
$334,036
__$342 050
$3.50,305
$358,808
Net Income Before Debt Service
$145,105
$137,550
$129,769
$121,754
$113,499
$104,996
Debt Service
$193,158
$203,995
$203,910
$208,448
$212,305
$210,520
Net Income
($48,053)
C4$ ,.
($74,141)_
CW 693
($98,8116}
_ ${ 105 524
Cumulative Depreciation
$813,707
$880,587
$947,467
$1,014,347
$1,081,227
$1,148,107
Cumuia#iveProfit/Loss
($45+6,915)
($523,360)
($597,501)
($684,195)
($783,001)
($888,524)
City of Rosemount, Minnesota
Ice Arena Pro -Forma
3% Esc thru 04, No Other Income
Operating Year
$2,310,000 Bond Issue
Income Escalation
2011
2012
2013
2014
2015
2016
Yr 95-04 Yr 05+
Operating Income:
Ice Time 3.00% 0.00%
$354,947
$354,947
$354,947
$354,947
$354,947
$354,947
Services 3,0096 0.00%
_ 108,857
108,857_
108,857
108,857
108,857
108,857
Total Operating Income
i
$463,804
$463,804
$463,804
$463,804
$463,804
$463,804
! Other Income:
Banquet Facility
0
0
0
0
0
0
Excess Tax Increment
0
0
0
0
0
0
Cost Reduction Contribution
0
0
0
D
0
0
Building Depreciation 0.00%0
0
0_
0
0
0
0
Total Other Income
-_-�$0
$0
_ $0
$0
-- $0
$0
Total Income
$463,804
$463,804
$ 53,804
$463,804
$463,804
$463,804
Expenses Escalation
Yr 95-04 Yr 05+
Operating Expense:
Personnel 3.00% 3.00%
160,194
165,000
159,950
175,048
180,300
185,709
Insurance 3.00% 3.00%
16,528
17,024
17,535
18,061
18,603
19,161
Utilities 3.00% 3,00%
107,435
110,658
113,978
117,397
120,919
124,547
Gen & Admin 3.00% 3.00%
16,528
17,024
17,535
18,061
18,603
18,161
Total Operating Expense
$300,686
$309,707
$318,998
$328,568
$338,425
$348,578
Depreciation: Cost Life
Building 2,044,000 50
40,880
40,880
40,880
40,880
40,880
40,880
Equipment 520,000 20
26,000
26,000
21,667
0
0
0
Total Depreciation
$66,880
$66,880
$62,547
$40,880
$40,880
$40,860
Total Operating Expense & Depre
$367,566
$376,587
$3811544
$369,448
$379,305
$389,456
Net Income Before Debt Service
$96,238
$87,218
$82,260
$94,357
$84,500
$74,347
Debt Service
$223,440
$235,110
$235,590
$250,390
$263,690
$270,380
Net Income
($127,202)
($147,892)
_ $153,330
($156,033)
($179,190)
_t$196,033)
Cumulative Depreciation
$1,214,987
$1,281,867
$1,344,413
$1,385,293
$1,426,173
$1,467,053
Cumulative Profit/Loss
($1,015,726)
($1,163,618)
($1,316,949)
($1,472,982)
($1,652,172)
($1,848,206)
0
City of Rosemount, Minnesota 3% Esc thru 04, No Other Income $2,310,000 Bond Issue •
Ice Arena Pro -Forma Operating Year
Income Escalation
2017
Yr 95-04
Yr 05+
Insurance
Operating Income:
3.00%
19,736
Ice Time 3.00%
0.00%
$354,947
Services 3.00%
0.00%
108,857
Totaf Operating Income
19,736
$463,804
Other Income:
$359,035
Depreciation:
Banquet Facility
Ilfe
0
Excess Tax Increment
2,044,000
0
Cost Reduction Contribution
Equipment
0
Building Depreciation
0.0011/0
0
Total Other Income
$40,880
$0
Total Income
Expenses Escalation
, Yr 95-04 Yr 05+
Operating Expense:
FAL
$354,947
108,857
$463,804
0
0
0
_ 0
$0
$463,804 $463,804
Personnel
3.00%
3.00%
191,280
Insurance
3.00%
3.00%
19,736
Utilities
3.00%
3.00%
128,283
Gen & Admin
3.00%
3.00%
19,736
Total Operating Expense
$359,035
Depreciation:
Cost
Ilfe
Building
2,044,000
50
40,880
Equipment
520,000
20
0
Total Depreciation
$40,880
Total Operating Expense & Depre $399,915
Net Income Before Debt Service $63,889
Debt Service
$275,860
Net Income
$211 9711
Cumulative Depreciation
$1,507,933
Cumulative Profit/Loss
($2,060,176)
197,018
20,328
132,132
20,328
$53,118
$0
$53,118
$1,548,813
($2,007,058)
2019
$354,947
108,857
� $463,804
0
0
0
0
$463,504
;yc:r err
m,e
$421,780
$42,024
$0-
_$12.024_
$1,589,693
($1,9$5,033)
City of Hosemount, Minnesota
Ice Arena Pro -Forma
Total
Net
Levy
Mat
Interest
Principal &
Cap.
Debt
Year
Year
Principal
Rate
Interest
Interest
Interest
Payable
(i)
(2)
(3)
(4)
(5)
(6)
(7)
(8)
1991
1993
0
3.10%
112,304
112,304
112,304
0
1992
1994
0
3.506
134,765
134,765
134,765
1993
1995
0
3.70%
134,765
134,765
134,765
1994
1996
0
3.900/0
134,765
134,765
134,765
1995
1997
20,000
4.20%
134,765
154,765
154,765
1996
1998
20,000
4.50%
133,925
153,925
153,925
1997
1999
30,000
4.80%
133,025
163,025
163,025
1998
2000
40,000
5.00%
131,585
171,585
171,585
1999
2001
45,000
5.15%
129,585
174,585
174,585
2000
2002
50,000
5.25%
127,268
177,269
17-7,268
2001
2003
55,000.
5.35%
124,M
179,643
179,643
2002
2004
65,000
5.45$6
121,700
186,700
166,700
2003
2005
75,000
5.55%
118,158
193,158
193,158
2004
2006
90,000
5.65%
113,995
203,995
203,995
2005
2007
95,000
5.75%
108,910
203,910
203,910
2006
2008
105,000
5.85%
103,448
208,448
208,448
2007
2009
115,000
5.90%
97,305
212,305
212,305
2008
2010
120,000
5.90%
90,520
210,520
210,520
2009
2011
140,000
5.95%
83,440
223,440
223,440
2010
2012
160,000
5.95%
75,110
235,110
235,110
2011
2013
170,000
6.00%
65,590
235,590
235,590
2012
2014
195,000
6.00%
55,390
250,390
250,390
2013
2015
220,000
6.05%
43,690
263,690
263,690
2014
2016
240,000
6.05%
30,380
270,380
270,380
2015
2017
260,000
5.10%
15,860
275,860
275,860
2016
2018
^_ 0
6.10%
0
0
0
_
Totals:
2,310,000
2,554,889
4,664,869
112,304
4,752,585