Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Internal Rate of Return (IRR)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Mortgage APR vs Interest Rate
- Regression Formula
- Correlation Coefficient Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- Regression vs ANOVA

**Weighted Mean Formula (Table of Contents)**

## What is the Weighted Mean Formula?

The weighted mean is a type of average in which weights are assigned to individual values in order to determine the relative importance of each observation. The relevance of each number is called weight. It is calculated by multiplying the weight with the quantitative outcome associated with it and then adding all the products together. If all the weights are equal, then weighted mean and arithmetic mean will be the same.

It is used in many instances. For example, financial analysts usually observe the behavior of specific securities under different market conditions and its calculation is used to calculate the expected returns on their investments.

**The technical formula for the weighted mean is represented as follows**

Where

- ∑ denotes the sum
- w is the weights and
- x is the value

**In cases where the sum of weights is 1,**

### Explanation of the Weighted Mean Formula

The weighted mean formula can be calculated by using the following five simple steps mentioned below:

**Step 1:** List the numbers and weights in tabular form. Presentation in tabular form is not compulsory but makes the calculations easy.

**Step 2: **Multiply each number and relevant weight assigned to that number (w_{1 }by x_{1, }w_{2 }by x_{2 }and so on)

**Step 3:** Add the numbers obtained in Step 2 (∑x_{1}w_{i})

**Step 4: **Find the sum of the weights (∑w_{i})

**Step 5: **Divide the total of the values obtained in Step 3 by the sum of the weights obtained in Step 4 (∑x_{1}w_{i}/∑w_{i})

**Note:**If the sum of the weights is 1, then the total of the values obtained in Step 3 will be the weighted mean.

### Examples of Weighted Mean Formula (with Excel Template)

Let’s see some simple to advanced examples of the Weighted Mean Formula to understand it better.

4.9 (927 ratings)

#### Example #1

**The following are 5 numbers and the weights assigned to each number. Calculate the weighted mean of the above numbers.**

**Solution:**

Wght Mean = 246/29

Wght Mean will be –

#### Example #2

**The CEO of a company has decided that he will continue the business only if the return on capital is more than the weighted average cost of capital. The company makes a return of 14% on its capital. The capital consists of equity and debt in the proportion of 60% and 40% respectively. The cost of equity is 15% and the cost of debt is 6%. Advise the CEO on whether the company should continue with its business.**

**Solution:**

Let us first present the given information in tabular form to understand the scenario under.

We will use the following data for the calculation of the Weighted Mean equation

WM =0.60*0.15 + 0.40*0.06

= 0.090 + 0.024

**Since the return on capital at 14% is more than the weighted average cost of capital of 11.4%, the CEO should continue with his business.**

#### Example #3

**It is difficult to gauge the future economic scenario. The stock returns could get affected. The finance advisor develops different business scenarios and expected stock returns for each scenario. This would enable him to make a better investment decision. Calculate the weighted average from the above data to help the Investment Advisor to showcase the expected stock returns to his clients.**

**Solution:**

We will use the following data for the calculation of the Weighted Mean equation

=0.20*0.25 + 0.30*(-0.10) + 0.50*0.05

= 0.050 – 0.030 + 0.025

WM will be –

**The expected return for the stock is 4.5%.**

#### Example #4

**Jay is a rice merchant who sells various types of rice in Maharashtra. Some rice grades are of higher quality and are sold at a higher price. He wants you to calculate the weighted mean from the following data:**

**Solution:**

We will use the following data for the calculation of the Weighted Mean equation

**Step 1:** In Excel, there is an inbuilt formula for calculating the products of the numbers and then their sum, which is one of the steps in calculating the weighted average. Select a blank cell and type this formula = SUMPRODUCT(B2:B5, C2:C5) where the range B2:B5 represents the weights and the range C2:C5 represents the numbers.

**Step 2: ** Calculate the sum of the weights using the formula =SUM(B2:B5) where the range B2:B5 represents the weights.

**Step 3: **Calculate =C6/B6,

WM will be –

**This gives the WM as Rs 51.36.**

### Relevance and Uses

Weighted mean can aid an individual to make decisions where some attributes have more significance than others. For instance, it is generally used for calculating the final grade for a specific course. In courses, generally, the comprehensive exam has more weight to the grade than chapter tests. Thus, if one performs poorly in chapter tests but does really well in final exams, the weighted average of the grades will be relatively high.

It is used in descriptive statistical analysis such as calculating index numbers. For instance, stock market indices such as Nifty or BSE Sensex are calculated by using the weighted average method. It can also be applied in physics to find the center of mass and moments of inertia of an object with a known density distribution.

Businessmen often calculate the weighted mean to evaluate the average prices of goods purchased from different vendors where the purchase quantity is considered as the weight. This gives a businessman a better understanding of his expenses.

This formula can be applied to calculate the average returns from a portfolio comprising of different financial instruments. For instance, let us assume equity consists of 80% of a portfolio and debt balance 20%. The returns from equity are 50% and from debt are 10%. The simple average would be (50%+10%)/2, which is 30%.

This gives a wrong understanding of the returns as equity constitutes a majority of the portfolio. Hence, we calculate a weighted average, which works out to be 42%. This number of 42% is much closer to equity returns of 50% as equity accounts for the majority of the portfolio. In other words, the returns are pulled by an equity weight of 80%.

### Recommended Articles

This has been a guide to Weighted Mean Formula. Here we discuss how to calculate weighted mean with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –

## Leave a Reply