儲(chǔ)能項(xiàng)目用戶(hù)側(cè)投資測(cè)算表

,,,,,,,,,,,,,,,,,,,,,,,,,,,,補(bǔ)貼上限,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,5年等額本金貸款,,,,,,0,,,,,,,,

,必填,Input,額定功率,8500,kw,,YEAR,容量保持率,充電電量,放電電量,谷時(shí)充電費(fèi)用,平時(shí)充電費(fèi)用,放電收入,峰谷電價(jià)所得,年電費(fèi)差收入,運(yùn)維費(fèi)用,保險(xiǎn)費(fèi)用,增值稅,折舊,經(jīng)營(yíng)所得(元),自有資金,每年還款,貸款余額,當(dāng)年利息(元),稅前利潤(rùn),所得稅(元),凈利潤(rùn)(元),補(bǔ)貼（元/kwh）,補(bǔ)貼（元/年）,補(bǔ)貼后凈利潤(rùn),現(xiàn)金流,累計(jì)現(xiàn)金流,IRR(10年),IRR(15年),NPV,靜態(tài)回收年限

,參考,,額定容量,25500,kwh,,0,100%,,,,,,,,,,0%,,,11475000,,26775000,,,25%,,0,0,,-11475000,-11475000,5%,12%,,

,,,系統(tǒng)設(shè)備價(jià)格,1500,元/kWh,,1,97.0%,25800.28,22075.36,5418.06,11610.13,36093.22,19065.04,6291461.91,-36000,-11475,0.00,-2550000,3693986.91,,-5355000,21420000,-1606500,2087486.91,-521871.73,1565615.18,0,0,1565615.18,-1239384.82,-12714385,,,-12644230.96,

,,,系統(tǒng)設(shè)備總價(jià),38250000,元,,2,94.1%,25022.46,21409.84,5254.72,11260.11,35005.09,18490.27,6101788.84,-36000,-11475,0.00,-2550000,3504313.84,,-5355000,16065000,-1285200,2219113.84,-554778.46,1664335.38,0,0,1664335.38,-1140664.62,-13855049,,,-3423803.232,

,,,施工費(fèi)用,510000,元/年,,3,91.1%,24244.64,20744.32,5091.37,10910.09,33916.97,17915.50,5912115.78,-36000,-11475,0.00,-2550000,3314640.78,,-5355000,10710000,-963900,2350740.78,-587685.19,1763055.58,0,0,1763055.58,-1041944.42,-14896994,,,-4199919.652,

,,,運(yùn)維費(fèi)用,36000,元/年,,4,88.1%,23466.82,20078.80,4928.03,10560.07,32828.84,17340.74,5722442.72,-36000,-11475,0.00,-2550000,3124967.72,,-5355000,5355000,-642600,2482367.72,-620591.93,1861775.79,0,0,1861775.79,-943224.21,-15840218,,,-4848321.372,

,,,保險(xiǎn)費(fèi)用,11475,元/年,,5,85.2%,22689.00,19413.28,4764.69,10210.05,31740.71,16765.97,5532769.65,-36000,-11475,0.00,-2550000,2935294.65,,-5355000,0,-321300,2613994.65,-653498.66,1960495.99,0,0,1960495.99,-844504.01,-16684722,,,-5380663.694,

,,,峰時(shí)電價(jià),1.09,元/kwh,,6,82.2%,21911.19,18747.76,4601.35,9860.03,30652.58,16191.20,5343096.59,-36000,-11475,0.00,-2550000,2745621.59,,0,0,0,2745621.59,-686405.40,2059216.19,0,0,2059216.19,4609216.19,-12075506,,,-2032627.955,

,,,平時(shí)電價(jià),0.9,元/kwh,,7,79.2%,21133.37,18082.24,4438.01,9510.01,29564.46,15616.43,5153423.52,-36000,-11475,0.00,-2550000,2555948.52,,0,0,0,2555948.52,-638987.13,1916961.39,0,0,1916961.39,4466961.39,-7608544,,,6391876.699,

,,,谷時(shí)電價(jià),0.21,元/kwh,,8,88.1%,21911.19,18747.76,4601.35,9860.03,30652.58,16191.20,5343096.59,-36000,-11475,0.00,-2550000,2745621.59,,0,0,0,2745621.59,-686405.40,2059216.19,0,0,2059216.19,4609216.19,-2999328,,,9141501.161,

,,,充放電深度,95%,,,9,95.5%,24050.19,20577.94,5050.54,10822.58,33644.93,17771.81,5864697.51,-36000,-11475,0.00,-2550000,3267222.51,,0,0,0,3267222.51,-816805.63,2450416.89,0,0,2450416.89,5000416.89,2001089,,,12243495.03,8.608175784

,,,系統(tǒng)綜合效率,85%,,,10,92.6%,24633.55,21077.08,5173.05,11085.10,34461.03,18202.89,6006952.31,-36000,-11475,0.00,-2550000,3409477.31,,0,0,0,3409477.31,-852369.33,2557107.98,0,0,2557107.98,5107107.98,7108197,,,15486478.15,

,,,充電效率,92.5%,,,11,89.6%,23855.73,20411.56,5009.70,10735.08,33372.90,17628.12,5817279.25,-36000,-11475,0.00,-2550000,3219804.25,,0,0,0,3219804.25,-804951.06,2414853.19,0,0,2414853.19,4964853.19,12073050,,,18208591.97,

,,,放電效率,92.5%,,,12,86.6%,23077.91,19746.04,4846.36,10385.06,32284.77,17053.35,5627606.18,-36000,-11475,0.00,-2550000,3030131.18,,0,0,0,3030131.18,-757532.80,2272598.39,0,0,2272598.39,4822598.39,16895648,,,20463020.82,

,,,自有資金比例,30%,,,13,83.7%,22300.09,19080.52,4683.02,10035.04,31196.65,16478.59,5437933.12,-36000,-11475,0.00,-2550000,2840458.12,,0,0,0,2840458.12,-710114.53,2130343.59,0,0,2130343.59,4680343.59,21575992,,,22515093.74,

,,,折現(xiàn)率,6%,,,14,80.7%,21522.28,18415.00,4519.68,9685.02,30108.52,15903.82,5248260.06,-36000,-11475,0.00,-2550000,2650785.06,,0,0,0,2650785.06,-662696.26,1988088.79,0,0,1988088.79,4538088.79,26114081,,,24380039.99,

,,,年運(yùn)行天數(shù),330,天,,15,77.7%,20744.46,17749.48,4356.34,9335.01,29020.39,15329.05,5058586.99,-36000,-11475,0.00,-2550000,2461111.99,,0,0,0,2461111.99,-615278.00,1845833.99,0,0,1845833.99,4395833.99,30509915,,,26072013.13,

,,,每天循環(huán)次數(shù),1.5,次,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,谷充電,1,次,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,平充電,0.5,次,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,運(yùn)營(yíng)年限,15,年,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,循環(huán)壽命@70%EOL,5000,次,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,是否更換電池,是,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,更換電池成本（假設(shè)）,600,元/wh,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,更換電池總成本（假設(shè)）,15300000,元,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

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

,,Output,自有資金,11475000,元,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,貸款金額,26775000,元,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,IRR_10年,\,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,IRR_15年,