Price Template

Price Templates can be used as Sales and Opex driver.

Actually the following templates are available: "Simple", "Serial" and "Matrix"

Simple

Simple

The Price Template "Simple" uses a driver ("Production", "Fix per Production Unit", "Fix per Project" or "Power"). In combination with this driver a value is supplied by the user. This value is constantly valid depending on the selected driver.

Input Field	Description	Unit	Presetting
Name	Price template name	Free text	"Price" + Index
Model	Simple	Selection	Simple
Driver	The available drivers per section are listed on the following page: Driver	Selection	Procuction
Value	Input of a value proper to the selected driver. This value is constantly valid depending on the selected driver.

Serial

Serial

The Price Template "Serial" allows the coverage of multiple prices over time. Possible application: Coverage of an electricity market price study.

Input Field

Description

Unit

Presetting

Name

Price template name

Free text

"Price" + Index

Model

Serial

Selection

Simple

Driver

The following drivers are available:

Driver details

Fix per Production Unit
Fix per Project
Production
Power
Material
Sales
Single per Production Unit
Single per Project
Option Based Component
Template
Custom
Fix
Asset Purchase Price
Capex
Next Debt Service

Drivers

All available drivers in green[::]match. The column "Applicability" shows all section in which the different drivers are available.

Driver Type	Description	Applicability
Fix per Production Unit	Fix value input in Currency per Production Unit. The value is multiplied with the number of added Production Units. For example: "EUR 20'000 per Production Unit and year" x 2 added Production Units" makes 40'000 EUR/a.	Template, Sales, Opex, Capex, Transaction Expenditures, Floor, Cap
Fix per Project	Fix value input in Currency per Project. The value is adopted without adjustments. For example: "40'000 EUR/a per Project". When for Start and End of the Date Choice Box "Production Unit Start" or "Production Unit End" is choosen in combination with this driver, the value is assigned to the Production Units pro rata.	Template, Sales, Opex, Capex, Transaction Expenditures
Production	The value input is in Currency per hour according to the Unit and is multiplied with the 2.1.2.4 Production per added Production Unit. For example: "80 Eur/MWh with 1 added Production Unit with a production of 1'000 MWh/a" makes 80'000 EUR/a.	Template, Sales, Opex, Capex, Floor, Cap
Power	The value input is in Currency per Unit per per year and is multiplied with the Power per added Production Unit. For example: "10'000 EUR/MW/a with 1 added Production Unit with an installed Power of 2 MW" makes 20'000 EUR/a.	Template, Sales, Opex, Reserves, Capex, Transaction Expenditures, Floor, Cap
Material	The value input is in Currency per Unit per year and is multiplied with the amount of material per year.	Sales, Opex
Sales	The value input is in percent and is multiplied with the Sales per added Production Unit.	Opex
Single per Production Unit	The value input is in Currency as single amount per added Production Units. Note: You should define as End the value Start + 1 month to receive a "real" single amount. Otherwise the single amount is divided through the months between start and end.	Sales, Opex
Single per Project	The value input is in Currency as single amount per Project. Note: You should define as End the value Start + 1 month to receive a "real" single amount. Otherwise the single amount is divided through the months between start and end.	Sales, Opex
Option Based Component	Choice between Bonus or Malus component, cap, floor as well as a combination of cap and floor. Explanations can be found when adding an Option Based Component in green[::]match valuation.	Opex
Template	Adoption of a Template according to the selection. The calculation occurs according to the driver input from the selected Template.	Sales, Opex
Custom	The Custom function allow to create an own formula for the calculations. More information can be found under: Opex, Tax	Opex, Tax
Fix	Fix value input in Currency. The value is adopted without adjustments.	Debt, Reserves, Shareholder Loans
Asset Purchase Price	The value refers to the percentage of the Asset Purchase Price.	Debt, Shareholder Loans
Capex	The value refers to the percentage of the sum of all Capexes, regardless if they are "Included in the Asset Purchase Price" or not.	Debt, Shareholder Loans
Next Debt Service	The Debt Service demand is orientated as percentage of the sum of the Debt Service from all Debt Tranches according to the Look Ahead Period. Thus the Reserve account demand is variable.	Reserves
Equity	The value refers to the percentage of Equity.	Shareholder Loans

Selection

Production

Reference Point

The Reference Point ("Date range" or "Production Unit Start") assigns how the values have to be interpreted.

