Hotel Business Plan - Interactive Model

Model Inputs

Property

Hotel Name

Number of Rooms

Financial Year

Revenue Drivers

Average Daily Rate (ADR)

€

Average Occupancy

65%

Other Revenue (% of Room Rev)

F&B / Restaurant

Extras (minibar, upsells, late checkout)

F&B Cost of Goods (%)

35%

Fixed Costs (Monthly)

Rent

€

Marketing

€

Management Fees

€

Software / PMS

€

Maintenance

€

Other Fixed Costs

€

Variable Costs

Avg Length of Stay (nights)

Cleaning per Reservation

€

Laundry & Toiletries per Res.

€

Utilities per Reservation

€

Platform Commission

15%

Staff & Tax

Annual Staff Cost

€

Corporate Tax Rate

12.5%

Multi-Year & Owner

Annual ADR Growth (%)

Annual Occ Growth (pp)

Annual Cost Inflation (%)

Projection Years

Owner Investment

€

Mgmt Fee to Urbanica (% of Rev)

15%

Total Revenue

RevPAR

GOP

Net Income

Blended ADR

Weighted annual average

Avg Occupancy

After seasonality

Total Room Nights

EBITDA Margin

Break-Even Analysis

Monthly Revenue & Occupancy

Monthly P&L

Cost Structure

Monthly ADR (Seasonal)

Profit & Loss Statement

Scenario Comparison: Conservative vs Base vs Optimistic

Scenario Revenue & Net Income Comparison

Multi-Year Projections

Revenue & Net Income Trajectory

Owner Net Income (Year 1)

Payback Period

On initial investment

5-Year ROI

Cash Yield (Year 1)

Annual return on investment

Urbanica Mgmt Fee

Cumulative Cash Flow (5yr)

Owner P&L (After Management Fee)

Owner Cumulative Cash Flow vs Investment

Sensitivity Matrix: Net Income by ADR & Occupancy

Blue-bordered cell = current input values. Green = profit, Red = loss.

Urbanica Hotel Business Plan