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

1、单单门门店店资资本本家家投投入入（万万元元）One Single Store Set-up Costs（EURO）公公司司创创办办费费公司执照，证明，证书1Setting up the businessBusiness registration,licences,legal expense1,250公司网站，软件开发5Website6,250商业计划书2Business plan2,500小计8sum10,000交交付付总总部部加加盟盟金金及及保保证证金金加盟金80Franchise fees and deposit feeFranchise fees100,000小计80sum100,000

2、设设备备装装修修费费装修40Plant and equipmentDecoration50,000设备60Equipment75,000办公设备3Office3,750小计103sum128,750前前期期运运营营费费广告宣传30Starting OperationsAdvertising and Promotion37,500半年货存（含进出口货运，物流，存储，包装）150Start-up inventory187,500半年房租75Advance rent（6 months）93,750半年物业管理费9Advance rent property management fee（6 month

3、s）11,250半年员工工资30Employees salaries（6 months）37,500半年管理人员人工福利15Managers salaries（6 months）18,750小计309sum386,250总总计计500Total625,000半年存货需要150万？#主要包括哪些？#因为很多搞点都是难以保存的，现买的单单店店销销售售收收入入和和销销售售税税金金及及附附加加估估算算表表（万万元元）第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年咖咖啡啡饮饮料料咖啡收入 255.50332.15398.58478.30573.96688.75日销售额0.700

4、.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

5、.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.00

6、200.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.

7、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%3

8、8%礼品收入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,3042

9、7,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,49

10、130,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,24

11、5221,370243,506267,857294,643年年工工资资合合计计2,195,400 2,414,940 2,656,4342,922,0773,214,2853,535,714所所有有门门店店员员工工年年工工资资开开销销第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年 第第六六年年合合计计2,195,400 4,610,340 7,266,774 10,188,85113,403,13716,938,85030,61733,6799,35610,2919,35610,29120,79022,86920,79022,86916,63218,2956,2376,8619,

12、35610,29110,09611,1061,8302,013单单店店损损益益分分析析预预测测（万万元元）第第一一年年第第二二年年第第三三年年第第四四年年第第五五年年第第六六年年年咖啡销售256332399478574689年咖啡销售25633239947857468918%年咖啡直接成本152024293441年糕点销售32942751261573888623%年糕点销售329427512615738886下午茶销售5487128541,0251,2301,47638%这些销售是否过于乐观年糕点直接成本145188225271325390礼品销售14619022827332839410%这些

13、销售是否过于乐观下午茶销售5487128541,0251,2301,476酒水销售14619022827332839410%下午茶直接成本164214256307369443总销售收入1,4241,8512,2212,6653,1983,837100%礼品销售146190228273328394礼品直接成本587691109131157年咖啡直接成本152024293441酒水销售146190228273328394年糕点直接成本145188225271325390酒水成本293846556679下午茶直接成本164214256307369443年总销售1,4241,8512,2212,665

14、3,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广告费用30272422

15、2018折旧费（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