| Strategic Capital Partners |
| Franchise Comparison |
| | Existing | | | Westin | | Hilton | | Marriott | | Calculation Requirmement |
| Market Share Index |
| Occupancy | 82.30 | | | 109.0 | | 107.0 | | 108.0 |
| ADR | 96.80 | | | 115.0 | | 106.0 | | 110.0 |
| Revpar | 82.30 | | | 125.4 | | 113.4 | | 119 |
| Hotel Financial Report - Prior Year |
| Available Rooms | 146,000 |
| Occupancy | 70% | | | | | | | | | Calculate new occupancy at the brand benchmark |
| Occupied Rooms | 102,200 | | | | | | | | | Calculate new occupied rooms |
| ADR | $ 165.00 | | | | | | | | | Calculate new ADR at the brand benchmark |
| RevPar | $ 115.50 | | | | | | | | | Calculate new RevPar (Occupancy % X ADR) |
| Revenue |
| Room Revenue | $ 16,863,000 | 65.0% | | | | | | | | Calculate room revenue (RevPar X Available Room Nights) |
| F&B | $ 7,782,923 | 30.0% | | | | | | | | Calculate on a per room occupied basis for existing, apply to new occupied room nights |
| Other | $ 1,297,154 | 5.0% | | | | | | | | Calculate on a per room occupied basis for existing, apply to new occupied room nights |
| Total | $ 25,943,077 | 100.0% |
| Departmental Profit |
| Rooms | $ 12,647,250 | 75% | | | | | | | | Use Existing Profit % for revised revenue |
| F&B | $ 2,334,877 | 30% | | | | | | | | Use Existing Profit % for revised revenue |
| Other | $ 1,102,581 | 85% | | | | | | | | Use Existing Profit % for revised revenue |
| Total | $ 16,084,708 | 62% | | | | | | | | Calculate (Total Departmental Profit divided by Total Revenue) |
| Undistributed Expenses |
| Adminstrative | $ 1,556,585 | 6.0% | | | | | | | | Use Existing cost %, apply against total revenue |
| Sales and Marketing | $ 1,297,154 | 5.0% | | | | | | | | Use Existing cost %, apply against total revenue |
| Repairs and Maintenance | $ 908,008 | 3.5% | | | | | | | | Use Existing cost %, apply against total revenue |
| Energy Expense | $ 518,862 | 2.0% | | | | | | | | Use Existing cost %, apply against total revenue |
| Total Undistributed Expenses | $ 4,280,608 | 16.5% | | | | | | | | Calculate (Total Undistributed Expense divided by Total Revenue) |
| Franchise Related Fees |
| Franchise Royalty Fee | $ 843,150 | 3.3% | | | 6% Rooms | | 5.5% Rooms | | 6% Rooms | Apply % to revised room revenue |
| Sales and Marketing Fee | $ 252,945 | 1.0% | | | 2% Rooms | | 2.5% Rooms | | 2% Rooms | Apply % to revised room revenue |
| Reservations Expense | $ 337,260 | 1.3% | | | $5.65 POR | | $4.95 POR | | 0.8% Rooms | Apply $ POR or % of room revenue |
| Frequency Program Fee | $ 389,146 | 1.5% | | | 1.5% Total | | 1.7% Total | | 1.8% Total | Apply % to Total Revenue |
| Total Franchise Related Fees | $ 1,822,501 | 7.0% |
| Gross Operating Profit | $ 9,981,599 | 38.5% | | | | | | | | Calculate based on revised costs. |
| FFE Reserve | $ 1,297,154 | 5.0% | | | 5% | | 6% | | 5% |
| Initial Supplies | | | | $ 55,000 |
| Other Fees |
| Training | | | | $ 10,500 |
| Guest Response | | | | $ 25,000 |
| Product Improvement Plan | | | | $ 3,500,000 | | $ 3,200,000 | | $ 3,000,000 |
| Net Benefit Year 1 | | | | | | | | | | Variance to Existing Franchise |
| Variance in FFE Reserve | | | | | | | | | | Variance to Existing Franchise |
| Intial Supplies | | | | | | | | | | Above |
| Fees | | | | | | | | | | Above |
| PIP | | | | | | | | | | Above |
| Net Benefit | | | | | | | | | | Subtract incremental cash cost from incremental profit |
wzy19961214
FranchiseAnalysisData.xlsx
