Ytd Comparison Financial Statement

Download as pdf or txt
Download as pdf or txt
You are on page 1of 9
At a glance
Powered by AI
The financial statement provides a year-to-date comparison of revenue, expenses, and profits between the current period (December 1, 2006 - December 31, 2006) and the same period last year for a Hampton Inn property. The document compares line items such as room revenue, total revenue, payroll expenses, other operating expenses, and capital expenses.

Room revenue increased by $70,307.08 or 3.85% compared to last year. Total revenue also increased, by $61,897.61 or 3.45% compared to last year.

Total payroll and related expenses increased by $13,551.26 or 0.75% compared to last year. While some individual payroll expense line items increased, others decreased.

Company: Hari Group LLC - dba Hampton Inn

YTD Comparison Financial Statement


Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Revenues
Room Revenue
Meeting Room
Telephone
Other Income

Total Revenue

Cost of Sales
Cost of Meeting Room
Cost of Telephone
Cost of Other Income
Total Cost of Sales
Gross Hotel Profit

Payroll and Related


Room Payroll
A&G Payroll
A&SP Payroll
Maintenance Payroll

Total Payroll and Related


Other Departmental
Rooms Other
Meeting Room Other
Telephone Other
A&G Other
A&SP Other
Maintenance Other
Energy Other

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

1,743,900.12
11,612.25
2,945.03
8,779.30

1,673,593.04
7,385.05
4,786.42
19,574.58

70,307.08
4,227.20
-1,841.39
-10,795.28

85.19
0.57
0.14
0.43

81.34
0.36
0.23
0.95

3.85
0.21
-0.09
-0.52

0.00
0.08
0.01

1,767,236.70

1,705,339.09

61,897.61

86.33

82.88

0.00
19,155.19
300.63

0.00
17,625.65
120.55

0.00
1,529.54
180.08

0.00
0.94
0.01

0.00
0.86
0.01

19,455.82

17,746.20

1,709.62

0.95

3.45

0.86

0.09

0.27
0.36
0.06
0.06

1,747,780.88

1,687,592.89

60,187.99

85.38

82.02

265,584.94
65,752.84
1,266.53
21,630.72

261,454.58
58,758.66
0.00
20,470.53

4,130.36
6,994.18
1,266.53
1,160.19

12.97
3.21
0.06
1.06

12.71
2.86
0.00
0.99

3.36

354,235.03

340,683.77

13,551.26

17.30

16.56

0.75

217,094.37
3,730.67
5,478.62
136,345.44
50,915.45
15,334.37
93,626.10

201,847.26
1,891.32
5,686.06
128,867.70
44,337.19
16,679.34
90,499.35

15,247.11
1,839.35
-207.44
7,477.74
6,578.26
-1,344.97
3,126.75

10.61
0.18
0.27
6.66
2.49
0.75
4.57

9.81
0.09
0.28
6.26
2.15
0.81
4.40

0.80
0.09
-0.01
0.40
0.33
-0.06
0.18

40.36

2.47

Total Other Expenses

522,525.02

489,808.22

32,716.80

25.53

23.80

Income Before Capital


GOP %

871,020.83
49.29%

857,100.90
50.26%

13,919.93
-0.97%

42.55
0.00%

41.66
0.00%

0.89
0.00%

262,727.03

-48,790.33

10.45

12.77

-2.32

291,053.62

-12,165.09

14.15

-0.52

Total Departmental

Capital Expenses
Net Income

Principal Payments
Depreciation & Amortization
Net Cash

876,760.05

657,084.13
213,936.70
-142,588.17
207,540.00

278,888.53

830,491.99

594,373.87
-179,213.41
207,540.00

46,268.06

62,710.26

36,625.24
0.00

42.83

32.10
-6.97
10.14

13.62

28.89
-8.71
10.09

1.72

3.21

1.74
0.05

Page 1 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Rooms Department
Revenue
Room Revenue

Total Room Revenue

Payroll and Related


Salaries & Wages - Rooms
Salaries & Wages - Front Desk
Salaries & Wages Salaries & Wages - Laundry
Salaries & Wages - Houseman
Salaries & Wages - Breakfast
Salaries & Wages - Inhouse
Vacation & Holiday Pay - Rooms
Payroll Taxes & Emp Benefits Total Rooms Payroll &

Other Expenses
Advertising - Rooms
Allowances
Cable Television
Carpet Cleaning
Charge Backs
Cleaning Expense
Complimentary Breakfast
Contract Labor Services
Decorations
Entertainment - Rooms
Furnishings - Rooms
Guest Supplies
House Laundry
In-Room Coffee
Laundry Supplies
Linen - Housekeeping
Miscellaneous - Rooms
Newspapers
Office Expense - Rooms
Printing, Postage & Stationary Reservation Expense
Shuttle Service
Travel Agent Commission
Travel - Rooms
Uniforms

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

