|
Proforma 4104
<br />NI
<br />City of Ramsey, MN l��L44
<br />Janney
<br />February
<br />Match
<br />Apt
<br />Mar
<br />.Iuly
<br />..At I
<br />September
<br />Octobec
<br />November
<br />December
<br />TOTAL
<br />Lodging Rooms Available
<br />1,860
<br />1,680
<br />1,860
<br />1,800
<br />1,860
<br />_Lune
<br />1,800
<br />1,860
<br />1,860
<br />1,800
<br />1,860
<br />1,800
<br />1,860
<br />21,900
<br />LodpngOccupancy %
<br />43.5%
<br />44.2%
<br />. 48.4%
<br />57,5%
<br />58.1%
<br />65.0%
<br />65.3%
<br />65.3%
<br />625%
<br />58.1%
<br />425%
<br />375%
<br />54.0%
<br />Total Oce Rooms -
<br />810
<br />743 •
<br />900
<br />1,035
<br />1,080
<br />1,170.
<br />1,215
<br />1,215
<br />1,125
<br />1,080
<br />765
<br />698
<br />11,835
<br />Average Daly Rate
<br />397.85
<br />$98.80
<br />5101.65
<br />$110.20
<br />111020
<br />511210
<br />$113.05
<br />$113.05
<br />1107.35
<br />$10450
<br />$99.75
<br />. 595.00
<br />$106.40
<br />Revenue Per Available Room 99EVPA8C)
<br />942.61
<br />543.67
<br />$49.19
<br />563.37
<br />563.99
<br />$7287
<br />$73.85
<br />573.85
<br />567.09
<br />$60.68
<br />34239
<br />335.63
<br />557.50
<br />REVENUE:
<br />Guest Rooms
<br />79,259
<br />73,359
<br />91,485
<br />114,057
<br />119,016
<br />131,157
<br />137,356
<br />137,356
<br />120,769
<br />112,860
<br />76,309
<br />66,263
<br />1,259,244
<br />F&BRevenue
<br />8,100
<br />7,425
<br />9,000
<br />10,350 -
<br />10,800
<br />11,700
<br />12,150
<br />12,150
<br />11,250
<br />10,80U
<br />7,650
<br />6,975
<br />118350
<br />Vending Revenue
<br />2,025
<br />1856
<br />2,250
<br />2,588
<br />2,700
<br />2,925
<br />3,038
<br />3,038
<br />2,813
<br />2,700
<br />1,913
<br />1,744
<br />29,588
<br />TOTAL HOTEL REVENUE
<br />89,384
<br />82,640
<br />102,735
<br />126,995
<br />132,516
<br />145,782
<br />152543
<br />152,543
<br />134,831
<br />126,360
<br />85,871
<br />74,981
<br />1,407,182
<br />HOTEL PAYROLL EXPENSE •
<br />Hotel Manager
<br />5,833
<br />5,833 '
<br />5,833
<br />5,833
<br />5,833
<br />5,833
<br />5,833
<br />5,833
<br />5,833
<br />5,833
<br />5,833
<br />• 5103
<br />70,000
<br />AstManager/Saks6lanager
<br />4,167
<br />4,167
<br />4,167
<br />4,167
<br />4,167
<br />4,167 '
<br />4,167
<br />4,167
<br />4,167
<br />4,167
<br />4,167
<br />4,167
<br />50,000
<br />Housekeeping
<br />. 4,455
<br />4,084
<br />4.950
<br />5,693
<br />5,940
<br />6,435
<br />6,683
<br />6,683
<br />6,188
<br />5,940
<br />4,208
<br />3,836
<br />65,093
<br />Maintenance
<br />793
<br />734
<br />915
<br />1,141
<br />• 1,190
<br />1,312
<br />1,374
<br />1,374
<br />1208
<br />1,129
<br />763'
<br />663
<br />12,592
<br />Front Desk
<br />3.963
<br />3,668
<br />4,574
<br />5,703
<br />5,951
<br />6,558
<br />6,868
<br />6,868
<br />6,038
<br />5,643
<br />3,815
<br />3,313
<br />62,962
<br />1050 5taf8mg
<br />4,455
<br />4,084 -
<br />4,950
<br />5,693
<br />5,940
<br />6,435
<br />* 6,683
<br />6,683
<br />6,188
<br />5,940
<br />4,208
<br />3,836
<br />65,093
<br />Breakfast/Social
<br />1,585
<br />1,467
<br />1,830
<br />2,281
<br />2,380
<br />2,623
<br />2,747'
<br />2,747
<br />2,415
<br />2,257
<br />1,525
<br />1,325
<br />25,185
<br />Workers Comp Insurance
<br />631
<br />601
<br />680
<br />763
<br />785
<br />834
<br />859
<br />859
<br />801
<br />773
<br />613
<br />574
<br />8,773
<br />Payroll Tax
<br />3,156
<br />3,005
<br />3,402
<br />3,814
<br />3,925 '
<br />'4,170
<br />4,294
<br />4,294
<br />4,605
<br />3,864
<br />3,065
<br />2,872
<br />43,866
<br />TOTAL HOTEL PAYROLL -
<br />29,038
<br />27,642
<br />31,302
<br />35,086
<br />36,111
<br />38,367
<br />39,506
<br />39,506
<br />36,842
<br />35,545
<br />28,198
<br />26,420
<br />403,563
<br />HOTEL OPERATING EXPENSE
<br />Cleaning Supplies
<br />405
<br />371
<br />450
<br />518
<br />540
<br />585
<br />608
<br />608.
<br />563
<br />540'
<br />383
<br />349
<br />5,918
<br />Laundry Supplies .
<br />608
<br />557
<br />675
<br />776
<br />810
<br />878
<br />911
<br />911
<br />844
<br />810.
<br />574
<br />523
<br />8,876
<br />Linens .
<br />810 -
<br />743
<br />900
<br />1,035
<br />1,080
<br />1,170
<br />1,215
<br />1,215
<br />1,125
<br />1,080
<br />765
<br />698
<br />11,835
<br />Guest Supplies
<br />1,013
<br />928
<br />1,125
<br />1,294
<br />1,350
<br />1,463
<br />1,519
<br />1,519
<br />1,406
<br />1,350
<br />956
<br />872 '
<br />14,794
<br />Operating Supplies
<br />689
<br />631
<br />765
<br />880
<br />918
<br />995
<br />1,033
<br />1,033
<br />956
<br />918
<br />650
<br />593
<br />10,060
<br />Uniforms Expense
<br />648
<br />594
<br />720
<br />828
<br />864
<br />936
<br />972
<br />' 972
<br />900
<br />864
<br />612
<br />558
<br />9,468
<br />Repairs & Maintenance
<br />396
<br />367
<br />457
<br />570
<br />595
<br />656
<br />687
<br />687
<br />604
<br />564
<br />382
<br />331
<br />6,296
<br />Swimming Pool
<br />' 1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />12,500
<br />Groum1s/Landscapin8
<br />750
<br />1,000
<br />1,000
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />750 '
<br />7,500
<br />Franchise Pee
<br />5;115
<br />4,620
<br />5,115
<br />4,950
<br />5,115
<br />4,950
<br />5,115
<br />5,115
<br />•4,950
<br />5,115
<br />4,950
<br />5,115
<br />60,275
<br />Training Expense
<br />417
<br />417
<br />417
<br />417
<br />417
<br />417
<br />417
<br />417
<br />417
<br />417
<br />417
<br />'417
<br />• 5,000
<br />Property MM,nt System Expense
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />5,160
<br />Complimentary Breakfast
<br />3,210
<br />2,970
<br />3,600
<br />4,140
<br />4,320
<br />4,680
<br />4,860
<br />4,860
<br />4,500
<br />4.320
<br />- 3,060
<br />2,790
<br />47,340
<br />TrapelAgent Fees
<br />1,981
<br />1,834
<br />2,287
<br />2851
<br />2,975
<br />3,279
<br />3,434
<br />3,434
<br />3,019
<br />2,822
<br />1,908
<br />1,657
<br />31,481
<br />Reservations Expense
<br />750 '
<br />. 750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />9,000
<br />F&B Expenses
<br />4,050
<br />3,713
<br />4,500
<br />_ 5,175
<br />5,400
<br />5,850
<br />6.075
<br />6.075
<br />5,625
<br />5,400
<br />3,825
<br />3,488
<br />59.175
<br />Vending Expense
<br />1,013
<br />928
<br />1,125
<br />1,294
<br />1,350
<br />1,463
<br />1,519
<br />1,519
<br />1,406
<br />1,350
<br />956
<br />872
<br />14,794
<br />Marketing/Advertising
<br />793
<br />. 734
<br />915
<br />1,141
<br />1,190
<br />1,312 '
<br />1374
<br />. 1,374 '
<br />1,208
<br />1,129
<br />763
<br />663
<br />12592
<br />U006,,
<br />6,257
<br />5,785
<br />7,191
<br />8.890
<br />9,276
<br />10,205
<br />10,678
<br />10,678
<br />9,438
<br />8,845
<br />6,011
<br />5,249
<br />98,503
<br />Cable/1nternet/Phone
<br />4.650
<br />4,650
<br />4,650
<br />4,650
<br />' 4,650
<br />4,650
<br />4,650
<br />4,650
<br />4,650
<br />4,650
<br />4,650
<br />' 4,650
<br />55,800
<br />Credit Cud Expense
<br />2,011
<br />1,859
<br />2,312
<br />2,857
<br />' 2,982
<br />3,280
<br />3,432
<br />3,432
<br />3,034
<br />' 2.843
<br />1,932
<br />1,687
<br />31,662
<br />Management Fee
<br />' 5,363
<br />4,958
<br />6,164
<br />7,620
<br />7,951
<br />8.747
<br />9,153
<br />9,153
<br />8,090 .
<br />7,582
<br />5,152
<br />4,499
<br />84,431
<br />Other Rapense/Frequent Stay
<br />' 203
<br />186 .
<br />225
<br />259
<br />270
<br />293
<br />304
<br />304
<br />281
<br />270
<br />191
<br />174
<br />2,959
<br />Accounting Services
<br />400 .
<br />400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />4,800
<br />TOTAL OPERATING EXPENSES •
<br />43,031
<br />40,465
<br />47,215 .
<br />53,265 -
<br />55,175
<br />58,927 .
<br />61,075
<br />61,075
<br />56,137
<br />53,990
<br />41,258
<br />38,554
<br />610,168
<br />Income Before Fixed Expenses
<br />17,314
<br />14533
<br />24,219
<br />38,643
<br />41,230
<br />48.488
<br />51,962
<br />51,962
<br />41,852
<br />36,825
<br />16,415
<br />10,007
<br />393,451
<br />Gross Operating Profit(GOP)
<br />1937%
<br />17.59%
<br />23.57%
<br />30.43%
<br />31.11%
<br />33.26w/
<br />34.06%
<br />34.06%
<br />31.04%
<br />29.14%
<br />19.12%
<br />1335%
<br />27.96%
<br />RESERVES & FIXED EXPENSES
<br />Debt Service
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />412,732
<br />Real Estate Taxes (Estimates)
<br />9,347 -
<br />9,347
<br />9.347
<br />9,347
<br />9.347
<br />9,347
<br />9,347
<br />9,347
<br />9.347
<br />9,347
<br />' 9,347
<br />9,347
<br />112,161
<br />Insurance
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />25,200
<br />Reserves For Replacement
<br />894
<br />826
<br />1,027
<br />1,270
<br />1,325
<br />1,458
<br />1,525
<br />1525
<br />1,348
<br />1,264
<br />859
<br />750
<br />14,072
<br />TOTAL RESERVES&FIXED
<br />46,735
<br />46,668
<br />46,868
<br />47,111
<br />47,166
<br />47,299
<br />47.367
<br />47.367
<br />47.189
<br />47,105
<br />46,700
<br />46591
<br />564,165
<br />NET OPERATING INCOME (N01)
<br />4,973
<br />2,260
<br />11,744
<br />25,927
<br />28,458
<br />35,584
<br />38,989
<br />38,989
<br />29,057
<br />24,115
<br />4,110
<br />(2,189)
<br />242,018
<br />NET CASH FLOW
<br />(29,421)
<br />(32,134)
<br />(22,65(1)
<br />(8,468)
<br />. (5,936)
<br />1,189
<br />4,595
<br />4,595
<br />15,337)
<br />(10 2:9)
<br />(30,2351
<br />(36584)
<br />(170,715)
<br />NOTE The Acre ;animation u a forwards lathing memono[.ncipo,d emte^'a and pm6n ddt ngad to flair proj ct bond en the p,ofcumn,l experience of Core Dhrincto, Group LLC (COG) participation in other'aro'Ica% lima. in nature Occupancy ad ADR pgau,n, derived
<br />(rim mutat data nand. =ported by Snails Truth tRescurrh th111) in the markets proxinny ®alia, to than nu throttling of Ind ard surrurnAnghoutr.TIth irrojuuthan thattet damage due to changernthe «oemnJ,troth billyand o. , the threpunce or the project bythe bell community
<br />wd pavans And the fenthd COG by rot teen;, 4d in•par*/inthin .r.Aadn.wuevp0,ywuh shoe dvnegre030, in the path 31eaby,dl in... and . 6mwkdxe that therehrwv,d taok'o,gp,Re000. arc notwarranted by COG and an Athirst moch,.t. and
<br />6uwaton
<br />'.a; Core Distinction Group, LT C
<br />2 12/28/2019
<br />
|