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

EXCEL文档

IMPORTANT NOTE 重要提示Lease Assumptions租赁项目Unit of Measurement计量单位Length of Term 合同年限Number of YearsLength of Term合同月数Number of MonthsGross Space 建筑面积M 2Rooms 房间数量NumberRoom Size 房间面积M 2Non-Room Space 非房间面积百分比% of Total SpaceNon-Room Space 非房间面积M 21400Year of Lease 年份Rent/M2/Day单位面积日租金RmbInitial 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,400Renovation & Acquisition Assumptions 改造项目Renovation Description 改造项目Conversion/GreenfieldBuilding Type Description (if conversion)建筑类型(办公室、住宅、仓库、酒店、其他)Office/Dormitory/Warehouse/Hotel/OtherRestaurant included in renovation?含餐厅否?Yes/NoDeposit 几个月的租金作为定金?Number of MonthsRenovation Time (Net of Grace Period)改造时间Number of MonthsTotal Renovation Time 总改造时间Number of MonthsGrace Period 免租期Number of MonthsMonths in Operation Y1第一年付租月Number of Months Initial Renovaton Cost per Room 间房初装费Rmb Total Initial Renovation Cost 初装费总计RmbInitial Renovation Amortization Period 初装费用分摊期(N 年)Number of YearsSecond Renovation Timing 二装时间(第N 年)Year in Agreement Second Renovation Cost per Room 间房二装费Rmb Second Renovation Total Cost 二装费总计RmbSecond Renovation Amortization Period 二装费用分摊期(N 年)Number of YearsThird Renovation Timing 三装时间(第N 年)Year in Agreement Third Renovation Cost per Room 间房三装费Rmb Third Renovation Total Cost 三装费总计RmbThird Renovation Amortization Period 三装费用分摊期(N 年)Number of YearsAcquisition Cost (Gross)转让费(总额)Total RmbProperty 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 costsPersonnel Costs 人力成本项目Training Costs - Y1培训费(第一年)Rmb ¥30,000Training Costs - Ongoing (Annual)培训费-持续(年度)Rmb ¥12,000Build-out Staff Headcount 筹建人员数量Headcount 1Average Build-out Monthly Salary+Benefits 筹建人员(项目经理)月薪(工资+福利)Rmb per Month¥3,000General Manager Monthly Salary+Benefits 总经理月薪(工资+福利)Rmb ¥5,000OnGoing Management Staffing 管理人员人数Headcount 4Average Manager Salary+Benefits per Month 管理人员平均月薪(工资+福利)Rmb¥3,000Management Bonus per Year 管理人员年度奖金% of Management Salary5%Total Management Personnel Cost per Year 管理人员年成本RmbHousekeeping/Maintenance Staffing per Room 人员房间比例Headcount per Room Housekeeping/Maintenance Staff 客房/维保员工人数Total Headcount FF&E Reserve 预提费用百分比% of RevenueAverage 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 Expenses5.0%Tax Rate 税率%Minority Interest 小股东权益%Restaurant Costs (Assume Operate Restaurant)Total Restaurant and Kitchen Space 餐厅厨房总面积M 2Percent of Non-Room Space 餐厅占非房间面积百分比%Renovation Time 餐厅改造占用时间MonthsInitial Renovaton Cost per M 2餐厅每平米初装费Rmb Total Initial Renovation Cost 餐厅初装费总计RmbInitial Renovation Amortization Period 餐厅初装费用分摊期(N 年)Number of YearsSecond Renovation Timing 餐厅二装时间(第N 年)Year in AgreementSecond Renovaton Cost per M 2餐厅每平米二装费Rmb Total Second Renovation Cost 餐厅二装费总计RmbSecond Renovation Amortization Period 餐厅二装费用分摊期(N 年)Number of YearsThird Renovation Timing 餐厅三装时间(第N 年)Year in Agreement Third Renovaton Cost per M 2餐厅每平米三装费Rmb Total Third Renovation Cost 餐厅三装费总计RmbThird Renovation Amortization Period 餐厅三装费用分摊期(N 年)Year in AgreementYear in Agreement/合同执行期Y2Y3Y4Y5Y6Negotiated per Breakfast Restaurant Fee 协商的早餐单价Rmb ¥0.00¥0.00¥0.00¥0.00¥0.00Total Breakfasts per Year 度总费用Number 20,52033,87736,92536,92536,92536,925Annual Restaurant Use Fees 年度总费用Rmb¥0¥0¥0¥0¥0¥0Financial Assumptions 财务费用Year in Agreement/合同执行期Inflation Assumption 上涨幅度%¥138,700¥1,664,400Y7714Y7¥0.00 36,925¥0。

相关主题