Date range

The price which is determined for the corresponding period is valid.

Possible application: Coverage of an electricity market price study.

Production Unit Start

The price determined for the commissioning period is valid. This price is valid constantly over time (respectively from Start till End of the Sales in which this template is used).

Possible application: Coverage of the EEG.

Selection

Fix

Segments

Add	With the button "Add" new rows can be added to the template.
Remove	With the button "Remove" existing rows can be deleted from the template.
Date	Assign the datelines of the different intervals with a date choice box. For example: Is 04.2016 selected, from 04.01.2016 the price which stands in this row at the corresponding Power or Production level is valid. This price is valid till the next segment, for example 10.2016. So the price is valid from 04.01.2016 till 09.30.2016.
Value	Input of a value proper to the selected driver. This value is valid for the corresponding time period depending on the selected driver.

Serial Price Template Example

This graph shows the coverage of an electricity market price study. From 01 /2012 till 12 /2012 a market price of 49.41 EUR / MWh is valid. From 01 /2013 till 12 / 2013 a price of 47.99 EUR / MWh is valid and so on. After 01 / 2018 a constant price of 51.10 EUR/MWh is valid.

Matrix

Matrix

The Matrix Template allows the coverage of multiple prices over time which are dependent of the Production or Power (compare Columns Driver). Possible application: Coverage of a Feed-in-Tariff.

Input Field

Description

Unit

Presetting

Name

Price template name

Free text

"Price" + Index

Model

Matrix

Selection

Simple

Driver

The following drivers are available:

Driver Details

Fix per Production Unit
Fix per Project
Production
Power
Material
Sales
Single per Production Unit
Single per Project
Option Based Component
Template
Custom
Fix
Asset Purchase Price
Capex
Next Debt Service

Drivers

All available drivers in green[::]match. The column "Applicability" shows all section in which the different drivers are available.

Driver Type	Description	Applicability
Fix per Production Unit	Fix value input in Currency per Production Unit. The value is multiplied with the number of added Production Units. For example: "EUR 20'000 per Production Unit and year" x 2 added Production Units" makes 40'000 EUR/a.	Template, Sales, Opex, Capex, Transaction Expenditures, Floor, Cap
Fix per Project	Fix value input in Currency per Project. The value is adopted without adjustments. For example: "40'000 EUR/a per Project". When for Start and End of the Date Choice Box "Production Unit Start" or "Production Unit End" is choosen in combination with this driver, the value is assigned to the Production Units pro rata.	Template, Sales, Opex, Capex, Transaction Expenditures
Production	The value input is in Currency per hour according to the Unit and is multiplied with the 2.1.2.4 Production per added Production Unit. For example: "80 Eur/MWh with 1 added Production Unit with a production of 1'000 MWh/a" makes 80'000 EUR/a.	Template, Sales, Opex, Capex, Floor, Cap
Power	The value input is in Currency per Unit per per year and is multiplied with the Power per added Production Unit. For example: "10'000 EUR/MW/a with 1 added Production Unit with an installed Power of 2 MW" makes 20'000 EUR/a.	Template, Sales, Opex, Reserves, Capex, Transaction Expenditures, Floor, Cap
Material	The value input is in Currency per Unit per year and is multiplied with the amount of material per year.	Sales, Opex
Sales	The value input is in percent and is multiplied with the Sales per added Production Unit.	Opex
Single per Production Unit	The value input is in Currency as single amount per added Production Units. Note: You should define as End the value Start + 1 month to receive a "real" single amount. Otherwise the single amount is divided through the months between start and end.	Sales, Opex
Single per Project	The value input is in Currency as single amount per Project. Note: You should define as End the value Start + 1 month to receive a "real" single amount. Otherwise the single amount is divided through the months between start and end.	Sales, Opex
Option Based Component	Choice between Bonus or Malus component, cap, floor as well as a combination of cap and floor. Explanations can be found when adding an Option Based Component in green[::]match valuation.	Opex
Template	Adoption of a Template according to the selection. The calculation occurs according to the driver input from the selected Template.	Sales, Opex
Custom	The Custom function allow to create an own formula for the calculations. More information can be found under: Opex, Tax	Opex, Tax
Fix	Fix value input in Currency. The value is adopted without adjustments.	Debt, Reserves, Shareholder Loans
Asset Purchase Price	The value refers to the percentage of the Asset Purchase Price.	Debt, Shareholder Loans
Capex	The value refers to the percentage of the sum of all Capexes, regardless if they are "Included in the Asset Purchase Price" or not.	Debt, Shareholder Loans
Next Debt Service	The Debt Service demand is orientated as percentage of the sum of the Debt Service from all Debt Tranches according to the Look Ahead Period. Thus the Reserve account demand is variable.	Reserves
Equity	The value refers to the percentage of Equity.	Shareholder Loans

