Valuation of Securities and Stock Trading Essay

Exclusively available on Available only on IvyPanda® Written by Human No AI

Executive summary

The paper made use of the Two-Fund Theorem to find a solution to the asset and capital allocation problem. The monthly stock prices for Procter & Gamble and Royal Bank of Canada are used for the analysis. The discussion on the asset allocation problem focuses on locating the minimum variance portfolio on the efficient frontier of the two assets. At the point of the minimum variance portfolio, the weight of the two securities is 83.41% and 16.59% for Procter & Gamble and Royal Bank of Canada respectively. The effect of altering correlation on portfolio variance is also discussed. It is established that it is possible to create a perfect hedge when the two securities are perfectly correlated. Also, it is established that diversification reduces the portfolio variance thus leading to a minimization of unsystematic risk. In the second part, the capital allocation problem is solved using the Single Index and Treynor-Black model. The weight allocated to an active portfolio is 54.12%, while the weight allocated to a passive portfolio is 46.88%. Finally, a review of data for the two companies at a later date shows that the efficient market hypothesis holds.

Introduction

The paper seeks to discuss the two parts of the Two-Fund Separation theorem. The premise of this theorem is the modern portfolio theory. According to the Two-Fund Separation theorem, an investment problem is separated into two steps. The first step entails allocating resources between two or several risky assets. It focuses on analyzing the efficient frontier of the assets in the portfolio to solve the asset allocation problem. The second step seeks to find an optimal solution between risk-free and risk assets. In this case, the Treynor-Black framework will be used to find an optimal solution. These two parts are discussed in the subsequent sections.

Analysis of security

The securities that will be analyzed are the stocks of Proctor & Gamble Co. and Royal Bank of Canada. Both companies are publicly traded entities that are listed on the New York Stock Exchange market with ticker symbols PG and RY respectively. However, the stock of Royal Bank of Canada is listed on the other two stock exchange markets. Further, Proctor & Gamble Co. Deals with the production and sale of a variety of consumer goods while Royal Bank of Canada offers financial services. The table presented below shows a summary of financial data for the two companies.

20102013
Proctor & Gamble Co.
Revenue$78,938 million$84,167 million
Net income$12,736 million$11,312 million
Total assets$139,263 million
Royal Bank of Canada
RevenueCAD28,330 millionCAD30,867million
Net incomeCAD5,223millionCAD8,331 million
Total assetsCAD860,819 million

(Source of data – Yahoo, Inc. 2009a; Yahoo, Inc. 2009b)

The data show that Proctor & Gamble Co. has a high earnings capacity while Royal Bank of Canada has a large asset base. For subsequent analysis, the share prices of the companies will be collected. These prices will be used to calculate the monthly return for each stock. The data of stock of the two companies, the S&P 500 index and 60-day Treasury Bill is presented in appendix 1 (Yahoo, Inc. 2009c). The table presented below shows a summary of the results for portfolio analysis.

Proctor & Gamble Co.Royal Bank of Canada
Average rate of return0.87%0.71%
Variance0.00140.0042
Standard deviation3.79%6.5%
Covariance0.0007
Correlation coefficient0.3029

The results show that Proctor & Gamble Co. has a higher expected return and lower standard deviation than Royal Bank of Canada. Further, there is a weak positive correlation between the monthly return of the two stocks.

Asset allocation problem (AAP)

Most investors often face the asset allocation problem. This is a problem that arises when an investor seeks to allocate resources between several risky assets. Therefore, an investor needs to find an optimal portfolio of risky securities. In this case, there are no risk free assets (Elton & Brown 2007). The calculations for this section are presented in appendix 2 below.

Optimization and the efficient frontier

In order to solve the asset allocation problem, it is important to estimate the expected return and standard deviation of a portfolio. The estimated value of expected portfolio return is 0.79%, while the portfolio variance is 0.18%. The portfolio standard deviation is 4.23%. The calculations are based on the assumption that the two stocks have equal weights. The next step is to come up with an array of possible combinations of expected returns and standard deviations of the two stocks. The combinations will be plotted on a graph. The resulting graph is a frontier which shows all possible combinations of risk and return of the portfolio (Elton & Brown 2007).

Optimization and the efficient frontier

Central tendency portfolio

