i have a project in Mgmt And Organization Behavior
joesephe
TemplateCh8.xlsxInstructions
Template
| Student Name | |||||
| ID | |||||
| Company Name | |||||
| Beta | |||||
| Is your company above average risk, about average risk, below average risk and why? | My company is | ||||
| S&P 500 | S&P 500 | your company | your company | ||
| Date | Adj Close | Return | Adj Close | Return | |
| 3/1/18 | 2677.669922 | ||||
| 3/2/18 | 2691.25 | 0.0050716027 | |||
| 3/5/18 | 2720.939941 | 0.0110320264 | |||
| 3/6/18 | 2728.120117 | 0.0026388587 | |||
| 3/7/18 | 2726.800049 | -0.0004838746 | |||
| 3/8/18 | 2738.969971 | 0.0044630783 | |||
| 3/9/18 | 2786.570068 | 0.0173788313 | |||
| 3/12/18 | 2783.02002 | -0.0012739848 | |||
| 3/13/18 | 2765.310059 | -0.0063635766 | |||
| 3/14/18 | 2749.47998 | -0.0057245223 | |||
| 3/15/18 | 2747.330078 | -0.0007819304 | |||
| 3/16/18 | 2752.01001 | 0.0017034473 | |||
| 3/19/18 | 2712.919922 | -0.0142041954 | |||
| 3/20/18 | 2716.939941 | 0.0014818053 | |||
| 3/21/18 | 2711.929932 | -0.0018439896 | |||
| 3/22/18 | 2643.689941 | -0.0251628887 | |||
| 3/23/18 | 2588.26001 | -0.0209668805 | |||
| 3/26/18 | 2658.550049 | 0.0271572557 | |||
| 3/27/18 | 2612.620117 | -0.0172763089 | |||
| 3/28/18 | 2605 | -0.0029166571 | |||
| 3/29/18 | 2640.870117 | 0.0137697186 | |||
Solved Example
| Student Name | Solved Example | |||||
| ID | Solved Example | |||||
| Company Name | GE: General Electrictic Company | |||||
| Beta | 0.4303660649 | |||||
| Is this stock above average, average, below average risk and why? | GE beta is ……………………………………….. | |||||
| S&P 500 | S&P 500 | GE | GE | |||
| Date | Adj Close | Return | Adj Close | Return | ||
| 3/1/18 | 2677.669922 | 14.02 | ||||
| 3/2/18 | 2691.25 | 0.0050716027 | 14.12 | 0.0071326676 | ||
| 3/5/18 | 2720.939941 | 0.0110320264 | 14.42 | 0.0212464589 | ||
| 3/6/18 | 2728.120117 | 0.0026388587 | 14.64 | 0.0152565881 | ||
| 3/7/18 | 2726.800049 | -0.0004838746 | 14.51 | -0.0088797814 | ||
| 3/8/18 | 2738.969971 | 0.0044630783 | 14.52 | 0.0006891799 | ||
| 3/9/18 | 2786.570068 | 0.0173788313 | 14.94 | 0.0289256198 | ||
| 3/12/18 | 2783.02002 | -0.0012739848 | 15.1 | 0.0107095047 | ||
| 3/13/18 | 2765.310059 | -0.0063635766 | 14.43 | -0.0443708609 | ||
| 3/14/18 | 2749.47998 | -0.0057245223 | 14.27 | -0.0110880111 | ||
| 3/15/18 | 2747.330078 | -0.0007819304 | 14.36 | 0.0063069376 | ||
| 3/16/18 | 2752.01001 | 0.0017034473 | 14.31 | -0.0034818942 | ||
| 3/19/18 | 2712.919922 | -0.0142041954 | 14.07 | -0.0167714885 | ||
| 3/20/18 | 2716.939941 | 0.0014818053 | 13.64 | -0.0305614783 | ||
| 3/21/18 | 2711.929932 | -0.0018439896 | 13.88 | 0.0175953079 | ||
| 3/22/18 | 2643.689941 | -0.0251628887 | 13.35 | -0.038184438 | ||
| 3/23/18 | 2588.26001 | -0.0209668805 | 13.07 | -0.0209737828 | ||
| 3/26/18 | 2658.550049 | 0.0271572557 | 12.89 | -0.0137719969 | ||
| 3/27/18 | 2612.620117 | -0.0172763089 | 13.44 | 0.0426687355 | ||
| 3/28/18 | 2605 | -0.0029166571 | 13.68 | 0.0178571429 | ||
| 3/29/18 | 2640.870117 | 0.0137697186 | 13.48 | -0.014619883 | ||