Selection

Production

Reference Point

The Reference Point ("Fix" or "Production Unit Start") assigns how the values have to be interpreted.

Date range

The price which is determined for the corresponding period is valid.

Possible application: Coverage of an electricity market price study.

Production Unit Start

The price determined for the commissioning period is valid. This price is valid constantly over time (respectively from Start till End of the Sales in which this template is used).

Possible application: Coverage of the EEG.

Selection

Fix

Columns Driver

On the basis of the Columns Driver the reference value for sales is determined.

Power	The Power of all Production Units is the reference value for the remuneration.
Production	The Production of all Production Units is the reference value for the remuneration.

Selection

MW, kW

Power

Columns Mode

Selection between "Weighted" and "Interval":

Weighted

The prices are weighted. The following example will show the functionality:

A facility with 200 kW Power and the following Column drivers: 30 kW, 100 kW, 1000 kW. The first 30 kW are remunerated with 26.40 Cent/kW, the next 70 kW (100 kW less 30 kW) are remunerated with 22.00 Cent/kW and the remaining 300 kW are remunerated with 21.30 Cent/kW (see example graph).

Interval

The remuneration for the affected interval is used for the whole Production. The following example will show the functionality:

A facility with 400 kW Power and the following Columns drivers: 30 kW, 100 kW, 1000 kW. The whole 400 kW are remunerated with 21.30 Cent/kW (see example graph).

Example Graph

Selection

Weighted

Segments

Add

With the button "Add" new rows or columns can be added to the matrix template.

Remove

With the button "Remove" existing rows or columns can deleted from the matrix template.

Date

Assign the datelines of the different intervals with a date choice box.

For example: Is 04.2016 selected, from 04.01.2016 the price which stands in this row at the corresponding Power or Production level is valid. This price is valid till the next segment, for example 10.2016. So the price is valid from 04.01.2016 till 09.30.2016.

Columns Driver

Definition of the Power or Production boundaries of the individual intervals. The remuneration is valid till this inserted value. Is the Column Driver 30 kW, this remuneration is valid up to and including 30 kW. The last column is an exception: This column is valid, if the Power or Production is higher as the inserted value. Compare Example of a Matrix Price Template.

Matrix-Logic

The Matrix Price Template follows this logic (Compare Example of a Matrix Price Template):

Date/ Columns Driver	≤	≤	≤	>
≥	0.264	0.22	0.213	0.191
≥	0.234	0.185	0.188	0.185
≥	0.204	0.177	0.176	0.176

Is a remuneration paid up to 20 kW Power for example but not for facilities with more installed Power, the Template has to be defined as followed:

Date/ Columns Driver	≤ 20	> 20
≥	0.264	0
≥	0.234	0
≥	0.204	0

Without the last column the remuneration would be paid for facilities ≤ 20 kW and for facilities > 20 kW!

Value

Input of a value proper to the selected driver. This value is valid for the corresponding time period depending on the selected driver and column driver.

Matrix Price Template Example

This graph shows the coverage of a Feed-in-tariff. The remuneration bases on the Production output (see Driver). The remuneration rate derives from the commissioning date of the Production Units (see Date \ Value) and from the Columns Driver, in this case Power of the facility.

The remuneration rates in the first row are valid from 01.01.2014 till 03.31 2015. The remuneration rates in the second row are valid from 04.01.2015 till 09.30.2015. The remuneration rates in the last row are valid from 10.01.2015.

The date and in this case the Power of all Production Units is essential for the remuneration rate. With Power less than 30 kW, the remuneration rate in the first column are used. With Power higher 30 kW (for example 30.1 kW) till 100 kW the rates in the second column are used. With Power higher 100 kW till 1000 kW the third column is used. With Power higher than 1000 kW the rates in the last column are used.

A Facility with commissioning date on the 06.01.2015 and 100 kW Power is remunerated accordingly with 0.185 CHF /kW.

Browser not supported