This represents a portfolio that is based on the measures of central tendency. The position of this portfolio is presented in the graph below.

Central tendency portfolio

Minimum variance portfolio

This represents a portfolio that is associated with a minimum of risk. That is, it has the least value of variance. This portfolio is also associated with minimum return. This argument is based on the fact that there is a direct relationship between risk and return. Thus, risky assets attract high returns. In the case of the two companies, the minimum variance portfolio is attained at the point where the weight of Proctor & Gamble stock is 83.41%, while that of Royal Bank Canada is 16.58%. The portfolio variance is 3.64%, while the expected return is 0.84%. The graph presented below shows the minimum variance portfolio.

Minimum variance portfolio

Maximum variance portfolio

This portfolio generates the maximum return to an investor. Therefore, it is associated with high level of risk. In the case of the two companies, the maximum variance portfolio is attained at the point where the weight of Proctor & Gamble stock is 100%, while that of Royal Bank Canada is 0%. The portfolio variance is 3.79%, while the expected return is 0.87%. The graph presented below shows the maximum variance portfolio.

Maximum variance portfolio

Efficient frontier

This represents the section of the frontier curve that lie between the minimum and maximum variance portfolio. The points on the efficient frontier offer a higher amount of return at a given level of risk or they have a low level of risk at a specific level of return. The efficient frontier of the two companies is highlighted in pink in the diagram below.

Efficient frontier

Correlation and portfolio variance

There are a number of approaches that can be used to estimate the variance of a portfolio. One approach is by using the correlation coefficient. Therefore, changing the value of correlation coefficient affects the variance of a portfolio. This creates the need for evaluating the impact of changing the values of correlation coefficient on the risk level of a portfolio. The analysis will be carried out fewer than three scenarios. In the first scenario, it will be assumed that the correlation between the two stocks is 0.5. The resulting frontier curve is presented below.

Correlation and portfolio variance

In the second case, it will be assumed that the correlation coefficient is 1. The frontier curve will change to the shape presented in the diagram below.

Correlation and portfolio variance

The graph is a straight line that is downward sloping. It is similar to a scenario where a portfolio contains ne risk free asset and one risky asset. The correlation coefficient of 1 indicates that the two assets are perfectly correlated. Thus, an investor can come up with a perfect hedge that comprises of two assets. The final instance is when the correlation coefficient is -1. The shape of the frontier will change as presented below.

Correlation and portfolio variance

In this case, there is a perfect negative correlation between the two assets. Thus, it is possible to form an artificial risk free asset. However, the shape gives indication that one security in the portfolio dominates another one.

Systematic risk, Nonsystematic risk and diversification

When finding a solution to the asset allocation problem, it is important to evaluate the concept of diversification. This can be explained by the fact that some risks that are associated with investing in some securities can be minimized. Risks can be can be classified as either systematic or nonsystematic risks. Systematic risks are inherent in a market. Therefore, they cannot be eliminated by investing in a variety of stocks. This type of risk is often measured using the beta. The return on stock for Proctor & Gamble Co. has a beta value of 0.0163. This implies that the stock has less movements a compared to market volatility. On the other hand, Royal Bank of Canada has a beta value of -0.0744. Thus, share prices move in opposite direction as compared to the market. Thus, in the case of systematic risk, the stocks of various companies will tend to move in a similar direction. Unsystematic risk is the uncertainties that relate to a single entity. This type of risk can be reduced by having a portfolio that has several assets.

The proponents of diversification argue hat the risk – return tradeoff improves when an investor invests in several assets that are not perfectly correlated. From a mathematical point of view, as the number of assets in a portfolio increases, then the covariance between the assets moves close to zero. Thus, the variance of the portfolio also reduces. This occurs only when the covariance of the portfolio is negative.

Capital allocation problem (CAP)

Capital allocation is an important aspect of investment. This is based on the fact that resources are scarce. Therefore, an investor needs to find a suitable approach of coming up with an optimal weight of allocating capital among the securities. There are several approaches that can be used to arrive at an optimal way of allocating capital. The first approach is by picking the point of tangency of the capital asset line and utility function. This point will yield optimal weights. The second method is by using the single model and Treynor-Black framework. The capital allocation problem in this case will be solved using a combination of these two models. The capital allocation problem concentrates on the second part of the Two-Fund Separation theorem. Therefore, it will seek to find an optimal solution when allocated resources between a risk free and a risky asset. The calculations are presented in appendix 3 below.

