##### Page tree
Go to start of banner

# Sales calculations

### Inputs

• Sales
• Interaction Group
• Driver
• Value
• Bounds (Floor, Cap)
• Start
• Model
• End
• Production Units
• Indexations
• Methods of Payment
• Interaction
• Price Interaction

### Calculations

#### Profit & Loss statement

The Profit & Loss statement depends on the selected Driver and the Value input.
t < Startt >= Start and t < Endt >= End
0Sales.Profit & Loss statement(t) = Driver x Value0

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

The Profit & Loss statement depends on Indexations.

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.

01.201602.201603.201604.201605.201606.201607.201608.201609.201610.201611.201612.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

The Profit & Loss statement depends on Interactions between Feed-in-Tariffs and Market Prices.

### Conservative Interaction

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.

01.201602.201603.201604.2016...11.202512.202501.202602.2016...12.2025
Feed-in-Tariff6'00050505050...505000...0
Market Price7'2000000...006060...60
Sum13'20050505050...50506060...60

### Opportunistic Interaction

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.

01.201602.201603.201604.2016...11.202512.202501.202602.2016...12.2025
Feed-in-Tariff00000...0000...0
Market Price14'40060606060...60606060...60
Sum14'40060606060...60606060...60

### Cumulative Interaction

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.

01.201602.201603.201604.2016...11.202512.202501.202602.2016...12.2025
Feed-in-Tariff600050505050...505000...0
Market Price14'40060606060...60606060...60
Sum20'400110110110110...1101106060...60

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

01.201602.201603.201604.2016...11.202512.202501.202602.2016...12.2025
Feed-in-Tariff1'20010101010...101000...0
Market Price12'00040404040...40406060...60
Sum13'20050505050...50506060...60

Sales depend on Cap and/or Floor Bounds.

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.

### Floor

Floor <= Sales/OpexFloor > Sales/Opex
Used ValueSales/OpexFloor

### Cap

Cap <= Sales/OpexCap > Sales/Opex
Used ValueCapSales/Opex

#### Cashflow statement

The Cashflow statement derives from the Profit & Loss statement dependent on the Method of Payment.

#### Balance Sheet

The Balane Sheet yields from the Balance Sheet logic.

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:

01.201602.201603.201604.201605.201606.201607.201608.201609.201610.201611.201612.2016
Profit & Loss statement48444444444444
Cashflow statement480012001200120012
Balance Sheet 480480480480

For 06 / 2016 the book value is calculated as follows:

Balance Sheet(06.2016) = 8 + 4 - 12 = 0