用电子表格和现金流量表计算投资项目财务指标FIRR-FNPV-Pt(新建项目)

投资项目财务现金流量表（新建项目）,,,,,,,,,,,,,,,,,,,,,,,

单位：万元,,,,,,,,,,,,,,,,,,,,,,,

序号,项目,,计算期（年）,,,,,,,,,,,,,,,,,,,,

,,,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

1,生产负荷（%）,,50.00,,,,,,,,100.00,,100.00,,,,,,,,,,

2,1.现金流入,,-,"7,285.00","8,540.00","8,216.00","9,114.00","9,653.00","11,289.00","11,444.00","14,370.00","15,276.00","18,417.00",-,-,-,-,-,-,-,-,-,-

3,1.1.产品销售收入,,,"5,920.00","7,252.00","6,890.00","7,925.00","8,321.00","9,869.00","10,006.00","12,890.00","13,542.00","15,840.00",,,,,,,,,,

4,1.2.回收固定资产余值,,,25.00,10.00,3.00,21.00,33.00,54.00,29.00,32.00,56.00,77.00,,,,,,,,,,

5,1.3.回收流动资金,,,"1,340.00","1,278.00","1,323.00","1,168.00","1,299.00","1,366.00","1,409.00","1,448.00","1,678.00","2,500.00",,,,,,,,,,

6,1.4.其他现金流入,,,,,,,,,,,,,,,,,,,,,,

7,2.现金流出,,"12,032.00","6,465.00","6,300.00","5,813.00","6,745.00","7,076.00","6,666.00","7,227.00","8,023.00","11,159.00","12,506.00",-,-,-,-,-,-,-,-,-,-

8,2.1.固定资产投资,,"10,769.00",367.00,445.00,,,340.00,,,,,,,,,,,,,,,

9,2.2.流动资金,,500.00,600.00,700.00,480.00,670.00,380.00,543.00,890.00,998.00,690.00,"1,203.00",,,,,,,,,,

10,2.3.经营成本,,763.00,"5,218.00","4,890.00","5,008.00","5,698.00","6,005.00","5,932.00","5,990.00","6,709.00","9,980.00","10,987.00",,,,,,,,,,

11,2.4.销售税金及附加,,,67.00,67.00,69.00,56.00,31.00,45.00,39.00,87.00,54.00,87.00,,,,,,,,,,

12,2.5.所得税,,,213.00,198.00,256.00,321.00,320.00,146.00,308.00,229.00,435.00,229.00,,,,,,,,,,

13,2.6.增值税,,,,,,,,,,,,,,,,,,,,,,

14,2.7.其他现金流出,,,,,,,,,,,,,,,,,,,,,,

15,3.净现金流量,,"-12,032.00",820.00,"2,240.00","2,403.00","2,369.00","2,577.00","4,623.00","4,217.00","6,347.00","4,117.00","5,911.00",-,-,-,-,-,-,-,-,-,-

16,4.累计净现金流量,,"-12,032.00","-11,212.00","-8,972.00","-6,569.00","-4,200.00","-1,623.00","3,000.00","7,217.00","13,564.00","17,681.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00","23,592.00"

17,,,-8.31E-05,-8.92E-05,-1.11E-04,-1.52E-04,-2.38E-04,-6.16E-04,3.33E-04,1.39E-04,7.37E-05,5.66E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05,4.24E-05

18,计算指标：,,,,,,,,,,,,,,,,,,,,,,

19,项目财务内部收益率（%）,,19.4991,,,,,,,,,,,,,,,,,,,,

20,项目财务净现值（ic=%）,,"2,880.7644",指定ic=,15.0000,,,,,,,,,,,,,,,,,,

21,项目投资回收期（年）,,5.54,,,,,,,,,,,,,,,,,,,,

,,,19.4991,"2,880.7644",6,3.00E+0