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
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!