Formula to Calculate Weighted Average

Weighted Average Formula = W1X1 + W2X2 +……+WnXn

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Weighted Average Formula (wallstreetmojo.com)

Here, w = respective weight (in percentage), x = value

Example

Let’s take a simple weighted average example to illustrate how we calculate a weighted average.

Ramen has invested his money into four types of investments: 10% of his money in Investment A, 20% in Investment B, 30% in Investment C, and 40% in Investment D. The rates of return for these investments are 5%, 10%, 15%, and 20%. But, first, calculate the weighted average of the rates of return Ramen would receive.

In this weighted average example, we have both w and x.

Using the weighted average formula, we get the following:

  • Weighted Avg = w1x1 + w2x2 + w3x3 + w4x4Weighted Avg = 10% * 5% + 20% * 10% + 30% * 15% + 40% * 20% = 0.005 + 0.02 + 0.045 + 0.08 = 15%.

Explanation

On a simple average, we don’t pay heed to the weight. The result becomes too generic when we calculate the simple average. However, in the weighted average, we pay the right emphasis on the right weight, and we portray the weight in terms of percentages.

If you look at the weighted average formula, you will see that the value is multiplied by the right amount of weight, which is the beauty of the weighted average.

  • For example, if we need to find the average of 10, 13, and 25 on a simple average, we will add three numbers and divide them by 3. Simple average of the above three numbers would be = (10 + 13 + 25) / 3 = 48 / 3 = 16.The result would be quite different if we took the same example with weight. Let’s say that the weight of number 10 is 25%, 13 is 30%, and 25 is 45%. Weighted average of the above three numbers of would-be = (10 * 25%) + (13 * 30%) + (25 * 45%) = 2.5 + 3.9 + 11.25 = 17.65.

Use

The usage of the weighted average is quite broad.

As for the weighted average example, we can talk about the + [Cost of Debt * % of Debt * (1-Tax Rate)]” url=”https://www.wallstreetmojo.com/weighted-average-cost-capital-wacc/”]weighted average cost of capital”Weighted”The. In calculating the weighted average cost of capital, we consider the cost of equity and the cost of debtCost Of DebtCost of debt is the expected rate of return for the debt holder and is usually calculated as the effective interest rate applicable to a firms liability. It is an integral part of the discounted valuation analysis which calculates the present value of a firm by discounting future cash flows by the expected rate of return to its equity and debt holders.read more. And depending on the company’s capital structure, we calculate the WACC.

Another example where we use the weighted average cost of capital is the issuance of outstanding shares. Let’s say a firm issued 100 shares on the 1st of January. And then another 100 shares are issued on the 1st of July.

Now, we will use the weighted average method while calculating the outstanding sharesCalculating The Outstanding SharesOutstanding shares are the stocks available with the company’s shareholders at a given point of time after excluding the shares that the entity had repurchased. It is shown as a part of the owner’s equity in the liability side of the company’s balance sheet.read more available during the year. Since the first 100 shares are issued on the 1st of January, it would be applicable for the whole year. But the next 100 shares are only issued in the middle of the year. That’s why the next 100 shares would be available only for 6 months. And here would be the calculation of weighted average of outstanding sharesWeighted Average Of Outstanding SharesWeighted Average Shares Outstanding is a calculation used to estimate the variations in a Company’s outstanding shares during a given period. It is determined by multiplying the outstanding number of shares (consider issuance & buybacks) in a given reporting period with their individual time-weighted portions. read more = (100 * 1) + (100 * 0.5) = 100 + 50 = 150.

Weighted Average in Excel (with excel template)

Let us now do the same example as above in Excel.

It is very simple. You need to provide the values of “X” and “Y.”

Then, you can easily calculate the ratio in the Weighted Average in the ExcelWeighted Average In The ExcelIn Excel, we calculate Weighted Average by assigning weights to each data set. It is generally used to compute robust observations in statistics or portfolios and is calculated as (w1x1+w2x2+….+wnxn)/(w1+w2+..wn), where w is the weight allocated to the x value and the sumproduct function is used.read more template provided.

This article is a guide to Weighted Average Formula. Here, we learn how to calculate the weighted average using its formula and practical examples, a calculator, and a downloadable Excel template. You may also take a look at the following useful articles: –

  • What is the Deadweight Loss Formula?What Is The Deadweight Loss Formula?When the two fundamental forces of Economy Supply and Demand are not balanced it leads to Deadweight loss. Deadweight loss could be calculated by drawing a graph of demand and supply. read moreFormula for Risk-Weighted AssetFormula For Risk-Weighted AssetRisk-weighted asset refers to the minimum amount that a bank or any other financial institution must maintain to avoid insolvency or bankruptcy risk. The risk associated with each bank asset is analyzed individually to figure out the total capital requirement.read moreAverage Formula in ExcelAverage in Power BI Average In Power BI Power BI average provides the aggregate of the numerical values across the selected column. It ignores the non-numeric variables and empty cells. However, the values written as zero are included in the aggregation.read more