Financial Data for Rosewood

Financial Data for Rosewood Hotel and Resorts

Particulars

Without Rosewood

Corporate Branding

(2003)

With Rosewood

Corporate Branding

Total Number of unique guests

115000.00

115000

Average daily spend

750.00

750

Number of days average guests

stays

2.00

2

Average gross margin per room

32%

32%

Average Number of visits per year

per guest

1.20

1.3

Average Marketing expense per

guest

$130.00

138.70

Average new guests acquistation

expense

150.00

150

Total number of repeat guest

19169.00

24919

Of which: Total number of

multiproperty stay guests

5750.00

11500

Average Guest Retantion Rate

16.67%

21.67%

576.00

624.00

Average Gross Profit Per Customer

CLTV Calculation Without Rosewood Corporate Branding

Year

Number of

days average

guests stays

Average

Number of

visits per

year per

guest

Average

daily spend

Revenue per

Customer

Gross Profit

per

Customer

Less Average

new guests

acquistation

expense

Less Average

Marketing

expense per

guest

Net Profit

Per Guest

Probability

of Being

Retained

Expected

Cash Flow

from

Customer

Discount

Factor

NPV of

Expected

Cash Flow

from

Customer

Total NPV of

CLTV

2003

2004

2005

2006

2007

2008

2009

2.0

2.0

2.0

2.0

2.0

2.0

2.0

1.2

1.2

1.2

1.2

1.2

1.2

1.2

$750.00

$795.00

$842.70

$893.26

$946.86

$1,003.67

$1,063.89

$1,800.00

$1,908.00

$2,022.48

$2,143.83

$2,272.46

$2,408.81

$2,553.33

$610.56

$647.19

$686.03

$727.19

$770.82

$817.07

6% increase per

year

$150 will not be

deducted in other

years as new guests

are not been added

($150.00)

($138.70)

($142.86)

($147.14)

($151.56)

($156.10)

($160.79)

($150.00)

$749.26

$790.05

$833.17

$878.74

$926.92

$977.85

1.00

1.00

0.17

0.03

0.00

0.00

0.00

($150.00)...