1,743,900.12

1,673,593.04

70,307.08

85.19

81.34

3.85

1,743,900.12

1,673,593.04

70,307.08

85.19

81.34

3.85

45,968.71
68,802.81
82,726.24
7,290.11
544.44
25,149.85
0.00
0.00
35,102.78

265,584.94

37,214.17
76,390.36
94,720.50
11,115.84
0.00
16,087.30
0.00
0.00
25,926.41

261,454.58

8,754.54
-7,587.55
-11,994.26
-3,825.73
544.44
9,062.55
0.00
0.00
9,176.37
4,130.36

2.25
3.36
4.04
0.36
0.03
1.23
0.00
0.00
1.71

12.97

1.81
3.71
4.60
0.54
0.00
0.78
0.00
0.00
1.26

12.71

0.44
-0.35
-0.56
-0.18
0.03
0.45
0.00
0.00
0.45

1,548.96
39.00
10,657.82
0.00
1,044.69
689.41
54,902.16
0.00
0.00
78.48
842.64
12,399.96
0.00
1,551.89
4,086.82
19,166.12
-964.93
1,714.59
606.80
101.20
85,288.23
0.00
22,455.38
0.00
885.15

2,279.70
-864.60
10,244.08
0.00
377.23
307.79
54,448.10
1,440.00
0.00
394.83
173.69
15,205.01
0.00
950.92
3,697.32
8,849.88
125.35
2,509.98
71.76
79.77
79,540.60
0.00
19,815.08
0.00
2,200.77

-730.74
903.60
413.74
0.00
667.46
381.62
454.06
-1,440.00
0.00
-316.35
668.95
-2,805.05
0.00
600.97
389.50
10,316.24
-1,090.28
-795.39
535.04
21.43
5,747.63
0.00
2,640.30
0.00
-1,315.62

0.08
0.00
0.52
0.00
0.05
0.03
2.68
0.00
0.00
0.00
0.04
0.61
0.00
0.08
0.20
0.94
-0.05
0.08
0.03
0.00
4.17
0.00
1.10
0.00
0.04

0.11
-0.04
0.50
0.00
0.02
0.02
2.65
0.07
0.00
0.02
0.01
0.74
0.00
0.05
0.18
0.43
0.01
0.12
0.00
0.00
3.87
0.00
0.96
0.00
0.11

-0.04
0.04
0.02
0.00
0.03
0.02
0.04
-0.07
0.00
-0.02
0.03
-0.13
0.00
0.03
0.02
0.51
-0.05
-0.04
0.03
0.00
0.30
0.00
0.13
0.00
-0.06

0.27

Total Rooms Other Expenses

217,094.37

201,847.26

15,247.11

10.61

Total Rooms Departmental

482,679.31

463,301.84

19,377.47

23.58

22.52

1.06

1,261,220.81

1,210,291.20

50,929.61

61.61

58.82

2.79

Rooms Departmental Income

9.81

0.80

Page 2 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Rooms Available

Rooms Occupied

Occupancy Percentage
Average Daily Rate
Rev PAR

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

27,375

27,375

20,471.00

20,576.00

-105.00

85.19

81.34

3.85

74.78%

63.70

75.16%

61.14

1.00

1.00

0.00

-0.38%

0.00%

0.00%

0.00%

2.57

0.00

0.00

0.00

0.00

0.00

0.00

Front Desk Labor %

3.95%

4.56%

-0.61%

0.00%

0.00%

0.00%

Laundry Labor %

0.42%

0.66%

-0.24%

0.00%

0.00%

0.00%

Housekeeping Labor %
Houseman Labor %

Breakfast Staff Labor %


Total Payroll Labor %

Total Contract Labor %


Management Fee %

4.74%
0.03%
1.44%

5.66%
0.00%
0.96%

20.04%

19.98%

2.38%

2.46%

0.00%

0.08%

-0.92%
0.03%
0.48%

0.00%
0.00%
0.00%

0.00%
0.00%
0.00%

0.00%
0.00%
0.00%

0.06%

0.00%

0.00%

0.00%

-0.08%

0.00%

0.00%

0.00%

-0.08%

0.00%

0.00%

0.00%

Page 3 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

90.00
0.00
11,498.50
23.75

0.00
0.00
7,085.00
300.05

90.00
0.00
4,413.50
-276.30

