新设法人项目投资可行性研究财务模型-M

1、流动资金估算表序号科目建设期生产投产期121234一流动资产09542279424554445544455441应收账款04687137002227222272222722存货04623136462239722397223973现金0232596875875875小计0954227942455444554445544二流动负债0253175941265712657126571应付账款025317594126571265712657三流动资本07011203483288732887328871自筹流动资金0210361049866986698662融资流动资金049081424423021230

2、2123021四流动资本金年增加额07011133371253900其中流动资金借款增加额049089336877700五流动资金借款利息03671064172017201720编报资料1应收账款占主营业务比率2存货占主营业务比率3应付账款占主营业务比率56789104554445544455444554445544455442227222272222722227222272222722239722397223972239722397223978758758758758758754554445544455444554445544455441265712657126571265712657126

3、57126571265712657126571265712657328873288732887328873288732887986698669866986698669866230212302123021230212302123021000000000000172017201720172017201720流动资金估算表生产投产期资金来源与使用表序号科目建设期生产投产期12123451投资总额250003017813337125390001.1建设投资2500023167000001.2建设期利息00000001.3流动资金-自筹02103400137620001.4流动资金-借款04908933

4、687770002资金筹措250003017813337125390002.1项目资本金2500025270400137620002.1.1用于建设投资2500023167000002.1.2用于建设期利息00000002.1.3用于流动资金02103400137620002.2债务资金04908933687770002.2.1建设投资借款00000002.2.2流动资金借款0490893368777000编报资料1建设投资2建设期利息3流动资金-自筹4流动资金-借款678910合计00000810540000048167000000000009866000002302100000810540

5、000058033000004816700000000000986600000230210000000000023021资金来源与使用表生产投产期总成本表序号科目建设期生产投产期12123451 原材料及采购022140664211107011107011107011107012 燃料动力0642192632103210321032103 工资及福利02223427542754275427542754 其他费用0356710890175761757617576175765 经营成本028572835121357621357621357621357626 折旧费01118430343034303

6、430343037 财务费用0367106417201720172017208 总成本费用030057888791417851417851417851417859固定成本07275205322787427874278742787410可变成本02278268347113911113911113911113911编报资料1原材料及采购2燃料动力3工资及福利4其他费用5经营成本6折旧费7财务费用6789101107011107011107011107011107013210321032103210321042754275427542754275175761757617576175761757613

7、576213576213576213576213576243034303430343034303172017201720172017201417851417851417851417851417852787427874278742787427874113911113911113911113911113911总成本表生产投产期项目法人损益表序号科目建设期生产投产期12123451产品销售收入032764982921638201638201638201638202总成本费用030056888901417961417961417961417963销售税金及附加0341021701701701704营业

8、外支出00000005利润总额026749300218542185421854218546所得税0668.523255463.55463.55463.55463.57税后利润02005.5697516390.516390.516390.516390.58资本公积0200.55697.51639.051639.051639.051639.059盈余公积000000010利润分配000000011未分配利润01804.956277.5 14751.45 14751.45 14751.45 14751.4512累计未分配利润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项目法人损益表生产投产期项目法人资产负债表序号科目建设期生产投产期121231资产25000.0059716.1085043.74119041.39125436.041.1流动资产总额0.0012667.1042357.7480657.39101355.041.1.1应收账款0.004687.0013700.0022272.0022272.001.1.2存货0.004623.0013646.0022397.0022397.001.1.3现金0.00232.00596.00875.00875.001.1.4累计现金盈余0.003125.1014415.74351

11、13.3955811.041.2在建工程25000.0035667.000.000.000.001.3固定资产净额0.0011382.0042686.0038384.0024081.001.4无形资产净额0.000.000.000.000.001.5长期投资2负债及所有者权益25000.0059714.5085089.50119082.00135472.502.1流动负债总额0.007439.0021838.0035678.0035678.002.1.1应付账款0.002531.007594.0012657.0012657.002.1.2流动资金借款0.004908.0014244.00230

