WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Weighted Average Formula

Weighted Average Formula

By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

By Dheeraj Vaidya, CFA, FRM

Formula to Calculate Weighted Average

Weighted average is a type of an average that takes into account the relative importance of each value under consideration and is calculated by multiplying the respective weights (in percentage terms) with its corresponding value

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

WEIGHTED AVERAGE FORMULA

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.

You can download this Weighted Average in Excel Template here – Weighted Average in Excel Template

Ramen has invested his money into four types of investments. He has invested 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%. Calculate weighted avg of the rates of return Ramen would receive.

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

Using the weighted average formula, we get –

  • Weighted Avg = w1x1 + w2x2 + w3x3 + w4x4
  • Weighted 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. That’s why when we calculate the simple average, the result becomes too generic. However, in the weighted average, we pay the right emphasis on the right weight, and we portray the weight in terms of percentages.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

If you look at the weighted average formula, you would see that the value is being multiplied by the right amount of weight, and that is the beauty of the wt average.

  • For example, if we need to find out the average of 10, 13, and 25, on a simple average, we will add three numbers and divide it by 3. Simple average of the above three numbers would be = (10 + 13 + 25) / 3 = 48 / 3 = 16.
  • If we take the same example with weight; then the result would be quite different. Let’s say that the weight of number 10 is 25%, 13 is 30%, and 25 is 45%. Wt 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 weighted average cost of capital. In calculating the weighted average cost of capital, we take the cost of equity and the cost of debt into account. And depending on the capital structure of the company, we calculate the WACC.

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

Now, while calculating the outstanding shares available during the year, we will use the weighted average method. 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 shares = (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.

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

You can easily calculate the ratio in the Weighted Average in the Excel template provided.

Weighted Average formula in Excel

Recommended Article

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?
  • Formula for Risk-Weighted Asset
  • Average Formula in Excel
  • Average in Power BI
7 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Category iconExcel Modeling,  Financial Modeling Tutorials

Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Weighted Average in Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More