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

1、20182018年年度度电电商商项项目目经经营营预预算算分分析析表表 科科目目20182018年年1 1月月20182018年年2 2月月20182018年年3 3月月20182018年年4 4月月 收收 入入 含含税税销销售售额额5 56 60 0, ,0 00 00 0. .0 04 45 5, ,0 00 00 0. .0 01 1, ,2 20 00 0, ,0 00 00 0. .0 01 1, ,4 45 50 0, ,0 00 00 0. .0 0 未税销售额478,632.538,461.51,025,641.01,239,316.2 含税成本504,000.040,500.0

2、780,000.0870,000.0 未税成本430,769.234,615.4666,666.7743,589.7 毛毛利利率率1 10 0. .0 0% %1 10 0. .0 0% %3 35 5. .0 0% %4 40 0. .0 0% % 含税毛利额56,000.04,500.0420,000.0580,000.0 未税毛利额47,863.23,846.2358,974.4495,726.5 费费 用用 平平台台费费用用率率0 0. .0 0% %5 5. .0 0% %5 5. .0 0% %5 5. .0 0% % 保证金率(只支付第一年）0.0%0.0%0.0%0.0% 平台

3、使用年费率0.0%0.0%0.0%0.0% 平台佣金扣点率5.0%5.0%5.0%5.0% 推推广广费费率率6 6. .0 0% %5 50 0. .4 4% %9 9. .3 3% %1 16 6. .3 3% % 淘内推广费率0.0%44.4%3.3%10.3% 淘外推广费率6.0%6.0%6.0%6.0% 物物流流 仓仓储储 费费用用 率率 物物流流损损耗耗费费率率6 6. .0 0% %6 6. .0 0% %6 6. .0 0% %6 6. .0 0% % 物流费率5.0%5.0%5.0%5.0% 损耗费率1.0%1.0%1.0%1.0% 仓仓储储费费率率4 4. .0 0% %4

4、4. .0 0% %4 4. .0 0% %4 4. .0 0% % 管管理理费费用用率率0 0. .0 0% %2 22 22 2. .2 2% %8 8. .3 3% %6 6. .9 9% % 平平台台费费用用额额1 13 38 8, ,0 00 00 0. .0 02 2, ,2 25 50 0. .0 06 60 0, ,0 00 00 0. .0 07 72 2, ,5 50 00 0. .0 0 保证金(只支付第一年）50,000.00.00.00.0 平台使用年费60,000.00.00.00.0 平台佣金扣点28,000.02,250.060,000.072,500.0 推推

5、广广费费3 33 3, ,6 60 00 0. .0 02 22 2, ,7 70 00 0. .0 01 11 12 2, ,0 00 00 0. .0 02 23 37 7, ,0 00 00 0. .0 0 淘内推广费0.020,000.040,000.0150,000.0 淘外推广费33,600.02,700.072,000.087,000.0 物物流流 仓仓储储 费费用用 物物流流损损耗耗费费3 33 3, ,6 60 00 0. .0 02 2, ,7 70 00 0. .0 07 72 2, ,0 00 00 0. .0 08 87 7, ,0 00 00 0. .0 0 物流费

6、28,000.02,250.060,000.072,500.0 损耗费5,600.0450.012,000.014,500.0 仓仓储储费费2 22 2, ,4 40 00 0. .0 01 1, ,8 80 00 0. .0 04 48 8, ,0 00 00 0. .0 05 58 8, ,0 00 00 0. .0 0 管管理理费费用用1 10 00 0, ,0 00 00 0. .0 01 10 00 0, ,0 00 00 0. .0 01 10 00 0, ,0 00 00 0. .0 01 10 00 0, ,0 00 00 0. .0 0 总总费费用用率率0 0% %2 28

7、88 8% %3 33 3% %3 38 8% % 费费用用总总额额3 32 27 7, ,6 60 00 0. .0 01 12 29 9, ,4 45 50 0. .0 03 39 92 2, ,0 00 00 0. .0 05 55 54 4, ,5 50 00 0. .0 0 利利 润润 净净毛毛利利率率（不不含含后后台台成成本本）0 0. .0 0% %- -2 27 77 7. .7 7% %2 2. .3 3% %1 1. .8 8% % 含含税税净净毛毛利利额额- -2 27 71 1, ,6 60 00 0. .0 0- -1 12 24 4, ,9 95 50 0. .0

8、02 28 8, ,0 00 00 0. .0 02 25 5, ,5 50 00 0. .0 0 不不含含税税净净毛毛利利额额- -2 23 32 2, ,1 13 36 6. .8 8- -1 10 06 6, ,7 79 94 4. .9 92 23 3, ,9 93 31 1. .6 62 21 1, ,7 79 94 4. .9 9 注注： 1 1、从从20182018年年8 8月月起起开开始始进进入入盈盈亏亏平平衡衡，前前期期现现金金流流出出14065001406500元元，因因此此所所需需现现金金资资本本设设定定为为150150万万元元。 2 2、20002000万万的的销销售售

9、额额按按年年周周转转率率8 8次次计计算算，货货物物资资本本设设定定为为250250万万。 两两者者合合并并总总投投入入最最大大资资金金规规模模设设定定为为400400万万。 20182018年年5 5月月20182018年年6 6月月20182018年年7 7月月20182018年年8 8月月20182018年年9 9月月20182018年年1010月月20182018年年1111月月 1 1, ,8 80 00 0, ,0 00 00 0. .0 02 23 3, ,0 00 00 0, ,0 00 00 0. .0 05 5, ,8 80 00 0, ,0 00 00 0. .0 06

10、6, ,5 50 00 0, ,0 00 00 0. .0 01 13 3, ,0 00 00 0, ,0 00 00 0. .0 01 13 3, ,5 50 00 0, ,0 00 00 0. .0 04 4, ,0 00 00 0, ,0 00 00 0. .0 0 1,538,461.519,658,119.74,957,265.05,555,555.611,111,111.111,538,461.53,418,803.4 1,080,000.012,650,000.02,900,000.02,600,000.03,900,000.04,050,000.02,000,000.0 923

11、,076.910,811,965.82,478,632.52,222,222.23,333,333.33,461,538.51,709,401.7 4 40 0. .0 0% %4 45 5. .0 0% %5 50 0. .0 0% %6 60 0. .0 0% %7 70 0. .0 0% %7 70 0. .0 0% %5 50 0. .0 0% % 720,000.010,350,000.02,900,000.03,900,000.09,100,000.09,450,000.02,000,000.0 615,384.68,846,153.82,478,632.53,333,333.37

12、,777,777.88,076,923.11,709,401.7 5 5. .0 0% %5 5. .0 0% %5 5. .0 0% %5 5. .0 0% %5 5. .0 0% %5 5. .0 0% %5 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.0%0.0%0.0% 5.0%5.0%5.0%5.0%5.0%5.0%5.0% 1 19 9. .9 9% %7 7. .3 3% %1 12 2. .9 9% %1 10 0. .6 6% %1 10 0. .0 0% %1 10 0. .1 1% %2 20 0.

13、.3 3% % 13.9%1.3%6.9%4.6%4.0%4.1%14.3% 6.0%6.0%6.0%6.0%6.0%6.0%6.0% 6 6. .0 0% %6 6. .0 0% %6 6. .0 0% %6 6. .0 0% %6 6. .0 0% %6 6. .0 0% %6 6. .0 0% % 5.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%1.0% 4 4. .0 0% %4 4. .0 0% %4 4. .0 0% %4 4. .0 0% %4 4. .0 0% %4 4. .0 0% %4 4. .0 0% % 5 5.

14、 .6 6% %0 0. .4 4% %4 4. .3 3% %3 3. .5 5% %1 1. .8 8% %1 1. .7 7% %5 5. .8 8% % 9 90 0, ,0 00 00 0. .0 01 1, ,1 15 50 0, ,0 00 00 0. .0 02 29 90 0, ,0 00 00 0. .0 03 32 25 5, ,0 00 00 0. .0 06 65 50 0, ,0 00 00 0. .0 06 67 75 5, ,0 00 00 0. .0 02 20 00 0, ,0 00 00 0. .0 0 0.00.00.00.00.00.00.0 0.00

15、.00.00.00.00.00.0 90,000.01,150,000.0290,000.0325,000.0650,000.0675,000.0200,000.0 3 35 58 8, ,0 00 00 0. .0 01 1, ,6 68 80 0, ,0 00 00 0. .0 07 74 48 8, ,0 00 00 0. .0 06 69 90 0, ,0 00 00 0. .0 01 1, ,3 30 00 0, ,0 00 00 0. .0 01 1, ,3 36 60 0, ,0 00 00 0. .0 08 81 10 0, ,0 00 00 0. .0 0 250,000.0

16、300,000.0400,000.0300,000.0520,000.0550,000.0570,000.0 108,000.01,380,000.0348,000.0390,000.0780,000.0810,000.0240,000.0 1 10 08 8, ,0 00 00 0. .0 01 1, ,3 38 80 0, ,0 00 00 0. .0 03 34 48 8, ,0 00 00 0. .0 03 39 90 0, ,0 00 00 0. .0 07 78 80 0, ,0 00 00 0. .0 08 81 10 0, ,0 00 00 0. .0 02 24 40 0,

17、,0 00 00 0. .0 0 90,000.01,150,000.0290,000.0325,000.0650,000.0675,000.0200,000.0 18,000.0230,000.058,000.065,000.0130,000.0135,000.040,000.0 7 72 2, ,0 00 00 0. .0 09 92 20 0, ,0 00 00 0. .0 02 23 32 2, ,0 00 00 0. .0 02 26 60 0, ,0 00 00 0. .0 05 52 20 0, ,0 00 00 0. .0 05 54 40 0, ,0 00 00 0. .0

18、01 16 60 0, ,0 00 00 0. .0 0 1 10 00 0, ,0 00 00 0. .0 01 10 00 0, ,0 00 00 0. .0 02 25 50 0, ,0 00 00 0. .0 02 23 30 0, ,0 00 00 0. .0 02 23 30 0, ,0 00 00 0. .0 02 23 30 0, ,0 00 00 0. .0 02 23 30 0, ,0 00 00 0. .0 0 4 40 0% %2 23 3% %3 32 2% %2 29 9% %2 27 7% %2 27 7% %4 41 1% % 7 72 28 8, ,0 00

19、00 0. .0 05 5, ,2 23 30 0, ,0 00 00 0. .0 01 1, ,8 86 68 8, ,0 00 00 0. .0 01 1, ,8 89 95 5, ,0 00 00 0. .0 03 3, ,4 48 80 0, ,0 00 00 0. .0 03 3, ,6 61 15 5, ,0 00 00 0. .0 01 1, ,6 64 40 0, ,0 00 00 0. .0 0 - -0 0. .4 4% %2 22 2. .3 3% %1 17 7. .8 8% %3 30 0. .8 8% %4 43 3. .2 2% %4 43 3. .2 2% %9

20、 9. .0 0% % - -8 8, ,0 00 00 0. .0 05 5, ,1 12 20 0, ,0 00 00 0. .0 01 1, ,0 03 32 2, ,0 00 00 0. .0 02 2, ,0 00 05 5, ,0 00 00 0. .0 05 5, ,6 62 20 0, ,0 00 00 0. .0 05 5, ,8 83 35 5, ,0 00 00 0. .0 03 36 60 0, ,0 00 00 0. .0 0 - -6 6, ,8 83 37 7. .6 64 4, ,3 37 76 6, ,0 06 68 8. .4 48 88 82 2, ,0

21、05 51 1. .3 31 1, ,7 71 13 3, ,6 67 75 5. .2 24 4, ,8 80 03 3, ,4 41 18 8. .8 84 4, ,9 98 87 7, ,1 17 79 9. .5 53 30 07 7, ,6 69 92 2. .3 3 20182018年年度度电电商商项项目目经经营营预预算算分分析析表表 20182018年年1212月月20182018年年1 1月月-2018-2018年年1212月月总总合合计计 3 3, ,8 80 00 0, ,0 00 00 0. .0 07 74 4, ,6 65 55 5, ,0 00 00 0. .0 0

22、 3,247,863.263,807,692.3 1,140,000.032,514,500.0 974,359.027,790,170.9 7 70 0. .0 0% %5 56 6. .4 4% % 2,660,000.042,140,500.0 2,273,504.336,017,521.4 5 5. .0 0% %5 5. .1 1% % 0.0%0.1% 0.0%0.1% 5.0%5.0% 1 19 9. .2 2% %1 10 0. .8 8% % 13.2%4.8% 6.0%6.0% 6 6. .0 0% %6 6. .0 0% % 5.0%5.0% 1.0%1.0% 4 4. .0 0% %4 4. .0 0% % 6 6. .1