Skip to end of metadata
Go to start of metadata

Inputs

Tax Components:

  • 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 Datet >= Start Date and t < End Datet >= 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 derives from the Profit & Loss statement dependent on the Method of Payment.

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

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

 

 

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