• Preview of Bonus and Incentive CalculatorExcel workbook preview

Compensation, Pay Equity and Benefits

Bonus and Incentive Calculator

$17.99 Free XLSX
Excel workbook · 14 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.