Investments in Renewable Energy - Discounted Cash Flow

	A	B	C	D	E	F	G	H	I	J	K	L
1	Investments in Renewable Energy
2
3
4	Investment	100000
5
6	Energy produced or saved per year (kWh)	15000
7	Savings per energy unit (1/kWh)	1
8	Energy savings per year (1/year)	15000
9
10	Running costs per year (1/year)	1000
11
12	Real monetary interest rate	0.05
13	Inflation rate	0.02
14	Nominal Interest rate	0.0294
15
16
17	Year	0	1	2	3	4	5	6	7	8	9	SUM
18	Investment	-100000	0	0	0	0	0	0	0	0	0	-100000
19	Energy savings	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	150000
20	Running costs	-1000	-1000	-1000	-1000	-1000	-1000	-1000	-1000	-1000	-1000	-10000
21	Cash flow	-86000	14000	14000	14000	14000	14000	14000	14000	14000	14000	40000
22
23	Discounted Present Value	-86000	13600	13211	12834	12467	12111	11765	11429	11102	10785	23305
24
25	https://www.engineeringtoolbox.com/renewable-energy-investment-d_2094.html
26
27	Download as excel file or Drive document from the "File" menu above. You can expand the number of periods by inserting new columns and copying the formulas.
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100