syb創(chuàng)業(yè)計(jì)劃書數(shù)據(jù)表(含公式)

1、銷售收入預(yù)測產(chǎn)品名稱123456789101112合計(jì)商品1銷售數(shù)量60908090901002002001201201201201390平均單價(jià)404040404040404040404040月銷售額24003600320036003600400080008000480048004800480055600商品2銷售數(shù)量60908090901002002001201201201201390平均單價(jià)454545454545454545454545月銷售額27004050360040504050450090009000540054005400540062550商品3銷售數(shù)量609080909010

2、02002001201201201201390平均單價(jià)404040404040404040404040月銷售額24003600320036003600400080008000480048004800480055600商品4銷售數(shù)量60908090901002002001201201201201390平均單價(jià)454545454545454545454545月銷售額27004050360040504050450090009000540054005400540062550商品5銷售數(shù)量平均單價(jià)月銷售額商品6銷售數(shù)量平均單價(jià)月銷售額商品7銷售數(shù)量平均單價(jià)月銷售額合計(jì)銷售總量24036032036036

3、04008008004804804804805560銷售總收入102001530013600153001530017000340003400020400204002040020400236300商品1成本101010101010101010101010商品2成本101010101010101010101010商品3成本101010101010101010101010商品4成本101010101010101010101010銷售和成本計(jì)劃123456789101112合計(jì)銷售含稅銷售收入1020015300136001530015300170003400034000204002040020400

4、20400236300增值稅2974463964464464959909905945945945946883銷售凈收入99031485413204148541485416505330103301019806198061980619806229417成本業(yè)主工資10001000100010001000100010001000100010001000100012000員工工資40004000400040004000400040004000400040004000400048000租金50005000500050005000500050005000500050005000500060000營銷費(fèi)用5

5、05050505050505050505050600公用事業(yè)費(fèi)5005005005005005005005005005005005006000維修費(fèi)202020202020202020202020240折舊費(fèi)3603603603603603603603603603603603604320貸款利息保險(xiǎn)費(fèi)303030303030303030303030360登記注冊費(fèi)101010101010101010101010120其他原料115001500150015001500150015001500150015001500150018000原料250050050050050050050050050050

6、05005006000原料3原料4原料5總成本129701297012970129701297012970129701297012970129701297012970155640利潤-306718842341884188435352004020040683668366836683673777稅費(fèi)企業(yè)所得稅納稅基數(shù)85777個(gè)人所得稅1313313133其他（附加稅）15851585凈收入(稅后)-306718842341884188435352004020040683668366836-788259059現(xiàn)金流量計(jì)劃123456789101112合計(jì)現(xiàn)金流入月初現(xiàn)金0-11817-8163-5

7、759-2104155064552386441274486805608663492現(xiàn)金銷售收入102001530013600153001530017000340003400020400204002040020400236300賒銷收入貸款其他現(xiàn)金流入7000070000可支配現(xiàn)金802003483543795411319618550404555786461674690807648683892現(xiàn)金流出現(xiàn)金采購支出列出商品1600900800900900100020002000120012001200120013900商品26009008009009001000200020001200120012

8、00120013900商品3600900800900900100020002000120012001200120013900商品4600900800900900100020002000120012001200120013900業(yè)主工資10001000100010001000100010001000100010001000100012000員工工資40004000400040004000400040004000400040004000400048000租金6000060000營銷費(fèi)用505050505050505050505050600公用事業(yè)費(fèi)5005005005005005005005005

9、005005005006000維修費(fèi)202020202020202020202020240貸款利息償還貸款本金保險(xiǎn)費(fèi)303030303030303030303030360登記注冊費(fèi)120120設(shè)備2160021600其他列出項(xiàng)目0原材料和包裝20002000200020002000200020002000200020002000200024000稅金2974463964464464959909905945945945946883現(xiàn)金總支出920171164611196116461164612095165901659012994129941299412994235403月底現(xiàn)金-11817-81

10、63-5759-210415506455238644127448680560866349270897納稅16818增值稅3544個(gè)人稅13133城市建設(shè)稅35教育費(fèi)附加106銷售收入預(yù)測產(chǎn)品名稱123456789101112合計(jì)商品1銷售數(shù)量5965586065705315355266136425636136216974平均單價(jià)363636363636363636363636月銷售額214562008821816205201911619260189362206823112202682206822356251064商品2銷售數(shù)量5635565665725505725705615765575674

11、716681平均單價(jià)606060606060606060606060月銷售額337803336033960343203300034320342003366034560334203402028260400860商品3銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品4銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品5銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品6銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品7銷售數(shù)量0平均單價(jià)0月銷售額0000000000000合計(jì)銷售總量1159111411721142108111071096117412181120

12、1180109213655銷售總收入552365344855776548405211653580531365572857672536885608850616651924成本一303030303030303030303030成本二505050505050505050505050成本三銷售和成本計(jì)劃123456789101112合計(jì)銷售含流轉(zhuǎn)稅銷售收入552365344855776548405211653580531365572857672536885608850616651924流轉(zhuǎn)稅33143207334732903127321531883344346032213365303739115銷售凈

