- Created by Thomas Stahel, last modified by green[::]match on Jul 22, 2016
The end value of a tariff-price group can be defined as a fix value dependent on an event (for example Last Production Unit End (Mode = Fix) or after achieving a certain production amount in MWh (Mode = Quotal). Indexations help to consider inflation. When there are yearly expenses with an amount of EUR 24'000, this amount increases because of inflation. The expenses in the first month are EUR 2'000. With an Inflation of 2% and a Inflation Frequency per month the second month expenses are 2'003.30 = EUR 2000 * (1 + 2%)1/12. The Inflation Frequency defines how often the inflation occurs. The Feed-in-Tariff group is valid for the particular Production Unit until the Sales reached their end, regardless if the Marked Price group would achieve higher Sales. When there is a Feed-in-Tariff of for example 50 EUR/MWh for the first 10 years and a Market Price of 60 EUR/MWh, the higher Market Price is not used before the Feed-in-Tariff expires. If the Market Price group generates higher Sales, this rate is used for the calculation, regardless if the Feed-in-Tariff group has reached his end. When there is a Feed-in-Tariff of for example 50 EUR/MWh for the first 10 years and a Market Price of 60 EUR/MWh, the higher Market Price is used since the beginning. Accumulation of the two groups if they are defined. When there is a Feed-in-Tariff of for example 50 EUR/MWh for the first 10 years and a Market Price of 60 EUR/MWh, the two tariffs are accumulated during the first 10 years. When the Feed-in-Tariff expires the Market Price is used. When the Market Price group is below the Feed-in-Tariff group, the difference between the two groups will be leveled by the market premium. When there is a Feed-in-Tariff of for example 50 EUR/MWh for the first 10 years and a Market Price of 40 EUR/MWh, a Market Premium of 10 EUR/MWh (Feed-in-Tariff - Market Price) is paid for the first 10 years. When the Feed-in-Tariff expires the Market Price is used A Cap or/and Floo value can be added to particular Sales and Opex entities. Dependent from a Driver, a Value for the Cap and Floor bounds is defined. The Floor Values are binding, when the Sales or Opex costs are below the Floor Value. The Cap Values are binding, when the Sales or Opex costs are above the Cap Value. When a Single amount per Production Unit or per Project is used as Sales or Opex driver, the End date should be Start + 1 months to get a "real" single amount. Otherwise the single amount is divided through the months between start and end. In this case the Cap/Floor value is compared with the single amount divided by the amount of months. The Balance Sheet gets calculated from the closing Balance Sheet of the previous period and from the difference between the Profit & Loss statement and the Cashflow statement of the actual period. Balance Sheet(t) = Balance Sheet(t - 1) + Profit & Loss statement(t) - Cashflow statement(t) The following example explains this functionality: For 06 / 2016 the book value is calculated as follows: Balance Sheet(06.2016) = 8 + 4 - 12 = 0 Inputs
Calculations
Profit & Loss statement
t < Start t >= Start and t < End t >= End 0 Sales.Profit & Loss statement(t) = Driver x Value 0 ∑ 01.2016 02.2016 03.2016 04.2016 05.2016 06.2016 07.2016 08.2016 09.2016 10.2016 11.2016 12.2016 Profit & Loss statement -24'219 -2'000 -2'003 -2'007 -2'010 -2'013 -2'017 -2'020 -2'023 -2'027 -2'030 -2'033 -2'037 Conservative Interaction
∑ 01.2016 02.2016 03.2016 04.2016 ... 11.2025 12.2025 01.2026 02.2016 ... 12.2025 Feed-in-Tariff 6'000 50 50 50 50 ... 50 50 0 0 ... 0 Market Price 7'200 0 0 0 0 ... 0 0 60 60 ... 60 Sum 13'200 50 50 50 50 ... 50 50 60 60 ... 60 Opportunistic Interaction
∑ 01.2016 02.2016 03.2016 04.2016 ... 11.2025 12.2025 01.2026 02.2016 ... 12.2025 Feed-in-Tariff 0 0 0 0 0 ... 0 0 0 0 ... 0 Market Price 14'400 60 60 60 60 ... 60 60 60 60 ... 60 Sum 14'400 60 60 60 60 ... 60 60 60 60 ... 60 Cumulative Interaction
∑ 01.2016 02.2016 03.2016 04.2016 ... 11.2025 12.2025 01.2026 02.2016 ... 12.2025 Feed-in-Tariff 6000 50 50 50 50 ... 50 50 0 0 ... 0 Market Price 14'400 60 60 60 60 ... 60 60 60 60 ... 60 Sum 20'400 110 110 110 110 ... 110 110 60 60 ... 60 Market Premium Interaction
∑ 01.2016 02.2016 03.2016 04.2016 ... 11.2025 12.2025 01.2026 02.2016 ... 12.2025 Feed-in-Tariff 1'200 10 10 10 10 ... 10 10 0 0 ... 0 Market Price 12'000 40 40 40 40 ... 40 40 60 60 ... 60 Sum 13'200 50 50 50 50 ... 50 50 60 60 ... 60 Floor
Floor <= Sales/Opex Floor > Sales/Opex Used Value Sales/Opex Floor Cap
Cap <= Sales/Opex Cap > Sales/Opex Used Value Cap Sales/Opex Cashflow statement
Balance Sheet
∑ 01.2016 02.2016 03.2016 04.2016 05.2016 06.2016 07.2016 08.2016 09.2016 10.2016 11.2016 12.2016 Profit & Loss statement 48 4 4 4 4 4 4 4 4 4 4 4 4 Cashflow statement 48 0 0 12 0 0 12 0 0 12 0 0 12 Balance Sheet 4 8 0 4 8 0 4 8 0 4 8 0