年度電商項目經營財務預算分析表.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