水电、风电效益测算分析表

风电项目投资效益测算分析表,,,,,,,,,,,,,,,,,,,,,,

序号,项目,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—财务内部收益率。

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

,,,,,,,