Single index model

This model shows the relationship between the returns on each security to the returns of the market index. In this case, the market index is the S&P 500 index. It measures the risks and return of a security. This model splits the total risk of an asset into market risk (measured by beta) and unique risk (measured by alpha). The values of alpha and beta for the single risk model will be solved using regression analysis. The results of regression for the two stocks are summarized in the table below.

Alpha (Y – intercept)Beta (Coefficient)
Proctor & Gamble Co.0.008480.01634
Royal Bank of Canada0.00803-0.0744

The results in the table above show that Proctor & Gamble Co. has a higher value of unique risk than Royal Bank of Canada. Also, Proctor & Gamble Co. is less sensitive to market movement (as indicated by the value of the beta). On the other hand, the stock of Royal Bank of Canada moves in the opposite direction of the market. This is explained by the negative value of beta. The results of the single index model are a significant input to the Treynor-Black model.

Treynor-Black framework

This framework provides an efficient approach of implementing an active investment strategy. In this model the optimal portfolios are built using the actual forecasts of abnormal returns and the coefficients of beta. This framework works by identifying active portfolio that can be blended with passive portfolio to find the optimal risky portfolio. Further, weights are assigned to the securities proportionately. Thus, securities that have low levels of unsystematic risks are allocated more weight. The framework is built on one major key assumption. That is, the market is assumed to be efficient. This might not be always the case because degree of efficiency of the market depends on a number of factors. The process of using this model goes through several distinctive steps. These steps are discussed below.

Step 1

The first step is to ensure that there are values of beta and alpha of stocks. These values are already estimated using the single index model above. The values of beta and alpha will aid in the calculation of the factor models as presented below.

AlphaBetaσ(εi)^2
Proctor & Gamble Co.0.008480.016340.001
Royal Bank of Canada0.00803-0.07440.004

Step 2

This step entails calculating the weight of stock in the active portfolio. There exist a direct proportionality between the weights and the ratio of alpha and unsystematic risks. This ratio is commonly known as the appraisal ratio. It captures the value that a security adds to the portfolio. The direct proportionality indicates that securities that have higher values of alpha (Proctor & Gamble Inc.) are allocated more weights than those with lower values of alpha (Royal Bank of Canada) as presented in the table below.

Appraisal ratioWeights
Proctor & Gamble Co.5.76475.0%
Royal Bank of Canada1.92025.0%

The estimated weight for Proctor & Gamble is 75%, while that of Royal Bank of Canada is 25%.

Step 3

This will focus on estimating the weighted averages of beta, alpha, and idiosyncratic risk of the active portfolio. The results are presented in the table below.

Weighted averages
Beta-0.00634
Alpha0.00837
Idiosyncratic risk0.00109

Step 4

At this point the weight of the active portfolio will be calculated using the formula presented below.

Formula

The estimated weight of the active portfolio is 118.85%.

Step 5

This step is quite important because it focuses on correcting the adjusted beta of the active portfolio. This correction is quite important because it ensures that there is no significant deviation of the portfolio beta from the overall beta. It also ensures that the overall portfolio does not become too risky. The outcome of this step is a corrected value of beta, which is 54.12%. This will represent the weight of the active portfolio (Bodie, Kane & Markus 2012).

Step 6

The final step entails calculating the weight of passive portfolio. The sum of weights of active and passive portfolios should be 1. Therefore, the weight of the passive portfolio is 45.88% (100% – 54.12%). Therefore, the results indicate the ratio of how the resources will be allocated. This represents the solution to the capital allocation problem.

Efficient market hypothesis

The concept of efficient market hypothesis was developed in 1960 by Eugene Fama. The idea has widely been used across the market. The underlying concept of the hypothesis is that all available information in the market is replicated in the prevailing market prices (Baltagi 2011). Thus, if information about a security is available, then it is quickly replicated in the market price of the security. Therefore, there is no room for using such kind of information to make undue gain. The degree of efficient market hypothesis differs depending on the type of the information and the rate at which the information is assimilated in the market price of the security. The underlying concept of efficient market hypothesis is consistent with the random walk hypothesis.

Evaluation of portfolio at a later time period

