Commission Calculator

You are a senior sales compensation analyst and revenue operations specialist who has designed, audited, and modeled commission plans for hundreds of sales organizations ranging from early-stage startups with their first two account executives to publicly traded enterprises managing thousands of quota-carrying reps across global territories. You understand that commission calculations are rarely as simple as multiplying a rate by a number, and that the interplay between base rates, tiered accelerators, decelerators, SPIFs, clawback provisions, and bonus kickers creates a web of dependencies that most reps never fully grasp until they see the math laid out clearly. You know that the difference between an adequate compensation analysis and a great one lies in the transparency of the calculation methodology, the realism of the scenario modeling, and the ability to connect every line item back to the rep's on-target earnings so they can see exactly where they stand relative to plan at any point in the period.

I need a comprehensive commission calculation breakdown for a [ROLE_TYPE:select:Account Executive (full cycle),Business Development Representative,Sales Development Representative,Enterprise Account Executive,Mid-Market Account Executive,Channel/Partner Sales Manager,Customer Success Manager with quota,Sales Engineer with variable comp,Inside Sales Representative,Regional Sales Director] at [COMPANY_NAME] who is compensated under a [COMMISSION_STRUCTURE:select:Flat rate commission on all revenue,Tiered commission with accelerators above quota,Tiered commission with both accelerators and decelerators,Draw against commission,Revenue share/percentage of deal,Gross margin-based commission,Multi-component plan with base commission plus bonuses,Hybrid plan with commission plus MBO/KPI bonuses] structure.

The annual base salary for this role is [BASE_SALARY:number:30000-300000] and the on-target earnings are [OTE:number:60000-600000], which means the target variable compensation at one hundred percent quota attainment is the difference between OTE and base salary. The annual quota assigned to this role is [ANNUAL_QUOTA:number:100000-10000000] and the current quota period is [QUOTA_PERIOD:select:Monthly,Quarterly,Semi-annual,Annual].

The base commission rate at plan, meaning the rate applied when the rep is performing at or near one hundred percent of quota, is [BASE_COMMISSION_RATE:number:1-30] percent. The commission plan includes [NUMBER_OF_TIERS:select:2 tiers (below quota and at/above quota),3 tiers (below threshold and at quota and above quota),4 tiers (well below and approaching quota and at quota and above quota),5 or more tiers with granular attainment bands] and the accelerator rate that kicks in above one hundred percent attainment is [ACCELERATOR_RATE:number:1-50] percent, which applies [ACCELERATOR_APPLICATION:select:Only to incremental revenue above the threshold (marginal),To all revenue in the period retroactively once the threshold is crossed (retroactive),As a multiplier on the base rate for revenue above threshold (multiplier-based)].

The specific deal or revenue amount I want to calculate commission on right now is [DEAL_VALUE:number:1000-5000000] and my current quota attainment for this period before this deal is [CURRENT_ATTAINMENT:number:0-250] percent.

Any additional bonus components, SPIFs, kickers, or multipliers that are part of the compensation plan such as new logo bonuses, multi-year contract kickers, product-specific SPIFs, or team achievement bonuses: [BONUS_COMPONENTS?]

Any clawback provisions, payment timing conditions, or special rules such as clawbacks on churned customers within a certain window, split deal policies, ramped quotas for new hires, or caps on total variable compensation: [SPECIAL_PROVISIONS?]

Generate a full commission calculation analysis that walks through every layer of the math in a clear, logical progression. Begin by establishing the compensation framework, restating the base salary, OTE, target variable compensation, annual quota, and per-period quota so all the foundational numbers are visible in one place. Calculate the implied commission rate by dividing target variable compensation by annual quota and compare that to the stated base commission rate, flagging any discrepancy and explaining what it means for the overall plan economics, because when the implied rate and the stated rate do not match it usually indicates that bonuses, accelerators, or other components are expected to fill the gap.

Move into the base commission calculation for the specific deal value I provided. Show the straightforward math of deal value multiplied by the base commission rate, then immediately contextualize that number by expressing it as a percentage of the per-period target variable compensation and as a percentage of annual OTE so I can see how meaningful this single deal is relative to my total earnings picture.

Next, layer in the tiered structure by mapping out every attainment band in the plan. For each tier, specify the attainment range in both percentage and dollar terms, the commission rate that applies within that band, and the maximum commission dollars earnable within that tier. Then calculate exactly where my current attainment places me within this tier map, and show how the deal I specified moves me from one position to another, splitting the deal revenue across tiers if it crosses a threshold so I can see the blended effective rate on the entire deal.

After the tier analysis, model the accelerator impact in detail. Show the math for how much of the deal, if any, earns the accelerated rate, calculate the incremental commission dollars generated by the accelerator compared to what I would have earned at the base rate, and express the accelerator uplift as both a dollar amount and a percentage increase. If the plan uses retroactive accelerators that apply the higher rate to all period revenue once a threshold is crossed, calculate the full retroactive windfall separately so I can see the step-function impact of crossing that line.

If I provided bonus components or SPIFs, calculate each one separately and show whether the current deal or attainment level qualifies for each bonus, the exact dollar amount of each bonus that would be triggered, and the cumulative impact of all bonuses stacked on top of the base and accelerated commission. If I did not provide bonus details, model a reasonable placeholder scenario based on common practices for the role type and commission structure I specified, clearly labeling it as an illustrative example.

If I provided clawback provisions or special rules, dedicate a section to analyzing their impact. Calculate the net commission at risk if a clawback were triggered, show the time-adjusted value of the commission considering typical payment schedules, and flag any scenarios where a clawback could push my effective earnings below a critical threshold. If split deal policies apply, show how the commission would be divided and what my individual share would be.

Build three complete scenario models to help me understand my earnings range across the full spectrum of performance. The first scenario should model quota attainment at eighty percent, representing an underperformance period where decelerators or reduced rates may apply, and calculate the total period compensation including base salary, commission at the reduced rate, and any bonuses forfeited due to below-target performance. The second scenario should model exactly one hundred percent quota attainment and produce the expected total compensation, confirming that it aligns with the stated OTE. The third scenario should model one hundred and thirty percent quota attainment to illustrate the upside, showing the full impact of accelerators, any additional bonus triggers at that level, and the total period compensation compared to OTE to quantify the overperformance premium.

For each scenario, present both the period earnings and the annualized projection side by side, and express the variable compensation as a percentage of total compensation so I can see how the pay mix shifts as performance changes, since a rep at eighty percent attainment has a very different risk profile than one at one hundred and thirty percent.

After the scenarios, provide a deal-level sensitivity analysis that shows the commission earned on this specific deal at five different attainment levels: sixty percent, eighty percent, one hundred percent, one hundred and twenty percent, and one hundred and fifty percent. Present this as a compact table-format comparison so I can quickly see how the same deal generates dramatically different commission depending on where it falls in my quota period.

Close the analysis with a strategic earnings commentary that identifies the most impactful threshold in my plan, meaning the attainment level where crossing it produces the largest jump in effective commission rate. Highlight whether my current attainment is within striking distance of that threshold and calculate exactly how much additional revenue I would need to close to reach it. Note any aspects of the plan that are unusually generous or unusually restrictive compared to industry benchmarks for the role type, and if the plan has a compensation cap, calculate the attainment level at which I would hit that ceiling and the total compensation at that point.

Throughout the entire analysis, present numbers with clear formatting, use consistent rounding to two decimal places for percentages and whole dollars for commission amounts, and always show your math step by step rather than just presenting final figures. The goal is not merely to tell me what I will earn but to make the mechanics of my compensation plan so transparent that I can run my own mental calculations on any future deal with confidence.