Scorecard Valuation Calculator: Free Excel Template With Bill Payne Weights and Worked Seed Example

The scorecard valuation method prices a pre-revenue startup by taking the median pre-money valuation of comparable funded startups and adjusting it with seven weighted factors that Bill Payne set out. You rate the target against the typical deal on each factor, multiply each rating by Payne's weight, add up the results and multiply the total by the regional median. A scorecard valuation calculator in Excel turns that into a 15-row spreadsheet model you can defend in a term sheet negotiation.

As of November 2026. Figures below are dated to their sources.

Key facts

Fact	Value	Source	As of
Payne 2019 ACA example scorecard valuation	$5,197,500	angelcapitalassociation.org	2019-10-21
Payne 2019 example sum of factors	1.1550	angelcapitalassociation.org	2019-10-21
Carta median seed pre-money valuation, Q1 2025	$16 million	carta.com	2025-03-31
Carta seed median pre-money growth YoY, Q3 2025	14%	carta.com	2025-09-30
PitchBook-NVCA US median seed pre-money, 2026 to 30 September	$18.3M	equidam.com	2026-10-18
2011 scorecard anchor average pre-money	$1.5M	equidam.com	2026-09-26

This guide gives you Payne's published weights, the exact cell logic for the Excel template, and a worked seed example from start to finish. It also covers the three mistakes that make most scorecard outputs useless.

What the Scorecard Valuation Method Is and Where It Came From

Bill Payne first wrote up the method in May 2001. He detailed it in his 2006 book, and Ohio TechAngels adopted it in 2008 as the "Bill Payne Method." It was renamed the "Scorecard Method" in 2010 for an Angel Capital Education Foundation workshop, according to Equidam's history of the method. The 2011 revision used a $1.5M average pre-money valuation as its anchor, based on an informal survey of angel groups in summer 2010.

The current reference version is Payne's October 2019 revision, published by the Angel Capital Association. The ACA says the method suits most pre-seed and seed deals. It does not suit ventures that need heavy capital before first revenue, such as some life science and energy companies. The logic has two moves:

Anchor: find the median pre-money valuation of recently funded pre-revenue companies in the same region and sector.
Adjust: score the target against that typical deal on seven factors, weight each score, and apply the total as a multiplier to the anchor.

The method answers a relative question. It tells you whether this company deserves more or less than the going rate, and by how much. If the anchor is wrong, every output is wrong, so most of the work goes into the baseline.

Takeaway. Before you open the spreadsheet, decide which comparable set you are benchmarking against and write it down. That one sentence will carry more weight in a negotiation than any factor score.

Bill Payne's Scorecard Weights

Payne's 2019 revision assigns these maximum weights. They add up to 100%:

Strength of management team: 0-30%
Size of the opportunity: 0-25%
Product/technology: 0-15%
Competitive environment: 0-10%
Marketing/sales channels/partnerships: 0-10%
Need for additional investment: 0-5%
Other: 0-5%

Team and market together account for 55% of the score. That matches how angels underwrite at seed, when there is little product data and almost no revenue to analyse. Product counts for less than either of them, because at this stage a strong team can rebuild a weak product but a strong product cannot rescue a weak team.

How Payne's own example scores

