Pakistan's Advanced Compensation, Benefits & Total Rewards Model

Description
Overview
If you are an HR Director, CFO, Company Secretary, People Operations lead, or management consultant working with large listed companies on the Pakistan Stock Exchange, this is the only Excel Model you will ever need for compensation planning, statutory compliance, and total rewards analysis.


This is not a basic payroll sheet with a few salary columns. This is a fully integrated, professionally engineered financial model built to the exact statutory and regulatory requirements of Pakistan's corporate landscape, the Companies Act 2017, the Income Tax Ordinance 2001 as amended by Finance Act 2025, the EOBI Act 1976, the Standing Orders Ordinance 1968, and the PSX Code of Corporate Governance 2019.


Every output, from an individual employee's monthly net take-home to the company's total annual statutory obligations, flows automatically from a single master control panel. Change one assumption and the entire workbook updates across all twelve sheets instantly.


Includes: FBR salaried tax calculator with 6-slab structure + 9% surcharge rule | EOBI, PESSI/SESSI, Recognized PF (8.33%), and Gratuity accrual | Basic + HRA (45%) + Conveyance + Medical + Utility salary structure | 12-grade pay band architecture (G1 → SVP → MD) with compa-ratios | Annual bonus calculator with PSX-aligned company performance gates | PSX ESOP/SAR equity grant register with vesting schedule and CGT analysis | Market benchmarking vs Korn Ferry / Mercer / ORAF P25–P75 | 12-month Jul–Jun HR people cost budget | Executive KPI dashboard with statutory cost charts. 

Bonus:
Separate statement snippets, in the form of Total Rewards Statements, are also included for internal management consumption and external employee consumption.