Target vs Achievement Percentage Calculator
Written by the percentages.co.uk team. Reviewed for accuracy.
This calculator compares targets against actual results for up to five goals at once. Enter each goal name, target value and achieved value to see the achievement percentage, whether each goal was hit or missed, and an average across all goals.
How it works
Achievement percentage tells you what proportion of a target was reached. A result of 100% means the target was hit exactly. Above 100% means the target was exceeded. Below 100% means there is a shortfall.
The formula
Achievement % = (Achieved / Target) × 100
Average % = Sum of all achievement percentages / Number of goals
Why this works: Dividing achieved by target gives a ratio that is independent of the scale of the original target. This makes it possible to meaningfully average together goals of very different sizes, such as a revenue target in thousands and a customer satisfaction score out of 10.
Worked examples
A marketing team has three targets for Q1: 500 leads (got 420), 10,000 website visits (got 11,200), 3 case studies (got 2).
- Leads: (420 / 500) × 100 = 84% (missed)
- Website visits: (11,200 / 10,000) × 100 = 112% (hit)
- Case studies: (2 / 3) × 100 = 66.67% (missed)
- Average: (84 + 112 + 66.67) / 3 = 87.56%
Answer: Average achievement 87.56% across three goals
A school sets attendance targets: Year 7 target 97% (achieved 96.2%), Year 8 target 96% (achieved 97.1%).
- Year 7: (96.2 / 97) × 100 = 99.18% (just missed)
- Year 8: (97.1 / 96) × 100 = 101.15% (hit and exceeded)
Answer: Year 7 at 99.18%, Year 8 at 101.15%
A charity sets a fundraising target of £50,000 and raises £62,000. What is the achievement percentage?
- Achievement: (62,000 / 50,000) × 100 = 124%
Answer: 124% of fundraising target achieved
A council aims to process 95% of planning applications within 8 weeks; actual rate is 91.4%. What is the achievement?
- Achievement: (91.4 / 95) × 100 = 96.21%
Answer: 96.21% of target met
A developer targets 30 story points per sprint, completes 27. What is their velocity achievement?
- Achievement: (27 / 30) × 100 = 90%
Answer: 90% of velocity target achieved
When to use this
- Quarterly business reviews: Reviewing OKR or KPI performance across multiple objectives at the end of each quarter.
- Annual appraisals: Summarising an employee's performance across several objectives set at the start of the year.
- School or university performance reporting: Tracking attendance, grades and outcomes against targets set by Ofsted or the institution.
- Project milestone tracking: Comparing planned deliverables against completed deliverables across several workstreams to generate an overall project health percentage.
Understanding the result
Each goal is independently assessed as hit (100% or above) or missed (below 100%). The average gives an overall picture of performance. A high average driven by one exceptional result while several goals are badly missed may need investigation.
Simple averages weight all goals equally. If some goals are more important than others, a weighted average would be more appropriate. Note the average in this calculator is unweighted.
Related concepts
➡ For tracking a single sales quota specifically with a gap and daily run rate, use the percentage to quota calculator designed for sales and revenue targets. ➡ To see how your performance this period compares to the same period last year, the percentage change calculator shows the relative movement between any two values. ➡ When a target is expressed as a percentage and you want to find the underlying number, the percentage of a number calculator converts any rate into a real-world amount.
How to do this in Excel
=(B1/A1)*100
Put target in A1 and achieved in B1. For average across multiple rows: =AVERAGE(C1:C5) where column C contains each row's achievement percentage.
How to do this without a calculator
Divide your actual result by the target and multiply by 100. To check whether you hit the target without calculating the exact percentage: if achieved is equal to or greater than target, it is a hit.
Common mistakes
Treating a simple average as a weighted one
This calculator gives an equal-weight average. If one goal has a target of £1m and another has a target of 10 customer calls, the simple average treats them identically. Use weights if goal importance differs.
Using inconsistent units
The target and achieved values for each goal must be in the same units. Mixing, say, weekly and monthly figures for the same goal produces a meaningless percentage.
Related calculators
Percentage to Quota Calculator
Calculate sales quota attainment percentage and required daily rate.
Percentage Change Calculator
Calculate the percentage change between old and new values.
Win Percentage Calculator
Calculate win percentage from wins, losses and draws.
Average Percentage Calculator
Calculate the average of up to five percentage values.
Percentage of a Number Calculator
Find what a percentage of any number is instantly.
Payroll Percentage Calculator
Calculate payroll as a percentage of revenue with UK benchmarks.