2018年可行性研究报告投资估算及财务分析全套计算表格共14个附表excle带公式只更改标红部分即可带说明

1、,资产负债表（此处无需填写，均有公式链接）,人民币单位：万元,序号,项目,计算期,1,2,3,4,5,6,7,8,9,10,111,资产,39617.2,65441.9,86292.4,101871.5,117450.5,133029.6,148608.7,164187.8,179766.9,195345.9,210925.01.1,流动资产总额,0.0,14552.1,39916.1,60008.8,80101.4,100194.1,120286.7,140379.4,160472.0,180564.7,200657.31.1.1,货币资金,0.0,8841.7,28958.9,49051.

2、6,69144.2,89236.9,109329.6,129422.2,149514.9,169607.5,189700.21.1.2,应收帐款,0.0,1903.6,3594.9,3594.9,3594.9,3594.9,3594.9,3594.9,3594.9,3594.9,3594.91.1.3,预付账款,1.1.4,存货,0.0,3806.7,7362.3,7362.3,7362.3,7362.3,7362.3,7362.3,7362.3,7362.3,7362.31.1.5,其他,1.2,在建工程,39617.2,1.3,固定资产净值,50872.3,46360.7,41849.1,

3、37337.4,32825.8,28314.2,23802.6,19290.9,14779.3,10267.71.4,无形及其他资产净值,0.0,17.6,15.6,13.7,11.7,9.8,7.8,5.9,3.9,2.0,0.02,负债及所有者权益（2.4+2.5）,39617.2,49655.6,70506.1,86085.2,101664.3,117243.3,132822.4,148401.5,163980.6,179559.7,195138.72.1,流动负债总额,0.0,559.9,1115.5,1115.5,1115.5,1115.5,1115.5,1115.5,1115.5,

4、1115.5,1115.52.1.1,短期借款,2.1.2,应付帐款,0.0,559.9,1115.5,1115.5,1115.5,1115.5,1115.5,1115.5,1115.5,1115.5,1115.52.1.3,预收账款,2.1.4,其他,2.2,建设投资借款,0.0,0.0,0.0,0.0,2.3,流动资金借款,3696.2,6997.3,6997.3,6997.3,6997.3,6997.3,6997.3,6997.3,6997.3,6997.32.4,负债小计（2.1+2.2+2.3）,0.0,4256.1,8112.8,8112.8,8112.8,8112.8,8112.

5、8,8112.8,8112.8,8112.8,8112.82.5,所有者权益,39617.2,45399.5,62393.3,77972.4,93551.5,109130.6,124709.6,140288.7,155867.8,171446.9,187026.02.5.1,资本金,39617.2,41201.3,42616.0,42616.0,42616.0,42616.0,42616.0,42616.0,42616.0,42616.0,42616.02.5.2,资本公积,0.0,419.8,1977.7,3535.6,5093.5,6651.5,8209.4,9767.3,11325.2,12883.1,14441.02.5.3,累计盈余公积金,0.0,188.9,890.0,1591.0,2292.1,2993.2,3694.2,4395.3,5096.3,5797.4,6498.42.5.4,累计未分配利润,3589.5,16909.6,30229.7,43549.8,56870.0,70190.1,83510.2,968