Equal-weighted Index (Weight, Value, and Return) – Excel Template

Ivan Kitov
Ivan Kitov

A price-weighted index is a stock index that requires each company to be assigned an equal weight. The total value of the index is determined by the value of each stock, as if all of them carry equal importance or value in the calculation. The return of an equal-weighted index is estimated as a simple average of the returns of the index stocks.

Some other related topics you might be interested to explore are Price-weighted index, Market-capitalization weighted index, and Float-adjusted market-capitalization weighted index.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Financial Analyst, Data Analyst, or Portfolio Manager.

You can now download the Excel template for free.

Equal-weighted index is among the topics included in the Portfolio Management module of the CFA Level 1 Curriculum.

Top