年度电商项目经营财务预算分析表

科目含税销售额未税销售额2015年1月0.00.00.00.00.0%0.00.00.0%0.0%0.0%5.0%6.0%0.0%6.0%6.0%5.0%1.0%4.0%0.0%110,000.050,000.060,000.00.00.00.00.00.00.00.00.0100,000.00%210,000.00.0%-210,000.0-179,487.22015年2月15,000.012,820.511,250.09,615.425.0%3,750.03,205.15.0%0.0%0.0%5.0%139.3%133.3%6.0%6.0%5.0%1.0%4.0%666.7%750.00.00.0750.020,900.020,000.0900.0900.0750.0150.0600.0100,000.0821%123,150.0-796.0%-119,400.0-102,051.32015年3月20,000.017,094.013,000.011,111.135.0%7,000.05,982.95.0%0.0%0.0%5.0%206.0%200.0%6.0%6.0%5.0%1.0%4.0%500.0%1,000.00.00.01,000.041,200.040,000.01,200.01,200.01,000.0200.0800.0100,000.0721%144,200.0-686.0%-137,200.0-117,265.0收入含税成本未税成本毛利率含税毛利额未税毛利额平台费用率保证金率(只支付第一年）平台使用年费率平台佣金扣点率推广费率淘内推广费率淘外推广费率物流物流损耗费率物流费率仓储损耗费率费用率仓储费率费用管理费用率平台费用额保证金(只支付第一年）平台使用年费平台佣金扣点推广费淘内推广费淘外推广费物流仓储费用物流损耗费物流费损耗费仓储费总费用率费用总额管理费用利润注：净毛利率（不含后台成本）含税净毛利额不含税净毛利额 1、从2015年8月起开始进入盈亏平衡，前期现金流出1406500元，因此所需现金资本设定为150万元。 2、2000万的销售额按年周转率8次计算，货物资本设定为250万。 两者合并总投入最大资金规模设定为400万。

2015年度电商项目经营预算分析表2015年4月450,000.0384,615.4270,000.0230,769.240.0%180,000.0153,846.25.0%0.0%0.0%5.0%39.3%33.3%6.0%6.0%5.0%1.0%4.0%22.2%22,500.00.00.022,500.0177,000.0150,000.027,000.027,000.022,500.04,500.018,000.0100,000.077%344,500.0-36.6%-164,500.0-140,598.32015年5月800,000.0683,760.7480,000.0410,256.440.0%320,000.0273,504.35.0%0.0%0.0%5.0%37.3%31.3%6.0%6.0%5.0%1.0%4.0%12.5%40,000.00.00.040,000.0298,000.0250,000.048,000.048,000.040,000.08,000.032,000.0100,000.065%518,000.0-24.8%-198,000.0-169,230.82015年6月1,000,000.0854,700.9550,000.0470,085.545.0%450,000.0384,615.45.0%0.0%0.0%5.0%36.0%30.0%6.0%6.0%5.0%1.0%4.0%10.0%50,000.00.00.050,000.0360,000.0300,000.060,000.060,000.050,000.010,000.040,000.0100,000.061%610,000.0-16.0%-160,000.0-136,752.12015年7月1,800,000.01,538,461.5900,000.0769,230.850.0%900,000.0769,230.85.0%0.0%0.0%5.0%28.2%22.2%6.0%6.0%5.0%1.0%4.0%13.9%90,000.00.00.090,000.0508,000.0400,000.0108,000.0108,000.090,000.018,000.072,000.0250,000.057%1,028,000.0-7.1%-128,000.0-109,401.72015年8月1,500,000.01,282,051.3600,000.0512,820.560.0%900,000.0769,230.85.0%0.0%0.0%5.0%26.0%20.0%6.0%6.0%5.0%1.0%4.0%15.3%75,000.00.00.075,000.0390,000.0300,000.090,000.090,000.075,000.015,000.060,000.0230,000.056%845,000.03.7%55,000.047,008.52015年9月3,000,000.02,564,102.6900,000.0769,230.870.0%2,100,000.01,794,871.85.0%0.0%0.0%5.0%23.3%17.3%6.0%6.0%5.0%1.0%4.0%7.7%150,000.00.00.0150,000.0700,000.0520,000.0180,000.0180,000.0150,000.030,000.0120,000.0230,000.046%1,380,000.024.0%720,000.0615,384.6此所需现金资本设定为150万元。2015年10月3,500,000.02,991,453.01,050,000.0897,435.970.0%2,450,000.02,094,017.15.0%0.0%0.0%5.0%21.7%15.7%6.0%6.0%5.0%1.0%4.0%6.6%175,000.00.00.0175,000.0760,000.0550,000.0210,000.0210,000.0175,000.035,000.0140,000.0230,000.043%1,515,000.026.7%935,000.0799,145.32015年11月4,000,000.03,418,803.42,000,000.01,709,401.750.0%2,000,000.01,709,401.75.0%0.0%0.0%5.0%20.3%14.3%6.0%6.0%5.0%1.0%4.0%5.8%200,000.00.00.0200,000.0810,000.0570,000.0240,000.0240,000.0200,000.040,000.0160,000.0230,000.041%1,640,000.09.0%360,000.0307,692.32015年12月2015年1月-2015年12月总合计3,800,000.03,247,863.21,140,000.0974,359.070.0%2,660,000.02,273,504.35.0%0.0%0.0%5.0%19.2%13.2%6.0%6.0%5.0%1.0%4.0%6.1%190,000.00.00.0190,000.0728,000.0500,000.0228,000.0228,000.0190,000.038,000.0152,000.0230,000.040%1,528,000.029.8%1,132,000.0967,521.419,885,000.016,995,726.57,914,250.06,764,316.260.2%11,970,750.010,231,410.35.6%0.3%0.3%5.0%24.1%18.1%6.0%6.0%5.0%1.0%4.0%10.1%1,104,250.050,000.060,000.0994,250.04,793,100.03,600,000.01,193,100.01,193,100.0994,250.0198,850.0795,400.02,000,000.050%9,885,850.010.5%2,084,900.01,781,965.8