新設(shè)法人項(xiàng)目投資可行性研究財(cái)務(wù)模型-M

1、流動(dòng)資金估算表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期121234一流動(dòng)資產(chǎn)09542279424554445544455441應(yīng)收賬款04687137002227222272222722存貨04623136462239722397223973現(xiàn)金0232596875875875小計(jì)0954227942455444554445544二流動(dòng)負(fù)債0253175941265712657126571應(yīng)付賬款025317594126571265712657三流動(dòng)資本07011203483288732887328871自籌流動(dòng)資金0210361049866986698662融資流動(dòng)資金049081424423021230

2、2123021四流動(dòng)資本金年增加額07011133371253900其中流動(dòng)資金借款增加額049089336877700五流動(dòng)資金借款利息03671064172017201720編報(bào)資料1應(yīng)收賬款占主營(yíng)業(yè)務(wù)比率2存貨占主營(yíng)業(yè)務(wù)比率3應(yīng)付賬款占主營(yíng)業(yè)務(wù)比率56789104554445544455444554445544455442227222272222722227222272222722239722397223972239722397223978758758758758758754554445544455444554445544455441265712657126571265712657126

3、57126571265712657126571265712657328873288732887328873288732887986698669866986698669866230212302123021230212302123021000000000000172017201720172017201720流動(dòng)資金估算表生產(chǎn)投產(chǎn)期資金來(lái)源與使用表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期12123451投資總額250003017813337125390001.1建設(shè)投資2500023167000001.2建設(shè)期利息00000001.3流動(dòng)資金-自籌02103400137620001.4流動(dòng)資金-借款04908933

4、687770002資金籌措250003017813337125390002.1項(xiàng)目資本金2500025270400137620002.1.1用于建設(shè)投資2500023167000002.1.2用于建設(shè)期利息00000002.1.3用于流動(dòng)資金02103400137620002.2債務(wù)資金04908933687770002.2.1建設(shè)投資借款00000002.2.2流動(dòng)資金借款0490893368777000編報(bào)資料1建設(shè)投資2建設(shè)期利息3流動(dòng)資金-自籌4流動(dòng)資金-借款678910合計(jì)00000810540000048167000000000009866000002302100000810540

5、000058033000004816700000000000986600000230210000000000023021資金來(lái)源與使用表生產(chǎn)投產(chǎn)期總成本表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期12123451 原材料及采購(gòu)022140664211107011107011107011107012 燃料動(dòng)力0642192632103210321032103 工資及福利02223427542754275427542754 其他費(fèi)用0356710890175761757617576175765 經(jīng)營(yíng)成本028572835121357621357621357621357626 折舊費(fèi)01118430343034303

6、430343037 財(cái)務(wù)費(fèi)用0367106417201720172017208 總成本費(fèi)用030057888791417851417851417851417859固定成本07275205322787427874278742787410可變成本02278268347113911113911113911113911編報(bào)資料1原材料及采購(gòu)2燃料動(dòng)力3工資及福利4其他費(fèi)用5經(jīng)營(yíng)成本6折舊費(fèi)7財(cái)務(wù)費(fèi)用6789101107011107011107011107011107013210321032103210321042754275427542754275175761757617576175761757613

7、576213576213576213576213576243034303430343034303172017201720172017201417851417851417851417851417852787427874278742787427874113911113911113911113911113911總成本表生產(chǎn)投產(chǎn)期項(xiàng)目法人損益表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期12123451產(chǎn)品銷(xiāo)售收入032764982921638201638201638201638202總成本費(fèi)用030056888901417961417961417961417963銷(xiāo)售稅金及附加0341021701701701704營(yíng)業(yè)

8、外支出00000005利潤(rùn)總額026749300218542185421854218546所得稅0668.523255463.55463.55463.55463.57稅后利潤(rùn)02005.5697516390.516390.516390.516390.58資本公積0200.55697.51639.051639.051639.051639.059盈余公積000000010利潤(rùn)分配000000011未分配利潤(rùn)01804.956277.5 14751.45 14751.45 14751.45 14751.4512累計(jì)未分配利潤(rùn)01804.958082.4522833.9 37585.3552336.8

9、 67088.256789101638201638201638201638201638201417961417961417961417961417961701701701701700000021854218542185421854218545463.55463.55463.55463.55463.516390.516390.516390.516390.516390.51639.051639.051639.051639.051639.05000000000014751.45 14751.45 14751.45 14751.45 14751.4581839.7 96591.15 111342.6

