Home > Free Essays > Economics > Investment > Optimal Portfolio and Stocks Management

Optimal Portfolio and Stocks Management Research Paper

Exclusively available on IvyPanda Available only on IvyPanda
Updated: Jul 5th, 2021


There are ten stocks in the portfolio, including Amazon, Inc., Intel Corporation, Twitter, Inc., Visa, Inc., Nokia Corporation, Ford Motor Company, Chesapeake Energy Corporation, Universal Forest Products, Inc., Tesla, Inc., and MKS Instruments, Inc. The reasons for selecting these stocks are their recent price gains and positive financial news. The stock performance and its volatility of all stocks are provided in the following.

Table 1. Stock Performance and Volatility.

Means (0.025) (0.006) 0.015 (0.017) 0.014 0.007 0.064 (0.016) 0.003 (0.015) (0.006) 0.002
Standard deviations 0.081 0.063 0.148 0.044 0.090 0.066 0.199 0.097 0.118 0.102 0.035 0.002

Main body

It is noted that the top performer was Chesapeake Energy Corporation, and the bottom performer was Amazon, Inc. on a monthly return basis. However, Amazon had the highest stock gain of 425.86% over the five years, and Chesapeake Energy Corporation made the most significant stock loss. The highest volatility was recorded in the stock value of Chesapeake Energy Corporation, and the lowest was of Visa, Inc. The S&P 500 index had an average monthly loss of -0.5723% over the last five years (see table 1). Its volatility was 0.03483, which was less than all stocks included in the portfolio that implies that it is well-diversified, and investors will be exposed to lower risk if they have an investment in all 500 stocks.

The correlation matrix between all the stocks over the past five years is provided in the following.

Table 2. Correlation Matrix.

AMZN 1.000
INTC 0.285 1.000
TWTR 0.182 0.203 1.000
V 0.689 0.352 0.070 1.000
NOK 0.139 0.101 0.308 0.151 1.000
F 0.239 0.300 0.383 0.314 (0.030) 1.000
CHK 0.266 0.334 0.064 0.178 0.032 0.340 1.000
UFPI 0.379 0.359 0.045 0.386 (0.126) 0.378 0.266 1.000
TSLA 0.124 0.221 0.115 0.126 0.047 0.026 0.165 (0.006) 1.000
MKSI 0.316 0.650 0.106 0.256 (0.032) 0.289 0.323 0.387 0.169 1.000

Table 2 indicates that the coefficients of correlations between AMZN and V and INTC and MKSI are more than 0.6 (see table 2). It could be due to the close relationship between these companies. There is a significant number of business transactions on Amazon’s e-commerce website, which is paid by users using VISA credit cards. Moreover, Intel, Inc. and MKS Instruments have similar businesses related to products/equipment used by other companies and industries. There are three combinations of companies’ stocks, including CHK/TWTR, CHK/NOK, and TSLA/F, which have small coefficients less than 0.1 (see table 2).

It implies that these companies are entirely unrelated to each other. For example, Tesla and Ford Motor Company are competitors, and their stocks are not correlated. The coefficient of TSLA/UFPI is negative (see table 2), which cannot be explained as both companies are operating in different industries and are not related to each other at all. The covariance matrix is provided in Appendix A. The optimal portfolio is created by determining the lowest value of the portfolio variance. In this case, short-selling is allowed, and the results are provided in the following:

Table 3. Optimal Portfolio.

Portfolio Return -0.0064
Portfolio Variance 0.0014
Portfolio Std. Dev. 0.0369

The lowest value of portfolio variance is 0.0014, and the expected portfolio return is -0.64% (see table 3). The weight of each stock is provided in the following.

Table 4. Stocks’ Weightage (No Short Sale).

Stocks Weights
AMZN 0.0000 0.0%
INTC 0.1252 12.5%
TWTR 0.0000 0.0%
V 0.5261 52.6%
NOK 0.1225 12.3%
F 0.1728 17.3%
CHK 0.0000 0.0%
UFPI 0.0000 0.0%
TSLA 0.0533 5.3%
MKSI 0.0000 0.0%

The highest weight is assigned to Visa, Inc., and no allocation of funds is made to AMZN, TWTR, CHK, UFPI, and MKSI (see table 4). The weight does not seem reasonable as it left out stocks such as AMZN, TWTR, and MKSI, which had significant growth rates recorded over the last five years. I will be reluctant to present this portfolio choice to a client. The minimum variance frontier is given in the following.

Minimum Variance Portfolio.
Figure 1. Minimum Variance Portfolio.

The expected return is nil when the standard deviation is 0.037 (see figure 1). The use of historical information as inputs to portfolio theory is useful in many ways. The historical stock returns are crucial to determine the performance of stocks over a period. It is the primary indicator observed by investors when making their decisions about investing in stocks. The primary objective of an equity investment is to maximize the expected return.

If a firm has poor stock performance in the past, then investors will be reluctant to invest in its stocks. The covariance between stocks assists in determining which stocks to be included in the portfolio. It is a statistical measure used by portfolio theory to lower the overall risk. It is also suggested that stocks that have a negative covariance with each other reduce the portfolio risk. Negative covariance, as it has been noted between TSLA and UFPI, is a good indicator and suitable for developing an efficient portfolio. It can help in creating an efficient portfolio of stocks that can optimize the portfolio return at a low level of risk.

