Simple
| 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
| 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 | 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
| 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 | 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). |
|---|
| |
|---|
| 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 |
|---|
|
|---|
|
|---|
| 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.