10、126094.1 140845.5項(xiàng)目法人損益表生產(chǎn)投產(chǎn)期項(xiàng)目法人資產(chǎn)負(fù)債表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期121231資產(chǎn)25000.0059716.1085043.74119041.39125436.041.1流動(dòng)資產(chǎn)總額0.0012667.1042357.7480657.39101355.041.1.1應(yīng)收賬款0.004687.0013700.0022272.0022272.001.1.2存貨0.004623.0013646.0022397.0022397.001.1.3現(xiàn)金0.00232.00596.00875.00875.001.1.4累計(jì)現(xiàn)金盈余0.003125.1014415.74351

11、13.3955811.041.2在建工程25000.0035667.000.000.000.001.3固定資產(chǎn)凈額0.0011382.0042686.0038384.0024081.001.4無(wú)形資產(chǎn)凈額0.000.000.000.000.001.5長(zhǎng)期投資2負(fù)債及所有者權(quán)益25000.0059714.5085089.50119082.00135472.502.1流動(dòng)負(fù)債總額0.007439.0021838.0035678.0035678.002.1.1應(yīng)付賬款0.002531.007594.0012657.0012657.002.1.2流動(dòng)資金借款0.004908.0014244.00230

12、21.0023021.002.1.3其他短期借款0.000.000.000.000.002.2建設(shè)投資借款0.000.000.000.000.002.3其他長(zhǎng)期負(fù)債0.000.000.000.000.00負(fù)債小計(jì)0.007439.0021838.0035678.0035678.002.3所有者權(quán)益25000.0052275.5063251.5083404.0099794.502.3.1資本金25000.0050270.0054271.0058033.0058033.002.3.2累計(jì)資本公積0.00200.55898.052537.104176.152.3.3累計(jì)盈余公積0.000.000.0

13、00.000.002.3.4累計(jì)未分配利潤(rùn)0.001804.958082.4522833.9037585.35計(jì)算指標(biāo)資產(chǎn)負(fù)債率0.000.120.260.300.28流動(dòng)比率#DIV/0!1.701.942.262.84速動(dòng)比率#DIV/0!1.081.311.632.2145678910151831.68168226.33184619.97201016.62217411.26233766.91251314.56122052.68142750.33163447.97184145.62204843.26225540.91246238.5622272.0022272.0022272.002227

14、2.0022272.0022272.0022272.0022397.0022397.0022397.0022397.0022397.0022397.0022397.00875.00875.00875.00875.00875.00875.00875.0076508.6897206.33117903.97138601.62159299.26179996.91200694.560.000.000.000.000.000.000.0029779.0025476.0021172.0016871.0012568.008226.005076.000.000.000.000.000.000.000.00151

15、863.00168253.50184644.00201034.50217425.00233815.50250206.0035678.0035678.0035678.0035678.0035678.0035678.0035678.0012657.0012657.0012657.0012657.0012657.0012657.0012657.0023021.0023021.0023021.0023021.0023021.0023021.0023021.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00

16、0.000.000.0035678.0035678.0035678.0035678.0035678.0035678.0035678.00116185.00132575.50148966.00165356.50181747.00198137.50214528.0058033.0058033.0058033.0058033.0058033.0058033.0058033.005815.207454.259093.3010732.3512371.4014010.4515649.500.000.000.000.000.000.000.0052336.8067088.2581839.7096591.15

17、111342.60126094.05140845.500.230.210.190.180.160.150.143.424.004.585.165.746.326.902.793.373.954.535.115.696.27項(xiàng)目法人資產(chǎn)負(fù)債表生產(chǎn)投產(chǎn)期項(xiàng)目法人現(xiàn)金流量表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期121231經(jīng)營(yíng)活動(dòng)凈現(xiàn)金流量0.003492.1012354.6422417.6522417.651.1現(xiàn)金流入0.0038333.88115001.64191669.40191669.401.1.1營(yíng)業(yè)收入0.0032764.0098292.00163820.00163820.001.1.2增值稅銷(xiāo)項(xiàng)稅

18、額0.005569.8816709.6427849.4027849.401.1.3補(bǔ)貼收入0.000.000.000.000.001.1.4其他流入0.000.000.000.000.001.2現(xiàn)金流出0.0034841.78102647.00169251.75169251.751.2.1經(jīng)營(yíng)成本0.0028572.0083512.00135762.00135762.001.2.2增值稅進(jìn)項(xiàng)稅額0.004000.0811691.6819006.6819006.681.2.3營(yíng)業(yè)稅金及附加0.0031.40100.36176.85176.851.2.4增值稅0.001569.805017.968

