Investment Principles: Portfolio of Three Stocks Report

Exclusively available on IvyPanda Available only on IvyPanda
Updated:

Data Sourcing

Data for five assets will be collected for the analysis. The five assets are KapStone Paper and Packaging Corporation (KS), Baxter Inc. (BAX), Bank of America Inc. (BAC), S&P 500 index, and the US 13-week Treasury bill. The S&P 500 index represents the market index while the US 13-week Treasury bill represents the risk free asset. Further, monthly data will collected for the period between December 1995 and December 2005. Finally, the data are collected from the Yahoo Finance Website (Yahoo Inc. 1a; Yahoo Inc. 1b; Yahoo Inc. 1c; Yahoo Inc. 1d; Yahoo Inc. 1e). The table presented in appendix 1 shows the monthly values of the five items.

Trend Lines and descriptive statistics

The time series plots for the monthly returns of the three companies, market index, and the risk free rate of return are presented in appendix B. In the graph, it can be noted that the monthly returns of the five securities are oscillating around zero. This shows that the monthly returns are stationary. A stationary data set is consistent with the random walk hypothesis and the efficient market hypothesis. The two theories state that the past trends cannot be used to predict future trends. Thus, the monthly prices reported in the future are independent of past performance. Since trend does not appear in the values of monthly return, it implies that the mean, variance, correlations and other variables are constant over the period of analysis. The concept of stationary data is an important aspect in statistics because it ensures that the results of the analysis are meaningful.

A summary of the descriptive statistics is presented in appendix B. The mean monthly return for KapStone Paper and Packaging Corporation was 3.92%, while the standard deviation was 15.66%. The minimum return was -46.28%, while the maximum return was 62.91%. In the case of Baxter Corporation, the mean return was 1.14%, while the standard deviation was 8.36%. The minimum return was -34.34%, while the maximum return was 27.86%. In the case of Bank of America Inc., the average monthly return was 1.40%, while the standard deviation was 7.6%. The minimum return was -27.9%, while the maximum return was 17.32%. Therefore, out of the three stocks, KapStone Paper and Packaging Corporation had the highest value of the mean and standard deviation. The S&P 500 index had a mean of 0.70% and a standard deviation of 4.50%. The maximum monthly return was -14.58%, while the maximum return was 9.672%. Finally, the 13-weeks US Treasury bill had a mean of 0.30% and a standard deviation of 0.14%. The maximum and the minimum monthly returns were 0.06% and 0.52% respectively.

The X-Y plot for the standard deviation and mean is presented in appendix B below. In the graph, it is evident that a positive relationship exists between the risk (standard deviation) and return (monthly return). This implies that return increases with an increase in risk. This is consistent with the theory which outlines that risky assets offer high return in order to compensate investors for pursuing such investments.

The correlation coefficients of the three securities and the S&P 500 index are presented in appendix B. There is a strong positive correlation between the monthly return for Bank of America and S&P 500 index (52.66%). This shows that the movement in stock prices of this stock will tend to follow the direction of the market. Thus, if the S&P 500 index increases, then the stock prices of Bank of America are also likely to increase. This is followed by the coefficient between monthly returns for Baxter Corporation and S&P 500 index (35.35%), and KapStone Paper and Packaging Corporation (9.9%). Therefore, the monthly returns for Bank of America are most likely to move in the same direction as the market while KapStone Paper and Packaging Corporation is the least likely to follow market trends. Also, it can be noted that there is positive correlation between the three securities.

Equally-weighted portfolio risk and return

In this section, a portfolio of the three stocks will be created. It will be assumed that the stocks have equal weight that is 100/3%. The results of the calculations are presented in appendix C. The results show that the equally-weighted portfolio mean is 2.15%, while the standard deviation is 6.78%. The Sharpe ratio for this portfolio is 0.2726.

Regression: Beta estimation

Regression analysis will be used to estimate the value of beta for each stock. The excess return of each stock will be regressed on the excess return of the market. All the regression results are presented in appendix D below. For KapStone Paper and Packaging Corporation, the estimated value of beta is 0.3559. The p-value of the coefficient is 0.382. This shows that the estimated value of beta is not statistically significant. The coefficient of determination is 0.9812%. It is low and this implies that the explanatory variable does not adequately explain the variations in the dependent variable. The F-test also shows that the overall regression line is not statistically significant. Therefore, the beta of this company is not valid and alternative values of beta such as industry beta can be used for future analysis. In the case of Baxter Corporation, the estimated value of beta is 0.656. The p-value of the coefficient is 06.94E-05. This shows that the estimated value of beta is statistically significant.