12、21.0023021.002.1.3其他短期借款0.000.000.000.000.002.2建设投资借款0.000.000.000.000.002.3其他长期负债0.000.000.000.000.00负债小计0.007439.0021838.0035678.0035678.002.3所有者权益25000.0052275.5063251.5083404.0099794.502.3.1资本金25000.0050270.0054271.0058033.0058033.002.3.2累计资本公积0.00200.55898.052537.104176.152.3.3累计盈余公积0.000.000.0

13、00.000.002.3.4累计未分配利润0.001804.958082.4522833.9037585.35计算指标资产负债率0.000.120.260.300.28流动比率#DIV/0!1.701.942.262.84速动比率#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项目法人资产负债表生产投产期项目法人现金流量表序号科目建设期生产投产期121231经营活动净现金流量0.003492.1012354.6422417.6522417.651.1现金流入0.0038333.88115001.64191669.40191669.401.1.1营业收入0.0032764.0098292.00163820.00163820.001.1.2增值税销项税

18、额0.005569.8816709.6427849.4027849.401.1.3补贴收入0.000.000.000.000.001.1.4其他流入0.000.000.000.000.001.2现金流出0.0034841.78102647.00169251.75169251.751.2.1经营成本0.0028572.0083512.00135762.00135762.001.2.2增值税进项税额0.004000.0811691.6819006.6819006.681.2.3营业税金及附加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投资活动净现金流量-25000.00-30178.00-13337.00-12539.000.002.1现金流入0.000.000.000.000.002.2现金流出25000.0030178.0013337.0012539.000.002.2.1建设投资25000.0023167.000.000.000.002.2.2维持运营投资0.000.000.000.000.002.2.3流动资金0.007011.0013337.00125

20、39.000.002.2.4其他流出0.000.000.000.000.003筹资活动净现金流量25000.0029811.0012273.0010819.00-1720.003.1现金流入25000.0030178.0013337.0012539.000.003.1.1项目资本金投入25000.0025270.004001.003762.000.003.1.2建设投资借款0.000.000.000.000.003.1.3流动资金借款0.004908.009336.008777.000.003.1.4短期借款0.000.000.000.000.003.2现金流出0.00367.001064.0

21、01720.001720.003.2.1各种利息支出0.00367.001064.001720.001720.003.2.2偿还债务本金0.000.000.000.000.003.2.3利润分配0.000.000.000.000.004净现金流量0.003125.1011290.6420697.6520697.655累计盈余资金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项目法人现金流量表生产投产期项目财务现金流量表序号科目建设期生产投产期1212341现金流入032764982921638201638201638201.1销售收入032764982921638201638201638201.2回收固定资产回收0000001.3流动资产回收0000001.4其他现金流入0000002现金流出2500058784969511484711359321359322.1建设投资250002316700002.2流动资金070111333712539002.3经营成本028572835121357621357621357622.4销售税金及附加034

27、1021701701702.5其他现金流出0000003净现金流量-25000-2602013411534927888278884累计净现金流量-25000-51020-49679-34330-6442214465净现金流量（所得税后）-25000 -26688.5-9849885.522424.522424.5注：融资前分析5678910163820163820163820163820163820163820163820163820163820163820163820163820000000000000000000135932135932135932135932135932135932000

28、000000000135762135762135762135762135762135762170170170170170170000000278882788827888278882788827888493347722210511013299816088618877422424.522424.522424.522424.522424.522424.5项目财务现金流量表生产投产期项目资本金财务现金流量表序号科目建设期生产投产期12123451现金流入032764982921638201638201638201638201.1销售收入032764982921638201638201638201638201.2回收固定资产00000001.3回收流动资产00000001.4其他现金流入00000002现金流出2500054911.591004 146877.5 143115.5 143115.5 143115.52.1项目资本金2500025270400137620002.2借款本金偿还00000002.3借款利息支付0367106417201720172017202.4经营成本028572835121357621357621357621357622.5销售税金及附加0341021701701701702.6所得税0668.523255463.55463.55