用電子表格和現(xiàn)金流量表計算投資項目財務指標FIRR-FNPV-Pt(新建項目)

投資項目財務現(xiàn)金流量表（新建項目）,,,,,,,,,,,,,,,,,,,,,,,

單位：萬元,,,,,,,,,,,,,,,,,,,,,,,

序號,項目,,計算期（年）,,,,,,,,,,,,,,,,,,,,

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

1,生產(chǎn)負荷（%）,,50.00,,,,,,,,100.00,,100.00,,,,,,,,,,

2,1.現(xiàn)金流入,,-,"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.產(chǎn)品銷售收入,,,"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.回收固定資產(chǎn)余值,,,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.其他現(xiàn)金流入,,,,,,,,,,,,,,,,,,,,,,

7,2.現(xiàn)金流出,,"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.固定資產(chǎn)投資,,"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.經(jīng)營成本,,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.其他現(xiàn)金流出,,,,,,,,,,,,,,,,,,,,,,

15,3.凈現(xiàn)金流量,,"-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.累計凈現(xiàn)金流量,,"-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,項目財務凈現(xiàn)值（ic=%）,,"2,880.7644",指定ic=,15.0000,,,,,,,,,,,,,,,,,,

21,項目投資回收期（年）,,5.54,,,,,,,,,,,,,,,,,,,,

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