The R-square is 12.5%. It is low and this implies that the data does not fit the model well. The F-test also shows that the overall regression line is statistically significant. Therefore, the estimated value of beta is statistically significant and can be used for further analysis. Finally, for Bank of America, the coefficient of S&P 500 index is 0.8887. It represents the value of beta. The estimated value of the intercept (0.0073) represents the alpha (Verbeek 138). The p-value of the coefficient is 5.427E-10. This shows that the estimated value of beta is statistically significant. The R-square is 27.74%. The value is low and this implies that the data does not fit the model well. The explanatory variable only explains 27.74% of the variations in the dependent variables. The F-test also shows that the overall regression line is statistically significant. Therefore, the estimated value of beta is statistically significant and can be used for further analysis. Based on the measure of the goodness of fit, the estimated regression lines for the three securities are weak. This indicates that there are several other factors that affect the value of beta of a stock (Verbeek 138).

Implementing CAPM

The results of the required rate of return are presented in appendix E. Using the CAPM model, the required rate of return for KapStone Paper and Packaging Corporation is 0.44%. Further, the estimated required rate of return for Baxter Corporation is 0.56%, while for Bank of America is 0.66%. A comparison of the required rate of return using the CAPM model and the mean monthly return shows that the later overstates the required rate of return. The results of mean monthly return of all the three stocks are higher than those generated using CAPM model. Further, it can also be observed that the raw mean of the three stocks are not consistent with the beta. Beta is a measure of risk. From a theoretical point of view, it is expected that as the value of beta increases, then the return on the stock should also increase. In the results, KapStone Paper and Packaging Corporation has the lowest value of beta yet it has the highest value of mean as compared to the other two securities. This shows a lack of consistency.

The optimal portfolio

A summary of the results for the minimum variance optimal portfolio is presented in appendix F. In the results, the optimal weights for KapStone Paper and Packaging Corporation, Baxter Corporation and Bank of America are 12.67%, 39.01%, and 48.32% respectively. The estimated portfolio return is 1.61%, while the portfolio standard deviation is 5.84%. The Sharpe ratio for this portfolio is 0.2248. When iterations are carried out, the weights of stock that maximizes the Sharpe ratio are 37.32%, 22.72% and 39.96% for KapStone Paper and Packaging Corporation, Baxter Corporation and Bank of America respectively. The mean for the portfolio is 2.28%, while the standard deviation is 7.18%. The Sharpe ratio is 0.2758.

The results of part 11 above differ from those of the equally-weighted portfolio. The minimum variance portfolio yields a lower mean and standard deviation than the equally weighted portfolio. On the other hand, the maximum Sharpe ratio portfolio yields higher return and standard deviation than both the equally distributed portfolio and the minimum variance portfolio.

Works Cited

Verbeek, Marno. A Guide to Modern Econometrics, England: John Wiley & Sons Ltd., 2008. Print.

Yahoo Inc. 2016a. Web.

Yahoo Inc. 2016b. Web.

Yahoo Inc. 2016c. Web.

Yahoo Inc. 2016d. Web.

Yahoo Inc.2016e. Web.

Appendices

Appendix A

Part a – Data sourcing

Data of stock prices, S&P index and Treasury bill.

