syb创业计划书数据表(含公式)

1、销售收入预测产品名称123456789101112合计商品1销售数量60908090901002002001201201201201390平均单价404040404040404040404040月销售额24003600320036003600400080008000480048004800480055600商品2销售数量60908090901002002001201201201201390平均单价454545454545454545454545月销售额27004050360040504050450090009000540054005400540062550商品3销售数量609080909010

2、02002001201201201201390平均单价404040404040404040404040月销售额24003600320036003600400080008000480048004800480055600商品4销售数量60908090901002002001201201201201390平均单价454545454545454545454545月销售额27004050360040504050450090009000540054005400540062550商品5销售数量平均单价月销售额商品6销售数量平均单价月销售额商品7销售数量平均单价月销售额合计销售总量24036032036036

3、04008008004804804804805560销售总收入102001530013600153001530017000340003400020400204002040020400236300商品1成本101010101010101010101010商品2成本101010101010101010101010商品3成本101010101010101010101010商品4成本101010101010101010101010销售和成本计划123456789101112合计销售含税销售收入1020015300136001530015300170003400034000204002040020400

4、20400236300增值税2974463964464464959909905945945945946883销售净收入99031485413204148541485416505330103301019806198061980619806229417成本业主工资10001000100010001000100010001000100010001000100012000员工工资40004000400040004000400040004000400040004000400048000租金50005000500050005000500050005000500050005000500060000营销费用5

5、05050505050505050505050600公用事业费5005005005005005005005005005005005006000维修费202020202020202020202020240折旧费3603603603603603603603603603603603604320贷款利息保险费303030303030303030303030360登记注册费101010101010101010101010120其他原料115001500150015001500150015001500150015001500150018000原料250050050050050050050050050050

6、05005006000原料3原料4原料5总成本129701297012970129701297012970129701297012970129701297012970155640利润-306718842341884188435352004020040683668366836683673777税费企业所得税纳税基数85777个人所得税1313313133其他（附加税）15851585净收入(税后)-306718842341884188435352004020040683668366836-788259059现金流量计划123456789101112合计现金流入月初现金0-11817-8163-5

7、759-2104155064552386441274486805608663492现金销售收入102001530013600153001530017000340003400020400204002040020400236300赊销收入贷款其他现金流入7000070000可支配现金802003483543795411319618550404555786461674690807648683892现金流出现金采购支出列出商品1600900800900900100020002000120012001200120013900商品26009008009009001000200020001200120012

8、00120013900商品3600900800900900100020002000120012001200120013900商品4600900800900900100020002000120012001200120013900业主工资10001000100010001000100010001000100010001000100012000员工工资40004000400040004000400040004000400040004000400048000租金6000060000营销费用505050505050505050505050600公用事业费5005005005005005005005005

9、005005005006000维修费202020202020202020202020240贷款利息偿还贷款本金保险费303030303030303030303030360登记注册费120120设备2160021600其他列出项目0原材料和包装20002000200020002000200020002000200020002000200024000税金2974463964464464959909905945945945946883现金总支出920171164611196116461164612095165901659012994129941299412994235403月底现金-11817-81

10、63-5759-210415506455238644127448680560866349270897纳税16818增值税3544个人税13133城市建设税35教育费附加106销售收入预测产品名称123456789101112合计商品1销售数量5965586065705315355266136425636136216974平均单价363636363636363636363636月销售额214562008821816205201911619260189362206823112202682206822356251064商品2销售数量5635565665725505725705615765575674

11、716681平均单价606060606060606060606060月销售额337803336033960343203300034320342003366034560334203402028260400860商品3销售数量0平均单价0月销售额0000000000000商品4销售数量0平均单价0月销售额0000000000000商品5销售数量0平均单价0月销售额0000000000000商品6销售数量0平均单价0月销售额0000000000000商品7销售数量0平均单价0月销售额0000000000000合计销售总量1159111411721142108111071096117412181120

12、1180109213655销售总收入552365344855776548405211653580531365572857672536885608850616651924成本一303030303030303030303030成本二505050505050505050505050成本三销售和成本计划123456789101112合计销售含流转税销售收入552365344855776548405211653580531365572857672536885608850616651924流转税33143207334732903127321531883344346032213365303739115销售净

