分布式光伏电站投资回报收益计算表格.xls

分布式光伏电站投资回报收益计算表格.xls

《分布式光伏电站投资回报收益计算表格.xls》由会员分享，可在线阅读，更多相关《分布式光伏电站投资回报收益计算表格.xls（2页珍藏版）》请在冰点文库上搜索。

分分布布式式光光伏伏电电站站投投资资回回报报收收益益表表数数据据录录入入provincia安装地点浙江用户类型屋顶平均年损耗-kWh/年自发自用比例脱硫煤标杆电价工业电价折扣工业电价计算电价销售（不含税）0.74元/kWh自自发发自自用用80.0%0.4570.8290%（0.941*6+0.457*2）/8电价补贴0.52元/kWh政政府府上上网网20.0%国家度电补贴（20年）浙江省度电补贴（20）年宁波市度电补贴（5年0.1转换成20年）光照条件1,091kWh/Kw0.420.1上网电价0.977自发自用电价1.258电电站站数数据据装机容量（MW）0.51MW年最大发电量556,410kWh电站发电损失其他潜在损耗每kw年净发电量1,091kWh电站年净发电量556,410kWh发电量年度损失0.80%使用寿命25年经经济济性性分分析析原始投资3,487元/kW3,487,179元每W造价8投资金额（含税）4,080,000所得税低扣管理成本20,400元/年0.50%维护成本20,400元/年0.50%欧洲的费用在15-25欧元/kW，国内按投资额的1%来计算或收入的4%来测算约80元/Kw维修年限年年度保险费用4,080元/年0.10%按按千分之一来计算保险年限25年售电价格0.74元/kWh年电价上涨幅度电价补贴0.520元/kWh宁波市5年补贴0.1贷贷款款贷款比例70%贷款金额2,856,000元年利率7.00%贷款期限10年预计分期偿债准备金（年）-406,630元电电站站收收益益分分析析年自发自用发电量480511.7838476667.6895472823.5952468979.501465135.4067427322.88423761.856420200.832416639.808413078.784409517.76405956.736402395.712398834.688395273.664391712.64388151.616384590.592381029.568377468.544373907.52年上网发电量122672.174121690.7966120709.4192119728.0418118746.6644106830.72105940.464105050.208104159.952103269.696102379.44101489.184100598.92899708.67298818.41697928.1697037.90496147.64895257.39294367.13693476.88年总发电量603183.9578598358.4861593533.0145588707.5428583882.0711534153.6529702.32525251.04520799.76516348.48511897.2507445.92502994.64498543.36494092.08489640.8485189.52480738.24476286.96471835.68467384.4平均年发电量（万KWH）51.2199754925年总发电量（万KWH）1280.499387年年0123456789101112131415161718192021收收入入电价销售收入￥604,484￥599,648￥594,812￥589,976￥585,140￥537,572￥533,092￥528,613￥524,133￥519,653￥515,173￥510,694￥506,214￥501,734￥497,254￥492,775￥488,295￥483,815￥479,335￥474,855￥275,944上网电价补贴收入￥119,851￥118,892￥117,933￥116,974￥116,015￥104,374￥103,504￥102,634￥101,764￥100,894￥100,025￥99,155￥98,285￥97,415￥96,546￥95,676￥94,806￥93,936￥93,066￥92,197￥42,719发发电电收收入入合合计计￥724,335￥718,540￥712,745￥706,951￥701,156￥641,946￥636,596￥631,247￥625,897￥620,548￥615,198￥609,849￥604,499￥599,149￥593,800￥588,450￥583,101￥577,751￥572,402￥567,052￥318,6632525年年售售电电总总额额（万万）1419.417489税税务务成成本本进项税￥414,974￥309,729￥205,326￥101,765-￥955销项税-￥105,245-￥104,403-￥103,561-￥102,719-￥101,877-￥93,274-￥92,497-￥91,720-￥90,942-￥90,165-￥89,388-￥88,610-￥87,833-￥87,056-￥86,279-￥85,501-￥84,724-￥83,947-￥83,169-￥82,392-￥46,301其他税项-￥942-￥934-￥927-￥919-￥912-￥835-￥828-￥821-￥814-￥807-￥800-￥793-￥786-￥779-￥772-￥765-￥758-￥751-￥744-￥737-￥414增值税-￥103,674-￥101,877-￥93,274-￥92,497-￥91,720-￥90,942-￥90,165-￥89,388-￥88,610-￥87,833-￥87,056-￥86,279-￥85,501-￥84,724-￥83,947-￥83,169-￥82,392-￥46,301营业税金及附加-￥10,367-￥10,188-￥9,327-￥9,250-￥9,172-￥9,094-￥9,017-￥8,939-￥8,861-￥8,783-￥8,706-￥8,628-￥8,550-￥8,472-￥8,395-￥8,317-￥8,239-￥4,630税税务务成成本本-￥942-￥934-￥927-￥114,960-￥112,977-￥103,436-￥102,574-￥101,712-￥100,850-￥99,988-￥99,126-￥98,264-￥97,402-￥96,540-￥95,678-￥94,816-￥93,954-￥93,093-￥92,231-￥91,369-￥51,346营营业业成成本本管理成本-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400维修成本-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400-￥20,400保险-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080-￥4,080总总营营业业成成本本-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880-44,880利利润润收收入入（无无融融资资）￥678,513￥672,726￥666,939￥547,110￥543,299￥493,630￥489,142￥484,655￥480,167￥475,679￥471,192￥466,704￥462,217￥457,729￥453,241￥448,754￥444,266￥439,779￥435,291￥430,804￥222,437净净利利润润（无无融融资资）￥508,885￥504,544￥500,204￥410,333￥407,474￥370,222￥366,857￥363,491￥360,125￥356,760￥353,394￥350,028￥346,662￥343,297￥339,931￥336,565￥333,200￥329,834￥326,468￥323,103￥166,828现现金金流流量量表表（无无融融资资）-￥4,080,000￥678,513￥672,726￥666,939￥547,110￥543,299￥493,630￥489,142￥484,655￥480,167￥475,679￥471,192￥466,704￥462,217￥457,729￥453,241￥448,754￥444,266￥439,779￥435,291￥430,804￥222,437现现金金流流量量累累进进（无无融融资资）-￥4,080,000-￥3,401,487-￥2,728,761-￥2,061,823-￥1,514,713-￥971,413-￥477,784￥11,358￥496,013￥976,180￥1,451,859￥1,923,051￥2,389,755￥2,851,972￥3,309,701￥3,762,942￥4,211,696￥4,655,962￥5,095,741￥5,531,032￥5,961,836￥6,184,273财财务务费费用用年年分分期期贷贷款款额额-￥406,630-￥406,630-￥406,630-￥406,630-￥406,630-￥406,630-￥406,630-￥406,630-￥406,630-￥406,630￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0年年贷贷款款偿偿付付金金（绝绝对对值值）￥406,630￥406,630￥406,630￥406,630￥406,630￥406,630￥406,630￥406,630￥406,630￥406,630￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0贷贷款款利利息息-￥199,920-￥185,450-￥169,968-￥153,401-￥135,675-￥116,708-￥96,414-￥74,699-￥51,464-￥26,602￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0每每年年偿偿还还资资本本金金-￥206,710-￥221,180-￥236,662-￥253,229-￥270,955-￥289,922-￥310,216-￥331,931-￥355,167-￥380,028￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0财财务务费费用用总总和和-￥199,920-￥185,450-￥169,968-￥153,401-￥135,675-￥116,708-￥96,414-￥74,699-￥51,464-￥26,602￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0电电费费收收入入及及各各费费用用之之和和（融融资资期期）-￥331,659-￥332,618-￥333,577-￥334,536-￥335,495-￥347,137-￥348,006-￥348,876-￥349,746-￥350,616￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0￥0MANCATOESBORSO+VENDUTA#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

00000000000I财财务务比比率率贴贴现现率率8.00%净净现现值值（无无融融资资）￥1,242,799净净现现值值（融融资资）￥3,060,993回回报报率率（无无融融资资）12.4%年年份份衰衰减减后后有有效效利利用用年年发发电电量量按按照照10%10%优优惠惠备备注注小小时时数数（hh）（万万kWhkWh）节节约约电电费费第1年1000.40206.0717.10第2年1135.69204.4216.97第3年1126.61202.7916.83第4年1117.59201.1716.70第5年1108.65199.5616.56第6年1099.78197.9616.43第7年1090.98196.3816.30第8年1082.26194.8116.17第9年1073.60193.2516.04第10年1065.01191.7015.91第11年1056.49190.1715.78第12年1048.04188.6515.66第13年1039.65187.1415.53第14年1031.34185.6415.41第15年1023.09184.1615.28第16年1014.90182.6815.16第17年1006.78181.2215.04第18年998.73179.7714.92第19年990.74178.3314.80第20年982.81176.9114.68第21年974.95175.4914.57第22年967.15174.0914.45第23年959.41172.6914.33第24年951.74171.3114.22第25年944.12169.9414.11合计26034.964686.29388.96