Calculation of annual returns:
Month |
Apple Ltd |
Returns |
Month |
Orange Ltd |
Returns |
Month |
Market Index |
Returns |
Share price ($) |
Share price ($) |
(ASX index) |
||||||
Jan-16 |
13.05 |
0.00% |
Jan-16 |
20.55 |
0.00% |
Jan-16 |
4650 |
0.00% |
Feb-16 |
13.4 |
2.68% |
Feb-16 |
21.15 |
2.92% |
Feb-16 |
4770 |
2.58% |
Mar-16 |
13.87 |
3.51% |
Mar-16 |
20.95 |
-0.95% |
Mar-16 |
4840 |
1.47% |
Apr-16 |
13.12 |
-5.41% |
Apr-16 |
18.75 |
-10.50% |
Apr-16 |
4940 |
2.07% |
May-16 |
13.37 |
1.91% |
May-16 |
17.1 |
-8.80% |
May-16 |
4815 |
-2.53% |
Jun-16 |
13 |
-2.77% |
Jun-16 |
19.35 |
13.16% |
Jun-16 |
4788 |
-0.56% |
Jul-16 |
13.5 |
3.85% |
Jul-16 |
20.1 |
3.88% |
Jul-16 |
5055 |
5.58% |
Aug-16 |
13.9 |
2.96% |
Aug-16 |
21.05 |
4.73% |
Aug-16 |
5125 |
1.38% |
Sep-16 |
14.12 |
1.58% |
Sep-16 |
22.15 |
5.23% |
Sep-16 |
5035 |
-1.76% |
Oct-16 |
14.87 |
5.31% |
Oct-16 |
23.85 |
7.67% |
Oct-16 |
5115 |
1.59% |
Nov-16 |
15.25 |
2.56% |
Nov-16 |
22.9 |
-3.98% |
Nov-16 |
5200 |
1.66% |
Dec-16 |
16.05 |
5.25% |
Dec-16 |
21.85 |
-4.59% |
Dec-16 |
5255 |
1.06% |
Jan-17 |
16.4 |
2.18% |
Jan-17 |
23.8 |
8.92% |
Jan-17 |
5305 |
0.95% |
Annual return |
23.61% |
Annual return |
17.69% |
Annual return |
13.49% |
(Source: Appendix A) (Source: Appendix A) (Source: Appendix A)
Comment:
It is seen that annual return of Apple ltd and annual return of orange ltd are more than market index annual return. Further it is also seen that Apple ltd annual return is more that Orange ltd which shows that both companies are performing well according to market index but Apple ltd is performing best among the three (Fama, 1990).
Calculation of standard deviations:
Month |
Apple Ltd |
Returns |
Month |
Orange Ltd |
Returns |
Month |
M Market Index |
Returns |
Share price ($) |
Share price ($) |
(ASX index) |
||||||
Jan-16 |
13.05 |
0.00% |
Jan-16 |
20.55 |
0.00% |
Jan-16 |
4650 |
0.00% |
Feb-16 |
13.4 |
2.68% |
Feb-16 |
21.15 |
2.92% |
Feb-16 |
4770 |
2.58% |
Mar-16 |
13.87 |
3.51% |
Mar-16 |
20.95 |
-0.95% |
Mar-16 |
4840 |
1.47% |
Apr-16 |
13.12 |
-5.41% |
Apr-16 |
18.75 |
-10.50% |
Apr-16 |
4940 |
2.07% |
May-16 |
13.37 |
1.91% |
May-16 |
17.1 |
-8.80% |
May-16 |
4815 |
-2.53% |
Jun-16 |
13 |
-2.77% |
Jun-16 |
19.35 |
13.16% |
Jun-16 |
4788 |
-0.56% |
Jul-16 |
13.5 |
3.85% |
Jul-16 |
20.1 |
3.88% |
Jul-16 |
5055 |
5.58% |
Aug-16 |
13.9 |
2.96% |
Aug-16 |
21.05 |
4.73% |
Aug-16 |
5125 |
1.38% |
Sep-16 |
14.12 |
1.58% |
Sep-16 |
22.15 |
5.23% |
Sep-16 |
5035 |
-1.76% |
Oct-16 |
14.87 |
5.31% |
Oct-16 |
23.85 |
7.67% |
Oct-16 |
5115 |
1.59% |
Nov-16 |
15.25 |
2.56% |
Nov-16 |
22.9 |
-3.98% |
Nov-16 |
5200 |
1.66% |
Dec-16 |
16.05 |
5.25% |
Dec-16 |
21.85 |
-4.59% |
Dec-16 |
5255 |
1.06% |
Jan-17 |
16.4 |
2.18% |
Jan-17 |
23.8 |
8.92% |
Jan-17 |
5305 |
0.95% |
Standard Deviation |
3.03% |
Standard Deviation |
6.99% |
Standard Deviation |
2.03% |
Annualized standard deviation |
10.93% |
|
Annualized standard deviation |
25.20% |
|
Annualized standard deviation |
7.30% |
(Source: Appendix A) (Source: Appendix A) (Source: Appendix A)
Comparing the annualized standard deviation of two companies it is seen that Apple ltd standard deviation is 10.93% whereas standard deviation of Orange ltd is 25.20% which means Apple ltd has least risk a compare to Orange Ltd. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Further it is also seen that market index has least standard deviation as compare to both companies. This is because standard deviation of market comprises of standard deviation of companies listed in that particular market and forms an average risk taking all companies risks comprises in that market (Tsiang, 1972). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Question4
Calculations of Beta:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Beta of Apple |
0.1471 |
Beta of a stock measures the volatility of the stock with repect to market index. If beta value of a stock is more than one then it is referred as ‘high beta stock’ means this types of stock are riskier than market index whereas if beta value of a stock is less than one then it is referred as ‘low beta stock’ this means stocks under this category are not riskier than market index (Babcock, 1972).
Here the beta of Apple ltd and orange ltd are less risky than market index. But comparing the beta of these two companies it can be said beta with high are more risky than beta with low value. Hence, Apple ltd has more risk than Orange Ltd.
Beta of Orange |
0.0157 |
Given information: |
|
|
Companies |
Beta [calculated in Q4] |
Weights [given] |
Apple Ltd |
0.147071207 |
40% |
Orange Ltd |
0.015665314 |
60% |
Calculation of Portfolio Beta: |
|
|
|
|
|
Portfolio beta = Weights of Apple * beta of apple + weights of orange * beta of orange |
|||||
Bp |
0.068227671 |
Comment:
Portfolio beta is the combined beta of all stocks according to the proportion of investments. |
Here the Portfolio beta is smaller than apple ltd whereas it is bigger than orange ltd (Markowitz, 1991). |
Calculation of Risk free rate (Rf):
Rf (%) |
5.39 |
(Source: Appendix D)
Calculation of Expected returns of Apple Ltd and Orange Ltd as per CAPM model:
Ri = Rf + β(Rm-Rf)
(Bruner, et.el., 2008).
Where,
Rf (%) |
5.39 |
Rm (%) [calculated in Q1] |
13.49 |
Apple ltd |
|
Orange Ltd |
||
Beta |
0.147071207 |
|
Beta |
0.015665314 |
Ri (%) |
6.58 |
|
Ri (%) |
5.52 |
Given information: |
|
|
Bond information |
Apple Ltd |
Orange Ltd |
Maturity value (FV) |
150000 |
200000 |
Current price |
140000 |
215000 |
Coupon rate |
9% |
10% |
Time to maturity |
6 years |
5 years |
Suppose, face value of bond |
100000 |
|
Given that interest paid semiannually. For calculation of YTM, time gets doubled and interest rate gets half. |
YTM = C + (FV -CP)/n |
Particulars |
Apple ltd |
Orange ltd |
YTM = Yield to maturity |
||
C = Interest amount |
4500 |
5000 |
FV = fair Value |
150000 |
200000 |
CP = current price |
140000 |
215000 |
n = no. of years |
12 |
10 |
Apple Ltd |
|
|
YTM (annually) |
7.36% |
|
Orange Ltd |
|
|
YTM (annually) |
3.37% |
|
(Rode.et el, 1976)
Given Information: |
|
|
|
|
Apple Ltd |
|
Orange Ltd |
||
Debt |
50% |
|
Debt |
30% |
Equity |
50% |
|
Equity |
70% |
Ke [calculated in Q6] |
6.58% |
|
Ke [calculated in Q6] |
5.52% |
WACC = Weight of Debt * Kd + Weight of Equity * Ke |
|||
|
Apple Ltd |
Orange Ltd |
|
Weight of debt |
50% |
30% |
|
Kd |
0 |
0 |
|
Weight of equity |
50% |
70% |
|
Ke |
6.58% |
5.52% |
|
WACC |
3.29% |
3.86% |
WACC is very useful for investors because it represents minimum rate of return. In other words, WACC is the overall cost of capital of the company which comprises of different category of capital is proportionately weighted. It includes common stock, debts, preferred stock. Thus, WACC of orange ltd is higher than WACC of Apple ltd which indicates investors should invest money in Orange ltd (Farber, Gillet and Szafarz, 2006).
Calculation of growth rate as per CAGR method:
|
Apple Ltd |
Orange Ltd |
Growth rate (g) |
4.56% |
5.92% |
(Source: Appendix B)
Given Information: |
|
|
Particulars |
Apple Ltd |
Orange Ltd |
Ke [calculated in Q6] |
6.58% |
5.52% |
Growth rate (g)[calculated in Q9] |
4.56% |
5.92% |
Dividend of current year [2015] |
1.25 |
2 |
(Source: Appendix B)
Calculation of market value of shares as per dividend discount model:
DDM = Dividend of current year/(Ke – g) |
||
|
|
|
|
Apple Ltd |
Orange Ltd |
market value of share ($) |
62.00 |
-497.0 |
Comment: |
|
|
|
|
|
|
Value of Apple is $ 62 whereas value of orange is in negative but taken as Zero. |
(Penman, 1998).
Penman, S.H., 1998, ‘a synthesis of equity valuation techniques and the terminal value calculation for the dividend discount model’, A review of accounting studies, vol.2, no.4, pp.303-323.
Rode, F., Crowley, Jr, W.L., Walker, A.D. and Cochran, D.S., Hewlett-Packard company, 1976, general purpose calculator with capability for performing yield-to-maturity of a bond calculation, U.S.
Markowitz, H.M., 1991, ‘foundation of portfolio theory’, the journal of finance, vol.46, no.2, pp.469-477.
Fama, E.F., 1990, ‘stock returns, expected returns, and real activity’, the journal of finance, vol.45, no.4, pp.1089-1108.
Tsiang, S.C., 1972, ‘the rationale of the mean-standard deviation analysis, skewness preference and the demand for money’, the American economic review,vol.62, no.3, pp.354-371.
Babcock, G.C., 1972, ‘a note on justifying beta as a measure of risk’, the journal of finance, vol.27, no.3, pp.699-702.
Bruner, R.F., Li,W., Kritzman, M., Myrgren, S. and Page, S., 2008, ‘market integration in developed and emerging markets: evidence from the CAPM’, Emerging markets review, vol.9, no.2, pp.89-103.
Farber, A., Gillet, R.L. and Szafarz, A., 2006, a general formula for the WACC.
Lettau, M and Ludvigson, S.C., 2005, ‘expected returns and expected dividend growth’, Journal of financial Economics, vol.76, no.3, pp.583-626.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download