Tanzia.xlsx - 60 Date 1/1/

Info icon This preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
60% 40% Lenovo Acer Date Close data Return Close data Return 11/1/2012 43.232132 1.21 12/1/2012 46.457233 7.46% 1.9 57.02% 1/1/2013 53.366505 14.87% 1.87 -1.58% 2/1/2013 57.959049 8.61% 2 6.95% 3/1/2013 50.463039 -12.93% 2.05 2.50% 4/1/2013 45.733822 -9.37% 2.51 22.44% 5/1/2013 51.327637 12.23% 1.92 -23.51% 6/1/2013 52.042881 1.39% 1.9 -1.04% 7/1/2013 52.6679 1.20% 1.89 -0.53% 8/1/2013 52.534561 -0.25% 1.77 -6.35% 9/1/2013 57.889759 10.19% 1.87 5.65% 10/1/2013 65.11026 12.47% 1.75 -6.42% 11/1/2013 64.648468 -0.71% 1.69 -3.43% 12/1/2013 71.055862 9.91% 1.55 -8.28% 1/1/2014 77.402451 8.93% 1.99 28.39% 2/1/2014 83.453445 7.82% 1.75 -12.06% 3/1/2014 91.548286 9.70% 1.96 12.00% 4/1/2014 92.476036 1.01% 1.65 -15.82% 5/1/2014 93.58252 1.20% 1.34 -18.79% 6/1/2014 80.401077 -14.09% 1.22 -8.96% 7/1/2014 90.968544 13.14% 1.36 11.48% 8/1/2014 89.932671 -1.14% 1.28 -5.88% 9/1/2014 84.359299 -6.20% 1.33 3.91% 10/1/2014 74.834732 -11.29% 1.22 -8.27% 11/1/2014 59.948822 -19.89% 1.1 -9.84% 12/1/2014 58.581448 -2.28% 1.04 -5.45% 1/1/2015 51.751877 -11.66% 1.95 87.50% 2/1/2015 58.26865 12.59% 0.91 -53.33% 3/1/2015 59.765972 2.57% 0.79 -13.19% 4/1/2015 68.458229 14.54% 0.61 -22.78% 5/1/2015 64.085754 -6.39% 0.65 6.56% 6/1/2015 62.393574 -2.64% 0.69 6.15% 7/1/2015 51.158848 -18.01% 1 44.93% 8/1/2015 52.284088 2.20% 1.35 35.00% 9/1/2015 42.345219 -19.01% 1.36 0.74% 10/1/2015 50.418232 19.06% 1.21 -11.03% 11/1/2015 52.192314 3.52% 1.5 23.97% 12/1/2015 48.552197 -6.97% 1.48 -1.33% 1/1/2016 46.058849 -5.14% 1.26 -14.86% 2/1/2016 48.026333 4.27% 1.43 13.49%
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
3/1/2016 30.013554 -37.51% 1.29 -9.79% 4/1/2016 60.820442 102.64% 1.32 2.33% 5/1/2016 56.248795 -7.52% 1.24 -6.06% 6/1/2016 62.469402 11.06% 1.18 -4.84% 7/1/2016 57.667645 -7.69% 1.48 25.42% 8/1/2016 56.262474 -2.44% 1.59 7.43% 9/1/2016 63.330379 12.56% 1.49 -6.29% 10/1/2016 59.387524 -6.23% 1.12 -24.83% 11/1/2016 71.187851 19.87% 1.42 26.79% 12/1/2016 73.660156 3.47% 1.25 -11.97% 1/1/2017 55.721672 -24.35% 1.19 -4.80% 2/1/2017 65.066475 16.77% 1.11 -6.72% 3/1/2017 63.998314 -1.64% 1.19 7.21% 4/1/2017 58.297398 -8.91% 1.11 -6.72% 5/1/2017 50.625679 -13.16% 1.11 0.00% 6/1/2017 52.876305 4.45% 1.05 -5.41% 7/1/2017 80.256508 51.78% 1.09 3.81% 8/1/2017 41.199535 -48.67% 1.11 1.83% 9/1/2017 51.49725 24.99% 1.23 10.81% 10/1/2017 60.671379 17.81% 2 62.60% Lenovo Acer Avg. Return 2.34% 3.00% Variance 0.0407249757 0.0490232488 SD 20.18% 22.14% Covariance -0.000268882 Correlation -0.00612144 Portfolio Return 2.60% Portfolio Variance 0.0223734227 Portfolio SD 14.96% -20 0 20 40 60 80 100 120 140 160 180
Image of page 2
Portfolio Return Lenovo Acer Portfolio Return Portfolio Variance Portfolio SD 0% 100% 3.00% 0.0490232488 22.14% 27.29% 10% 90% 2.93% 0.0400676826 20.02% 8.29% 20% 80% 2.87% 0.0329178362 18.14% 7.94% 30% 70% 2.80% 0.0275737095 16.61% -6.76% 40% 60% 2.73% 0.0240353025 15.50% 3.35% 50% 50% 2.67% 0.0223026154 14.93% -2.06% 60% 40% 2.60% 0.0223756479 14.96% 0.42% 70% 30% 2.54% 0.0242544002 15.57% 0.51% 80% 20% 2.47% 0.0279388723
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern