当前位置:文档之家› EXCEL文档

EXCEL文档

EXCEL文档
EXCEL文档

IMPORTANT NOTE 重要提示

Lease Assumptions

租赁项目Unit of Measurement

计量单位

Length of Term 合同年限

Number of Years

Length of Term

合同月数Number of Months

Gross Space 建筑面积

M 2

Rooms 房间数量Number

Room Size 房间面积

M 2

Non-Room Space 非房间面积百分比% of Total Space

Non-Room Space 非房间面积

M 2

1400Year of Lease 年份

Rent/M2/Day

单位面积日租金Rmb

Initial Exchange Rate 兑换率Rmb/USD Rent/M2/Day 单位面积日租金(美元)

USD Total Monthly Rent 月租金Rmb ¥138,700¥138,700¥138,700¥138,700¥138,700¥138,700Total Annual Rent 年租金

Rmb

¥1,664,400¥1,664,400¥1,664,400¥1,664,400¥1,664,400¥1,664,400

Renovation & Acquisition Assumptions 改造项目

Renovation Description 改造项目Conversion/Greenfield

Building Type Description (if conversion)建筑类型(办公室、住宅、仓库、酒店、其他)Office/Dormitory/Warehouse/Hotel/Other

Restaurant included in renovation?含餐厅否?Yes/No

Deposit 几个月的租金作为定金?Number of Months

Renovation Time (Net of Grace Period)改造时间Number of Months

Total Renovation Time 总改造时间Number of Months

Grace Period 免租期Number of Months

Months in Operation Y1第一年付租月Number of Months Initial Renovaton Cost per Room 间房初装费Rmb Total Initial Renovation Cost 初装费总计Rmb

Initial Renovation Amortization Period 初装费用分摊期(N 年)Number of Years

Second Renovation Timing 二装时间(第N 年)Year in Agreement Second Renovation Cost per Room 间房二装费Rmb Second Renovation Total Cost 二装费总计Rmb

Second Renovation Amortization Period 二装费用分摊期(N 年)Number of Years

Third Renovation Timing 三装时间(第N 年)Year in Agreement Third Renovation Cost per Room 间房三装费Rmb Third Renovation Total Cost 三装费总计Rmb

Third Renovation Amortization Period 三装费用分摊期(N 年)Number of Years

Acquisition Cost (Gross)转让费(总额)Total Rmb

Property Life 租赁期Total Lease plus Option Term (Years)

Fees Assumptions 费用项目

Year in Agreement/合同执行期

Application Fee to S8 China/交给速8的申请费Rmb Initial Fee to S8 China/交给速8的加盟费

Rmb Conversion credit/转换奖励Rmb Development incentive/发展激励

Rmb Agent Fees and Commissions/中介费用及佣金

Rmb Number of installment pmts of Initial Fee/加盟费分期支付年限

Number Fees to Wyndham-- %/交给温德姆的百分比% of Revenue Continuing Operating Fees-- %/续生咨询费百分比

% of Revenue Mkt and Tech fees-- %/续生运营费百分比

% of Revenue Other Fees/其他费用

% of Revenue Hotel Management fees 酒店管理费

% of Revenue Year of Lease 租赁年份Sequential Years Remaining 剩余租期

Reverse Sequential Affects only OPEX costs

Personnel Costs 人力成本项目Training Costs - Y1培训费(第一年)

Rmb ¥30,000Training Costs - Ongoing (Annual)培训费-持续(年度)

Rmb ¥12,000

Build-out Staff Headcount 筹建人员数量

Headcount 1Average Build-out Monthly Salary+Benefits 筹建人员(项目经理)月薪(工资+福利)

Rmb per Month

¥3,000General Manager Monthly Salary+Benefits 总经理月薪(工资+福利)

Rmb ¥5,000

OnGoing Management Staffing 管理人员人数

Headcount 4Average Manager Salary+Benefits per Month 管理人员平均月薪(工资+福利)

