What Is a Weighted Average? Formula and How to Calculate It

By Markets & Investing DeskUpdated Nov 10, 2026

Weighted Average
Illustration · Fintrev

Definition

A weighted average is an average in which each value counts in proportion to its assigned weight. Multiply each value by its weight, add the products, and divide by the sum of the weights.

Key takeaways

  • If the weights already sum to 1, the weighted average is simply the sum of the weighted values.
  • Buying 200 shares at $25, 100 at $40 and 50 at $52 gives an average cost of $33.14, not $39.
  • A geometric mean, not a weighted average, fits returns of the same item across successive periods.
  • A common mistake is dividing by the number of items instead of by the sum of the weights.

A weighted average (also called a weighted mean) is an average in which each value counts in proportion to an assigned weight, rather than equally. You multiply every value by its weight, add those products, and divide by the sum of the weights. Values with larger weights pull the result toward themselves.

The weights can reflect quantity (shares bought at each price), money (dollars invested in each holding), frequency (how often a value occurs) or judgment (how much a final exam counts toward a grade). The arithmetic is the same in each case; only what the weight represents changes.

How a Weighted Average Works

Weighted Average Formula

For values x₁, x₂, … xₙ with weights w₁, w₂, … wₙ:

Weighted average = (w₁x₁ + w₂x₂ + … + wₙxₙ) ÷ (w₁ + w₂ + … + wₙ)

In compact notation: Σ(wᵢ × xᵢ) ÷ Σwᵢ.

If the weights already sum to 1 (or 100%), the denominator equals 1, and the weighted average is simply the sum of the weighted values. Portfolio and capital-structure calculations are usually set up this way, which is why their formulas often show no division at all.

How to Calculate a Weighted Average Step by Step

  1. List each value and its weight. Make sure every weight is measured in the same unit: all shares, all dollars, or all percentages.
  2. Multiply each value by its weight.
  3. Add the products.
  4. Add the weights.
  5. Divide the sum of the products by the sum of the weights.

A common mistake is dividing by the number of items in step 5. That works only when the weights add up to the item count, which is rarely true.

Hypothetical example: a course grade. A course weights homework at 20%, the midterm at 30% and the final exam at 50%. A student scores 90, 75 and 82.

Component Score Weight Score × weight
Homework 90 0.20 18.0
Midterm 75 0.30 22.5
Final exam 82 0.50 41.0
Total 1.00 81.5

The weights sum to 1, so the weighted average is 81.5. The simple average of the three scores is 82.33. The gap exists because the midterm, the lowest score, carries more weight than homework, the highest score.

Interpreting a Weighted Average

Provided all weights are positive, a weighted average always falls between the smallest and largest values in the set. If one weight dominates, the result sits close to that value; if the weights are nearly equal, it sits close to the simple average. A weighted average above the simple average means the heavier weights sit on the higher values.

Weighted Average vs. Simple Average vs. Geometric Mean

These three averages answer different questions.

Simple (arithmetic) average. Add the values and divide by the count. It treats every observation as equally important. Technically it is a weighted average in which every weight is 1. It fits when items really are comparable, such as daily temperature readings or the average of several equally sized test scores.

Weighted average. Use it when observations differ in size or importance: positions of different dollar value, purchases of different share counts, loans of different balances. Applying a simple average to unequal items distorts the result.

Geometric mean. Multiply n values together and take the nth root. In finance it is used for returns over successive periods, because returns compound. Suppose an investment gains 50% in year one and loses 50% in year two. The arithmetic average return is 0%, yet $100 becomes $150 and then $75. The geometric mean is √(1.5 × 0.5) minus 1, or about -13.4% per year, which matches what happened. This is the logic behind the compound annual growth rate (CAGR).

The rule of thumb:

  • Use a weighted average to combine different items at one point in time (holdings in a portfolio, components of a grade).
  • Use a geometric mean to combine the same item across periods (yearly returns).

How Weighted Averages Are Used in Finance

Average Cost Basis of Shares

Investors often buy the same stock at different prices over time. The average price paid per share is a weighted average, with the share count at each price as the weight.

Hypothetical example:

  • 200 shares at $25 = $5,000
  • 100 shares at $40 = $4,000
  • 50 shares at $52 = $2,600

The total cost is $11,600 for 350 shares, so the weighted average cost is $11,600 ÷ 350 = $33.14 per share. The simple average of the three prices, $39, overstates the cost because most shares were bought at the lowest price. Tax rules on which cost-basis method you may use depend on the asset and jurisdiction, so the method and any commissions should match your broker’s records.

Weighted Average Portfolio Return

A portfolio’s return for a period equals the weighted average of each holding’s return. Each weight is that holding’s share of total portfolio value at the start of the period.

Hypothetical example: a portfolio is 60% stocks, 30% bonds and 10% cash. Over the period, stocks return 8%, bonds 4% and cash 3%.

(0.60 × 8%) + (0.30 × 4%) + (0.10 × 3%) = 4.8% + 1.2% + 0.3% = 6.3%

Two assumptions sit behind this figure: the weights are measured at the start of the period, and no money is added or withdrawn during it. A mutual fund or ETF reporting a one-year return is in effect reporting a value-weighted average of what its positions did, reflected through changes in net asset value.

Dollar-Weighted vs. Time-Weighted Returns

When cash flows in and out of an account during the period, there are two common ways to measure performance:

  • A dollar-weighted return (money-weighted return) is the internal rate of return on all the cash flows. Periods when more money was invested count more heavily, so the result reflects the timing of your deposits and withdrawals.
  • A time-weighted return links the returns of each sub-period between cash flows. This removes the effect of their size and timing.