In the ACA post, Payne rates a sample company at 125% on team, 150% on opportunity, 100% on product, 75% on competition, 80% on marketing and channels, and 100% on the last two factors. The weighted sum is 1.1550. He applies that to a $4.5M median (the midpoint of the ACA's $4M pre-seed and $5M seed deal averages) and gets $5,197,500, which he calls "just over $5.2 million."

A rating of 100% means "equal to the average funded deal in the comparable set." A rating of 150% means meaningfully stronger, and 75% means weaker. Equidam points out that the 2011 version printed a sum of 1.075 even though its listed factors add to 1.155. That is a good reason to let Excel do the arithmetic and to audit any scorecard you receive from someone else.

Takeaway: start with Payne's weights unchanged. If you change them, put the reason in a cell comment. Investors will ask.

How to Build a Scorecard Valuation Calculator in Excel, Step by Step

The full Excel template fits on one tab. Here is the layout we use, with real cell references so you can rebuild it from scratch.

Inputs block (B2:B4). B2 holds the baseline median pre-money valuation. B3 holds the source and date of that median as text. B4 holds the planned raise, which you will need for the post-money and dilution check.
Factor table (A7:D13). Column A lists the seven factors. Column B holds Payne's weights (30%, 25%, 15%, 10%, 10%, 5%, 5%). Column C holds your rating as a percentage. Column D is the weighted contribution: =B7*C7, filled down to row 13.
Weight check (B14). =SUM(B7:B13), with conditional formatting that turns the cell red if the result is not 100%. That catches edited weights that no longer add up.
Multiplier (D14). =SUM(D7:D13). This is the sum of factors, Payne's 1.1550 in the ACA example.
Valuation (D16). =B2*D14 gives the scorecard pre-money valuation.
Post-money and dilution (D17:D18). =D16+B4 for post-money and =B4/D17 for the share of the company the round sells.
Rating guardrails. Add data validation on C7:C13 that allows only 50% to 150%. Payne sets no hard cap. This is a house rule that keeps one enthusiastic score from swamping the model.
Evidence column (E7:E13). One line per factor explaining the rating, such as "CTO shipped payments infra at prior employer." A rating with no evidence behind it is just an opinion.

Add a sensitivity block under the main table. A two-way data table with the team rating (100% to 150%) on one axis and the baseline on the other shows the range of defensible outcomes in a single view.

Takeaway. Lock column B and leave column C open. Whoever uses the spreadsheet model should be able to argue about ratings without being able to quietly change the method.

Worked Seed Example: Scorecard Valuation Calculator in Action

This example is illustrative. The company, which we will call Example Co., is a hypothetical seed-stage B2B software startup with a working product, design partners and no recurring revenue yet. It plans to raise $2.5M.

Step 1: Set the baseline

Market data shows where seed pricing has been. Carta reported a median pre-money of $16 million for new seed rounds in Q1 2025, about 18% higher than a year earlier, while the number of seed rounds fell 28%. In Q3 2025, Carta's seed median pre-money was again $16 million, up 14% year on year. Equidam, citing the PitchBook-NVCA Venture Monitor, puts the US median seed pre-money for 2026 (to 30 September) at $18.3M.

Those medians include companies with revenue and are dominated by US software deals. VC Careers warns that applying a priced-seed median to a pre-revenue company can inflate the result sharply. For Example Co., we discount the national figure to a $12M baseline to reflect a pre-revenue regional comparable set. That $12M is our assumption for this example, and it goes in B2 with the reasoning written in B3.

Step 2: Rate each factor

Team (30% weight), rated 150%: repeat founders, and the CTO has built the core system before. Contribution 0.4500.
Opportunity (25%), rated 125%: a large buyer pool with clear budget ownership. Contribution 0.3125.
Product/technology (15%), rated 110%: live with design partners, though nothing is defensible yet. Contribution 0.1650.
Competitive environment (10%), rated 80%: two well-funded incumbents. Contribution 0.0800.
Marketing/sales/partnerships (10%), rated 70%: no channel partners and all sales are founder-led. Contribution 0.0700.
Need for additional investment (5%), rated 90%: will need a Series A within 18 months. Contribution 0.0450.
Other (5%), rated 100%: nothing unusual. Contribution 0.0500.

Step 3: Compute

The sum of factors is 1.1725. Multiplied by the $12M baseline, that gives a scorecard pre-money of about $14.07M. Adding the $2.5M raise puts post-money at $16.57M, so the round sells about 15.1% of the company.

Step 4: Stress-test

Drop the team rating from 150% to 125% and the multiplier falls by 0.075 to 1.0975, giving a pre-money of about $13.17M. Moving one rating down one notch removes roughly $900K of value. If the founders cannot back up the 150% team score with references and track record, that $900K is the first thing a lead investor will take back.

Takeaway. When you present a scorecard number, show the range alongside it. A $13.2M to $14.1M range with evidence for each rating is easier to defend than a single figure.

Three Mistakes That Break a Scorecard Valuation

1. Anchoring on the wrong median

Mixing pre-money and post-money figures is the most common error. Carta's seed data is reported on a pre-money basis, and some secondary sites quote post-money medians next to it as if the two were the same measure. Check which basis your source uses before the number goes into B2.

2. Rating everything above 100%

Founders who score their own company rarely give anything below 100%. Payne's own example includes a 75% and an 80%. If none of your seven ratings is below 100%, assume you are biased and ask an outside angel to rate the company blind.

3. Using one method alone

Equidam notes that Payne himself advised using several methods. Run the scorecard alongside the Berkus method and Risk Factor Summation, and treat the overlap between them as your negotiating zone. If the three methods are more than 30% apart, your inputs need another look.

Takeaway: keep a "Method comparison" tab in the same workbook so all three numbers update from the same inputs.

Why a Ready-Made Scorecard Template Pays Off

The arithmetic behind the scorecard method is simple. Deals go wrong because of the discipline around it. That discipline means a baseline you can source, weights that sum to 100%, ratings with evidence, and a sensitivity range that shows how much depends on each judgment call. Payne's own published example contained a summing error for years, which shows how easily a hand-built version can go wrong.

A pre-built scorecard valuation calculator gives you locked weights and validated rating cells. It also puts post-money, dilution and sensitivity in one free download that you can send to co-investors without explaining your formulas. Load your comparable median, score the seven factors with evidence, and you will have a defensible seed valuation before the first partner meeting. ModelStack's VC and startup toolkit includes this template next to Berkus and Risk Factor Summation tabs, so you can triangulate a number in an afternoon and spend the rest of your prep time on the term sheet.