|
Input
|
Compensation Package
|
Summary
|
Guidelines
|
Employee's Personal Information:
Employee's First Name*
Employee's Last Name*
Marital Status*
Single
Married
Dependent spouse*
Yes
No
Children (number of )*
0
1
2
3
4
5
6
7
8
9
10
11
12
Resident in
abruzzo
basilicata
calabria
campania
emilia romagna
friuli venezia giulia
lazio
liguria
lombardia
marche
molise
piemonte
puglia
sardegna
sicilia
toscana
trentino alto adige
umbria
valle d'aosta
veneto
Date of Birth
Employment Information:
Enrollment*
Operaio
Impiegato
Quadro
Quadro Super
Dirigente
Category/Level
Date of Engagement
N° of expatriations
"INPS" registration before January 1996*
Yes
No
"Previndai" registration before April 1993*
Yes
No
Assignment Information:
Host City*
Warsaw
Krakow
Estimated starting date
Lenght of assignement (years)
Exchange rate (1€ =)*
Family status on foreign country (marital status)*
Single
Married
Family status on foreign country (children)*
0
1
2
3
4
5
6
7
8
9
10
11
12
Residence status*
Italian
Foreign
Remuneration Information:
Starting Job Position
New Job Position
Starting Annual Gross Salary (RAL)*
Starting Annual Net Salary (RAN)*
% Net Increment*
New Annual Gross Salary (RAL)*
Bonus (as % of Gross)*
Benefits
Housing
value*
cash
in kind
Travel
value*
cash
in kind
Company Car
value*
cash
in kind
School tution
value*
cash
in kind
Other
value*
cash
in kind
One off net allowances:
Language course*
Dual career allowance (max 3 month)*
Medical insurance
Medical insurance*
Extra allowance
Extra allowance (net)
Note:
Note
|
Input
|
Compensation Package
|
Summary
|
Guidelines
|
Annual Basic Salary
Annual Basic Gross Salary (RAL)
Annual Basic Net Salary (RAN)
Bonus Base
% Bonus
Bonus
Notional Salary
monthly notional salary
monthly notional salary (bonus month)
Notional salary
("convenzionale")
Tax and SSC ITA
Personal income tax (IRPEF)
Personal income tax + regional tax
Bonus Tax (IRPEF)
Employee SSC
Regional tax
NET ALLOWANCE
Foreign premium
15%
of the ran
Hardship
of the ran
IME
Cost of Living Coverage (percentuale ran)
Cost of Living (percentuale ran)
COLA
Extra allowance
BENEFIT IN KIND
Value
Taxable
Housing
Travel
Car
School Tution
Other
TOTAL NET CASH PAY
IME
Total net cash pay
TOTAL GROSS CASH PAY
Amount to be grossed-up
Taxable income
Tax EST
IRPEF
Loan for italian taxes
SSC ITA c/dip
SSC EST c/dip
Total gross cash pay (A+B+C)
Bonus Tax EST
Bonus Tax EST
TAX CREDIT
Tax Credit
ONE OFF ALLOWANCES
Language course
Dual career allowance (max 3 month)
Lump sum Relocation
Medical insurance
Medical insurance
COMPANY COST
Benefits value
Employer SSC ITA
TFR
Employer SSC Host Country
Unrecoverable loan for italian taxes
Company Cost
STARTING vs. NEW COMPANY COST
Starting company cost
Company cost increase (value)
Company cost increase (%)
|
Input
|
Compensation Package
|
Summary
|
Guidelines
|
DETACHMENT SHEET
PERSONAL DATA INFORMATION
First Name
Starting Job Position
Last Name
Date of Birth
Enrollment
Date of Engagement
Home country
Italia
Category/Level
Detachment starting date
Seniority (years)
Status
N° of expatriations
ITALIAN REMUNERATION
Starting Annual Gross Salary
Starting Annual Net Salary
DETACHMENT CONDITIONS
N° years of detachment
Average host country tax rate
Host country
Exchange rate
New Job Position
Residence status
% Net Increment
New Annual Net Salary
Increment per job
New Annual Gross Salary
Foreign Service Premium Net Allow
ance
Base Bonus
Bonus (as % of Gross)
TOTAL NET CASH PAY
Bonus
Lump sum relocation
(1st year)
Medical insurance
Other (net)
NOTE
""
Signatures:
HR Manager
Employee
|
Input
|
Compensation Package
|
Summary
|
Guidelines
|
GUIDE LINES
1. This workbook is composed by 6 worksheets:
Guidelines
,
Input
,
Compensation
Package
,
Summary,
% Bonus
and
Tables
.
Input
is an "input" worksheet;
Compensation
Package
and
Summary
are the "output" worksheets. If you want to know how company cost is affected by the bonus you can change the percentage of the bonus in the worksheet called
% bonus.
The last worksheet, called
Tables,
contain tables used for the calculations and you must not modify it.
2. It is necessary to fill in only the first worksheet: the other two will be fill it out automatically. It is necessary to fill in all cells marked with the star.
3. This workbook is created to describe only an international assignment situation from Italy to Poland.
4. This workbook describes the assignment situation after the first year of employee expatriation. The following benefits are not considered on top of the taxable income: the lump sum relocation cost, language course and dual carrer allowance because they relate to a limited period of time.
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.