Rmb

¥3,000

Management Bonus per Year 管理人员年度奖金

% of Management Salary

5%

Total Management Personnel Cost per Year 管理人员年成本Rmb

Housekeeping/Maintenance Staffing per Room 人员房间比例

Headcount per Room Housekeeping/Maintenance Staff 客房/维保员工人数

Total Headcount FF&E Reserve 预提费用百分比

% of Revenue

Average Housekeeping/Management Salary+Benefits per Month 客房

/维保员工平均月薪(工资+福利)

Rmb Total Non-Management Personnel Costs per Year 非管理人力成本总额

Rmb Total Labor Cost per Year 年人力成本Rmb Salary Inflation per Year 工资上涨幅度

%

OPEX Margins (does not include 2.0% management fee)营运毛利(不包括2%管理费)

Other On-Going Cost Assumptions 其他-运营成本

Utilities (electricity, water, heating, property management)能耗(电,水,暖,物管)

Rmb/Occupied Room/Day

¥25.00Laundry Costs per Occupied Room per Day 占用房/间/夜的洗衣成本Rmb

¥5.00Amenities - Cost per Occupied Room per Day 占用房/间/夜的低耗品成本

% of Pre-Fee Revenue 1.00%Telephone and Communication Costs per Year 年通讯联络费用

% of Pre-Fee Revenue ¥8.00Local Marketing Expenses per Year 年本地市场推广费

% of Pre-Fee Revenue 1.50%Travel and Entertainment 差旅招待费

% of Pre-Fee Revenue 0.50%Hotel Operators Insurance - Year 1酒店运营保险费-第一年

Rmb per Room per Year

¥200Other Ongoing Maintenance Cost 其他持续维护成本

Rmb/M 2/Month ¥3.00Business Tax 营业税

% of Gross Revenue 5.5%Cost Inflation 运营成本上涨幅度Annual % Inflation 0.0%Cost Contingency 其他附加成本

% of Operating Expenses

5.0%Tax Rate 税率

%Minority Interest 小股东权益

%

Restaurant Costs (Assume Operate Restaurant)Total Restaurant and Kitchen Space 餐厅厨房总面积M 2Percent of Non-Room Space 餐厅占非房间面积百分比%

Renovation Time 餐厅改造占用时间Months

Initial Renovaton Cost per M 2

餐厅每平米初装费Rmb Total Initial Renovation Cost 餐厅初装费总计Rmb

Initial Renovation Amortization Period 餐厅初装费用分摊期(N 年)Number of Years

Second Renovation Timing 餐厅二装时间(第N 年)Year in Agreement

Second Renovaton Cost per M 2

餐厅每平米二装费Rmb Total Second Renovation Cost 餐厅二装费总计Rmb

Second Renovation Amortization Period 餐厅二装费用分摊期(N 年)Number of Years

Third Renovation Timing 餐厅三装时间(第N 年)Year in Agreement Third Renovaton Cost per M 2餐厅每平米三装费Rmb Total Third Renovation Cost 餐厅三装费总计Rmb

Third Renovation Amortization Period 餐厅三装费用分摊期(N 年)Year in Agreement

Year in Agreement/合同执行期

Y2Y3Y4Y5Y6Negotiated per Breakfast Restaurant Fee 协商的早餐单价Rmb ¥0.00¥0.00¥0.00¥0.00¥0.00Total Breakfasts per Year 度总费用Number 20,520

33,877

36,925

36,925

36,925

36,925

Annual Restaurant Use Fees 年度总费用

Rmb

¥0

¥0

¥0

¥0

¥0

¥0

Financial Assumptions 财务费用

Year in Agreement/合同执行期

Inflation Assumption 上涨幅度%

¥138,700¥1,664,400

Y7

7

14

Y7¥0.00 36,925

¥0

相关主题
文本预览
相关文档 最新文档