-
Excel workbook preview
Compensation, Pay Equity and Benefits
Bonus and Incentive Calculator
3 downloads per free account, no card needed.
Who this is for
A reward or payroll lead who must calculate year-end bonuses after the results are signed off and prove every award to finance.
What is inside
- Funding curve with threshold, target and maximum, calculated on a straight line (104% achievement funds 120%)
- Target and maximum payout percentages for 5 levels and modifiers for 5 ratings
- 11 sample participants including a part-year joiner and a rating 1 at zero
- Payout capped at the level maximum and scaled down equally when awards exceed the funded pool
- Non-exempt participants flagged for the FLSA regular rate true-up (29 CFR 778.209)
- Pool check: participants, total target, funded pool, total awards and scaling factor
How to use it: Enter the funding curve, company result, targets and modifiers on Plan, then each participant's level, FLSA status, eligible salary and rating.
Files & formats
- XLSXbonus-incentive-calculator.xlsx14 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.



