Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
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 In Excel – Explanation & Construction - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Risk Parity Portfolio In Excel – Explanation & Construction - MarketXLS

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
I agree to the MarketXLS Terms and Conditions
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

Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

139.46
 
USD
 
4.52
 
(3.35%)
89
Rank
Optionable: Yes
Market Cap: 8,983 M
Industry: Specialty Retail
52 week range    
101.58   
   176.89
Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

55.74
 
USD
 
1.93
 
(3.59%)
88
Rank
Optionable: Yes
Market Cap: 2,929 M
Industry: Auto & Truck Dealerships
52 week range    
42.72   
   56.01
Haverty Furniture Companies Inc. logo

Haverty Furniture Companies Inc.

35.01
 
USD
 
0.09
 
(0.26%)
88
Rank
Optionable: Yes
Market Cap: 564 M
Industry: Home Improvement Stores
52 week range    
22.77   
   35.40
PulteGroup Inc. logo

PulteGroup Inc.

58.44
 
USD
 
1.55
 
(2.72%)
87
Rank
Optionable: Yes
Market Cap: 12,961 M
Industry: Residential Construction
52 week range    
35.03   
   58.65
Toll Brothers Inc. logo

Toll Brothers Inc.

60.26
 
USD
 
0.77
 
(1.29%)
86
Rank
Optionable: Yes
Market Cap: 6,578 M
Industry: Residential Construction
52 week range    
39.53   
   63.19
Weis Markets Inc. logo

Weis Markets Inc.

86.71
 
USD
 
0.37
 
(0.43%)
85
Rank
Optionable: Yes
Market Cap: 2,322 M
Industry: Grocery Stores
52 week range    
58.40   
   95.57
Victory Capital Holdings Inc. logo

Victory Capital Holdings Inc.

30.34
 
USD
 
0.70
 
(2.36%)
85
Rank
Optionable: Yes
Market Cap: 2,030 M
Industry: Asset Management
52 week range    
22.22   
   36.90
Regional Management Corp. logo

Regional Management Corp.

35.98
 
USD
 
1.49
 
(4.32%)
85
Rank
Optionable: Yes
Market Cap: 331 M
Industry: Credit Services
52 week range    
26.52   
   56.95
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

130.72
 
USD
 
2.90
 
(2.27%)
85
Rank
Optionable: Yes
Market Cap: 9,114 M
Industry: Auto & Truck Dealerships
52 week range    
88.58   
   131.67
El Pollo Loco Holdings Inc. logo

El Pollo Loco Holdings Inc.

12.22
 
USD
 
-0.05
 
(-0.41%)
85
Rank
Optionable: Yes
Market Cap: 455 M
Industry: Restaurants
52 week range    
8.15   
   13.97

More Features