DateKapStoneDateBAXBACS&PIRX
11/1/201325.8967912/1/200517.0102737.058991264.673.877
10/1/201325.255211/1/200516.7175937.067061249.483.857
9/3/201320.8029810/3/200516.4550334.952811207.013.805
8/1/201320.414149/1/200517.1609233.642271228.813.47
7/1/201321.410548/1/200517.3589234.385441220.333.43
6/3/201319.529527/1/200516.9026734.436741234.183.332
5/1/201314.100336/1/200515.9686536.024311191.333.06
4/1/201314.377385/2/200515.8825736.229661191.52.882
3/1/201313.512214/1/200515.9686535.22851156.852.837
2/1/201312.948393/1/200514.6257434.493271180.592.722
1/2/201311.665222/1/200515.3488536.139021203.62.69
12/3/201210.785471/3/200514.5310435.922111181.272.422
11/1/20129.67498412/1/200414.8667736.402411211.922.182
10/1/20129.69705311/1/200413.3766335.496031173.822.182
9/4/20129.88243110/1/200413.0004834.360651130.21.867
8/1/20128.8407829/1/200413.5921833.240611114.581.674
7/2/20127.4195488/2/200412.907534.161191104.241.568
6/1/20126.9958267/1/200412.7088532.281491101.721.412
5/1/20126.8148616/1/200414.5853932.133391140.841.303
4/2/20127.9712695/3/200413.2878731.263461120.681.052
3/1/20128.6951274/1/200413.3766330.270621107.30.952
2/1/20128.8716783/1/200413.0554230.45491126.210.923
1/3/20127.7064422/2/200412.3073430.509661144.940.927
12/1/20116.9472741/2/200412.3200230.338341131.130.897
11/1/20117.31803112/1/200312.8990429.954741111.920.907
10/3/20117.23858311/3/200311.5251527.799221058.20.908
9/1/20116.13072710/1/200311.0114527.909781050.710.932
8/1/20116.6338969/2/200312.0388528.76111995.970.926
7/1/20116.8810688/1/200311.6411528.912891008.010.96
6/1/20117.3136177/1/200311.4381630.12413990.310.927
5/2/20117.2606526/2/200310.7711728.83262974.50.838
4/1/20117.6711325/1/200310.4977526.84165963.591.085
3/1/20117.5784444/1/20039.52834226.78739916.921.101
2/1/20117.5696163/3/20037.722124.17919848.181.09
1/3/20117.5166512/3/200311.7612924.81182841.151.175
12/1/20106.7530681/2/200311.6742925.10208855.71.148
11/1/20106.4970712/2/200211.5997224.93007879.821.182
10/1/20105.64962611/1/200213.0062624.88091936.311.202
9/1/20105.35831710/1/200210.1724524.7815885.761.417
8/2/20105.0272849/3/200212.420822.65128815.281.527
7/1/20105.0493538/1/200214.7545224.65852916.071.645
6/1/20104.916947/1/200216.2263223.39886911.621.665
5/3/20104.8772166/3/200218.0721624.75705989.821.659
4/1/20105.6937635/1/200221.8329526.459581067.141.705
3/1/20105.2391454/1/200223.1339925.297331076.921.73
2/1/20104.0430143/1/200224.1992123.740671147.391.74
1/4/20104.0783232/1/200222.5566522.320141106.731.72
12/1/20094.3387361/2/200222.6989521.791631130.21.72
11/2/20093.12936312/3/200121.8044921.763971148.081.67
10/1/20093.06315711/1/200120.902321.016921139.451.73
9/1/20093.59280910/1/200119.4431620.198571059.782.01
8/3/20093.032269/4/200122.128319.996551040.942.3
7/1/20092.224548/1/200120.7415120.867541133.583.28
6/1/20092.0700587/2/200120.0179721.586871211.233.44
5/1/20091.8758526/1/200120.2993520.368751224.383.56
4/1/20091.2579245/1/200119.8491520.104091255.823.54
3/2/20091.0857874/2/200118.3196618.82281249.463.83
2/2/20090.6664793/1/200118.920618.402641160.334.18
1/2/20090.7900652/1/200118.5085917.041351239.944.72
12/1/20081.0504771/2/200117.6624417.893081366.014.84
11/3/20081.955312/1/200017.7493715.251671320.285.73
10/1/20082.11419611/1/200017.15813.277681314.956.01
9/2/20082.80274410/2/200016.290815.757991429.46.15
8/1/20083.30159/1/200015.8200517.17191436.516.03
7/1/20083.3765348/1/200016.5045117.566361517.686.11
6/2/20082.9439857/3/200015.4112315.379931430.836.02
5/1/20083.1470186/1/200013.93713.959621454.65.7
4/1/20083.0366745/1/200013.1813117.997351420.65.49
3/3/20082.9219164/3/200012.9087615.762691452.435.65
2/1/20082.9351573/1/200011.8878516.868491498.585.72
1/2/20082.8468822/1/200010.335214.636791366.425.64
12/3/20073.0896391/3/200012.1130415.412371394.465.53
11/1/20073.04108812/1/199911.9115615.969211469.255.17
10/1/20073.08963911/1/199912.7543618.489881388.915.15
9/4/20073.16908710/1/199912.2706220.328511362.934.96
8/1/20073.032269/1/199911.3739217.568091282.714.71
7/2/20073.2176388/2/199912.599618.944361320.414.85
6/1/20073.3500527/1/199912.904920.7841328.724.62
5/1/20073.3986036/1/199911.3901322.956341372.714.67
4/2/20072.8777785/3/199912.0779820.111771301.844.51
3/1/20072.9130884/1/199911.7856822.249251335.184.43
3/1/199912.346921.957771286.374.36
2/1/199913.1122320.171211238.334.55
1/4/199913.2170420.653771279.644.36
12/1/199811.9826718.569091229.234.35
11/2/199811.7880119.993361163.634.42
10/1/199811.1157417.635561098.674.21
9/1/199811.0693716.408741017.014.25
8/3/19989.80219617.51876957.284.76
7/1/199811.0245924.297761120.674.95
6/1/19989.92904823.364691133.844.97
5/1/199810.4961422.886831090.824.89
4/1/199810.1749523.03841111.754.85
3/2/199810.1175922.110041101.754.99
2/2/199810.3393220.650411049.345.18
1/2/199810.1681418.05027980.285.04
12/1/19979.20952618.33289970.435.2
11/3/19979.1934817.99525955.45.06
10/1/19978.42168217.92035914.625.06
9/2/19979.4885818.53829947.284.97
8/1/19979.60879417.80107899.475.09
7/1/199710.4330521.2086954.315.1
6/2/19979.45071819.23484885.145.05
5/1/19979.47928717.44371848.284.82
4/1/19978.60323917.88814801.345.1
3/3/19977.74965416.44375757.125.17
2/3/19978.21374217.68279790.825.07
1/2/19978.21374215.93293786.165.01
12/2/19967.32094414.40411740.745.05
11/1/19967.53718915.16905757.024.99
10/1/19967.38201113.7967705.275.01
9/3/19967.60812812.71711687.334.91
8/1/19967.2721112.3749651.995.14
7/1/19966.76428212.5021639.955.18
6/3/19967.67837412.01147670.635.03
5/1/19967.14403111.71198669.125.04
4/1/19967.14403111.53152654.175.01
3/1/19967.30547711.56761645.55
2/1/19967.33872710.64725640.434.88
1/2/19967.29862410.00981636.024.91
12/1/19956.717149.973994615.934.96