Fund managers are typically judged on time-weighted returns because they do not control when investors add money. The dollar-weighted return is closer to the experience of an individual investor who contributed at particular times. The two figures can differ considerably for the same account.

Market Value Weighted Indexes

Many stock indexes are weighted averages. A market capitalization weighted index, such as the S&P 500, weights each company by the market value of its float-adjusted shares, so a 1% move in the largest company moves the index far more than a 1% move in the smallest. A price-weighted index such as the Dow Jones Industrial Average weights each stock by its share price. An equal-weighted index gives every member the same weight, making it a simple average of returns.

Weighted Average Cost of Capital (WACC)

WACC is the blended rate a company pays for its financing, weighted by the market value of each source of capital:

WACC = (E/V × Re) + (D/V × Rd × (1 minus Tc))

Here E is the market value of equity, D is the market value of debt, V = E + D, Re is the cost of equity, Rd is the pre-tax cost of debt, and Tc is the corporate tax rate. The debt term is adjusted for tax because interest is generally tax-deductible.

Hypothetical example: a company is financed 70% by equity at a 10% cost and 30% by debt at a 5% pre-tax cost, with a 21% tax rate.

(0.70 × 10%) + (0.30 × 5% × 0.79) = 7.0% + 1.185% = 8.19%

Analysts use WACC as a discount rate for a company’s projected cash flows when estimating its value. Because the weights use market values, WACC shifts as share prices and debt levels change.

Weighted Average Interest Rate

Borrowers with several loans can combine them into one blended rate by weighting each rate by its balance.

Hypothetical example: $10,000 at 6% and $30,000 at 4%.

($10,000 × 6% + $30,000 × 4%) ÷ $40,000 = $1,800 ÷ $40,000 = 4.5%

The simple average of the rates is 5%, which is too high because most of the balance carries the lower rate. US federal student loan consolidation sets the new fixed rate from the weighted average of the loans being combined, rounded up to the nearest one-eighth of a percentage point.

Inventory: The Weighted Average Cost Method

Under the weighted average cost method, a business values its inventory, and the cost of goods sold, at the average cost of all units available. It divides the total cost of goods available for sale by the number of units.

Hypothetical example: 100 units bought at $5 and 300 units at $6 give a total cost of $2,300 for 400 units, or $5.75 per unit. Every unit sold is costed at $5.75, whichever batch it physically came from.

The alternatives give priority to the order of purchase rather than to averaging. FIFO (first in, first out) assigns the oldest costs to goods sold. LIFO (last in, first out) assigns the newest costs. When prices are rising, the weighted average method produces a cost of goods sold between the FIFO and LIFO figures. LIFO is permitted under US GAAP but not under IFRS.

Bond Portfolio Metrics

Bond funds often report a weighted average maturity, a weighted average duration and a weighted average yield. Each holding is weighted by its market value. A fund’s average yield to maturity built this way summarizes the portfolio, but it is not the return any single bond will deliver.

VWAP and Moving Averages

Traders use weighted averages in price indicators:

  • Volume-weighted average price (VWAP) = Σ(price × volume) ÷ Σ(volume), usually calculated over one trading session. Prices at which more shares traded count more heavily. Institutions often compare their execution prices against VWAP.
  • Weighted and exponential moving averages give recent prices larger weights than older ones, so they react faster to new price moves than a simple moving average does.

Advantages and Limitations

Advantages

The main advantage is accuracy when items differ in size or importance: for cost basis, portfolio return and blended rates, the weighted figure is the correct answer, not an approximation. It also reduces the pull of small, extreme observations, since an unusual value with a small weight barely moves the result, while a simple average treats it like every other value.

Limitations

  • Weights can be subjective. When weights reflect judgment rather than measurable quantities (for example, scoring factors in a stock screen), the result builds that judgment in. Two analysts using the same data but different weights can reach different conclusions.
  • Sensitivity to the weighting scheme. Small changes in weights can shift the result noticeably, especially when the values are far apart.
  • Information is hidden. A single number conceals the spread of the values beneath it. A 6% average portfolio return could come from holdings that all returned about 6%, or from one big winner and several losers.
  • Stale weights. Market-value weights drift as prices move. A portfolio return calculated with last year’s allocation will not match this year’s results.

Common Calculation Mistakes

  • Mixing weight units. Combining share counts with dollar amounts, or percentages with decimals, in the same calculation.
  • Weights that do not total 100%. If allocation percentages add up to 98% because a position was left out, the “return” that results is understated.
  • Averaging averages. The average of two branch-level averages is wrong if the branches have very different sizes. Weight each one by its count or volume.

FAQs

Can a weight be negative?

In portfolio math, yes. A short position or a leveraged allocation can carry a negative weight, with the long positions summing to more than 100%. In that case the weighted average can fall outside the range of the individual values, so the usual "between the minimum and maximum" check no longer applies.

How do you calculate a weighted average in a spreadsheet?

Put the values in one column and the weights in another. In Excel or Google Sheets, the formula is =SUMPRODUCT(values, weights)/SUM(weights).

The Bottom Line

Investors, borrowers, students and business owners all rely on weighted averages to figure cost basis, portfolio returns, blended loan rates, grades and inventory costs. When items differ in size or importance, the weighted figure is the correct answer, while a simple average distorts it. Keep weight units consistent, confirm the weights total 100%, and remember that one average can hide a wide spread of values beneath it.

About this page

Written by Markets & Investing Desk

The Markets & Investing Desk covers investing guides, the financial dictionary, companies, people, economics and market data.

Published
Last updated

Spotted an error? Tell the editors. This page is general information, not financial advice.