电商项目经营财务预算分析表.xlsx

20XX年度电商项目经营预算分析表科目20XX/1/120XX/2/120XX/3/1收入含税销售额1,000.01,001.01,002.0未税销售额854.7855.6856.4含税成本900.0900.9651.3未税成本769.2770.0556.7毛利率10.0%10.0%35.0%含税毛利额100.0100.1350.7未税毛利额85.585.6299.7费用平台费用率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%2004.0%3998.0%淘内推广费率0.0%1998.0%3992.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%9990.0%9980.0%平台费用额110,050.050.150.1保证金(只支付第一年）50,000.00.00.0平台使用年费60,000.00.00.0平台佣金扣点50.050.150.1推广费60.020,060.140,060.1淘内推广费0.020,000.040,000.0淘外推广费60.060.160.1物流仓储费用物流损耗费60.060.160.1物流费50.050.150.1损耗费10.010.010.0仓储费40.040.040.1管理费用100,000.0100,000.0100,000.0总费用率0%12009%13993%费用总额210,210.0120,210.2140,210.4利润净毛利率（不含后台成本）0.0%-11999.0%-13958.1%含税净毛利额-210,110.0-120,110.1-139,859.7不含税净毛利额-179,581.2-102,658.2-119,538.2注：1、从xx年x月起开始进入盈亏平衡，前期现金流出x元，因此所需现金资本设定为x万元。2、2000万的销售额按年周转率8次计算，货物资本设定为250万。两者合并总投入最大资金规模设定为400万。20XX/4/120XX/5/120XX/6/120XX/7/120XX/8/120XX/9/11,003.01,004.01,005.01,007.01,008.01,009.0857.3858.1859.0860.7861.5862.4601.8602.4552.8503.5403.2302.7514.4514.9472.4430.3344.6258.740.0%40.0%45.0%50.0%60.0%70.0%401.2401.6452.3503.5604.8706.3342.9343.2386.5430.3516.9603.75.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%14961.1%24906.4%29856.7%39727.9%29767.9%51542.2%14955.1%24900.4%29850.7%39721.9%29761.9%51536.2%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%9970.1%9960.2%9950.2%24826.2%22817.5%22794.8%50.250.250.350.450.450.50.00.00.00.00.00.00.00.00.00.00.00.050.250.250.350.450.450.5150,060.2250,060.2300,060.3400,060.4300,060.5520,060.5150,000.0250,000.0300,000.0400,000.0300,000.0520,000.060.260.260.360.460.560.560.260.260.360.460.560.550.250.250.350.450.450.510.010.010.110.110.110.140.140.240.240.340.340.4100,000.0100,000.0100,000.0250,000.0230,000.0230,000.024946%34882%39822%64569%52600%74352%20XX年度电商项目经营预算分析表250,210.6350,210.8400,211.1650,211.5530,211.7750,211.9-24906.2%-34841.6%-39777.0%-64519.2%-52540.4%-74282.0%-249,809.4-349,809.2-399,758.8-649,708.0-529,606.9-749,505.6-213,512.3-298,982.3-341,674.2-555,306.0-452,655.5-640,603.1 1、从xx年x月起开始进入盈亏平衡，前期现金流出x元，因此所需现金资本设定为x万元。20XX/10/120XX/11/120XX/12/120XX年1月-20XX年12月总合计1,010.01,011.01,012.07,063.0863.2864.1865.010,317.9303.0505.5303.66,530.7259.0432.1259.55,581.870.0%50.0%70.0%7.5%707.0505.5708.45,541.4604.3432.1605.54,736.25.0%5.0%5.0%1562.4%0.0%0.0%0.0%707.9%0.0%0.0%0.0%849.5%5.0%5.0%5.0%5.0%54461.4%56385.8%49413.1%50980.1%54455.4%56379.8%49407.1%50969.8%6.0%6.0%6.0%6.0%6.0%6.0%6.0%10.3%5.0%5.0%5.0%5.0%1.0%1.0%1.0%1.0%4.0%4.0%4.0%4.0%22772.3%22749.8%22727.3%28316.6%50.550.650.6110,353.20.00.00.050,000.00.00.00.060,000.050.550.650.6353.2550,060.6570,060.7500,060.73,600,724.3550,000.0570,000.0500,000.03,600,000.060.660.760.7724.360.660.760.7724.350.550.650.6603.610.110.110.1120.740.440.440.5282.5230,000.0230,000.0230,000.02,000,000.077249%79151%72155%80873%780,212.1800,212.3730,212.55,712,084.3-77178.7%-79100.6%-72085.4%-80794.9%-779,505.1-799,706.8-729,504.1-5,706,543.0-666,243.7-683,510.1-623,507.8-4,877,772.5