Conduct some market research to find out what has been happening to your stock (Carlisle Companies Incorporated (CSL)for the last 5 years. What are the two primary sources which cause the prices of your stock to plunge (i.e. decline) at certain times; Unsystematic risk and Systematic risk. Highlight two specific down periods where one is caused by unsystematic risk and the other by systematic risk. [11 marks]
For each, discuss the real-event in detail and how it affected the company performance on the day (or over the days) by referring to price changes (You can have a look at daily price changes in Yahoo by following these steps:
1.To download the data go tohttp://au.finance.yahoo.com
2.Type the name of your company in the search box. Then click "Search".
3.Click the tab titled "Historical Data".
4.Set Start date as 01/07/2015 and End date as 01/07/2020 (sample period). Please note that date format should be 'dd/mm/yyyy'. Set frequency at 'Daily'. Click "Apply".
5.Click "Download data".Save the data using the file extension .xlsx or .xls. Do not use .csv or .xlsm
6.You will see seven columns in the saved spread sheet with data ranging from 01/07/2015 to 01/07/2020. All we need is Date and Close price[P]. Delete other columns.
Clearly discuss through what channels company performance would have been affected.
For each, discuss how S&P/ASX200 responded on the same day (or over the days) by referring to value changes.
-To get data for S&P/ASX200 follow the same steps, enter in the search box "AXJO" to get the data for S&P/ASX200
Discuss your findings with reference to the impact of unsystematic and systematic risks.
If your answer contains plagiarised materials, no marks will be given.
A B C D E F 1 Date Close (P) Dividend (D) Close price for the market index (m) Monthly realised return for Stock Monthly realised return for market index 1/7/15 101.260002 5699.200195 1/8/15 100.699997 207 0.55% -8.64% 1/9/15 87.379997 0.3 5021.600098 12.93% -3.56% 1/10/15 87 5239.399902 0.43% 4.34% 1/11/15 88.449997 5166.5 1.60%% 1.39% 1/12/15 88.690002 0.3 5295.899902 0.61 2.50% 1/1/16 83.68 5005.5 -5.65% -5.48% 1/2/16 90.160004 4880.899902 7.74% -2.49%% 1/3/16 19.5 0.3 5082.799805 10.69% 4.14% 1/4/16 101.900002 5252.200195 2.40% 3.33% 1/5/16 103.82 5378.600098 1.88% 2.41%% 1/6/16 105.68 0.3 5233.399902 2.08% -2.70% 14 1/7/16 103.290001 6562.299805 -2.26 6.28% 15 1/8/16 104.860001 5433 1.52% -2.32%% 16 1/9/16 102.57 0.35 5435.899902 -1.85% 0.05% 17 1/10/16 104.849998 5317.700195 2.22% 2.17% 18 1/11/16 112.169998 5440.5 6.98% 2.31% 19 1/12/16 110.290001 0.35 5665.799805 -1.36% 4.14% 20 1/1/17 109.110001 5620.899902 -1.06% -0.79% 21 1/2/17 103.300003 5712.200195 -5.32% 1.62% 22 1/3/17 106.410004 0.35 5864.899902 3.35% 2.67% 23 1/4/17 101.389999 5924.100098 4.72% 1.01% 24 1/5/17 101.330002 5724.600098 -0.06% -3.37% 25 1/6/17 95.400002 0.35 5721.5 -5.51% 0.05% 26 1/7/17 97.589996 5720.600098 2.30% -0.02%% 27 1/8/17 94.690002 5714.5 -2.97% -0.11% 28 1/9/17 100.290001 0.37 5681.600098 6.30% 0.58% 29 1/10/17 109.830002 5909 9.50% 4.00% 30 1/11/17 114.970001 5969.899902 4.68% 1.03% 31 1/12/17 113.650002 0.37 6065.100098 0.83% 1.59% 32 1/1/18 114.209999 6037.700195 0.49% -0.45% 33 1/2/18 102.910004 5016 9.89 0.36% 34 1/3/18 104.410004 0.37 5759.399902 1.82% 4.27%% 35 1/4/18 107.730003 5982.700195 3.18% 3.88% 36 1/5/18 107.389999 6011.899902 0.32% 0.49% 37 1/6/18 108.309998 0.37 6194.600098 1.20% 3.04% 38 1/7/18 122.839996 6280.200195 13.42% 1.38% 39 1/8/18 126.809998 6319.5 3.23% 0.63%% 40 1/9/18 121.800003 0.4 6207.600098 -3.64% -1.77% 1/10/18 96.589996 5830.299805 -20.70% -6.08% 42 1/11/18 105.519997 5667.200195 9.25% -2.80%% 1/12/18 100.519997 0.4 5646.399902 -4.36% -0.37%A B C D E F 32 1/1/18 114.209999 6037.700195 D.49% 0.45%% 33 1/2/18 102.910004 6016 -9.89% 0.36% 34 1/3/18 104.410004 0.37 5759.399902 1.82% -4.27% 35 1/4/18 107.730003 5982.700195 3.18% 3.88% 36 1/5/18 107.389999 6011.899902 -0.32% 0.49% 37 1/6/18 108.309998 0.37 6194.600098 1.20% 3.04% 38 1/7/18 122.839996 6280.200195 13.42% 1.38% 39 1/8/18 126.809998 6319.5 3.23% 0.63% 40 1/9/18 121.800003 D.4 6207.600098 -3.64% 1.77 1/10/18 96.589996 5830.299805 -20.70% -6.08% 1/11/18 105.519997 5667.200195 9.25% -2.80% 43 1/12/18 100.519997 0.4 5646.399902 -4.36% -0.37 44 1/1/19 107.730003 5864.700195 7.17% 3.87% 45 1/2/19 123.080002 6169 14.25% 5.19% 46 1/3/19 122.620003 0.4 6180.700195 -0.05% 0.19% 1/4/19 141.419998 6325.5 15.33% 2.34%% 48 1/5/19 133.309998 6396.899902 -5.73% 1.13% 49 1/6/19 140.410004 0.4 6618.799805 5.63% 3.47% 50 1/7/19 144.210007 6812.600098 2.71% 2.93% 1/8/19 144.960007 6604.200195 0.52% -3.06% 1/9/19 145.539993 0.5 6688.299805 0.75% 1.27%% 1/10/19 152.270004 6663.399902 4.62%% 0.37% 54 1/11/19 155.979996 6846 2.44% 2.74% 55 1/12/19 161.839996 D.5 6684.100098 4.08% -2.36% 56 1/1/20 156.229996 7017.200195 -3.47% 4.98% 1/2/20 145.289993 6441.200195 -7.00% -8.20% 58 1/3/20 125.279999 0.5 5076.799805 -13.43% -21.18% 59 1/4/20 120.959999 5522.399902 -3.45% 8.78% 60 1/5/20 119.860001 5755.700195 0.90% 4.22% 1/6/20 119.669998 0.5 5897.899902 0.26% 2.47% 62 1/7/20 119.080002 5927.799805 0.49% 0.51% 63 Average 0.59% 0.17% 64 Variance D.004078468 0.001921737 65 Standard Deviation 0.063862886 0.043837616 66 Covariance 0.001207118 67 Correlation Coefficient .431175819 68 Beta step 1 0.628139367 Beta Step 2 70 leta Step 3 Regression Analysis is on Sheet 2 0.628139367
