calculator template · Free download
Bonus Calculator Template
Bonus calculator with target % of base, company and individual multipliers, partial-year proration, a team payout table, and FLSA and withholding notes.
Sign in with Google below to download the PDF and CSV straight away.
Get your free download
Sign in with Google to unlock the PDF and CSV instantly. No form to fill in.
Free. By continuing you agree to our terms and privacy policy. We record your email and this download; marketing emails only if you tick the box.
What you get
- The standard bonus formula (base x target % x company multiplier x individual multiplier x proration) with four worked examples
- A team payout table that checks total payouts against the funded bonus pool
- Multiplicative versus weighted bonus models compared on the same employee
- FLSA regular-rate math for nondiscretionary bonuses paid to non-exempt staff
- A supplemental-wage withholding example and a blank payout sheet
Template preview
A preview of the structure. Download the PDF or CSV for the complete, ready-to-use version.
Inputs
- Base salary— year-end salary or actual eligible earnings, as your plan defines it
- Target bonus %— e.g. 8% individual contributor, 10-15% manager, 20%+ director
- Company performance multiplier— e.g. 0.00 to 1.50 based on revenue, EBITDA, or goals
- Individual performance multiplier— e.g. 0.00 to 1.50 based on review rating
Bonus formulas
| Calculation | Formula | Example | Result |
|---|---|---|---|
| Target bonus | Base salary x target % | $80,000 x 10% | $8,000 |
| Combined multiplier | Company multiplier x individual multiplier | 1.10 x 1.20 | 1.32 |
| Proration factor | Eligible months / 12 | Hired April 1: 9 / 12 | 0.75 |
| Payout | Target bonus x combined multiplier x proration | $8,000 x 1.32 x 1.00 | $10,560 |
Team payout example
Company multiplier for the year is 1.10. Individual multipliers come from the review rating.
| Employee | Target bonus (base x %) | Company x individual | Proration | Payout |
|---|---|---|---|---|
| A | $120,000 x 15% = $18,000 | 1.10 x 1.00 = 1.10 | 12/12 | $19,800 |
| B | $80,000 x 10% = $8,000 | 1.10 x 1.20 = 1.32 | 12/12 | $10,560 |
| C | $65,000 x 8% = $5,200 | 1.10 x 0.50 = 0.55 | 12/12 | $2,860 |
| D (hired April 1) | $90,000 x 10% = $9,000 | 1.10 x 1.00 = 1.10 | 9/12 | $7,425 |
Checking the pool
The company multiplier funds the pool: prorated targets ($18,000 + $8,000 + $5,200 + $6,750 = $37,950) x 1.10 = $41,745 available. Individual payouts total $40,645, leaving $1,100 unspent. If individual multipliers push the total above the funded pool, either scale every payout down by the same factor (pool / total requested) or have the plan say that individual multipliers must average 1.00 across the population.
Multiplier scales (example)
| Result | Company multiplier | Individual rating | Individual multiplier |
|---|---|---|---|
| Below threshold | 0.00 (no pool funded) | Below expectations | 0.00 |
| Threshold | 0.50 | Partially meets | 0.50 |
| Target | 1.00 | Meets | 1.00 |
| Above target | 1.25 | Exceeds | 1.20 |
This is a preview — the full template continues in the download.
Sign in above to download the full template.
How to use this template
- 1
Set targets by level
Record each employee's base salary and target bonus percentage from your bonus plan, usually set by job level.
- 2
Enter the multipliers
Add the company performance multiplier approved by leadership and each employee's individual multiplier from their review rating.
- 3
Prorate partial years
Apply eligible months / 12 for anyone hired, promoted, or on unpaid leave during the plan year, per your plan rules.
- 4
Check the pool and taxes
Compare total payouts with the funded pool, then flag non-exempt employees whose bonus must be added to overtime calculations and confirm withholding with payroll.
Frequently asked questions
How is an annual bonus calculated?
Most plans multiply base salary by a target percentage, then adjust for company and individual performance. An $80,000 salary with a 10% target is an $8,000 target bonus; with a 1.10 company multiplier and a 1.20 individual multiplier it pays $8,000 x 1.32 = $10,560.
How do you prorate a bonus for a new hire?
Multiply the full-year bonus by eligible months divided by 12. An employee hired April 1 in a calendar-year plan has 9 eligible months, so a $9,900 full-year payout becomes $7,425. Many plans also set a cutoff, such as no bonus for hires after October 1.
Why is my bonus taxed so much?
Employers often withhold federal income tax on separately paid bonuses at a flat supplemental rate (22% up to $1 million in recent years; check IRS Pub. 15 for the current rate), plus FICA and state tax. Withholding is not the final tax bill; if it exceeds what you owe based on your full-year income, the difference comes back at filing.
Do bonuses count toward overtime pay?
For non-exempt employees, nondiscretionary bonuses do. They must be added to the regular rate, which raises the overtime premium for every week the bonus covers. Truly discretionary bonuses, gifts, and certain other payments listed in the FLSA are excluded.
What is the difference between a discretionary and nondiscretionary bonus?
A discretionary bonus is decided at the end of the period, with no prior promise and no formula; the employer controls both whether and how much. If employees were told in advance they would earn a bonus for hitting goals, it is nondiscretionary for FLSA purposes, regardless of what the plan document calls it.