财务预算表819.xlsVIP免费

项目第一年第二年销售收入3.20005.80000.70.7水产1.10002.10000.8650.865米0.90001.30000.82750.8275猪1.00001.70000.70.7果0.20000.40000.7750.775菜0.10000.7750.775禽0.10000.70.7其他0.1000销售成本2.51604.5063水产0.77001.4700米0.77851.1245猪0.82751.4068果0.14000.2800菜0.00000.0775禽0.00000.0775其他0.00000.0700主营业务税金及附加0.08890.1682销售毛利0.59511.1256费用销售费用0.16330.27641.775873市场推广费0.05000.0906销售网络建设0.04660.07050.01000.0165销售人员工资0.02470.0408物流0.03200.0580管理费用0.14160.2226人员工资0.03410.0437租金0.00810.0108办公费用0.03000.0422摊销费用0.00200.0020固定资产折旧0.00910.0157技术费用0.00500.0116坏帐损失0.03730.0677其他不可预见费0.01600.0290营业利润0.29020.6266投资收益0.04800.0700财务费用0.00000.0520税前利润0.33820.6446所得税0.150.05070.0967净利润0.28740.5479利润率0.08980.0945利润5478.852税金0.2649销售人员办公费用（差旅、招待等）第三年第四年第五年10.900034.500050.00004.800015.000020.00001.70004.50006.00003.10009.500014.00000.70002.50004.00000.20001.00002.00000.20001.00002.00000.20001.00002.00008.335826.25383.360010.50001.47053.89252.56537.86130.49001.75000.15500.77500.15500.77500.14000.70000.33342.23090.42270.12000.11130.02380.05870.10900.34370.05030.01080.06070.00200.13730.19820.01640.02180.12720.05451.46440.12000.12001.46440.21971.24470.114212447.4695510.5530第一年第二年期初现金余额0.9720现金收入2.71475.3993销售收入2.66674.8333应收账款回收0.00000.4960投资收益0.04800.0700现金支出3.74275.85272.09673.0563存货成本0.69891.2517应付账款偿还0.00000.5591销售费用0.16330.2764管理费用0.11320.1373利息支出0.00000.0520固定资产支出0.05100.0350长期投资0.48000.22000.13960.2649贷款返还0.00000.0000现金盈余及短缺-1.02800.5186贷款所得0.00001.3000权益收入2.00000.0000现金余额0.97201.818618186销货成本(扣掉应付账款)税金第三年1.818610.10239.08330.89900.120011.97175.69472.31550.86160.42270.19820.12000.00600.50000.55301.3000-0.05083.00000.00002.949229492第一年第二年第三年资产284664996986821流动资产232464235774313现金97201818629492应收款5333966718167坏账备抵(373)(677)(1272)存货83871502127786待摊费用180160140固定资产固定资产原值510860920累计折旧(91)(248)(412)长期投资4800700012000负债流动负债应付账款5591861616020长期负债01300030000权益228742835340801284664996986821000负债和所有者权益