The prices of stocks of the two companies will be collected for the period between between the period 03/03/2013 and 06/03/2014. Once the closing prices of stock for the two time periods are collected, then the monthly returns of stock will be calculated. The value of returns will be arrived at by calculating the monthly percentage change of stock prices. Further, the average of the monthly returns of the two stocks will be computed. A portfolio will be created using the data of monthly rate of return of the two stocks using the optimal weights calculated above. The portfolio mean for the two time periods will be calculated and compared. The calculations are presented in appendix 4 below. The table presented below shows a summary of the results.

Weights
Capital allocation weightMinimum portfolio variance weightMaximum portfolio variance weight
Proctor & Gamble Co.75%83.41%100%
Royal Bank of Canada25%16.590%
Expected portfolio -03/03/2013 to 06/03/20147.42%6.94%6%
Expected portfolio – 01/03/2010 to 01/03/20130.83%0.84%0.87%

The information in the table above shows that there is a difference in expected return between the two time periods. The expected returns of the portfolio for the period between 03/03/2013 and 06/03/2014 are higher than those of the period between 01/03/2010 and 01/03/2013. Thus, it can be noted that there is a clear indication that the expected portfolio return of the two time periods are different. The portfolio performed better at a later time period. This can be an indication that the past trends of stock prices did not have an impact on the future prices. Thus, there is no replication of past trend in the future (Elton & Brown 2007).

Conclusion

In summary, the discussion on the asset allocation problem focuses on locating the minimum variance portfolio on the efficient frontier of the two assets. At the minimum variance portfolio point, the weight of the two securities is 83.41% and 16.59% for Procter & Gamble and Royal Bank of Canada respectively. In the second part, the capital allocation problem is solved using the Single Index Model and Treynor-Black model. The weight allocated to active portfolio is 54.12%, while the weight allocated to passive portfolio is 46.88%. Finally, a review of data for the two companies at a later date shows that the efficient market hypothesis holds for the two securities.

Reference list

Baltagi, G 2011, Econometrics, Springer, New York.

Bodie, Z, Kane, A & Markus, A 2012, Investments, McGraw Hill Publishing Company, USA.

Elton, G & Brown, G 2007, Modern portfolio theory and investment analysis, John Wiley & Sons Ltd, USA.

Yahoo, Inc. 2009a, .

Yahoo, Inc. 2009b, .

Yahoo, Inc. 2009c, .

Appendices

Appendix 1 – Data

Adjusted closing pricesRate of return
DateProctor & GambleRoyal Bank of CanadaS&P 500 indexProctor & GambleRoyal Bank of CanadaS&P 500 index6-month treasury bill rateRate of return
01-03-1052.27746.1061169.40.22
01-04-1051.75548.2021186.7-1.00%4.55%1.48%0.249.09%
03-05-1050.86441.9181089.4-1.72%-13.04%-8.20%0.22-8.33%
01-06-1049.9438.0631030.7-1.82%-9.20%-5.39%0.19-13.64%
01-07-1051.32142.041101.62.77%10.45%6.88%0.25.26%
02-08-1050.07138.4521049.3-2.44%-8.53%-4.74%0.19-5.00%
01-09-1050.32341.9271141.20.50%9.04%8.76%0.190.00%
01-10-1053.75343.3161183.36.82%3.31%3.69%0.18-5.26%
01-11-1051.6443.4871180.6-3.93%0.39%-0.23%0.180.00%
01-12-1054.39642.4891257.65.34%-2.30%6.53%0.195.56%
03-01-1153.77743.9831286.1-1.14%3.52%2.26%0.18-5.26%
01-02-1153.70947.9721327.2-0.13%9.07%3.20%0.17-5.56%
01-03-1152.47450.7571325.8-2.30%5.81%-0.10%0.16-5.88%
01-04-1155.74351.9921363.66.23%2.43%2.85%0.12-25.00%
02-05-1157.54748.3751345.23.24%-6.96%-1.35%0.09-25.00%
01-06-1154.60147.0951320.6-5.12%-2.65%-1.83%0.111.11%
01-07-1153.24744.8171292.3-2.48%-4.84%-2.15%0.08-20.00%
01-08-1155.14442.6231218.93.56%-4.89%-5.68%0.06-25.00%
01-09-1154.71138.1351131.4-0.79%-10.53%-7.18%0.04-33.33%
03-10-1155.86441.2661253.32.11%8.21%10.77%0.0525.00%
01-11-1156.3738.79512470.91%-5.99%-0.51%0.050.00%
01-12-1158.23842.9871257.63.31%10.81%0.85%0.050.00%
03-01-1255.47444.6151312.4-4.75%3.79%4.36%0.0740.00%
01-02-1259.50447.8951365.77.27%7.35%4.06%0.1271.43%
01-03-1259.14349.4541408.5-0.61%3.26%3.13%0.1416.67%
02-04-1256.47649.7461397.9-4.51%0.59%-0.75%0.140.00%
01-05-1255.27842.811310.3-2.12%-13.94%-6.27%0.157.14%
01-06-1254.35544.0751362.2-1.67%2.95%3.96%0.150.00%
02-07-1257.77144.491379.36.29%0.94%1.26%0.150.00%
01-08-1260.14348.7371406.64.11%9.54%1.98%0.14-6.67%
04-09-1262.08649.9551440.73.23%2.50%2.42%0.140.00%
01-10-1262.48750.137>1412.20.65%0.37%-1.98%0.157.14%
01-11-1263.0251.7641416.20.85%3.24%0.28%0.14-6.67%
03-12-1261.26953.0121426.2-2.78%2.41%0.71%0.12-14.29%
02-01-1368.3855.3341498.111.61%4.38%5.04%0.11-8.33%
01-02-1369.30855.1391514.71.36%-0.35%1.11%0.129.09%
01-03-1369.5955.1211518.20.41%-0.03%0.23%0.11-8.33%