0.00
0.00
0.56
0.00

0.00
0.00
0.34
0.01

0.00
0.00
0.22
-0.01

0.00
0.00
0.00

Meeting Room

Revenues
Banquet Sales
Banquet Food - Outside Caterer
Meeting Room Rental
Equipment Rental
Total Meeting Revenue
Cost
Cost
Cost
Cost

of
of
of
of

Sales
Food Sold
Food - Catering
Other Goods Sold

Total Cost of Food Sales


Gross Meeting Profit
Other Operating Expenses
Banquet Expense
Bar Supplies
Carpet Cleaning - F&B
Decorations - F&B
Linen Expense
Office Expense - F&B
Printing, Postage & Stationary -

11,612.25

7,385.05

4,227.20

0.57

0.36

0.00
0.00
0.00

0.00
0.00
0.00

0.00
0.00
0.00

0.00
0.00
0.00

0.00
0.00
0.00

0.21

0.00

0.00

0.00

0.00

0.00

0.00

11,612.25

7,385.05

4,227.20

0.57

0.36

0.21

65.57
0.00
0.00
0.00
3,665.10
0.00
0.00

60.79
0.00
0.00
0.00
1,830.53
0.00
0.00

4.78
0.00
0.00
0.00
1,834.57
0.00
0.00

0.00
0.00
0.00
0.00
0.18
0.00
0.00

0.00
0.00
0.00
0.00
0.09
0.00
0.00

0.00
0.00
0.00
0.00
0.09
0.00
0.00

Total Meeting Other

3,730.67

1,891.32

1,839.35

0.18

0.09

0.09

Total Meeting Departmental

3,730.67

1,891.32

1,839.35

0.18

0.09

0.09

Meeting Departmental

7,881.58

5,493.73

2,387.85

0.39

0.27

0.12

Page 4 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Telephone Department
Revenue
Long Distance
Commissions - Telephone

Total Telephone Revenue


Cost of Sales
C/S of Long Distance
C/S Local

Total Cost of Phone Sales


Gross Phone Profit

Other Operating Expenses


Equipment Rent
High Speed Internet
Maintenance Contracts
Other Expenses

Total Phone Other Expenses


Phone Departmental Profit

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

2,945.03
0.00

4,786.42
0.00

-1,841.39
0.00

0.14
0.00

0.23
0.00

-0.09
0.00

2,945.03

4,786.42

-1,841.39

0.14

0.23

-0.09

718.16
18,437.03

459.00
17,166.65

259.16
1,270.38

0.04
0.90

0.02
0.83

0.01
0.07

19,155.19

17,625.65

1,529.54

0.94

0.86

0.08

-16,210.16

-12,839.23

-3,370.93

-0.79

-0.62

-0.17

64.31
4,787.29
0.00
627.02

1,961.24
3,327.50
0.00
397.32

-1,896.93
1,459.79
0.00
229.70

0.00
0.23
0.00
0.03

0.10
0.16
0.00
0.02

-0.09
0.07
0.00
0.01

-21,688.78

-18,525.29

-3,163.49

174.41
3,318.20
212.66
2,907.59
0.00
0.00
2,166.44

152.56
3,563.31
121.58
13,515.91
0.00
0.00
2,221.22

21.85
-245.11
91.08
-10,608.32
0.00
0.00
-54.78

5,478.62

5,686.06

-207.44

0.27

-1.06

0.28

-0.90

-0.01

0.01
0.16
0.01
0.14
0.00
0.00
0.11

0.01
0.17
0.01
0.66
0.00
0.00
0.11

0.00
-0.01
0.00
-0.51
0.00
0.00
0.00

-0.16

Other Income

Revenues
Commissions - Vending
Guest Laundry
Interest Income
Miscellaneous Income
Movie Revenue
Pantry Shop Revenue
Sales Tax Commissions
Total Other Income

Other Cost of Sales


Guest Laundry Expense
Cost of Movie Rentals
Cost of Pantry Shop Supplies
Total Other Cost of Sales

Other Income Depatmental

8,779.30

19,574.58

-10,795.28

0.43

0.95

-0.52

300.63
0.00
0.00

120.55
0.00
0.00

180.08
0.00
0.00

0.01
0.00
0.00

0.01
0.00
0.00

0.01
0.00
0.00

300.63

8,478.67

120.55

19,454.03

180.08

-10,975.36

0.01
0.41

0.01
0.95

0.01

-0.53

Page 5 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

53,716.20
0.00
0.00
12,036.64

65,752.84

45,693.88
0.00
0.00
13,064.78

58,758.66

