资金投向.xlsVIP免费

基地水产600大米1000猪800网点先期投入350专卖店100广告500信息化270总部固定资产150办公室90房租人员工资505080车（傲第1上他那2火车2）50元/月平米，800~900平米，加上半年的总10万每人经理4万/人其他2万/人项目第一年第二年第三年第四年销售收入5.300011.100022.700034.50000.6水产1.80004.000010.000015.00000.82米1.50002.50003.50004.50000.77猪1.60003.20006.50009.50000.6果0.40000.80001.50002.50000.7菜0.20000.40001.00000.7禽0.20000.40001.00000.6其他0.20000.40001.0000销售成本3.78207.794015.575023.5050水产1.08002.40006.00009.0000米1.23002.05002.87003.6900猪1.23202.46405.00507.3150果0.24000.48000.90001.5000菜0.00000.14000.28000.7000禽0.00000.14000.28000.7000其他0.00000.12000.24000.6000主营业务税金及附加0.19730.42980.9263销售毛利1.32072.87626.1988费用销售费用0.22880.44400.90801.940559市场推广费0.10000.19410.39693.968531销售网络建设0.04660.09040.18490.01000.01940.0397销售人员工资0.02220.04310.0881其他0.05000.09700.1984管理费用0.20850.39510.77070.003396226415094人员工资0.01800.03770.0771租金0.00810.01080.02160.005660377358491办公费用0.03000.06280.1285摊销费用0.00200.00200.00200.3634固定资产折旧0.05710.08570.1405技术费用0.00500.01110.0227坏帐损失0.06180.12950.2648其他不可预见费0.02650.05550.1135营业利润0.88332.03714.5200财务费用0.05200.25200.5720税前利润0.83131.78513.9480所得税0.150.12470.26780.5922净利润0.70661.51733.3558利润率0.13330.13670.1478销售人员办公费用（差旅、招待等）0.69751.5185第五年50.000020.00006.000014.00004.00002.00002.00002.0000第一年第二年期初现金余额2.2730现金收入4.416710.0715销售收入4.41679.2500应收账款回收0.00000.8215现金支出5.443710.71223.15175.4444存货成本1.05062.1650应付账款偿还0.00000.8404销售费用0.22880.4440管理费用0.10760.1805利息支出0.05200.2520固定资产支出0.53100.25500.32200.6975贷款返还0.00000.4333现金盈余及短缺-1.02701.6323贷款所得1.30005.0000权益收入2.00000.0000现金余额2.27306.6323销货成本(扣掉应付账款)税金第三年6.632320.637218.91671.720522.654710.81414.32641.52190.90800.36780.57200.52601.51852.10004.61498.00000.000012.6149第一年第二年第三年资产48470116100223704流动资产43731109668213391现金2273066323126149应收款88331850037833坏账备抵-618-1295-2648存货126062598051917待摊费用180160140固定资产固定资产原值5310786013120累计折旧-571-1428-2807负债流动负债应付账款84041521930281长期负债1300058667117667权益2706642257758654847011614322381343109负债和所有者权益