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
Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

108.01
 
USD
 
-0.39
 
(-0.36%)
84
Rank
Optionable: Yes
Market Cap: 8,953 M
Industry: Auto & Truck Dealerships
52 week range    
72.35   
   119.47
Zim Integrated Shipping Services Ltd logo

Zim Integrated Shipping Services Ltd

64.70
 
USD
 
0.94
 
(1.47%)
80
Rank
Optionable: Yes
Market Cap: 7,792 M
Industry: Deep Sea Freight Transportation
52 week range    
33.71   
   91.23
Universal Logistics Holdings Inc. logo

Universal Logistics Holdings Inc.

24.07
 
USD
 
-0.55
 
(-2.23%)
79
Rank
Optionable: No
Market Cap: 684 M
Industry: Trucking
52 week range    
15.86   
   26.90
NRG Energy Inc. logo

NRG Energy Inc.

45.72
 
USD
 
-0.49
 
(-1.06%)
79
Rank
Optionable: Yes
Market Cap: 10,725 M
Industry: Utilities - Independent Power Producers
52 week range    
31.94   
   46.86
Corteva Inc. logo

Corteva Inc.

59.23
 
USD
 
0.23
 
(0.39%)
79
Rank
Optionable: Yes
Market Cap: 41,692 M
Industry: Agricultural Inputs
52 week range    
40.60   
   62.04
Avnet Inc. logo

Avnet Inc.

46.30
 
USD
 
-0.27
 
(-0.58%)
78
Rank
Optionable: Yes
Market Cap: 4,732 M
Industry: Electronics Distribution
52 week range    
35.71   
   48.75
Universal Corporation logo

Universal Corporation

59.59
 
USD
 
-0.47
 
(-0.78%)
77
Rank
Optionable: Yes
Market Cap: 1,529 M
Industry: Tobacco
52 week range    
46.24   
   63.46
Kronos Worldwide Inc logo

Kronos Worldwide Inc

17.50
 
USD
 
-0.52
 
(-2.89%)
77
Rank
Optionable: Yes
Market Cap: 1,897 M
Industry: Specialty Chemicals
52 week range    
12.06   
   18.48
Boise Cascade L.L.C. logo

Boise Cascade L.L.C.

76.72
 
USD
 
-1.29
 
(-1.65%)
77
Rank
Optionable: Yes
Market Cap: 3,260 M
Industry: Lumber & Wood Production
52 week range    
46.51   
   85.17
Rollins Inc. logo

Rollins Inc.

35.28
 
USD
 
0.95
 
(2.77%)
76
Rank
Optionable: Yes
Market Cap: 17,428 M
Industry: Business Services
52 week range    
28.51   
   40.11

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!