ETFsPortfolio analysis and optimizationPortfolio Management

Risk Parity Portfolio In Excel – Explanation & Construction

Written by Ansh Thakkar (Individual Contributor)
Wed Mar 24 2021
Risk_Parity_Portfolio
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Risk_Parity_Portfolio
 

Risk Parity Portfolio
The risk parity approach to portfolio construction seeks to allocate the capital in a portfolio based on a risk-weighted basis. It attempts to avoid the risks and skews of traditional portfolio diversification.
The basic difference between Risk Parity Portfolio and normal portfolio is that the Risk Parity Portfolio contains diversified class of assets and it makes the usage of correlation to maximize the returns and keep the volatility tolerable. Market XLS will automatically calculate the ratios and metrics which include: Correlation, CAGR, Value at Risk, Portfolio Volatility, Positive Period, Portfolio Beta, Treynor Ratio, Max. Drawdown, Sharpe Ratio and Sortino Ratio.
Correlation
Correlation is a statistical measure of how two asset prices move in relation to each other. Correlation calculations are based on historical data; there is no guarantee that these correlations will continue in the future. MarketXLS has a ready-to-use template, using which you can find correlation between two assets easily. The link for this template is attached with the image given below.

Building a Risk-Parity Portfolio using MarketXLS
1) We have tried to build a Risk-Parity Portfolio using 4 assets (each having a weightage of 25%)
2) We will start by allocating equal weight to all these assets
3) We will use MSFT (stable), TSLA (highly volatile), an ETF and an Inflation Protected bond in our example.
4) For better simulation, we will use the period from March 2020 – February 2021.
5) A basic Investment of 7,000 USD has been taken.
Let us dive straight into the construction!

Normal Portfolio

As you can see, the value of our portfolio is now $18,946 having only 8 positive periods out of 12 and a CAGR of 89.46%.

In order to aim for an improvement in the risk and growth structure, let’s dig into the correlation of all the 4 assets in the portfolio.

Correlation Table:

Correlation_Matrix
https://marketxls.com/template/correlation-matrix-r/

The Correlation between the 4 assets can be calculated from the ‘Correlation Matrix R’ whose link has been provided as the caption of the image.

MarketXLS provides ready-to-use templates for facilitating data collection and presentation of a Risk Parity Portfolio in an easy manner. In MarketXLS, there are several functions using which you will be able to compare two different kinds of portfolios in the same period or the same portfolio in 2 different periods using the “Comparisons” template
Let’s concentrate on the following points:
• In Risk Parity Portfolio, we try to reduce the risk of the asset in the portfolio. Indicator of risk is Standard Deviation. Since Tesla (TSLA/”>NYSE:TSLA) is very volatile, they have a very high standard deviation. To reduce the risk they offer, lets reduce their participation in our portfolio from 25% to 15%. This frees 10% of the total space of portfolio.
• Since Inflation Protected Bonds (NYSE:VTIP) have a lower CAGR than the other 2 assets which are left, we transfer the weightage of 10% from Inflation Protected Bonds to MSFT equity. (MSFT/”>NYSE:MSFT).
• Our software will also provide the Correlation between different assets which would facilitate you in determining the weight to be assigned to a particular asset in the portfolio. Looking at the table which shows the monthly correlation of the assets, we can see that Invesco ETF has a low correlation with the other 3 assets. As mentioned earlier, the low correlation helps in reducing the overall risk of the portfolio, we allocate the freed up 10% weightage to the Invesco Developed Markets Momentum ETF. (NYSE:PIZ)

Concluding from the above three points, we can see the allocation of the new portfolio as follows:
• 15% Tesla (TSLA)
• 15% Vanguard Short Term Inflation Protected ETF (VTIP)
• 35% Microsoft (MSFT)
• 35% Invesco ETF (PIZ)

MarketXLS will now calculate the returns provided by the new Risk Parity Portfolio as compared to the Basic Portfolio. It will emphasize your focus on volatility and standard deviation, rather than on capital allocation.

Risk_Parity_Portfolio

MarketXLS has created a database of several templates including risk management, portfolio analysis and management and investment strategies covering how investors can manage risk across various sectors. These templates are designed in such a way that it will enable you to get all the historic as well as current information relating to all varieties of stocks.

Conclusion
There is a sharp rise in the CAGR. The value of the portfolio has turned out to be 27,559 USD after balancing it out with parity.
Since MSFT & PIZ have been allotted 10% more weightage than earlier, they will give more returns. Secondly, the volatility of TSLA has been reduced by reducing the weightage given to it by 10%. This is a perfect example of a Risk Parity Portfolio which can be created using MarketXLS.
The pictures and graphics used were taken from this software itself – MarketXLS.

For more such useful information, please visit https://marketxls.com/ .

Disclaimer
None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.
The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.
the article is written for helping users collect the required information from various sources deemed to be an authority in their content. The trademarks if any are the property of their owners and no representations are made.

Reference
https://seekingalpha.com/article/4353057-building-risk-parity-portfolio-example

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

Top 100 Gainers Today

Top 100 losers Today

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

Cowen Inc. logo

Cowen Inc.

30.93
 
USD
 
6.89
 
(28.66%)
83
Rank
Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
21.35   
   41.05
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

90.12
 
USD
 
-2.72
 
(-2.93%)
82
Rank
Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
69.32   
   93.45
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.41
 
USD
 
-0.14
 
(-0.27%)
81
Rank
Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Amdocs Limited logo

Amdocs Limited

83.04
 
USD
 
-1.41
 
(-1.67%)
80
Rank
Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
67.36   
   87.76
NBT Bancorp Inc. logo

NBT Bancorp Inc.

38.30
 
USD
 
0.14
 
(0.37%)
79
Rank
Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
31.68   
   41.70
CRA InternationalInc. logo

CRA InternationalInc.

89.64
 
USD
 
0.49
 
(0.55%)
79
Rank
Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
78.05   
   115.47
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

10.23
 
USD
 
0.01
 
(0.10%)
78
Rank
Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
7.05   
   12.39
America's Car-Mart Inc. logo

America's Car-Mart Inc.

107.19
 
USD
 
5.55
 
(5.46%)
77
Rank
Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
72.50   
   165.50
ManTech International Corporation logo

ManTech International Corporation

95.66
 
USD
 
0.26
 
(0.27%)
76
Rank
Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
66.09   
   95.87
CACI International Inc. Class A logo

CACI International Inc. Class A

279.18
 
USD
 
-8.01
 
(-2.79%)
76
Rank
Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    
238.29   
   313.52

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!