19、842.728842.721.2.5所得稅0.00668.502325.005463.505463.501.2.6其他流出0.000.000.000.000.002投資活動(dòng)凈現(xiàn)金流量-25000.00-30178.00-13337.00-12539.000.002.1現(xiàn)金流入0.000.000.000.000.002.2現(xiàn)金流出25000.0030178.0013337.0012539.000.002.2.1建設(shè)投資25000.0023167.000.000.000.002.2.2維持運(yùn)營(yíng)投資0.000.000.000.000.002.2.3流動(dòng)資金0.007011.0013337.00125

20、39.000.002.2.4其他流出0.000.000.000.000.003籌資活動(dòng)凈現(xiàn)金流量25000.0029811.0012273.0010819.00-1720.003.1現(xiàn)金流入25000.0030178.0013337.0012539.000.003.1.1項(xiàng)目資本金投入25000.0025270.004001.003762.000.003.1.2建設(shè)投資借款0.000.000.000.000.003.1.3流動(dòng)資金借款0.004908.009336.008777.000.003.1.4短期借款0.000.000.000.000.003.2現(xiàn)金流出0.00367.001064.0

21、01720.001720.003.2.1各種利息支出0.00367.001064.001720.001720.003.2.2償還債務(wù)本金0.000.000.000.000.003.2.3利潤(rùn)分配0.000.000.000.000.004凈現(xiàn)金流量0.003125.1011290.6420697.6520697.655累計(jì)盈余資金0.003125.1011290.6420697.6520697.654567891022417.6522417.6522417.6522417.6522417.6522417.6522417.65191669.40191669.40191669.40191669.40

22、191669.40191669.40191669.40163820.00163820.00163820.00163820.00163820.00163820.00163820.0027849.4027849.4027849.4027849.4027849.4027849.4027849.400.000.000.000.000.000.000.000.000.000.000.000.000.000.00169251.75169251.75169251.75169251.75169251.75169251.75169251.75135762.00135762.00135762.00135762.0

23、0135762.00135762.00135762.0019006.6819006.6819006.6819006.6819006.6819006.6819006.68176.85176.85176.85176.85176.85176.85176.858842.728842.728842.728842.728842.728842.728842.725463.505463.505463.505463.505463.505463.505463.500.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00

24、0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00-1720.00-1720.00-1720.00-1720.00-1720.00-1720.00-1720.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00

25、0.000.000.000.000.000.000.000.000.000.000.001720.001720.001720.001720.001720.001720.001720.001720.001720.001720.001720.001720.001720.001720.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0020697.6520697.6520697.6520697.6520697.6520697.6520697.6520697.6520697.6520697.6520697.6520697.6520697.

26、6520697.65項(xiàng)目法人現(xiàn)金流量表生產(chǎn)投產(chǎn)期項(xiàng)目財(cái)務(wù)現(xiàn)金流量表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期1212341現(xiàn)金流入032764982921638201638201638201.1銷(xiāo)售收入032764982921638201638201638201.2回收固定資產(chǎn)回收0000001.3流動(dòng)資產(chǎn)回收0000001.4其他現(xiàn)金流入0000002現(xiàn)金流出2500058784969511484711359321359322.1建設(shè)投資250002316700002.2流動(dòng)資金070111333712539002.3經(jīng)營(yíng)成本028572835121357621357621357622.4銷(xiāo)售稅金及附加034

27、1021701701702.5其他現(xiàn)金流出0000003凈現(xiàn)金流量-25000-2602013411534927888278884累計(jì)凈現(xiàn)金流量-25000-51020-49679-34330-6442214465凈現(xiàn)金流量（所得稅后）-25000 -26688.5-9849885.522424.522424.5注：融資前分析5678910163820163820163820163820163820163820163820163820163820163820163820163820000000000000000000135932135932135932135932135932135932000

28、000000000135762135762135762135762135762135762170170170170170170000000278882788827888278882788827888493347722210511013299816088618877422424.522424.522424.522424.522424.522424.5項(xiàng)目財(cái)務(wù)現(xiàn)金流量表生產(chǎn)投產(chǎn)期項(xiàng)目資本金財(cái)務(wù)現(xiàn)金流量表序號(hào)科目建設(shè)期生產(chǎn)投產(chǎn)期12123451現(xiàn)金流入032764982921638201638201638201638201.1銷(xiāo)售收入032764982921638201638201638201638201.2回收固定資產(chǎn)00000001.3回收流動(dòng)資產(chǎn)00000001.4其他現(xiàn)金流入00000002現(xiàn)金流出2500054911.591004 146877.5 143115.5 143115.5 143115.52.1項(xiàng)目資本金2500025270400137620002.2借款本金償還00000002.3借款利息支付0367106417201720172017202.4經(jīng)營(yíng)成本028572835121357621357621357621357622.5銷(xiāo)售稅金及附加0341021701701701702.6所得稅0668.523255463.55463.55