EXCEL文档

3.50% 3.80% 1.80% 0.00% 6 15
Affects only OPEX costs
Personnel Costs人力成本项目 Training Costs - Y1培训费(第一年) Training Costs - Ongoing (Annual)培训费-持续(年度) Build-out Staff Headcount筹建人员数量 Average Build-out Monthly Salary+Benefits筹建人员(项目经理)月薪(工资+福利) General Manager Monthly Salary+Benefits总经理月薪(工资+福利) OnGoing Management Staffing管理人员人数 Average Manager Salary+Benefits per Month管理人员平均月薪(工资+福利) Management Bonus per Year管理人员年度奖金 Total Management Personnel Cost per Year管理人员年成本 Housekeeping/Maintenance Staffing per Room人员房间比例 Housekeeping/Maintenance Staff客房/维保员工人数 FF&E Reserve预提费用百分比 Average Housekeeping/Management Salary+Benefits per Month 客房 /维保员工平均月薪(工资+福利) Total Non-Management Personnel Costs per Year非管理人力成本总额 Total Labor Cost per Year年人力成本 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)能耗(电,水,暖,物管) Laundry Costs per Occupied Room per Day占用房/间/夜的洗衣成本 Amenities - Cost per Occupied Room per Day占用房/间/夜的低耗品成本 Telephone and Communication Costs per Year年通讯联络费用 Local Marketing Expenses per Year年本地市场推广费 Travel and Entertainment差旅招待费 Hotel Operators Insurance - Year 1酒店运营保险费-第一年 Other Ongoing Maintenance Cost其他持续维护成本 Business Tax营业税 Cost Inflation运营成本上涨幅度 Cost Contingency其他附加成本 Tax Rate税率 Minority Interest小股东权益
2.00%
3.00%
4.00%
4.00%
4.00%
Rmb/Occupied Room/Day Rmb % of Pre-Fee Revenue % of Pre-Fee Revenue % of Pre-Fee Revenue % of Pre-Fee Revenue Rmb per Room per Year Rmb/M2/Month % of Gross Revenue Annual % Inflation % of Operating Expenses % %
￥25.00 ￥5.00 1.00% ￥8.00 1.50% 0.50% ￥200 ￥3.00 5.5% 0.0% 5.0% 25% 0%
NOTE: IF RESTAURANT IS NOT INCLUDED IN THE OPERATION, DO NOT CHANGE ANY VALUES IN THIS SECTION 备注:若餐厅非自营项目,以下区域数字切勿改动 Restaurant Costs (Assume Operate Restaurant) Total Restaurant and Kitchen Space餐厅厨房总面积 M2 Percent of Non-Room Space餐厅占非房间面积百分比 % Renovation Time餐厅改造占用时间 Months Initial Renovaton Cost per M2餐厅每平米初装费 Rmb Total Initial Renovation Cost餐厅初装费总计 Rmb Initial Renovation Amortization Period餐厅初装费用分摊期(N年) Number of Years Second Renovation Timing餐厅二装时间(第N年) Year in Agreement 2 Second Renovaton Cost per M 餐厅每平米二装费 Rmb Total Second Renovation Cost餐厅二装费总计 Rmb Second Renovation Amortization Period餐厅二装费用分摊期(N年) Number of Years Third Renovation Timing餐厅三装时间(第N年) Year in Agreement 2 Third Renovaton Cost per M 餐厅每平米三装费 Rmb Total Third Renovation Cost餐厅三装费总计 Rmb Third Renovation Amortization Period餐厅三装费用分摊期(N年) Year in Agreement
Conversion Office No 0 4 4 0 8 ￥20,000 ￥2,400,000 8 9 ￥30,000 ￥3,600,000 7 16 ￥20,000 ￥2,400,000 5 ￥5,000,000 20 Y1 Y2 Y3 Y4 Y5 ￥0 ￥0 ￥0 ￥0 ￥0 1 3.00% 3.50% 3.50% 3.50% 3.50% 3.80% 3.80% 3.80% 3.80% 3.80% 0.00% 0.00% 1.80% 1.80% 1.80% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Note: US Super 8 Avg is 6%/美国速8的平均比例为6% 1 2 3 4 5 20 19 18 17 16 0% -10% 10% Y6
IMPORTANT NOTE重要提示:
Only Change Values or Labels in Cells with border and yellow shading, do NOT change any other cells 仅就表格内黄色区域进行填写，其他部分切勿更改
百度文库
Hotel Type Type A: Direct Lease Ops Hotel Name S8 Hotel Example Property
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费用项目 Application Fee to S8 China/交给速8的申请费 Initial Fee to S8 China/交给速8的加盟费 Conversion credit/转换奖励 Development incentive/发展激励 Agent Fees and Commissions/中介费用及佣金 Number of installment pmts of Initial Fee/加盟费分期支付年限 Fees to Wyndham-- %/交给温德姆的百分比 Continuing Operating Fees-- %/续生咨询费百分比 Mkt and Tech fees-- %/续生运营费百分比 Other Fees/其他费用 Hotel Management fees酒店管理费 Year of Lease租赁年份 Years Remaining剩余租期 Cost Scenario Trigger 成本状况测试 Year in Agreement/合同执行期 Rmb Rmb Rmb Rmb Rmb Number % of Revenue % of Revenue % of Revenue % of Revenue % of Revenue Sequential Reverse Sequential Base Case (Input 0)水平状况 Upside Case (Input 1)上升状况 Downside Case (Input 2)下降状况
Rmb Rmb Headcount Rmb per Month Rmb Headcount Rmb % of Management Salary Rmb Headcount per Room Total Headcount % of Revenue Rmb Rmb Rmb %
￥30,000 ￥12,000 1 ￥3,000 ￥5,000 4 ￥3,000 5% ￥221,850 0.280 34 0.00% ￥900 ￥362,880 ￥584,730 7% 35%
Lease Assumptions租赁项目 Length of Term合同年限 Length of Term合同月数 Gross Space建筑面积 Rooms房间数量 Room Size房间面积 Non-Room Space非房间面积百分比 Non-Room Space非房间面积 Year of Lease年份 Rent/M2/Day单位面积日租金 Initial Exchange Rate兑换率 Rent/M2/Day单位面积日租金(美元) Total Monthly Rent月租金 Total Annual Rent年租金 Unit of Measurement计量单位 Number of Years Number of Months M2 Number M2 % of Total Space M2 Rmb Rmb/USD USD Rmb Rmb 20 240 3,800 120 20 36.84% 1400 Y1 Y2 Y3 Y4 Y5 Y6 ￥1.200 ￥1.200 ￥1.200 ￥1.200 ￥1.200 ￥1.200 6.900 $0.17391 ￥138,700 ￥138,700 ￥138,700 ￥138,700 ￥138,700 ￥138,700 ￥1,664,400 ￥1,664,400 ￥1,664,400 ￥1,664,400 ￥1,664,400 ￥1,664,400