Balance Sheet Manager Worksheet

Prepared for: Demo Company


Home Location: Mexico City, Mexico
Host Location: Seoul, Korea
Employee ID: Sample
Family Size: Differentials = 4 Taxes = 4
Report Date: 6/2/2008
Pricing Date: Jan 2008
Rate of Exchange Date: Feb 2008
Rate of Exchange (ROE): 1 MXN = 83.9 KRW

All amounts are annual KRW ROE MXN
1.   Base Salary 500,000
  a. Home Location Hypothetical Tax (On Base Salary + Bonus) (109,608)
  b. After-Tax Income 390,392
2.   Additional Payments
  a. Hardship Premium (15% of Base Salary) 75,000
  b. Bonus 95,000
  c. Total Additional Payments 170,000
3.   Housing and Utilities Costs
  a. Host Location (Variant: Mod) 76,461,136 / 83.9= 911,337
  b. Home Location (96,510)
  c. Housing and Utilities Differential 814,827
4.   Goods and Services Costs
  a. Host Location (Variant: MPR) 23,133,610 / 83.9= 275,728
  b. Home Location (164,026)
  c. Goods and Services Differential 111,702
5.   Automobile Costs
  a. Host Location 23,126,834 / 83.9= 275,648
  b. Home Location (45,111)
  c. Automobile Differential 230,537
6.   Total Host Location Payments 122,721,580
7.   Net Foreign Compensation (1b)+(2c)+(3c)+(4c)+(5c) 1,717,458

8.   Estimated Host Location Tax Gross-up 18,614,199 / 83.9 221,862
9.   Estimated Host Gross Compensation 1,939,320


Support Documentation


HOST LOCATION HOUSING & UTILITIES DETAIL KRW ROE MXN
Host Rent 63,690,747
Host Utilities 12,770,389
Total Host Housing & Utilities 76,461,136 / 83.9= 911,337
HOME LOCATION HYPOTHETICAL TAX DETAIL MXN
Compensation for Hypothetical Tax Calculation (Base Salary + Bonus) 595,000
National Income Tax 109,608
Local Income Tax 0
Family Allowance 0
Total Home Location Hypothetical Tax 109,608
Social Security 12,907
HOST LOCATION TAX GROSS-UP DETAIL KRW ROE MXN
National Income Tax 18,614,199
Local Income Tax 0
Total Host Location Gross-up Tax 18,614,199 / 83.9 = 221,862
ILLUSTRATION OF SPLIT PAY (NET) KRW ROE MXN
Total Net Compensation in MXN (7) 1,717,458
Paid at Host Location in KRW (6) 122,721,580 / 83.9 = (1,462,713)
Paid at Home Location in MXN 254,745

Notes:
Host Housing Includes: -Rent -Utilities
Home Transportation Includes: -Gas -Insurance -Maintenance -Ownership Costs
Host Transportation Includes: -Gas -Insurance -Maintenance -Ownership Costs