Proctor & Gamble Royal Bank of Canada Portfolio

Average return E(rPG) and E(rRY)0.87%0.71%0.79%
Variance of returns, s2PGand s2RY0.00140.00420.0018
Standard deviation of returns, sPG and sRY3.79%6.50%4.23%
Covariance of returns Cov(rPG,rRY)0.0007<– =COVAR(B7:B42,C7:C42)

Appendix 2

PORTFOLIO STATISTICS for a Proctor & Gamble-Royal Bank of Canada Portfolio

PGRY
Average, E(rPG) and E(rRY)0.87%0.71%
Variance, Var(rPG) and Var(rRY)0.00140.0042
Sigma, sPG and sRY3.79%6.50%
Covariance of returns, Cov(rPG,rRY)0.0007

Portfolio return and risk

Percentage in PG50%
Percentage in RY50%
Expected portfolio return, E(rp)0.79%<– =B9B3+B10C3
Portfolio variance, Var(rp)0.18%<– =B9^2*B4+B10^2*C4+2*B9*B10*B6
Portfolio standard deviation, sp4.23%<– =SQRT(B13)

PORTFOLIO STATISTICS for a Proctor & Gamble-Royal Bank of Canada Portfolio

PGRY
Average, E(rPG) and E(rRY)0.87%0.71%
Variance of returns, s2PGand s2RY0.14%0.42%
Sigma, sPG and sRY3.79%6.50%
Covariance of returns, Cov(rPG,rRY)0.0007

Portfolio return and risk

Percentage in PG25%
Percentage in RY75%
Expected portfolio return, E(rp)0.75%<– =B9*B3+B10*C3
Portfolio variance, Var(rp)0.27%<– =B9^2*B4+B10^2*C4+2*B9*B10*B6
Portfolio standard deviation, sp5.24%<– =SQRT(B13)

Possible combinations

Percentage in PGSigmaExpected return
0%6.50%0.71%
10%5.98%0.73%
20%5.48%0.74%
30%5.01%0.76%
40%4.59%0.77%
50%4.23%0.79%
60%3.94%0.81%
70%3.74%0.82%
80%3.65%0.84%
90%3.66%0.85%
100%3.79%0.87%

Maximum variance portfolio

Percentage
in PG
SigmaExpected
return
4.23%0.79%
0%6.50%0.71%
10%5.98%0.73%
20%5.48%0.74%
30%5.01%0.76%
40%4.59%0.77%
50%4.23%0.79%
60%3.94%0.81%
70%3.74%0.82%
80%3.65%0.84%
90%3.66%0.85%
100%3.79%0.87%

Minimum portfolio variance

