說(shuō)明：本表中黃色標(biāo)注的格子可以根據(jù)實(shí)際情況修改，其他格子有公式自動(dòng)生成無(wú)需改動(dòng),,,,,,,,,

分布式光伏發(fā)電投資回報(bào)表,,,,年限,首年收益,發(fā)電比例,年收益,累計(jì)收益,去本收益

序號(hào),項(xiàng)目?jī)?nèi)容,數(shù)值,,1,22292.01,100.00%,22292.01,22292.01,-67707.99

,項(xiàng)目地點(diǎn),蘇州,,2,22292.01,99.30%,22135.97,44427.98,-45572.02

,平均日照時(shí)數(shù)（h）,3.9,,3,22292.01,98.60%,21979.92,66407.90,-23592.10

1,裝機(jī)容量（KW）,10,,4,22292.01,97.90%,21823.88,88231.78,-1768.22

2,項(xiàng)目運(yùn)行期限（年）,25,,5,22292.01,97.20%,21667.83,109899.61,19899.61

3,平均年發(fā)電量（KWH),14235.00,,6,22292.01,96.50%,21511.79,131411.40,41411.40

,國(guó)家補(bǔ)貼（元/KWH）,0.42,,7,22292.01,95.80%,21355.75,152767.14,62767.14

,地方補(bǔ)貼（元/KWH）,0.10,,8,22292.01,95.10%,21199.70,173966.85,83966.85

4,自發(fā)自用比例,80.00%,,9,22292.01,94.40%,21043.66,195010.50,105010.50

,買電價(jià)格（元/KWH）,1.20,,10,22292.01,93.70%,20887.61,215898.12,125898.12

5,賣電價(jià)格（元/KWH）,0.43,,11,22292.01,93.00%,20731.57,236629.69,146629.69

6,自發(fā)自用平均電價(jià)（元/KWH）,1.72,,12,22292.01,92.30%,20575.53,257205.21,167205.21

8,上網(wǎng)電價(jià)（元/KWH）,0.95,,13,22292.01,91.60%,20419.48,277624.69,187624.69

9,年均售電收入（元）,22292.01,,14,22292.01,90.90%,20263.44,297888.13,207888.13

,年均發(fā)電量衰減率,0.70%,,15,22292.01,90.20%,20107.39,317995.52,227995.52

10,25年發(fā)電銷售收入總額（元）,510487.03,,16,22292.01,89.50%,19951.35,337946.87,247946.87

11,項(xiàng)目投資總額(元),90000,,17,22292.01,88.80%,19795.30,357742.18,267742.18

13,投資回收期（年）,<5,,18,22292.01,88.10%,19639.26,377381.44,287381.44

,,,,19,22292.01,87.40%,19483.22,396864.65,306864.65

,,,,20,22292.01,86.70%,19327.17,416191.83,326191.83

,,,,21,22292.01,86.00%,19171.13,435362.96,345362.96

,,,,22,22292.01,85.30%,19015.08,454378.04,364378.04

,,,,23,22292.01,84.60%,18859.04,473237.08,383237.08

,,,,24,22292.01,83.90%,1