Recently the British govt decided to force energy companies to pay people who installed photovoltaic solar panels on their roof. The rates are as follows:
Main Tariff: 41.3 p/kWh for everything you generate plus
Export Tariff: 3 p/kWh for what they deem you export, e.g. they might say you use 50% and you export 50% of what the panels generate.
Both tariffs rise by inflation rate r = 2.4% each year.
A typical 1kW system in the UK generates 850 kWh per year. A 2.0 kW system will generate twice this and so on, whatever the size. Anything under 4 kW qualifies.
Okay, so far, so good. I want to work out three short formulas that will predict my earnings from
Main tariff (m)
Export Tariff (e)
for any given year 1-25
rate rise = 2.4% (r)
For example, year n=1,2,3,4....25 (the last year they'll pay).
I can do this on a long complex spreadsheet, but I'm sure that there is a shorter formulaic way to do this.
It's a good problem to solve actually, so I hope someone can provide the formulas.
If this is the case then it would increase by a factor of each year which would make it into a geometric series with common ratio
First of all I'm going to denote inflation, as in this next sum as not to confuse it with the common ratio which is denoted r.
Applying your values:
If you add this to
Chances are my summation notation is wrong so ignore it if it makes no sense
However, how would I do the same if this was the problem instead:
Let say that the rates themselves rose by 2.4% each year. And that the power of the PV unit diminished by 0.5%.
Now I want the cumulative sum formula so that I just plug in n year from n=1 to 25 and I can work out the separate tariff cumulative incomes?
It should provide growing numbers...