Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
ChartsPortfolio analysis and optimizationPortfolio Management

Wealth Index Using Excel

Written by Priya Kumar
Wed Sep 02 2020
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
 

The Wealth Index of portfolio with MarketXLS calculates the highest rate of return for the investment. The MarketXLS add-in enables it to apply to either financial instrument or business portfolios. The wealth index is a popular function to evaluate the investment and to calculate the returns.

What is Wealth Index

The wealth index is a data series that presents the value of your portfolio at historical time periods explaining the portfolio’s value at different points in time corresponding to the returns generated by it.

Calculation of Wealth Index

Wealth is referred to as earnings, and wealth index means profits over investments. It is a metric used to evaluate the investments and deciding whether to go on with the same investments or to include other assets in the portfolio.

The return on investment can be calculated by using total return. The total return is the total amount of yield plus capital earning form the portfolio.

Wealth Index using Excel

And if the investment does not pay the yield or capital gain, then the return can be calculated by using relative return.

Wealth Index using Excel

Both of the above formulas are used to calculate the return on individual investment.

Cumulative Wealth Index

The cumulative wealth index (CWI) is simply the return, expressed as a decimal multiple of the initial amount, earned by a certain initial amount of money over years. The calculation usually uses $1 as the initial investment, and the returns are compounded annually:

CWIn = WI0 × (1 + TR1) × (1 + TR2) × … × (1 + TRn)

Where:

WI0= Initial wealth

TR = Total Return

n = No. of years

Geometric Mean

The geometric mean is more accurate than the arithmetic mean because it accounts for compounding:

Geometric Mean = [(1+ TR1) (1+ TR2) … (1+ TRn)] 1/n – 1

where:

TR = Total Return

n = No. of years

The geometric mean will usually yield the correct, accurate result, but the example was off a little because of rounding errors in the data. Total returns can also be adjust for inflation by dividing the total return over a given period by the inflation rate over that same period, usually one year.

 

How MarketXLS Calculates Wealth Index of your Portfolio

MarketXLS® completely automates the process of calculating the wealth index using excel to get the optimal portfolios by calculating the wealth index.

The following inputs are required to be entered by the investor:

1. Symbol of the asset: Enter the ticker under which the security in your Portfolio is traded.

2. Weight of the asset in your Portfolio: Enter the percentage weight of each security, as shown below.

Input:

Optional Input:

Initial Investment: Enter the amount you invested initially to derive a data series that explains the present value of your portfolio.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Oppenheimer Holdings Inc. Class A (DE) logo

Oppenheimer Holdings Inc. Class A (DE)

42.74
 
USD
 
1.08
 
(2.59%)
85
Rank
Optionable: Yes
Market Cap: 451 M
Industry: Capital Markets
52 week range    
28.41   
   50.14
Midland States Bancorp Inc. logo

Midland States Bancorp Inc.

27.57
 
USD
 
0.66
 
(2.45%)
83
Rank
Optionable: No
Market Cap: 589 M
Industry: Banks - Regional - US
52 week range    
23.48   
   30.60
Kroger Company (The) logo

Kroger Company (The)

48.41
 
USD
 
-0.78
 
(-1.59%)
83
Rank
Optionable: Yes
Market Cap: 35,325 M
Industry: Grocery Stores
52 week range    
41.82   
   62.78
Ingles Markets Incorporated Class A Common Stock logo

Ingles Markets Incorporated Class A Common Stock

100.76
 
USD
 
-0.34
 
(-0.34%)
83
Rank
Optionable: Yes
Market Cap: 1,910 M
Industry: Grocery Stores
52 week range    
74.63   
   102.88
Amdocs Limited logo

Amdocs Limited

89.99
 
USD
 
1.13
 
(1.27%)
82
Rank
Optionable: Yes
Market Cap: 10,525 M
Industry: Software - Infrastructure
52 week range    
69.79   
   90.77
Tecnoglass Inc. logo

Tecnoglass Inc.

30.37
 
USD
 
1.37
 
(4.72%)
81
Rank
Optionable: Yes
Market Cap: 1,349 M
Industry: Building Materials
52 week range    
16.05   
   34.08
Interpublic Group of Companies Inc. (The) logo

Interpublic Group of Companies Inc. (The)

34.46
 
USD
 
0.10
 
(0.29%)
81
Rank
Optionable: Yes
Market Cap: 13,330 M
Industry: Advertising Agencies
52 week range    
25.14   
   39.98
Guess? Inc. logo

Guess? Inc.

20.71
 
USD
 
-0.05
 
(-0.24%)
81
Rank
Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
14.27   
   25.27
Bristol-Myers Squibb Company logo

Bristol-Myers Squibb Company

80.88
 
USD
 
0.60
 
(0.75%)
81
Rank
Optionable: Yes
Market Cap: 168,030 M
Industry: Drug Manufacturers - Major
52 week range    
55.76   
   81.44
Best Buy Co. Inc. logo

Best Buy Co. Inc.

86.47
 
USD
 
1.17
 
(1.37%)
81
Rank
Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    
60.79   
   112.96

More Features