Appendix B

Part b – Trend lines and descriptive statistics

Time series plots
Time series plots.

Descriptive statistics.

KSBAXBACS&PIRX
Mean0.0391510540.0113665690.0139470.0070310.003002
Standard Error0.0175036710.0076296770.0069380.0041120.000132
Median0.0175062980.0168751390.0129850.009220.003609
Mode#N/A0#N/A#N/A0.00421
Standard Deviation0.15655750.08357890.0759990.0450470.001448
Sample Variance0.0245102790.0069854370.0057760.0020292.1E-06
Kurtosis3.5963518762.7123744331.6623440.377647-1.45692
Skewness0.798813067-0.5346251-0.62809-0.52181-0.34173
Range1.0918931560.6220078760.4521850.2425170.004479
Minimum-0.462754053-0.3434308-0.279-0.14580.000699
Maximum0.6291391030.2785770660.1731880.096720.005178
Sum3.1320842941.36398831.6736440.8436830.36028
Count80120120120120
Largest(1)0.6291391030.2785770660.1731880.096720.005178
Smallest(1)-0.462754-0.3434308-0.279-0.14580.000699
XY scatter plots
XY scatter plots.

Correlation matrix.

KSBAXBACS&P
KS10.0050790.0489070.099058
BAX0.00507910.2215580.353456
BAC0.0489070.22155810.526647
S&P0.0990580.3534560.5266471

Appendix C

Part c – Equally weighted portfolio risk and return

Equally weighted portfolio.

KSBAXBAC
Weights0.33330.33330.3333
0.33330.0027233647.38456E-066.46559E-05
0.33337.38456E-060.000776160.000156368
0.33336.46559E-050.0001563680.000641755
1.00000.00280.00090.0009
0.03920.01140.0139
Variance0.0046
St. Dev0.067809262
R * weight0.0130503510.0037888560.004649011
Mean0.0214882180.00300233
Risk free rate of return0.00300233
Mean – rf0.018485888
Sharpe ratio0.272615978

Appendix D

Part D: Regression results

