/
Tax calculations

Tax calculations

Dec 21, 2022



Inputs

Tax Components:

  • Tax Rate

  • Reference

  • Start Date

  • End Date

  • Loss Carried Forward

  • Driver

  • Value

  • Method of Payment

Calculation

Profit & Loss statement

The following key figures can be used as Reference:

EBITDA, EBIT or EBT 

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 (compare Loss Carried Forward Example).

Balance Sheet

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



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