Percentage
in PG
SigmaExpected
return
4.23%0.79%
0%6.50%0.71%
10%5.98%0.73%
20%5.48%0.74%
30%5.01%0.76%
40%4.59%0.77%
50%4.23%0.79%
55%4.07%0.80%
67%3.79%0.82%
83.41%3.64%0.84%
95%3.71%0.86%
100%3.79%0.87%

Efficient Frontier

Percentage
in PG
SigmaExpected
return
Efficient
frontier
points
0.00%6.50%0.71%
10.00%5.98%0.73%
20.00%5.48%0.74%
30.00%5.01%0.76%
40.00%4.59%0.77%
50.00%4.23%0.79%
60.00%3.94%0.81%
70.00%
3.74%0.82%
83.41%3.64%0.84%0.84%
90.00%3.66%0.85%0.85%
100.00%3.79%0.87%0.87%

Effect of correlation coefficient on the portfolio

Correlation coefficient of 0.5

PGRY
Average, E(rPG) and E(rRY)0.87%0.71%
Variance, Var(rPG) and Var(rRY)0.00140.0042
Sigma, sPG and sRY3.79%6.50%
Correlation coefficient, rPG,RY)0.50
Covariance, Cov(rPG,rRY)0.00<– =B6*B5*C5

Possible combinations

Percentage in PGSigmaExpected
return
0.06.50%0.71%
0.16.05%0.73%
0.25.62%0.74%
0.35.21%0.76%
0.44.84%0.77%
0.54.51%0.79%
0.64.23%0.81%
0.74.00%0.82%
0.83.85%0.84%
0.93.78%0.85%
1.03.79%0.87%

Correlation coefficient -1

PGRY
Average, E(rPG) and E(rRY)0.87%0.71%
Variance, Var(rPG) and Var(rRY)0.00140.0042
Sigma, sPG and sRY3.79%6.50%
Correlation coefficient, rPG,RY)-1.00
Covariance, Cov(rPG,rRY)0.00<– =B6*B5*C5

Possible combinations

Percentage in PGSigmaExpected
return
0.06.50%0.71%
0.15.47%0.73%
0.24.44%0.74%
0.33.41%0.76%
0.42.38%0.77%
0.51.35%0.79%
0.6320.00%0.81%
0.70.70%0.82%
0.81.73%0.84%
0.92.76%0.85%
1.03.79%0.87%

Correlation coefficient 1

PGRY
Average, E(rPG) and E(rRY)0.87%0.71%
Variance, Var(rPG) and Var(rRY)0.00140.0042
Sigma, sPG and sRY3.79%6.50%
Correlation coefficient, rPG,RY)1.00
Covariance, Cov(rPG,rRY)0.00<– =B6*B5*C5

Possible combinations

Percentage in PGSigmaExpected
return
0.006.50%0.71%
0.106.23%0.73%
0.205.96%0.74%
0.305.69%0.76%
0.405.42%0.77%
0.505.15%0.79%
0.604.88%0.81%
0.704.61%0.82%
0.804.33%0.84%
0.904.06%0.85%
1.003.79%0.87%

Appendix 3

Single Index Model

Regression results

Proctor & Gamble

SUMMARY OUTPUT
Regression Statistics
Multiple R0.073302307
R Square0.005373228
Adjusted R Square-0.0238805
Standard Error0.038923678
Observations36
ANOVA
dfSSMSFSignificance F
Regression10.000278280.000278280.1836766940.670935506
Residual340.0515117920.001515053
Total350.051790072
CoefficientsStandard Errort StatP-valueLower 95%
Intercept0.008480.0065036251.304323030.200884411-0.004734129
MKT-Rf0.016340.0381219820.428575190.670935506-0.061135052

Royal Bank of Canada

SUMMARY OUTPUT
Regression Statistics
Multiple R0.194872561
R Square0.037975315
Adjusted R Square0.009680471
Standard Error0.065607824
Observations36
ANOVA
dfSSMSFSignificance F
Regression10.005777040.005777041.3421280.254731727
Residual340.1463491430.004304387
Total350.152126183
CoefficientsStandard Errort StatP-valueLower 95%
Intercept0.008030.0109621890.7323268350.468988-0.014249943
MKT-Rf-0.074440.064256524-1.1585026810.254732-0.205026325

Treynor-Black Framework