8,022.32
0.00
0.00
-1,028.14
6,994.18

2.62
0.00
0.00
0.59

3.21

2.22
0.00
0.00
0.64

2.86

0.40
0.00
0.00
-0.05

0.00
-123.45
39,621.35
0.00
100.00
298.47
230.42
0.00
69,764.59
0.00
199.00
3,830.38
78.48
0.00
4,953.37
1,225.00
557.34
13,150.97
0.00
365.81
669.78
242.22
1,181.71

0.00
267.92
41,452.06
210.00
725.00
108.13
167.07
344.84
67,020.85
0.00
238.80
2,279.50
106.79
0.00
4,331.65
1,100.00
787.96
5,425.23
0.00
405.65
677.39
1,945.18
1,273.68

0.00
-391.37
-1,830.71
-210.00
-625.00
190.34
63.35
-344.84
2,743.74
0.00
-39.80
1,550.88
-28.31
0.00
621.72
125.00
-230.62
7,725.74
0.00
-39.84
-7.61
-1,702.96
-91.97

0.00
-0.01
1.94
0.00
0.00
0.01
0.01
0.00
3.41
0.00
0.01
0.19
0.00
0.00
0.24
0.06
0.03
0.64
0.00
0.02
0.03
0.01
0.06

0.00
0.01
2.01
0.01
0.04
0.01
0.01
0.02
3.26
0.00
0.01
0.11
0.01
0.00
0.21
0.05
0.04
0.26
0.00
0.02
0.03
0.09
0.06

0.00
-0.02
-0.08
-0.01
-0.03
0.01
0.00
-0.02
0.15
0.00
0.00
0.08
0.00
0.00
0.03
0.01
-0.01
0.38
0.00
0.00
0.00
-0.08
0.00

187,626.36

14,471.92

9.87

9.12

0.75

Administration & General

Payroll & Related


Salaries & Wages - A&G
Bonus & Incentives - A&G
Vacation & Holiday Pay - A&G
Payroll Taxes & Emp Benefits -

Total A&G Payroll & Related

Other Operating Expenses


Bad Debt Expense
Cashier (Over) / Short
Credit Card Commissions
Directory Advertising
Donations
Dues & Subscription
Entertainment - A&G
Equipment Rental
Franchise Fees
Insurance - General
Internal Communications
Licenses and Taxes
Manager's Reception
Miscellaneous - A&G
Office Expense - A&G
Personnel Expense
Printing, Postage & Stationary Professional Fees
Provision for Doubtful Accounts
Security Service
Telephone - A&G
Training
Travel - A&G
Total A&G Other Expenses

A&G Departmental Expenses

136,345.44
202,098.28

128,867.70

7,477.74

6.66

6.26

0.36

0.40

Page 6 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

1,112.86
0.00
153.67

0.00
0.00
0.00

1,112.86
0.00
153.67

0.05
0.00
0.01

0.00
0.00
0.00

0.05
0.00
0.01

499.00
0.00
736.20
0.00
0.00
3.07
2,427.51
8,400.00
0.00
36,208.44
2,355.04
0.00
286.19
0.00

511.71
0.00
436.75
0.00
0.00
0.00
0.00
7,800.00
0.00
35,487.45
101.28
0.00
0.00
0.00

-12.71
0.00
299.45
0.00
0.00
3.07
2,427.51
600.00
0.00
720.99
2,253.76
0.00
286.19
0.00

0.02
0.00
0.04
0.00
0.00
0.00
0.12
0.41
0.00
1.77
0.12
0.00
0.01
0.00

0.02
0.00
0.02
0.00
0.00
0.00
0.00
0.38
0.00
1.72
0.00
0.00
0.00
0.00

0.00
0.00
0.01
0.00
0.00
0.00
0.12
0.03
0.00
0.04
0.11
0.00
0.01
0.00

Advertising & Sales

Payroll & Related


Salaries and Wages - Sales
Vacation & Holiday Pay - A&SP
Payroll Taxes & Emp Benefits Total A&SP Payroll & Related

Other Operating Expenses


Advertising - A&SP
Dues & Subscriptions - A&SP
Entertainment - A&SP
Fruit Baskets
Magazines and Newspaper
Marketing Expense
Office Expense - A&SP
Outdoor Advertising
Printing, Postage, & Stationary Priority Club
Signs
Special Promotions
Telephone - A&SP
Travel - A&SP
Total A&SP Other Expenses
Total A&SP Departmental

1,266.53

50,915.45
50,915.45

0.00

44,337.19
44,337.19

1,266.53

6,578.26
6,578.26

0.06

2.49
2.49