It is stated that the standard deviation is a measure of the systematic risk of investing in an individual stock. Its use by portfolio theory helps in understanding how investors can reduce the degree of investment risk by reviewing the historical data and then choosing stocks that have lesser volatility. The criticism of the Modern Portfolio Theory lies in its use of historical data, which states that it is difficult to select a representative subset of historical data to use. Moreover, there may be certain economic events in the past that could have distorted the trend in the stock return.

If no short sales are allowed, then the optimal portfolio is achieved where the Sharpe Ratio value is the highest (see table 5).

Table 5. No Short Sale Allowed.

Port Variance 0.0124
Port S.D. 0.1115
Port Mean 0.0398
Risk-free rate 0.00191
Monthly Sharpe Ratio 0.3400
Annual Sharpe Ratio 1.1777

The weight assigned to each stock is provided below:

Table 6. Stock Weightage.

AMZN 0.0000 0.00%
INTC 0.0000 0.00%
TWTR 0.0864 8.64%
V 0.0000 0.00%
NOK 0.3988 39.88%
F 0.0000 0.00%
CHK 0.5149 51.49%
UFPI 0.0000 0.00%
TSLA 0.0000 0.00%
MKSI 0.0000 0.00%

When this is compared with the previous optimal portfolio, it is noted that the allocation to INTC, TSLA, and F is reduced to zero. On the other hand, funds are allocated to stocks, including TWTR, CHK, and V, which had zero allocation in the previous portfolio. Furthermore, investment in NOK is increased, and still, no allocation is made to AMZN (See table 6).

I decided not to invest in Nokia because of its misleading advertising case reported in 2012 as it attempted to deceive its customers by using false imagery in its advertisements. Furthermore, I excluded Chesapeake Energy Corporation as it was involved in a land price manipulation case. The following optimal portfolio was achieved without these two stocks.

Table 7. Green Listing.

Port Variance 0.0061
Port S.D. 0.0784
Port Mean 0.0102
Risk-free rate 0.00191
Monthly Sharpe Ratio 0.1054
Annual Sharpe Ratio 0.3650


In this case, the Sharpe Ratio is 0.3650 (annualized) (see table 7), as compared to 1.1777. It implies that this portfolio is more efficient than the previous one. Moreover, the weight assigned to each stock is given below.

Table 8. Stock Weightage (Green Listing).

AMZN 0.0000 0.0%
INTC 0.0000 0.0%
TWTR 0.3587 35.9%
V 0.0000 0.0%
NOK 0.0000 0.0%
F 0.6286 62.9%
CHK 0.0000 0.0%
UFPI 0.0000 0.0%
TSLA 0.0127 1.3%
MKSI 0.0000 0.0%

The cost of the above portfolio is determined by using the current price of these stocks along with their allocation (see table 8).

Table 8. Portfolio Cost.

Aug-08 25-Oct
Weight Allocation Price Shares Price Value
TWTR 0.359 35,870,000.0 42.07 852,626 30.10 25,664,059.9
F 0.629 62,860,000.0 9.41 6,680,127 8.70 58,117,109.5
TSLA 0.013 1,270,000.0 238.30 5,329 313.64 1,671,518.3
TOTAL FUNDS 100,000,000.0 85,452,687.61

It is noted that the value of the portfolio has reduced from August 8, 2019, to October 25, 2019 (see table 8).

This research paper on Optimal Portfolio and Stocks Management was written and submitted by your fellow student. You are free to use it for research and reference purposes in order to write your own paper; however, you must cite it accordingly.
Removal Request
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda.
Request the removal

Need a custom Research Paper sample written from scratch by
professional specifically for you?

Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar

certified writers online

Cite This paper
Select a referencing style:


IvyPanda. (2021, July 5). Optimal Portfolio and Stocks Management. Retrieved from https://ivypanda.com/essays/optimal-portfolio-and-stocks-management/

Work Cited

"Optimal Portfolio and Stocks Management." IvyPanda, 5 July 2021, ivypanda.com/essays/optimal-portfolio-and-stocks-management/.

1. IvyPanda. "Optimal Portfolio and Stocks Management." July 5, 2021. https://ivypanda.com/essays/optimal-portfolio-and-stocks-management/.


IvyPanda. "Optimal Portfolio and Stocks Management." July 5, 2021. https://ivypanda.com/essays/optimal-portfolio-and-stocks-management/.


IvyPanda. 2021. "Optimal Portfolio and Stocks Management." July 5, 2021. https://ivypanda.com/essays/optimal-portfolio-and-stocks-management/.


IvyPanda. (2021) 'Optimal Portfolio and Stocks Management'. 5 July.

More related papers
Psst... Stuck with your
assignment? 😱
Psst... Stuck with your assignment? 😱
Do you need an essay to be done?
What type of assignment 📝 do you need?
How many pages (words) do you need? Let's see if we can help you!