What is Weighted Average?
Weighted average is a statistical method that gives different values different importance (weights) in calculating an average. Learn how to calculate weighted average, where it's used in accounting and finance, and why it matters for freelancers.
What Is Weighted Average?
Weighted average (also called weighted mean) is a statistical and accounting method that calculates an average by assigning different weights to different values based on their relative importance, frequency, or proportion. Unlike a simple arithmetic average, the weighted average reflects the fact that not all data points contribute equally to the final result. Schema DefinedTerm: Weighted average — a statistical measure that calculates an average by multiplying each value by its assigned weight, summing those products, and dividing by the sum of weights; used in accounting (inventory costing), finance (portfolio returns), and statistics to account for variables of different significance. The weighted average is one of the most practical and widely-used statistical tools in business — appearing in inventory accounting, financial portfolio analysis, grading systems, supply chain costing, and countless other applications.
The Weighted Average Formula
Weighted Average = Σ (Value × Weight) / Σ (Weights) Or in plain language: The sum of (each value multiplied by its weight), divided by the sum of all weights. Step-by-Step Calculation Example: Calculate the weighted average of three exam scores, where exams have different weightings: | Exam | Score (Value) | Weight | Score × Weight | |---|---|---|---| | Midterm | 85 | 30% | 25.5 | | Final | 92 | 50% | 46.0 | | Quiz Average | 78 | 20% | 15.6 | | Total | | 100% | 87.1 | Weighted Average = 87.1 Note that the simple average would be (85 + 92 + 78) / 3 = 85.0 — the weighted average is higher because the stronger final exam (92) was weighted more heavily than the quiz average.
Weighted Average in Accounting: Inventory Costing
Weighted Average Cost (WAC) Method One of the three primary inventory valuation methods under GAAP (alongside FIFO and LIFO). WAC assigns the same cost to all units in inventory, based on the weighted average cost per unit. WAC Formula: `` WAC per unit = Total Cost of Goods Available for Sale / Total Units Available for Sale `` Example: - Beginning inventory: 100 units @ $10 = $1,000 - Purchase 1: 200 units @ $12 = $2,400 - Purchase 2: 150 units @ $14 = $2,100 - Total: 450 units, $5,500 - WAC per unit: $5,500 / 450 = $12.22 If 200 units are sold, COGS = 200 × $12.22 = $2,444, and ending inventory = 250 × $12.22 = $3,055. - Smooths out price fluctuations: Unlike FIFO (which uses oldest costs) or LIFO (which uses newest costs), WAC blends all costs - Simpler than FIFO/LIFO: Easier to calculate and maintain - IRS requirements: LIFO has specific requirements and restrictions; WAC is more straightforward - Inventory composition matters: In periods of rising prices, WAC produces results between FIFO (lower COGS, higher inventory) and LIFO (higher COGS, lower inventory)
Weighted Average in Finance
Portfolio Returns A portfolio's overall return is the weighted average of its components' returns: Example: - 60% stocks, returning 12% - 25% bonds, returning 4% - 15% real estate, returning 8% Portfolio Return = (0.60 × 12%) + (0.25 × 4%) + (0.15 × 8%) = 7.2% + 1.0% + 1.2% = 9.4% Weighted Average Cost of Capital (WACC) WACC represents the average cost of all capital (debt + equity), weighted by the proportion of each in the company's capital structure. It's used as the discount rate in DCF valuation. WACC Formula: `` WACC = (E/V × Re) + (D/V × Rd × (1 - Tax Rate)) Where: E = equity value, D = debt value, V = total value, Re = cost of equity, Rd = cost of debt ``
Weighted Average in Freelance/Small Business Context
Calculating Effective Hourly Rate If you have multiple projects at different hourly rates, your effective rate is a weighted average: | Project | Rate | Hours | Revenue | |---|---|---|---| | Project A | $150/hr | 40 | $6,000 | | Project B | $100/hr | 20 | $2,000 | | Project C | $75/hr | 30 | $2,250 | | Total | | 90 | $10,250 | Effective Rate = $10,250 / 90 hours = $113.89/hour This is more meaningful than a simple average of ($150 + $100 + $75) / 3 = $108.33 — the effective rate properly accounts for the actual time distribution. Job Costing with Weighted Average Freelancers doing job costing can use weighted average to blend rates for different team members or different skill levels on a single project.
How Eonebill Helps
Eonebill's time tracking and reporting features automatically calculate your effective hourly rate across all projects, accounting for different rates by client or project type. This gives you the weighted average perspective you need to understand true profitability by client and by type of work.
Related Terms
- Inventory Valuation — WAC, FIFO, LIFO methods - WACC — weighted average cost of capital - Effective Hourly Rate — freelance rate analysis
Related Templates
- Weighted Average Cost Calculator - Job Costing Template