水電、風電效益測算分析表

風電項目投資效益測算分析表,,,,,,,,,,,,,,,,,,,,,,

序號,項目,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21

一、,基本情況,,,,,,,,,,,,,,,,,,,,,

1,總投資（萬元）,,31438,設備購置稅,3561.799,,,,,,,,,,,,,,,,,

2,投入資本金（萬元）,6287.640221,6288,,,,,,,,,,,,,,,,,,,

,其中：集團投入,,,,,,,,,,,,,,,,,,,,,

3,貸款余額（萬元）,25150.56088,25151,23055,20959,18863,16767,14671,12575,10479,8384,6288,4192,2096,,,,,,,,

,其中：歸還貸款（萬元）,,2096,2096,2096,2096,2096,2096,2096,2096,2096,2096,2096,2096,,,,,,,,

4,折現率,8.00%,,,,,,,,,,,,,,,,,,,,

,現值系數,1.0000,0.9259,0.8573,0.7938,0.7350,0.6806,0.6302,0.5835,0.5403,0.5002,0.4632,0.4289,0.3971,0.3677,0.3405,0.3152,0.2919,0.2703,0.2502,0.2317,0.2145

5,容量(萬kW),,4.60,,,,,,,,,,,,,,,,,,,

,發電利用小時,,2020,,,,,,,,,,,,,,,,,,,

,發電量（萬千瓦時）,,9292,,,,,,,,,,,,,,,,,,,

,綜合廠用電率（%）,,5.0%,,,,,,,,,,,,,,,,,,,

,年上網電量(萬kW.h),,8827,,,,,,,,,,,,,,,,,,,

6,上網電價(元/KWH),,0.510,,,,,,,,,,,,,,,,,,,

二、,銷售收入（萬元）,,4476,4476,4476,4476,4476,4476,4476,4476,4476,4476,4440,4149,4149,4149,4149,4149,4149,4149,4149,4149

,售電收入（萬元）,,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149,4149

,其他收入（增值稅抵扣）（萬元）,,327,327,327,327,327,327,327,327,327,327,291,,,,,,,,,

,,,327.07,654.13,981.20,1308.27,1635.33,1962.40,2289.47,2616.53,2943.60,3270.66,3561.80,,,,,,,,,

三、,總成本費用（萬元）,,4394,4247,4256,4108,3961,3813,3665,3517,3527,3379,3231,3083,2936,2936,3093,2675,1103,1103,1103,1103

1,折舊(萬元),,1990,1990,1990,1990,1990,1990,1990,1990,1990,1990,1990,1990,1990,1990,1990,1572,,,,

2,營運成本(萬元),,561,561,718,718,718,718,718,718,875,875,875,875,875,875,1032,1032,1032,1032,1032,1032

,其中：材料（萬元）,,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92,92.92

,修理（萬元）,,157,157,314,314,314,314,314,314,472,472,472,472,472,472,629,629,629,629,629,629

,職工薪酬（萬元）,,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82,104.82

,其他費用（萬元）,,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50,111.50

,保險費用（萬元）,,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31,94.31

4,財務費用（萬元）,,1773,1625,1478,1330,1182,1034,887,739,591,443,296,148,0,0,0,0,0,0,0,0

5,稅金及附加（萬元）,,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71,71

四、,利潤總額（萬元）,,82,230,220,368,516,664,811,959,950,"1,097","1,209","1,066","1,214","1,214","1,056","1,475","3,046","3,046","3,046","3,046"

1,所得稅（萬元）,,10,29,28,-,-,-,203,240,237,274,302,266,303,303,264,369,762,762,762,762

2,凈利潤（萬元）,,72,201,193,368,516,664,608,719,712,823,907,799,910,910,792,"1,106","2,285","2,285","2,285","2,285"

五、,現金流量（萬元）,-6287.640221,-34,95,87,262,410,558,503,613,606,717,801,694,"2,900","2,900","2,782","2,678","2,285","2,285","2,285","2,285"

,凈流量（萬元）,-6287.640221,-34,95,87,262,410,558,503,613,606,717,801,694,"2,900","2,900","2,782","2,678","2,285","2,285","2,285","2,285"

,現值（萬元）,"-6,288",-32,82,69,193,279,351,293,331,303,332,344,275,"1,066",987,877,782,618,572,529,490

,全現金流,"-31,438","3,835","3,816","3,660","3,688","3,688","3,688","3,485","3,448","3,293","3,256","3,192","2,937","2,900","2,900","2,782","2,678","2,285","2,285","2,285","2,285"

,累計凈現值（NPV）（萬元）,"2,455",,,,,,,,,,,,,,,,,,,,

,自有資金投資回報率,10.76%,,,,,,,,,,,,,,,,,,,,

,全投資回報率,8.63%,,,,,,,,,,,,,,,,,,,,

,累計現金流量（萬元）,-6287.640221,"-6,322","-6,227","-6,140","-5,878","-5,468","-4,910","-4,407","-3,794","-3,188","-2,471","-1,669",-976,"1,924","4,824","7,607","10,285","12,569","14,854","17,139","19,424"

,投資回收期(年),13.34,,,,,,,,,,,,,,,,,,,,

,EVA（萬元）,,-44.65,70.23,47.57,208.45,341.80,475.15,405.68,502.09,480.61,577.02,646.48,524.54,620.95,620.95,503.06,816.65,"1,995.58","1,995.58","1,995.58","1,995.58"

,經營期內EVA,,"14,778.87",,,,,,,,,,,,,,,,,,,

,EVA率,,-0.14%,0.24%,0.17%,0.83%,1.48%,2.27%,2.15%,2.99%,3.28%,4.59%,6.17%,6.26%,9.88%,9.88%,8.00%,12.99%,31.74%,31.74%,31.74%,31.74%

,"風電還貸期設定為12年,設備購置成本按照總投資70%考慮,未考慮CDM收入,所得稅按“減三免三”計算。如前期折舊、利潤不足以還貸的情況下需適當增加資本金至30%比例。",,,,,,,,,,,,,,,,,,,,,

,IRR=k·IRRm+(1-k)IL,IRR全投資回報率，IRRM自有資金回報率，IL銀行利率，K自有資金百分比；IRR>IL時，IRRm>IRR；IRR<IL時，IRRm<IRR,,,,,,,,,,,,,,,,,,,,

,"資本金內部收益率其實質就是使技資方案在計算期內各年凈現金流量的現值累計等于零時的折現率。其數學表達式為：中FIRR—財務內部收益率。

",,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,