How to Map Revenue Tiers to Scores for Business Evaluation (Step-by-Step)

By · November 16, 2026
Business revenue charts and scoring analysis on a laptop

A practical method for turning company revenue into a fair, consistent score inside a business evaluation, supplier review, lead scoring or investment screening model.

Quick answer: To map revenue tiers to scores, first define clear revenue bands (for example under $1M, $1M–$5M, $5M–$25M and so on), then give each band a score on a fixed scale such as 1 to 5 or 0 to 100. Decide whether higher revenue should always score higher, apply a weight to the revenue score inside your overall evaluation, and calculate it with a lookup formula. Test the model on real companies and adjust the bands until the results make sense.

Business evaluations often compare companies on many factors: revenue, growth, profitability, risk and fit. Revenue is one of the most useful signals, but raw numbers are hard to combine with other criteria. A company with $40 million in sales cannot simply be added to a growth rate of 15%.

The solution is to convert revenue into a score. This guide shows how to build revenue tiers, map them to points, weight them in a wider scorecard, and calculate everything in a spreadsheet, with examples for supplier reviews, sales lead scoring and investment screening.

The same method works for any numeric factor, so once you learn it you can score employees, profit margins or customer counts the same way.

In this article

Why map revenue to scores?

  • Comparability: puts revenue on the same scale as other criteria
  • Consistency: everyone scores companies the same way
  • Speed: screen many companies quickly
  • Transparency: stakeholders see exactly why a company scored as it did
  • Flexibility: change bands as your strategy changes

Common uses include lead scoring in sales, supplier and vendor evaluation, grant and loan screening, acquisition target screening and partner selection.

Step 1: Define the purpose of the score

Before choosing tiers, decide what “good” means for your evaluation.

  • Bigger is better: for supplier stability or acquisition scale
  • Sweet spot: for sales teams whose product fits mid-sized companies best
  • Smaller is better: for programmes aimed at small businesses, such as some grants

This decision shapes the whole mapping. If your ideal customer has $5M to $50M in revenue, very large firms may deserve a lower score, not a higher one.

Write this decision down in one sentence, such as “We prefer suppliers with at least $5M revenue because they are more stable,” so everyone using the model understands the logic.

Step 2: Set revenue tiers

Use bands that reflect real differences in your market. Wider bands at the top work well because revenue is spread unevenly across companies.

Tier Annual revenue Typical company type
Tier 1 Under $1M Micro business or start-up
Tier 2 $1M – $5M Small business
Tier 3 $5M – $25M Lower mid-market
Tier 4 $25M – $100M Mid-market
Tier 5 Over $100M Large company

Make sure bands do not overlap. Decide which tier a boundary value belongs to, such as “$5M and above goes to Tier 3”. For official size definitions, the US SBA size standards and our guide to SME meaning are helpful references.

Step 3: Assign a score to each tier

Tier Revenue Score if bigger is better (1–5) Score if mid-size is ideal (1–5)
Tier 1 Under $1M 1 1
Tier 2 $1M – $5M 2 3
Tier 3 $5M – $25M 3 5
Tier 4 $25M – $100M 4 4
Tier 5 Over $100M 5 2

Use the same scale as your other criteria, for example 1 to 5 or 0 to 100. If you use 0 to 100, Tier 1 to Tier 5 could map to 20, 40, 60, 80 and 100.

Step 4: Weight the revenue score in your scorecard

Revenue is rarely the only factor. Give each criterion a weight that adds up to 100%.

Criterion Weight Score (1–5) Weighted score
Revenue tier 25% 4 1.00
Growth rate 25% 3 0.75
Profitability 20% 5 1.00
Credit or risk rating 15% 4 0.60
Strategic fit 15% 2 0.30
Total 100% — 3.65 out of 5
Example 1: Supplier evaluation
A manufacturer compares three packaging suppliers. Supplier A has $60M revenue (score 4), strong credit and good fit. Supplier B has $3M revenue (score 2) but the best prices. Supplier C has $15M (score 3). After weighting, A scores 3.9, C 3.4 and B 2.8, so A becomes the preferred supplier with C as backup.

Step 5: Build the formula in Excel or Google Sheets

1. Create a lookup table

In columns A and B, list the lower bound of each tier and its score: 0 → 1, 1,000,000 → 2, 5,000,000 → 3, 25,000,000 → 4, 100,000,000 → 5.

2. Use an approximate-match lookup

If revenue is in cell D2, use =XLOOKUP(D2, A2:A6, B2:B6, , -1) to find the score for the largest lower bound not above D2. In older Excel, =VLOOKUP(D2, A2:B6, 2, TRUE) does the same if column A is sorted.

3. Or use IFS

=IFS(D2>=100000000,5, D2>=25000000,4, D2>=5000000,3, D2>=1000000,2, TRUE,1)

4. Multiply by the weight

Weighted score = revenue score × weight, then add all weighted scores together.

See Microsoft’s XLOOKUP guide for more options, and our list of data analysis tools for larger models.

Advanced options: smooth and relative scoring

  • Logarithmic scoring: score = log10(revenue), scaled to 0–100, so each tenfold increase adds the same points
  • Percentile scoring: rank each company against the group and use its percentile as the score
  • Min-max normalisation: (revenue − minimum) ÷ (maximum − minimum) × 100, best when values are not extremely skewed
  • Capped scoring: stop adding points above a level that no longer matters to you
Example 2: Lead scoring for a software firm
A software company sells best to firms with $10M to $50M revenue. It gives 30 points to that band, 20 points to $50M–$200M, 10 points to $2M–$10M and 0 points to the rest. Combined with industry and job title points, sales reps now call the highest-scoring leads first, and meeting rates rise noticeably.

Common mistakes when scoring revenue

  1. Using bands that put almost every company in one tier.
  2. Assuming bigger always means better when your strategy says otherwise.
  3. Mixing currencies or financial years without converting.
  4. Giving revenue too much weight compared with profit, growth or risk.
  5. Using estimated revenue without noting it is an estimate.
  6. Never testing the model against real past decisions.

Revenue data for private companies is often estimated. Our guide to Buzzfile business search explains how to treat directory figures carefully, and our article on gross margin vs markup helps you add profitability to the scorecard.

BTS Magazine Tip
Run your scoring model on ten companies you already know well. If the ranking surprises you, adjust the tiers or weights before you use it on new companies.
Try this today
Open a spreadsheet, enter five revenue bands and their scores, and use the IFS formula above on three real companies. You will have a working revenue score in 15 minutes.

Frequently Asked Questions

What is a revenue tier?

A revenue tier is a range of annual revenue, such as $1M to $5M, used to group companies by size.

How many revenue tiers should I use?

Four to six tiers usually work well. Too few hide differences; too many make the model hard to explain.

Should higher revenue always get a higher score?

No. It depends on your goal. Sales teams often score a mid-size “sweet spot” highest.

How do I score revenue in Excel?

Use a lookup table with XLOOKUP or VLOOKUP approximate match, or an IFS formula with revenue thresholds.

How much weight should revenue have?

Often 15% to 30% of a total score, balanced with growth, profitability, risk and fit.

What if I do not know a company’s exact revenue?

Use reliable estimates, note the source, and consider giving a neutral score until you can verify.

Final Thoughts

  • Mapping revenue tiers to scores makes company size comparable with other criteria.
  • Define your goal first, then set clear, non-overlapping bands.
  • Weight revenue sensibly and calculate it with simple lookup formulas.
  • Test and adjust the model using companies you already know.

Explore More on BTS Magazine