Tax calculations

Inputs

Tax Rate
Reference
Start Date
End Date
Loss Carried Forward
Driver
Value
Method of Payment

Calculation

Profit & Loss statement

The Profit & Loss statement depends on the Tax Rate and on the selected Reference.

t < Start Date	t >= Start Date and t < End Date	t >= End Date
0	Taxes(t) = Tax Rate x Reference(t)	0

The following key figures can be used as Reference:

EBITDA, EBIT or EBT

The Profit & Loss statement depends on Start and End dates.

The Taxes are due between Start Date and End Date. Taxes before Start or after End aren't considered.

Cashflow statement

The Cashflow statement depends on the Loss Carried Forward.

The Cashflow statement depends on the Loss Carried Forward (compare Loss Carried Forward Example).

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

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

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

Loss Carried Forward Example

When Loss Carried Forwards can be adopted infinite (Loss Carried Forward Mode = infinite) the Cashflow statement depends on the transferred balance.

When a Loss Carried Forward of for example EUR 200'000 is adopted with a Tax Rate of 30%, then there is an amount of EUR 60'000 due at Transaction (EUR 200'000 x 30%).

According to the Profit & Loss statement there are no taxes due during the first four years because of a negative EBT (compare figure Loss Carried Forward Profit & Loss statement). The Loss Carried Forward of EUR 60'000 is charged with the tax credit from these four years. The first tax payment gets due in 2023 (compare figure Loss Carried Forward Cashflow statement) after the Loss Carried Forward of EUR 60'000 and the tax credits from the first four years were reduced to 0 (compare figure Loss Carried Forward Balance Sheet).


1. Loss Carried Forward Profit & Loss statement	2. Loss Carried Forward Cashflow Statement	3. Loss Carried Forward Balance Sheet

When a tax credit of EUR 200'000 is transferred, at Transaction EUR 200'000 are due to compensate the seller for the tax credit. According to the Profit & Loss statement there are no taxes due during the first four years because of a negative EBT (compare figure Tax Credit Profit & Loss statement). The first Tax payment is due in 2024 (compare figure Tax Credit Cashflow statement) after the tax credit from the first years and the transferred tax credits were reduced to 0 (compare figure Tax Credit Balance Sheet).


1. Tax Credit Profit & Loss statement	2. Tax Credit Cashflow statement	3. Tax Credit Balance Sheet