{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

XC-Obtaining Beta

XC-Obtaining Beta - JaredLindenberg Kiss0701 FlowserveCorp...

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

View Full Document Right Arrow Icon
Jared Lindenberg OFFSET($B$1,MATCH Kiss - 0701  Extra Credit - Obtaining Beta Flowserve Corp Information obtained from Daileyfinance.com Year Month Stock Returns Index Returns Calculated Beta 2006 Jan N/A 2.65% Feb N/A 0.27% Mar N/A 1.24% Apr 1.40% 1.34% 1.55 May -7.54% -2.88% Jun 7.00% 0.14% Jul -8.95% 0.62% Aug -1.26% 2.38% Sep -1.07% 2.58% Oct 4.76% 3.26% Nov 1.58% 1.90% Dec -6.25% 1.40% 2007 Jan 5.15% 1.51% Feb -2.21% -1.96% Mar 10.21% 1.12% Apr 6.68% 4.43% May 13.77% 3.49% Jun 3.16% -1.66% Jul 0.94% -3.10% Aug -1.18% 1.50% Sep 6.68% 3.74% Oct 3.65% 1.59% Nov 19.16% -4.18% Dec 2.24% -0.69% 2008 Jan -14.64% -6.00% Feb 32.63% -3.25% Mar -4.14% -0.43% Apr 18.88% 4.87% May 11.63% 1.30% Jun -1.30% -8.43% Jul -2.45% -0.84% Aug -0.90% 1.45% Sep -32.80% -8.91% Oct -35.87% -16.79% Nov -11.57% -7.18% The calculated beta for Flows Finance, Reuter's , and MSN M slightly above the given Betas This is most likely because the risk associated with Flowserve
Image of page 1

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

View Full Document Right Arrow Icon
Dec 2.32% 1.06% 2009 Jan 3.51% -8.43% Feb -5.32% -10.65% Mar 11.19% 8.76% Apr 20.99% 9.57% May 8.35% 5.59% Jun -5.10% 0.20% Jul 15.70% 7.56% Aug 6.78% 3.61% Sep 14.25% 3.73% Oct -0.32% -1.86% Nov 1.27% 6.00% Dec -4.95% 1.93% 2010 Jan -4.60% -3.70% Feb 11.00% 2.90% Mar 10.17% 5.80% Apr 3.91% 1.50% May -16.99% -8.20% Jun -10.82% -5.40% Jul 16.93% 6.90% Aug -9.85% -4.70% Sep 22.42% 8.80% Oct -8.60% 3.70% Nov 5.46% -0.20% Dec 13.05% 6.50%
Image of page 2
H($B$16,B1:B16,0)-1,0) Google Finance Beta Reuter's Beta MSN Money Beta 1.54 1.53 1.53 serve Corp seems to be inline with the betas obtained from Google Money. The calculated beta of 1.546 (rounded up to 1.55) is very s of 1.54, 1.53, and 1.53, which provides for a very narrow range. e major financial services have been able to properly measure the e's stock returns.
Image of page 3

Info icon This 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 icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
STANDARD & POOR'S INDEX SERVICES S&P 500 MONTHLY RETURNS MONTH OF PRICE PRICE 1 MONTH 3 MONTH 6 MONTH 1 YEAR 2 YEAR CLOSE CHANGE % CHANGE % CHANGE % CHANGE % CHANGE % CHANGE 10/2009 1036.19 -20.88 -1.98% 4.93% 18.72% 6.96% -33.12% 09/2009 1057.08 36.45 3.57% 14.98% 32.49% -9.37% -30.76% 08/2009 1020.62 33.14 3.36% 11.04% 38.84% -20.44% -30.76% 07/2009 987.48 68.16 7.41% 13.14% 19.57% -22.08% -32.14% 06/2009 919.32 0.18 0.02% 15.22% 1.78% -28.18% -38.85% 05/2009 919.14 46.33 5.31% 25.04% 2.56% -34.36% -39.95% 04/2009 872.81 74.94 9.39% 5.68% -9.90% -37.01% -41.12% 03/2009 797.87 62.77 8.54% -11.67% -31.59% -39.68% -43.85% 02/2009 735.09 -90.79 -10.99% -17.98% -42.70% -44.76% -47.75% 01/2009 825.88 -77.37 -8.57% -14.75% -34.84% -40.09% -42.58% 12/2008 903.25 7.02 0.78% -22.56% -29.43% -38.49% -36.31% 11/2008 896.24 -72.52 -7.49% -30.14% -36.00% -39.49% -36.01% 10/2008 968.75 -197.61 -16.94% -23.56% -30.08% -37.47% -29.70% 09/2008 1166.36 -116.47 -9.08% -8.88% -11.82% -23.60% -12.69% 08/2008 1282.83 15.45 1.22% -8.39% -3.59% -12.97% -1.61% 07/2008 1267.38 -12.62 -0.99% -8.53% -8.06% -12.91% -0.73% 06/2008 1280.00 -120.38 -8.60% -3.23% -12.83% -14.86% 0.77% 05/2008 1400.38 14.79 1.07% 5.24% -5.45% -8.51% 10.26% 04/2008 1385.59 62.88 4.75% 0.51% -10.57% -6.53% 5.72% 03/2008 1322.70 -7.93 -0.60% -9.92% -13.36% -6.91% 2.15% 02/2008 1330.63 -47.91 -3.48% -10.16% -9.73% -5.42% 3.90% 01/2008 1378.55 -89.81 -6.12% -11.03% -5.27% -4.15% 7.69% 12/2007 1468.36 -12.79 -0.86% -3.82% -2.33% 3.53% 17.63% 11/2007 1481.14 -68.23 -4.40% 0.49% -3.23% 5.75% 18.54% 10/2007 1549.38 22.63 1.48% 6.47% 4.52% 12.44% 28.37% 09/2007 1526.75 52.76 3.58% 1.56% 7.45% 14.29% 24.25% 08/2007 1473.99 18.71 1.29% -3.70% 4.77% 13.05% 20.79% 07/2007 1455.27 -48.07 -3.20% -1.83% 1.18% 13.99% 17.91% 06/2007 1503.35 -27.27 -1.78% 5.81% 6.00% 18.35% 26.19% 05/2007 1530.62 48.25 3.26% 8.80% 9.28% 20.51% 28.46% 04/2007 1482.37 61.50 4.33% 3.07% 7.58% 13.10% 28.14% 03/2007 1420.86 14.04 1.00% 0.18% 6.36% 9.73% 20.35% 02/2007 1406.82 -31.42 -2.18% 0.44% 7.90% 9.85% 16.88% 01/2007 1438.24 19.94 1.41% 4.38% 12.66% 12.36% 21.75% 12/2006 1418.30 17.67 1.26% 6.17% 11.66% 13.62% 17.03% 11/2006 1400.63 22.69 1.65% 7.43% 10.28% 12.10% 19.32% 10/2006 1377.94 42.10 3.15% 7.93% 5.14% 14.16% 21.92% 09/2006 1335.85 32.03 2.46% 5.17% 3.17% 8.71% 19.85% 08/2006 1303.82 27.16 2.13% 2.66% 1.81% 6.84% 18.07% 07/2006 1276.66 6.46 0.51% -2.59% -0.27% 3.44% 15.88%
Image of page 7

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

View Full Document Right Arrow Icon
06/2006 1270.20 0.11 0.01% -1.90% 1.76% 6.62% 11.34% 05/2006 1270.09 -40.52 -3.09% -0.83% 1.65% 6.60% 13.33% 04/2006 1310.61 15.78 1.22% 2.38% 8.58% 13.29% 18.36% 03/2006 1294.83 14.16 1.11% 3.73% 5.37% 9.68% 14.97% 02/2006 1280.66 0.58 0.05% 2.50% 4.94% 6.40% 11.85% 01/2006 1280.08 31.79 2.55% 6.05% 3.72% 8.37% 13.17% 12/2005 1248.29 -1.19 -0.09%
Image of page 8
Image of page 9
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