13、收入519225024152429515504898950365499485238454212504675272347579612809成本業(yè)主工資15001500150015001500150015001500150015001500150018000員工工資14001400140014001400140014001400140014001400140016800租金5005005005005005005005005005005005006000營銷費(fèi)用505050505050505050505050600公用事業(yè)費(fèi)202020202020202020202020240維修費(fèi)00000000

14、0000折舊費(fèi)1001001001001001001001001001001001001200貸款利息000000000000保險(xiǎn)費(fèi)1001001001001001001001001001001001001200登記注冊費(fèi)5050原材料列出0商品1178801674018180171001593016050157801839019260168901839018630209220商品2281502780028300286002750028600285002805028800278502835023550334050商品30000000000000商品40商品50總成本49750482105015

15、0493704710048320479505011051730484105041045850587360利潤21722031227921801889204519982274248220572313172925449稅費(fèi)企業(yè)所得稅0個(gè)人所得稅1841771891841691771751891991781911612172其他0凈收入(稅后)19881855209019961720186818232086228318792122156823276現(xiàn)金流量計(jì)劃123456789101112合計(jì)現(xiàn)金流入月初現(xiàn)金0697110856108321401418717194012195321649221812

16、828428215203074現(xiàn)金銷售收入05523653448557765484052116535805313655728576725368856088601308賒銷收入0貸款0其他現(xiàn)金流入6000060000可支配現(xiàn)金600006220764304666086885470833729817508977377798538197284303864382現(xiàn)今流出現(xiàn)金采購支出列出01196681841419998188101752317655173582022921186185792022920493230142229557.52919029715300302887530030299252945

17、2.53024029242.529767.524727.5350752.530賒購支出0業(yè)主工資15001500150015001500150015001500150015001500150018000員工工資14001400140014001400140014001400140014001400140016800租金5005005005005005005005005005005005006000營銷費(fèi)用505050505050505050505050600公用事業(yè)費(fèi)202020202020202020202020240維修費(fèi)0000000000000貸款利息0000000000000償還貸款

18、本金0保險(xiǎn)費(fèi)1001001001001001001001001001001001001200登記注冊費(fèi)5050設(shè)備0其他列出項(xiàng)目00稅金1841771891841691771751891991781911612172現(xiàn)金總支出530295135153472525945013751432510285344055195515695375748952625957月底現(xiàn)金69711085610832140141871719401219532164922181282842821535351238425納稅3625增值稅1397個(gè)人稅2172城市建設(shè)稅14教育費(fèi)附加42亮亮化肥銷售收入預(yù)測產(chǎn)品名稱1234

19、56789101112合計(jì)磷酸二銨銷售數(shù)量2422452482422462422422452482422462422930平均單價(jià)185185185185185185185185185185185185月銷售額447704532545880447704551044770447704532545880447704551044770542050磷肥銷售數(shù)量1141111171191111121111141151141111111360平均單價(jià)808080808080808080808080月銷售額912088809360952088808960888091209200912088808880108

20、800商品3銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品4銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品5銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品6銷售數(shù)量0平均單價(jià)0月銷售額0000000000000商品7銷售數(shù)量0平均單價(jià)0月銷售額0000000000000合計(jì)銷售總量3563563653613573543533593633563573534290銷售總收入538905420555240542905439053730536505444555080538905439053650650850成本一145145145145145145145145145

21、145145145成本二555555555555555555555555成本三銷售和成本計(jì)劃123456789101112合計(jì)銷售含流轉(zhuǎn)稅銷售收入538905420555240542905439053730536505444555080538905439053650650850流轉(zhuǎn)稅32333252331432573263322432193267330532333263321939051銷售凈收入506575095351926510335112750506504315117851775506575112750431611799成本業(yè)主工資1000100010001000100010001000

22、1000100010001000100012000員工工資7007007007007007007007007007007007008400租金5005005005005005005005005005005005006000營銷費(fèi)用100000000000100公用事業(yè)費(fèi)202020202020202020202020240維修費(fèi)000000000000折舊費(fèi)3533533533533533533533533533533533534236貸款利息000000000000保險(xiǎn)費(fèi)0000000000000登記注冊費(fèi)5050原材料列出0商品1350903552535960350903567035090

23、350903552535960350903567035090424850商品262706105643565456105616061056270632562706105610574800商品30000000000000商品40商品50總成本440834420344968442084434843823437684436844858439334434843768530676利潤65746750695868256779668366636810691767246779666381123稅費(fèi)企業(yè)所得稅0個(gè)人所得稅3793873983913893843833913963863893834656其他0凈收入(稅后)61956362656064336390629962806420652163376390628076467現(xiàn)金流量計(jì)劃123456789101112合計(jì)現(xiàn)金流入月初現(xiàn)金020697765129402003825972325913860843888494205661262146352049現(xiàn)金銷售收入05389054205552405429054390537305365