| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | シナリオ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
2 | 敷地面積(m2) | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 |
3 | 敷設率 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 |
4 | 設置面積(m2) | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 |
5 | 太陽光密度(KW/m2) | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
6 | 発電効率 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 |
7 | 発電力(kW) | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 |
8 | 発電時間/日 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
9 | 発電量(KWh/日) | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 |
10 | 売電価格(円/KWh) | 40 | 20 | 10 | 40 | 20 | 10 | 40 | 20 | 10 |
11 | 電力売上高(円/日) | 8,400 | 4,200 | 2,100 | 8,400 | 4,200 | 2,100 | 8,400 | 4,200 | 2,100 |
12 | 電力売上高(円/年) | 3,066,000 | 1,533,000 | 766,500 | 3,066,000 | 1,533,000 | 766,500 | 3,066,000 | 1,533,000 | 766,500 |
13 | 発電施設単価(円/KW) | 600,000 | 600,000 | 600,000 | 300,000 | 300,000 | 300,000 | 150,000 | 150,000 | 150,000 |
14 | 発電施設価格(円) | 42,000,000 | 42,000,000 | 42,000,000 | 21,000,000 | 21,000,000 | 21,000,000 | 10,500,000 | 10,500,000 | 10,500,000 |
15 | 返済=償却期間(年) | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
16 | 借入利息 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 |
17 | 借入返済金額(元利+利息)(円/年) | 2,823,060 | 2,823,060 | 2,823,060 | 1,411,530 | 1,411,530 | 1,411,530 | 705,765 | 705,765 | 705,765 |
18 | 利益(円/年) | 242,940 | (1,290,060) | (2,056,560) | 1,654,470 | 121,470 | (645,030) | 2,360,235 | 827,235 | 60,735 |
19 | ||||||||||
20 | ||||||||||
21 | ||||||||||
22 | シナリオ | 売電価格(円/KWh) | 発電施設単価(円/KW) | 利益(円/年) | ||||||
23 | 1 | 40 | 600,000 | 242,940 | ||||||
24 | 2 | 20 | 600,000 | (1,290,060) | ||||||
25 | 3 | 10 | 600,000 | (2,056,560) | ||||||
26 | 4 | 40 | 300,000 | 1,654,470 | ||||||
27 | 5 | 20 | 300,000 | 121,470 | ||||||
28 | 6 | 10 | 300,000 | (645,030) | ||||||
29 | 7 | 40 | 150,000 | 2,360,235 | ||||||
30 | 8 | 20 | 150,000 | 827,235 | ||||||
31 | 9 | 10 | 150,000 | 60,735 | ||||||
32 | ||||||||||
33 | ||||||||||
34 |