13、收入519225024152429515504898950365499485238454212504675272347579612809成本业主工资15001500150015001500150015001500150015001500150018000员工工资14001400140014001400140014001400140014001400140016800租金5005005005005005005005005005005005006000营销费用505050505050505050505050600公用事业费202020202020202020202020240维修费00000000

14、0000折旧费1001001001001001001001001001001001001200贷款利息000000000000保险费1001001001001001001001001001001001001200登记注册费5050原材料列出0商品1178801674018180171001593016050157801839019260168901839018630209220商品2281502780028300286002750028600285002805028800278502835023550334050商品30000000000000商品40商品50总成本49750482105015

15、0493704710048320479505011051730484105041045850587360利润21722031227921801889204519982274248220572313172925449税费企业所得税0个人所得税1841771891841691771751891991781911612172其他0净收入(税后)19881855209019961720186818232086228318792122156823276现金流量计划123456789101112合计现金流入月初现金0697110856108321401418717194012195321649221812

16、828428215203074现金销售收入05523653448557765484052116535805313655728576725368856088601308赊销收入0贷款0其他现金流入6000060000可支配现金600006220764304666086885470833729817508977377798538197284303864382现今流出现金采购支出列出01196681841419998188101752317655173582022921186185792022920493230142229557.52919029715300302887530030299252945

17、2.53024029242.529767.524727.5350752.530赊购支出0业主工资15001500150015001500150015001500150015001500150018000员工工资14001400140014001400140014001400140014001400140016800租金5005005005005005005005005005005005006000营销费用505050505050505050505050600公用事业费202020202020202020202020240维修费0000000000000贷款利息0000000000000偿还贷款

18、本金0保险费1001001001001001001001001001001001001200登记注册费5050设备0其他列出项目00税金1841771891841691771751891991781911612172现金总支出530295135153472525945013751432510285344055195515695375748952625957月底现金69711085610832140141871719401219532164922181282842821535351238425纳税3625增值税1397个人税2172城市建设税14教育费附加42亮亮化肥销售收入预测产品名称1234

19、56789101112合计磷酸二铵销售数量2422452482422462422422452482422462422930平均单价185185185185185185185185185185185185月销售额447704532545880447704551044770447704532545880447704551044770542050磷肥销售数量1141111171191111121111141151141111111360平均单价808080808080808080808080月销售额912088809360952088808960888091209200912088808880108

20、800商品3销售数量0平均单价0月销售额0000000000000商品4销售数量0平均单价0月销售额0000000000000商品5销售数量0平均单价0月销售额0000000000000商品6销售数量0平均单价0月销售额0000000000000商品7销售数量0平均单价0月销售额0000000000000合计销售总量3563563653613573543533593633563573534290销售总收入538905420555240542905439053730536505444555080538905439053650650850成本一145145145145145145145145145

21、145145145成本二555555555555555555555555成本三销售和成本计划123456789101112合计销售含流转税销售收入538905420555240542905439053730536505444555080538905439053650650850流转税32333252331432573263322432193267330532333263321939051销售净收入506575095351926510335112750506504315117851775506575112750431611799成本业主工资1000100010001000100010001000

22、1000100010001000100012000员工工资7007007007007007007007007007007007008400租金5005005005005005005005005005005005006000营销费用100000000000100公用事业费202020202020202020202020240维修费000000000000折旧费3533533533533533533533533533533533534236贷款利息000000000000保险费0000000000000登记注册费5050原材料列出0商品1350903552535960350903567035090

23、350903552535960350903567035090424850商品262706105643565456105616061056270632562706105610574800商品30000000000000商品40商品50总成本440834420344968442084434843823437684436844858439334434843768530676利润65746750695868256779668366636810691767246779666381123税费企业所得税0个人所得税3793873983913893843833913963863893834656其他0净收入(税后)61956362656064336390629962806420652163376390628076467现金流量计划123456789101112合计现金流入月初现金020697765129402003825972325913860843888494205661262146352049现金销售收入05389054205552405429054390537305365