咖啡厅财务分析表格推荐下载.xlsx

咖啡厅财务分析表格推荐下载.xlsx

《咖啡厅财务分析表格推荐下载.xlsx》由会员分享，可在线阅读，更多相关《咖啡厅财务分析表格推荐下载.xlsx（8页珍藏版）》请在冰豆网上搜索。

单单门门店店资资本本家家投投入入（万万元元）OneSingleStoreSet-upCosts（EURO）公公司司创创办办费费公司执照，证明，证书1SettingupthebusinessBusinessregistration,licences,legalexpense1,250公司网站，软件开发5Website6,250商业计划书2Businessplan2,500小计8sum10,000交交付付总总部部加加盟盟金金及及保保证证金金加盟金80FranchisefeesanddepositfeeFranchisefees100,000小计80sum100,000设设备备装装修修费费装修40PlantandequipmentDecoration50,000设备60Equipment75,000办公设备3Office3,750小计103sum128,750前前期期运运营营费费广告宣传30StartingOperationsAdvertisingandPromotion37,500半年货存（含进出口货运，物流，存储，包装）150Start-upinventory187,500半年房租75Advancerent（6months）93,750半年物业管理费9Advancerentpropertymanagementfee（6months）11,250半年员工工资30Employeessalaries（6months）37,500半年管理人员人工福利15Managerssalaries（6months）18,750小计309sum386,250总总计计500Total625,000半年存货需要150万？

@#@主要包括哪些？

@#@因为很多搞点都是难以保存的，现买的单单店店销销售售收收入入和和销销售售税税金金及及附附加加估估算算表表（万万元元）第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年咖咖啡啡饮饮料料咖啡收入255.50332.15398.58478.30573.96688.75日销售额0.700.911.091.311.571.89日销售量200260312374449539营业天数365.00365.00365.00365.00365.00365.00均价35.0035.0035.0035.0035.0035.00糕糕点点系系列列糕点收入328.50427.05512.46614.95737.94885.53日销售额0.901.171.401.682.022.43日销售量200260312374449539营业天数365.00365.00365.00365.00365.00365.00均价45.0045.0045.0045.0045.0045.00下下午午茶茶套套餐餐简餐收入547.50711.75854.101024.921229.901475.88日销售额1.501.952.342.813.374.04日销售量50657894112135营业天数365.00365.00365.00365.00365.00365.00均价300.00300.00300.00300.00300.00300.00礼礼品品系系列列礼品收入146.00189.80227.76273.31327.97393.57日销售额0.400.520.620.750.901.08日销售量202631374554营业天数365.00365.00365.00365.00365.00365.00均价200.00200.00200.00200.00200.00200.00酒酒水水酒水收入146.00189.80227.76273.31327.97393.57日销售额0.400.520.620.750.901.08日销售量50657894112135营业天数365.00365.00365.00365.00365.00365.00均价80.0080.0080.0080.0080.0080.00销销售售总总收收入入1423.501850.552220.662664.793197.753837.30日日销销售售总总额额3.905.076.087.308.7610.51增增值值税税85.41111.03133.24159.89191.87230.24城城市市维维护护建建设设费费5.987.779.3311.1913.4316.12教教育育费费附附加加2.563.334.004.805.766.91地地方方教教育育费费附附加加1.712.222.663.203.844.60销销售售税税金金及及附附加加10.2513.3215.9919.1923.0227.63咖啡收入256332399糕点收入329427512简餐收入548712854礼品收入146190228酒水收入146190228合合计计1,4241,8512,221咖啡收入18%18%18%糕点收入23%23%23%简餐收入38%38%38%礼品收入10%10%10%酒水收入10%10%10%合合计计100%100%100%最最近近好好像像增增值值税税率率降降了了？

@#@确确认认一一下下?

@#@4785746896157388861,0251,2301,4762733283942733283942,6653,1983,83718%18%18%23%23%23%38%38%38%10%10%10%10%10%10%100%100%100%单单门门店店员员工工年年工工资资开开销销第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年岗位人数月工资水平（税前工资+公司应缴税）总经理120,91223,00325,30427,83430,61733,67920,91223,00325,30427,834财务212,78014,05815,46417,01018,71120,5826,3907,0297,7328,505行政16,3907,0297,7328,5059,35610,2916,3907,0297,7328,505营销114,20015,62017,18218,90020,79022,86914,20015,62017,18218,900店长114,20015,62017,18218,90020,79022,86914,20015,62017,18218,900厨房222,72024,99227,49130,24033,26436,59111,36012,49613,74615,120收银28,5209,37210,30911,34012,47413,7224,2604,6865,1555,670咖啡师425,56028,11630,92834,02037,42241,1656,3907,0297,7328,505服务员8+1055,16860,68566,75373,42980,77188,8496,8967,5868,3449,179清洁工22,5002,7503,0253,3283,6604,0261,2501,3751,5131,664月月工工资资合合计计182,950201,245221,370243,506267,857294,643年年工工资资合合计计2,195,4002,414,9402,656,4342,922,0773,214,2853,535,714所所有有门门店店员员工工年年工工资资开开销销第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年合合计计2,195,4004,610,3407,266,77410,188,85113,403,13716,938,85030,61733,6799,35610,2919,35610,29120,79022,86920,79022,86916,63218,2956,2376,8619,35610,29110,09611,1061,8302,013单单店店损损益益分分析析预预测测（万万元元）第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年年咖啡销售256332399478574689年咖啡销售25633239947857468918%年咖啡直接成本152024293441年糕点销售32942751261573888623%年糕点销售329427512615738886下午茶销售5487128541,0251,2301,47638%这些销售是否过于乐观年糕点直接成本145188225271325390礼品销售14619022827332839410%这些销售是否过于乐观下午茶销售5487128541,0251,2301,476酒水销售14619022827332839410%下午茶直接成本164214256307369443总销售收入1,4241,8512,2212,6653,1983,837100%礼品销售146190228273328394礼品直接成本587691109131157年咖啡直接成本152024293441酒水销售146190228273328394年糕点直接成本145188225271325390酒水成本293846556679下午茶直接成本164214256307369443年总销售1,4241,8512,2212,6653,1983,837礼品直接成本587691109131157年总直接成本4125356427719251,110酒水成本293846556679总销售成本4125356427719251,110业绩完成%100%100%100%100%100%100%100%调试并进行敏感性分析1,0121,3151,5781,8942,2732,727毛利1,0121,3151,5781,8942,2732,72771%71%71%71%71%71%毛利率71.08%71.08%71.08%71.08%71.08%71.08%成成本本计计算算工资220241266292321354广告费用302724222018折旧费（5年）151515151515加盟费分摊（10年）888888租金151151151159159159租金无上涨？

@#@物业管理费171717171717冷链物流121619222732管理层房租181818181818维修费666666水电煤气费121620263445我们医院：

@#@500元/平米/年；@#@咖啡应该在这个的好几倍总部管理费（销售额7%）100130155187224269总成本588644699773850940销售费用及附加101316192328税前营业利润4136588631,1021,4001,760减盈利所得税103164216275350440税后净利润3104936478261,0501,320净利率21.77%26.66%29.14%31.01%32.84%34.39%3,970,0003,970,0001,697,7395,667,739年回报3104936478261,050累计回报-567-2572368841,7102,760