KapStone Paper and Packaging Corporation.

SUMMARY OUTPUT
Regression Statistics
Multiple R0.099058329
R Square0.0098125
Adjusted R Square-0.0028828
Standard Error0.1567839
Observations80
ANOVA
DfSSMSFSignificance F
Regression10.01900010.01900010.77296380.8391856
Residual781.91731180.0245809
Total791.9363120
CoefficientsStandard Errort StatP-valueLower 95%
Intercept0.036962230.01757052.10364920.03863180.0019819
S&P0.35592840.40483940.87918360.3820022-0.4500452

Baxter Corporation.

SUMMARY OUTPUT
Regression Statistics
Multiple R0.353570164
R Square0.125011861
Adjusted R Square0.117659019
Standard Error0.078186424
Observations121
ANOVA
dfSSMSFSignificance F
Regression10.1039342570.10393417.001846.94432E-05
Residual1190.7274609120.006113
Total1200.831395169
CoefficientsStandard Errort StatP-valueLower 95%
Intercept0.0055800050.0071324620.7823390.435569-0.008542983
S&P0.6559912050.1590926114.1233296.94E-050.340971946

Bank of America.

SUMMARY OUTPUT
Regression Statistics
Multiple R0.5267579
R Square0.2774739
Adjusted R Square0.2714022
Standard Error0.0646091
Observations121
ANOVA
DfSSMSFSignificance F
Regression10.19076690.190766945.6999355.42664E-10
Residual1190.49674610.0041743
Total1200.6875130
CoefficientsStandard Errort StatP-valueLower 95%
Intercept0.00727310.00589381.23402120.2196265-0.0043973
S&P0.8887300.13146566.76017275.42664E-100.6284155

Appendix E

Part E – CAPM

Summary of calculations.

Return on stock = risk free rate of return + β * (expected return on market – risk free rate of return)
Risk free ratebetaexpected return on marketrisk free rateRequired rate of return
KS0.0030020.3559280.0070310.0030020.004436
BAX0.0030020.6559910.0070310.0030020.005645
BAC0.0030020.8887310.0070310.0030020.006582

Appendix F

Part F – Optimal portfolio results

Minimum variance.

PortfolioKSBAXBAC
Weight0.1267350.39010.483165
0.1267354410.0003943.29E-063.56E-05
0.3900996623.29E-060.0010630.000265
0.4831648973.56E-050.0002650.001348
10.0004330.0013320.001649
Variance0.003413
St. Dev0.058424
R * weight0.0049620.0044340.006739
Mean0.016135
Mean – Rf0.013132
Sharpe ratio0.224775

Maximum Sharpe ratio.

PortfolioKSBAXBAC
Weight0.37320.22720.3996
0.3732417530.0034145125.63568E-068.67825E-05
0.2271899065.63568E-060.0003605550.000127753
0.3995683418.67825E-050.0001277530.000922134
1.00000.00350.00050.0011
Variance0.0051
St. Dev0.071676659
R * weight0.0146128080.002582370.005572792
Mean0.02276797
Mean – Rf0.01976564
Sharpe ratio0.275761179
Print
Cite This paper
Select a referencing style:

Reference

IvyPanda. (2024, April 10). Investment Principles: Portfolio of Three Stocks. https://ivypanda.com/essays/investment-principles-portfolio-of-three-stocks/

Work Cited

"Investment Principles: Portfolio of Three Stocks." IvyPanda, 10 Apr. 2024, ivypanda.com/essays/investment-principles-portfolio-of-three-stocks/.

References

IvyPanda. (2024) 'Investment Principles: Portfolio of Three Stocks'. 10 April.

References

IvyPanda. 2024. "Investment Principles: Portfolio of Three Stocks." April 10, 2024. https://ivypanda.com/essays/investment-principles-portfolio-of-three-stocks/.

1. IvyPanda. "Investment Principles: Portfolio of Three Stocks." April 10, 2024. https://ivypanda.com/essays/investment-principles-portfolio-of-three-stocks/.


Bibliography


IvyPanda. "Investment Principles: Portfolio of Three Stocks." April 10, 2024. https://ivypanda.com/essays/investment-principles-portfolio-of-three-stocks/.

Powered by CiteTotal, citation creator
If, for any reason, you believe that this content should not be published on our website, please request its removal.
More related papers
Updated:
Cite
Print
1 / 1