International Assignments by the Numbers: Cost Projections, Allowances, Cost-of-Living Indices, Split Pay & Assignment Budgets
Estimate what sending someone abroad really costs: base pay, cost-of-living and housing allowances, relocation, home trips, currency splits, a fictional tax-equalisation step and the comparison with a local hire, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you build the full cost projection of one fictional international assignment in a live spreadsheet. You split the dates into calendar years with DAYS, MIN and MAX, look up a spendable share in a band table and turn a weighted cost-of-living index into an allowance. You price housing by location and band with a cap, cost relocation, temporary housing and home-leave trips, split pay between two currencies and measure an exchange-rate move. A simplified, fictional tax-equalisation step with gross-up follows, then the full-term cost against a local hire and a budget tracker with SUMIFS up to a cut-off date and a chart.
Lessons
- The Assignment Timeline: Dates, Days per Year & Months Pro
- Spendable Income & the Cost-of-Living Allowance Pro
- Housing, Utilities & Transport Allowances Pro
- One-Off Costs: Relocation, Temporary Housing & Home Leave Pro
- Split Pay & Exchange Rates Pro
- Tax Equalisation & Gross-Up (Simplified) Pro
- Total Assignment Cost vs a Local Hire Pro
- Capstone: The Assignment Budget Tracker Pro