Rewards System

SassySweetStacey
LOCATIONINSPREADSHEET.xlsx

Sheet1

International Assignment Balance Sheet
Lincoln, Nebraska to Jakarta, Indonesia
2019 2020 Total
Base Salary
Family size Home
Family Size Post
Foreign Exchange Rate
Base Compensation
Base Salary
Bonus
Federal Tax
Social Security
Net Income Home Country
Differential Calculations
Goods & Services Differential
Home Housing Norm
Foreign Housing Cost
Differential Total
Net Base Income on Assignment (Pre-Premium)
Assignment Premium Allowances
Allowance (specify here)
Allowance (specify here)
Allowance (specify here)
Allowance (specify here)
Relocation Costs
Relocation cost (specify here)
Relocation cost (specify here)
Relocation cost (specify here)
Net Base + Premium Income on Assignment
Recommended Method of Pay (specify currency)
Portion Paid in Assignment Location (use Indonesian Rupiah)
Base Pay
Goods and Services Differential
Foreign Housing Cost
Premium Allowances
Relocation Costs
Assignment Location Total
Portion paid in the Home Country (use US dollars)
Base Salary
Bonus
Goods and Services Differential
Home Housing Norm
Federal Income Tax
Social Security Tax
Home Country Total
Net Compensation