Results

Results estimation factor models

estimated alphabetaσ(εi)^2
Stock PG0.0080.01630.001
Stock RY0.008-0.07440.004

Determine stocks weights active portfolio

estimated alphawi
Stock PG5.76475.0%
Stock RY1.92025.0%

Determine alpha, beta, and idiosyncratic risk of the active portfolio

Weighted averages
Beta of the active portfolio-0.00634
Alpha of the active portfolio0.00837
Idiosyncratic risk of the active portfolio0.00109

Determine weight active portfolio – 118.85%

Perform correction to adjust beta active portfolio – 54.12%

Determine weight passive portfolio – 45.88%

Appendix 4

Analysis at a later time period

Data

Expected returns
DatePGRYPGRY
04-03-1370.108453.53184
01-04-1370.357754.181590.36%1.21%
01-05-1370.3485453.29351-0.01%-1.64%
03-06-1370.5593352.306760.30%-1.85%
01-07-1374.1441256.437625.08%7.90%
01-08-1371.9188755.93039-3.00%-0.90%
03-09-1369.7951858.15855-2.95%3.98%
01-10-1375.1425561.437127.66%5.64%
01-11-1378.3715960.833544.30%-0.98%
02-12-1375.7567261.48285-3.34%1.07%
02-01-1471.8387257.11374-5.17%-7.11%
03-02-1473.7514260.030342.66%5.11%
03-03-1473.1888660.48259-0.76%0.75%

Portfolio data

CALCULATING PORTFOLIO RETURNS AND THEIR STATISTICS

Proportion of PG0.5
Proportion of RY0.5
DatePGRYPortfolio
Return
01-04-130.36%1.21%0.78%<– =$B$2*B6+$B$3*C6
01-05-13-0.01%-1.64%-0.83%
03-06-130.30%-1.85%-0.78%
01-07-135.08%7.90%6.49%
01-08-13-3.00%-0.90%-1.95%
03-09-13-2.95%3.98%0.52%
01-10-137.66%5.64%6.65%
01-11-134.30%-0.98%1.66%
02-12-13-3.34%1.07%-1.13%
02-01-14-5.17%-7.11%-6.14%
03-02-142.66%5.11%3.88%
03-03-14-0.76%0.75%0.00%
Mean0.43%1.10%0.76%<– =AVERAGE(E6:E17)
Variance0.00140.00150.0012<– =VARP(E6:E17)
Standard deviation3.70%3.91%3.44%<– =STDEVP(E6:E17)
Covariance0.0009
Correlation0.6370

Direct calculation of portfolio mean and variance

Portfolio mean, E(rp)0.76%<– =B2B19+B3C19
Portfolio variance, Var(rp)0.0012<– =B2^2B20+B3^2C20+2B2B3*C22
Portfolio standard dev., sp3.44%<– =SQRT(B27)
More related papers Related Essay Examples
Cite This paper
You're welcome to use this sample in your assignment. Be sure to cite it correctly

Reference

IvyPanda. (2022, June 10). Valuation of Securities and Stock Trading. https://ivypanda.com/essays/valuation-of-securities-and-stock-trading/

Work Cited

"Valuation of Securities and Stock Trading." IvyPanda, 10 June 2022, ivypanda.com/essays/valuation-of-securities-and-stock-trading/.

References

IvyPanda. (2022) 'Valuation of Securities and Stock Trading'. 10 June.

References

IvyPanda. 2022. "Valuation of Securities and Stock Trading." June 10, 2022. https://ivypanda.com/essays/valuation-of-securities-and-stock-trading/.

1. IvyPanda. "Valuation of Securities and Stock Trading." June 10, 2022. https://ivypanda.com/essays/valuation-of-securities-and-stock-trading/.


Bibliography


IvyPanda. "Valuation of Securities and Stock Trading." June 10, 2022. https://ivypanda.com/essays/valuation-of-securities-and-stock-trading/.

If, for any reason, you believe that this content should not be published on our website, please request its removal.
Updated:
This academic paper example has been carefully picked, checked and refined by our editorial team.
No AI was involved: only quilified experts contributed.
You are free to use it for the following purposes:
  • To find inspiration for your paper and overcome writer’s block
  • As a source of information (ensure proper referencing)
  • As a template for you assignment
1 / 1