Case1Excel

Case1Excel - Rosewood Hotels & Resorts Individual...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Rosewood Hotels & Resorts Individual Corporate Branding Branding Remarks Source 2003 Total number of unique guests 115,000 115,000 Exhibit 8 Average daily spend $750.00 $750.00 Growth? 6% Exhibit 8 Number of days average guests stays 2 2 Exhibit 8 Average gross margin per room 32% 32% Exhibit 8 Average number of visits per year per guest 1.2 1.3 Exhibit 8 Average marketing expense per guest $130 $138.70 Growth? 3% Exhibit 8 Average new guest acquisition expense $150 $150 Exhibit 8 Total number of repeat guests 19,169 24,919 Calculate of which: Total number of multiproperty stay guests 5,750 11,500 Calculate Additional costs required per annum n.a. 1,000,000 Page 6 Discount rate 8% 8% Exhibit 8 Average guest retention rate 16.67% 21.67% Calculate
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Rosewood Hotels & Resorts CLTV Calculation with Individual Brand Strategy 2003 2004 2005 2006 2007 2008 2009 Number of nights per stay n.a. 2.0 2.0 2.0 2.0 2.0 2.0 Number of stays per guest n.a. 1.2 1.2 1.2 1.2 1.2 1.2 Revenue per night n.a. $795
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/11/2012 for the course FIN FIN4345 taught by Professor Koij during the Fall '10 term at FIU.

Page1 / 2

Case1Excel - Rosewood Hotels & Resorts Individual...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online