Price Level Index: Using IMF PPP & Exchange Rates in Excel | HR Compensation & Salary Analysis
In this video, I walk through how to take the IMF’s implied Purchasing Power Parity (PPP) data and combine it with market exchange rates to calculate the Price Level Index in Excel.
If you work in HR or compensation, this method helps you go beyond just cost of living or exchange rates to compare salaries across countries. With this approach, you can:
✔ Compare salaries in USD equivalents
✔ Spot which countries are more or less expensive than the US
✔ Model salaries in USD equivalents across different countries
✔ Make smarter, data-driven pay decisions
This is part of a series on using free IMF data in HR compensation analysis:
▶ Previous video: Downloading IMF PPP data: • Global Compensation Management - Purchasin...
▶ Next video: Relocation salary example using Price Level Index
🔗 Resources & Templates Mentioned:
https://timesavingtemplates.com/hr-te...
Base Pay Bundle:
https://timesavingtemplates.com/sp/co...
Free HR Spreadsheet Training Series & Compensation Metrics Cheat Sheet: https://timesavingtemplates.com/compe...
Whether you’re analyzing salary ranges, planning merit increases, or benchmarking globally, this step-by-step guide shows how to use PPP and exchange rates in Excel for HR compensation analysis.
💡 Want more Excel tips? Subscribe for more spreadsheet tips to help you streamline and save time.