0.00

2.15
2.15

0.06

0.33
0.33

Page 7 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Repairs & Maintenance

Payroll & Related Expenses


Salaries & Wages - Maintenance
Vacation & Holiday Pay Payroll Taxes & Emp Benefits Total Maintenance Payroll &
Other Operating Expenses
A/C and Heating
Building
Electrical Equipment
Elevators
Extermination
Floor Covering
Furnishings - Maintenance
Grounds And Landscaping
Ice Machines
Laundry Equipment
Maintenance Contracts
Office Expense - Maintenance
Paint and Wall Covering
Plumbing
Pool
Refrigeration Equipment
Televisions
Tools and Supplies
Uniforms - Maintenance
Total Maintenance Other

Maintenance Departmental
Energy Department
Other Departmental
Electric Bulbs
Electric Current
Fire Protection
Fuel - Gas
Removal of Waste
Sewer Service
Water

Total Energy Expense

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

19,683.16
0.00
1,947.56

18,621.37
0.00
1,849.16

1,061.79
0.00
98.40

0.96
0.00
0.10

0.91
0.00
0.09

0.06
0.00
0.01

21,630.72

20,470.53

1,160.19

1.06

0.99

0.06

1,608.49
0.00
1,704.89
3,170.00
1,575.53
10.57
83.64
234.89
1,167.76
1,078.09
0.00
0.00
111.33
3,596.17
290.40
0.00
433.46
269.15
0.00

314.10
3,950.00
499.84
4,157.30
939.00
0.00
0.00
1,306.24
150.00
1,053.12
0.00
0.00
59.01
3,215.18
962.61
0.00
0.00
72.94
0.00

1,294.39
-3,950.00
1,205.05
-987.30
636.53
10.57
83.64
-1,071.35
1,017.76
24.97
0.00
0.00
52.32
380.99
-672.21
0.00
433.46
196.21
0.00

0.08
0.00
0.08
0.15
0.08
0.00
0.00
0.01
0.06
0.05
0.00
0.00
0.01
0.18
0.01
0.00
0.02
0.01
0.00

0.02
0.19
0.02
0.20
0.05
0.00
0.00
0.06
0.01
0.05
0.00
0.00
0.00
0.16
0.05
0.00
0.00
0.00
0.00

0.06
-0.19
0.06
-0.05
0.03
0.00
0.00
-0.05
0.05
0.00
0.00
0.00
0.00
0.02
-0.03
0.00
0.02
0.01
0.00

15,334.37

16,679.34

-1,344.97

0.75

0.81

-0.06

1,376.67
49,021.51
3,820.72
13,131.26
1,817.39
12,823.76
11,634.79

1,343.90
46,883.79
4,410.06
13,609.05
1,366.92
11,492.00
11,393.63

32.77
2,137.72
-589.34
-477.79
450.47
1,331.76
241.16

0.07
2.39
0.19
0.64
0.09
0.63
0.57

0.07
2.28
0.21
0.66
0.07
0.56
0.55

0.00
0.12
-0.03
-0.02
0.02
0.07
0.01

36,965.09

93,626.10

37,149.87

90,499.35

-184.78

3,126.75

1.81

4.57

1.81

4.40

0.00

0.18

Page 8 of 9

Company: Hari Group LLC - dba Hampton Inn


YTD Comparison Financial Statement
Period from 12/1/2006 to 12/31/2006
Year from 1/1/2006 to 12/31/2006
Item

Capital Expenses

Amortization - Franchise Fee


Depreciation
Insurance
Interest
Land Rent
Non-Capital Lease Payments
Ownership Purchasing
Property Taxes
Supervisory Fees
Supervisory Fees - Additional
Total Capital Expenses

Property: Hampton Inn

YTD

YTD Last Year

Variance

YTD POR

YTD Last Year


POR

Variance

8,676.00
198,864.00
29,250.66
349,104.39
0.00
0.00
0.00
29,189.08
42,000.00
0.00

8,676.00
198,864.00
23,624.62
292,072.49
0.00
0.00
0.00
29,136.76
42,000.00
0.00

0.00
0.00
5,626.04
57,031.90
0.00
0.00
0.00
52.32
0.00
0.00

0.42
9.71
1.43
17.05
0.00
0.00
0.00
1.43
2.05
0.00

0.42
9.66
1.15
14.19
0.00
0.00
0.00
1.42
2.04
0.00

0.00
0.05
0.28
2.86
0.00
0.00
0.00
0.01
0.01
0.00

657,084.13

594,373.87

62,710.26

32.10

28.89

3.21

Page 9 of 9

You might also like