VIDEO: Creating a pension tax table in Excel

Pension tax table can be displayed for private pensions

The taxation of pensions is subject to the Income tax. Statutory pension, Riester pension and Rürup pension are taxed according to the applicable law at the percentage (in 2011 62 percent) that is valid in the year in which the pension commences. One hundred percent taxation will be achieved from 2040. This also applies to pensions from direct insurance.

1. The exception is drawing a pension from a private one pension insurance. This is taxed with your share of the income. The income share denotes the portion of the pension that is to be regarded as interest and also depends on the age of the beneficiary when the pension is drawn.
2. In turn, the income share is taxed at the personal tax rate. A 60-year-old receives a monthly pension of 200 euros. The share of income for retirement starting at 60 is 22 percent. With a personal tax rate of 30 percent, a monthly tax of EUR 13.20 is to be paid on EUR 44 income for a EUR 200 pension.
3. You can create income share taxation in Excel as follows: The basics are time, patience and the
   instagram viewer
   Share of earnings table for a pension tax table.
4. Enter the age data in the first column of the worksheet and the income share rates in the second column.


Pension taxation for the widow's pension - worth knowing

With the change in pension taxation in 2005, the ...

5. In the third column you will add the pension amount later. In the fourth column, underlay a formula that contains the percentage from column two.
6. Example: In line four, pension payments between the ages of six and eight are stored, the income share is 56 percent. The formula is = (b4 / 100) * c3.
7. If you store the corresponding formula for each starting age, you can use this pension tax table to determine the nominal income share on the pension at any time.