年度电商项目经营财务预算分析表.xls
下载文档
上传人:地**
编号:1290089
2024-12-17
54页
62.50KB
1、2015年度电商项目经营预算分析表科目2015年1月2015年2月2015年3月收入含税销售额0.015,000.020,000.0未税销售额0.012,820.517,094.0含税成本0.011,250.013,000.0未税成本0.09,615.411,111.1毛利率0.0%25.0%35.0%含税毛利额0.03,750.07,000.0未税毛利额0.03,205.15,982.9费用平台费用率0.0%5.0%5.0%保证金率(只支付第一年)0.0%0.0%0.0%平台使用年费率0.0%0.0%0.0%平台佣金扣点率5.0%5.0%5.0%推广费率6.0%139.3%206.0%淘内推2、广费率0.0%133.3%200.0%淘外推广费率6.0%6.0%6.0%物流仓储费用率物流损耗费率6.0%6.0%6.0%物流费率5.0%5.0%5.0%损耗费率1.0%1.0%1.0%仓储费率4.0%4.0%4.0%管理费用率0.0%666.7%500.0%平台费用额110,000.0750.01,000.0保证金(只支付第一年)50,000.00.00.0平台使用年费60,000.00.00.0平台佣金扣点0.0750.01,000.0推广费0.020,900.041,200.0淘内推广费0.020,000.040,000.0淘外推广费0.0900.01,200.0物流仓储费用物流损耗费3、0.0900.01,200.0物流费0.0750.01,000.0损耗费0.0150.0200.0仓储费0.0600.0800.0管理费用100,000.0100,000.0100,000.0总费用率0%821%721%费用总额210,000.0123,150.0144,200.0利润净毛利率(不含后台成本)0.0%-796.0%-686.0%含税净毛利额-210,000.0-119,400.0-137,200.0不含税净毛利额-179,487.2-102,051.3-117,265.0注:1、从2015年8月起开始进入盈亏平衡,前期现金流出1406500元,因此所需现金资本设定为150万元。4、2、2000万的销售额按年周转率8次计算,货物资本设定为250万。两者合并总投入最大资金规模设定为400万。2015年4月2015年5月2015年6月2015年7月2015年8月2015年9月450,000.0800,000.01,000,000.01,800,000.01,500,000.03,000,000.0384,615.4683,760.7854,700.91,538,461.51,282,051.32,564,102.6270,000.0480,000.0550,000.0900,000.0600,000.0900,000.0230,769.2410,256.4470,085.575、69,230.8512,820.5769,230.840.0%40.0%45.0%50.0%60.0%70.0%180,000.0320,000.0450,000.0900,000.0900,000.02,100,000.0153,846.2273,504.3384,615.4769,230.8769,230.81,794,871.85.0%5.0%5.0%5.0%5.0%5.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%5.0%5.0%5.0%5.0%5.0%5.0%39.3%37.3%36.0%28.2%26.0%23.3%33.3%36、1.3%30.0%22.2%20.0%17.3%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%5.0%5.0%5.0%5.0%5.0%5.0%1.0%1.0%1.0%1.0%1.0%1.0%4.0%4.0%4.0%4.0%4.0%4.0%22.2%12.5%10.0%13.9%15.3%7.7%22,500.040,000.050,000.090,000.075,000.0150,000.00.00.00.00.00.00.00.00.00.00.00.00.022,500.040,000.050,000.090,000.075,000.0157、0,000.0177,000.0298,000.0360,000.0508,000.0390,000.0700,000.0150,000.0250,000.0300,000.0400,000.0300,000.0520,000.027,000.048,000.060,000.0108,000.090,000.0180,000.027,000.048,000.060,000.0108,000.090,000.0180,000.022,500.040,000.050,000.090,000.075,000.0150,000.04,500.08,000.010,000.018,000.015,0008、.030,000.018,000.032,000.040,000.072,000.060,000.0120,000.0100,000.0100,000.0100,000.0250,000.0230,000.0230,000.077%65%61%57%56%46%344,500.0518,000.0610,000.01,028,000.0845,000.01,380,000.0-36.6%-24.8%-16.0%-7.1%3.7%24.0%-164,500.0-198,000.0-160,000.0-128,000.055,000.0720,000.0-140,598.3-169,230.8-19、36,752.1-109,401.747,008.5615,384.62015年度电商项目经营预算分析表 1、从2015年8月起开始进入盈亏平衡,前期现金流出1406500元,因此所需现金资本设定为150万元。2015年10月2015年11月2015年12月2015年1月-2015年12月总合计3,500,000.04,000,000.03,800,000.019,885,000.02,991,453.03,418,803.43,247,863.216,995,726.51,050,000.02,000,000.01,140,000.07,914,250.0897,435.91,709,40110、.7974,359.06,764,316.270.0%50.0%70.0%60.2%2,450,000.02,000,000.02,660,000.011,970,750.02,094,017.11,709,401.72,273,504.310,231,410.35.0%5.0%5.0%5.6%0.0%0.0%0.0%0.3%0.0%0.0%0.0%0.3%5.0%5.0%5.0%5.0%21.7%20.3%19.2%24.1%15.7%14.3%13.2%18.1%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%5.0%5.0%5.0%5.0%1.0%1.0%1.0%1.0%11、4.0%4.0%4.0%4.0%6.6%5.8%6.1%10.1%175,000.0200,000.0190,000.01,104,250.00.00.00.050,000.00.00.00.060,000.0175,000.0200,000.0190,000.0994,250.0760,000.0810,000.0728,000.04,793,100.0550,000.0570,000.0500,000.03,600,000.0210,000.0240,000.0228,000.01,193,100.0210,000.0240,000.0228,000.01,193,100.0175,000.0200,000.0190,000.0994,250.035,000.040,000.038,000.0198,850.0140,000.0160,000.0152,000.0795,400.0230,000.0230,000.0230,000.02,000,000.043%41%40%50%1,515,000.01,640,000.01,528,000.09,885,850.026.7%9.0%29.8%10.5%935,000.0360,000.01,132,000.02,084,900.0799,145.3307,692.3967,521.41,781,965.8