PLEASE COMPLETE BY WEDNESDAY 2/15/17 EST 7PM AND SHOW ANY WORK ALL INSTRUCTIONS ARE ATTACHED

MY STOCK TICKER SYMBOLS ARE 341-360

FIN 5550 - Investments Project 1: Beta and Return. This project is worth 10% of your final grade. This project must be completed individually. The objectives of this exercise: 1. To access and download stock and index price data from yahoo.com. 2. To discern the difference between a real-time closing price and an adjusted closing price. 3. To discover how yahoo.com calculates beta for an individual stock. 4. To replicate the yahoo.com calculation for twenty firms in the S&P 500 index, tabulate the results and report your findings. Learning Outcomes: Students should be able to: 1. Identify individual stocks in the S&P 500 index and discuss the composition of the S&P 500 index. 2. Collect financial data including closing stock prices and adjusted closing stock prices. 3. Estimate beta from historical data. 4. Tabulate regression results and discuss empirical findings. Guidelines: 1. You will be assigned twenty (20) stocks from the current S&P 500 index. You must use these 20 stocks (or, more precisely, the ticker symbols) to download data from yahoo.com. Go to yahoo.com, then Finance, then type in your ticker symbol. Next choose Historical Prices from the tabs on the left. Tag \"Monthly\" then choose the appropriate dates (to be determined below). Click Get Prices, scroll to the bottom of the page and download to spreadsheet (it is actually saved as a '.csv' file, but it will open okay in Excel). The last month of return data should be December 2016. Be sure to use end-of-month data! Yahoo might print a beginning of month date in the monthly output, but it should be end of month. To check this, look at the daily data and verify that the last day of the month is used in the monthly spreadsheet (it should be if you wait until after the sample period to collect your data). 2. You must determine how exactly yahoo.com calculates historical beta, then replicate their calculations. This requires the use of regression software (or functions in Excel, if you know how to do that). Note, you must calculate returns first. Is the data sorted correctly - in time order? If not, you must sort your stock prices and market prices so that the oldest prices are first, then calculate returns. Answer the following questions: a. How, exactly, does yahoo.com calculate their beta? How many months of return data do they use? How many months of price data do you need? How do you know that you and Yahoo used the same data period? b. Should you use closing price or adjusted price when calculating returns? Why? c. What is the market proxy? What ticker did you use for your market proxy? 3. After calculating returns for your twenty stocks and the market, you must calculate beta for each of your twenty stocks. Create a Table showing the following: Ticker, Company Name, yahoo beta, calculated beta, intercept and r-square from your regressions. 4. Do your regression results match yahoo.com results? Why or why not? Output: You must submit a brief write-up of your results. Your paper should be detailed enough so that someone else could pick up your paper and replicate your results. So, you will need a brief introduction describing your data sources, how you manipulated the data, how you calculated returns, how you calculated beta, a Table, and a brief summary and discussion of your findings. In total, you must submit: 1. Your write-up as a Word file including the Table described above in Guideline #3 and your answers to the various questions. 2. An Excel spreadsheet (one sheet), properly formatted, containing the ticker symbol, closing price, adjusted price and dates (dates should be the same for each ticker) for each of your twenty stocks and your market proxy. 3. Another Excel spreadsheet, properly formatted, detailing how, exactly, you calculated the results in your Table (i.e., replicate the detailed findings for your stocks). The two Excel worksheets should be in one file with two different labeled worksheet tabs. Alternatively, you may use 20 Excel sheets named with the ticker symbol if you wish to combine the date, ticker symbol, closing price, adjusted closing price, and calculations and/or regressions separately for each of your 20 companies. List of Stocks in the S&P 500 Index on December 31, 2016: Ticker No. Ticker Symbol Company 3M Co 1 MMM Abbott Laboratories 2 ABT AbbVie Inc. 3 ABBV Accenture plc 4 ACN Activision Blizzard 5 ATVI Acuity Brands Inc. 6 AYI Adobe Systems Inc 7 ADBE Advance Auto Parts Inc. 8 AAP AES Corp 9 AES Aetna Inc 10 AET Affiliated Managers Group, Inc. 11 AMG Agilent Technologies Inc 12 A Air Products & Chemicals Inc 13 APD Akamai Technologies Inc 14 AKAM Alaska Air Group Inc. 15 ALK Albemarle Corp. 16 ALB Alcoa Inc 17 AA Alexion Pharmaceuticals Inc 18 ALXN Allegion 19 ALLE Allergan PLC 20 AGN Alliance Data Systems 21 ADS Alliant Energy Corp. 22 LNT Allstate Corp 23 ALL Altria Group Inc 24 MO Alphabet Class A 25 GOOGL Alphabet Class B 26 GOOG Amazon.com Inc 27 AMZN Ameren Corp 28 AEE American Airlines Group 29 AAL American Electric Power 30 AEP American Express Co 31 AXP American Intl Group Inc 32 AIG American Tower Corp A 33 AMT American Water Works Co. Inc. 34 AWK Ameriprise Financial Inc 35 AMP AmerisourceBergen Corp 36 ABC Ametek 37 AME Amgen Inc 38 AMGN Amphenol Corp A 39 APH Anadarko Petroleum Corp 40 APC Analog Devices Inc 41 ADI Anthem Inc (formerly WellPoint Inc) 42 ANTM Aon plc 43 AON 44 APA 45 AIV 46 AAPL 47 AMAT 48 ADM 49 AJG 50 AIZ 51 T 52 ADSK 53 ADP 54 AN 55 AZO 56 AVGO 57 AVB 58 AVY 59 BHI 60 BLL 61 BAC 62 BK 63 BCR 64 BAX 65 BBT 66 BDX 67 BBBY 68 BRK.B 69 BBY 70 BIIB 71 BLK 72 HRB 73 BA 74 BWA 75 BXP 76 BSX 77 BMY 78 BF.B 79 CHRW 80 CA 81 COG 82 CPB 83 COF 84 CAH 85 KMX 86 CCL 87 CAT 88 CBG Apache Corp Apartment Investment & Mgmt Apple Inc. Applied Materials Inc Archer-Daniels-Midland Co Arthur J. Gallagher & Co. Assurant Inc AT&T Inc Autodesk Inc Automatic Data Processing AutoNation Inc AutoZone Inc Avago Technologies AvalonBay Communities Inc Avery Dennison Corp Baker Hughes Inc Ball Corp Bank of America Corp The Bank of New York Mellon Corp Bard C.R. Inc Baxter International Inc BB&T Corp Becton Dickinson & Co Bed Bath & Beyond Inc Berkshire Hathaway B Best Buy Co Inc Biogen Idec Inc BlackRock Inc Block H & R Inc Boeing Co Borgwarner Inc Boston Properties Inc Boston Scientific Corp Bristol-Myers Squibb Brown-Forman Corp B C.H. Robinson Worldwide Inc CA Inc Cabot Oil & Gas A Campbell Soup Co Capital One Financial Cardinal Health Inc Carmax Inc Carnival Corp Caterpillar Inc CBRE Group Inc. 89 CBS 90 CELG 91 CNC 92 CNP 93 CTL 94 CERN 95 CF 96 SCHW 97 CHTR 98 CHK 99 CVX 100 CMG 101 CB 102 CHD 103 CI 104 XEC 105 CINF 106 CTAS 107 CSCO 108 C 109 CFG 110 CTXS 111 CLX 112 CME 113 CMS 114 COH 115 KO 116 CTSH 117 CL 118 CMCSA 119 CMA 120 CAG 121 CXO 122 COP 123 ED 124 STZ 125 COO 126 GLW 127 COST 128 COTY 129 CCI 130 CSRA 131 CSX 132 CMI 133 CVS CBS Corp B Celgene Corp Centene Corporation Centerpoint Energy Inc CenturyLink Inc Cerner Corp CF Industries Holdings Charles Schwab Corp Charter Communications Chesapeake Energy Corp Chevron Corp Chipotle Mexican Grill Inc. Chubb Limited Church & Dwight CIGNA Corporation Cimarex Energy Cincinnati Financial Corp Cintas Corp Cisco Systems Inc Citigroup Inc Citizens Financial Group Citrix Systems Inc Clorox Co CME Group CMS Energy Corp Coach Inc Coca-Cola Co Cognizant Technology Solutions Colgate-Palmolive Co Comcast A Corp Comerica Inc (MI) ConAgra Foods Inc Concho Resources ConocoPhillips Consolidated Edison Inc Constellation Brands Inc A The Cooper Companies Corning Inc Costco Co. Coty Inc Crown Castle Intl Corp CSRA Inc. CSX Corp Cummins Inc CVS Health 134 DHI 135 DHR 136 DRI 137 DVA 138 DE 139 DLPH 140 DAL 141 XRAY 142 DVN 143 DLR 144 DFS 145 DISCA 146 DISCK 147 DG 148 DLTR 149 D 150 DOV 151 DOW 152 DPS 153 DTE 154 DD 155 DUK 156 DNB 157 ETFC 158 EMN 159 ETN 160 EBAY 161 ECL 162 EIX 163 EW 164 EA 165 EMR 166 ENDP 167 ETR 168 EVHC 169 EOG 170 EQT 171 EFX 172 EQIX 173 EQR 174 ESS 175 EL 176 ES 177 EXC 178 EXPE D.R. Horton Inc Danaher Corp Darden Restaurants Inc DaVita Inc Deere & Co Delphi Automotive PLC Delta Airlines Dentsply Sirona Devon Energy Corp Digital Realty Trust Discover Financial Services Discovery Communications - A Discovery Communications - C Dollar General Corp Dollar Tree Inc Dominion Resources Inc Dover Corp Dow Chemical Dr Pepper Snapple Group DTE Energy Co Du Pont (E. I. ) Duke Energy Corp Dun & Bradstreet Corp E*TRADE Financial Corp Eastman Chemical Co Eaton Corp plc eBay Inc. Ecolab Inc Edison Intl Edwards Lifesciences Corp Electronic Arts Emerson Electric Co Endo International Entergy Corp Envision Healthcare Corporation EOG Resources EQT Corporation Equifax Inc Equinix Equity Residential Essex Property Trust Inc. Estee Lauder Cos. Eversource Energy Exelon Corp Expedia Inc. 179 EXPD 180 ESRX 181 EXR 182 XOM 183 FFIV 184 FB 185 FAST 186 FRT 187 FDX 188 FIS 189 FITB 190 FSLR 191 FE 192 FISV 193 FLIR 194 FLS 195 FLR 196 FMC 197 FTI 198 FL 199 F 200 FTV 201 FBHS 202 BEN 203 FCX 204 FTR 205 GPS 206 GRMN 207 GD 208 GE 209 GGP 210 GIS 211 GM 212 GPC 213 GILD 214 GPN 215 GS 216 GT 217 GWW 218 HAL 219 HBI 220 HOG 221 HAR 222 HRS 223 HIG Expeditors Intl Express Scripts Extra Space Storage Exxon Mobil Corp F5 Networks Inc Facebook Fastenal Co Federal Realty Investment Trust FedEx Corporation Fidelity National Information Srvcs. Fifth Third Bancorp (OH) First Solar Inc FirstEnergy Corp Fiserv Inc FLIR Systems Inc Flowserve Corp Fluor Corp FMC Corp FMC Technologies Inc Foot Locker Inc. Ford Motor Co Fortive Corp. Fortune Brands Home & Security Franklin Resources Inc Freeport McMoRan Copper & Gold Frontier Communications Corp Gap Inc Garmin Ltd General Dynamics General Electric Co General Growth Properties Inc. General Mills Inc General Motors Genuine Parts Co Gilead Sciences Inc Global Payments Goldman Sachs Group Inc Goodyear Tire & Rubber Co Grainger W.W. Inc Halliburton Co Hanesbrands Inc. Harley-Davidson Inc Harman Intl Industries Inc Harris Corp Hartford Finl Services Group 224 HAS 225 HCA 226 HCP 227 HP 228 HSIC 229 HSY 230 HES 231 HPE 232 HOLX 233 HD 234 HON 235 HRL 236 HST 237 HPQ 238 HUM 239 HBAN 240 IDXX 241 ITW 242 ILMN 243 IR 244 INTC 245 ICE 246 IBM 247 IP 248 IPG 249 IFF 250 INTU 251 ISRG 252 IVZ 253 IRM 254 JBHT 255 JEC 256 JNJ 257 JPM 258 JNPR 259 KSU 260 K 261 KEY 262 KMB 263 KIM 264 KMI 265 KLAC 266 KSS 267 KHC 268 KR Hasbro Inc HCA Holdings HCP Inc Helmerich & Payne Inc Henry Schein Hershey Foods Corp Hess Corp Hewlett-Packard Enterprise Hologic Inc. Home Depot Inc Honeywell Intl Inc Hormel Foods Corp Host Hotels & Resorts Inc HP Inc. Humana Inc Huntington Bancshares (OH) IDEXX Laboratories Illinois Tool Works Inc Illumina Inc. Ingersoll-Rand PLC Intel Corp IntercontinentalExchange International Business Machines International Paper Co Interpublic Group Cos Intl Flavors & Fragrances Intuit Inc Intuitive Surgical Inc Invesco Ltd Iron Mountain Inc J.B. Hunt Transport Services Inc. Jacobs Engineering Group Inc Johnson & Johnson JP Morgan Chase & Co Juniper Networks Inc Kansas City Southern Kellogg Co KeyCorp Kimberly-Clark Kimco Realty Corp Kinder Morgan Inc KLA-Tencor Corporation Kohl's Corp Kraft Heinz Co. Kroger Co 269 LB 270 LLL 271 LH 272 LRCX 273 LEG 274 LEN 275 LUK 276 LVLT 277 LLY 278 LNC 279 LLTC 280 LKQ 281 LMT 282 L 283 LOW 284 LYB 285 MTB 286 MAC 287 M 288 MNK 289 MRO 290 MPC 291 MAR 292 MMC 293 MLM 294 MAS 295 MA 296 MAT 297 MKC 298 MCD 299 MCK 300 MJN 301 MDT 302 MRK 303 MET 304 MTD 305 KORS 306 MCHP 307 MU 308 MSFT 309 MAA 310 MHK 311 TAP 312 MDLZ 313 MON L Brands Inc L-3 Communications Holdings Lab Corp of America Hldgs Lam Research Corp Leggett & Platt Lennar Corp Leucadia National Corp (NY) Level 3 Communications Lilly (Eli) & Co Lincoln National Corp Linear Technology Corp LKQ Corporation Lockheed Martin Loews Corp Lowe's Cos Inc LyondellBasell Industries N.V. M&T Bank Corp Macerich Macy's Inc Mallinckrodt PLC Marathon Oil Corp Marathon Petroleum Corp. Marriott Intl A Marsh & McLennan Companies Martin Marietta Materials Masco Corp Mastercard Inc A Mattel Inc McCormick & Co McDonald's Corp McKesson Corp Mead Johnson Nutrition Co Medtronic PLC Merck & Co Inc Metlife Inc Mettler Toledo Michael Kors Holdings Microchip Technology Inc Micron Technology Inc Microsoft Corp Mid-America Apartments Mohawk Industries Molson Coors Brewing Co B Mondelez International Inc Monsanto Co. 314 MNST 315 MCO 316 MS 317 MOS 318 MSI 319 MUR 320 MYL 321 NDAQ 322 NOV 323 NAVI 324 NTAP 325 NFLX 326 NWL 327 NFX 328 NEM 329 NWSA 330 NWS 331 NEE 332 NLSN 333 NKE 334 NI 335 NBL 336 JWN 337 NSC 338 NTRS 339 NOC 340 NRG 341 NUE 342 NVDA 343 ORLY 344 OXY 345 OMC 346 OKE 347 ORCL 348 PCAR 349 PH 350 PDCO 351 PAYX 352 PYPL 353 PNR 354 PBCT 355 PEP 356 PKI 357 PRGO 358 PFE Monster Beverage Corp Moody's Corp Morgan Stanley Mosaic Co Motorola Solutions Inc Murphy Oil Corp Mylan N.V. Nasdaq OMX Group National Oilwell Varco Inc Navient NetApp Inc NetFlix Inc Newell Rubbermaid Co. Newfield Exploration Co Newmont Mining Corp News Corp. Class A News Corp. Class B NextEra Energy Inc Nielsen Holdings NIKE Inc B NiSource Inc Noble Energy Inc Nordstrom Inc Norfolk Southern Corp Northern Trust Corp (IL) Northrop Grumman Corp NRG Energy Nucor Corp Nvidia Corp O'Reilly Automotive Occidental Petroleum Omnicom Group ONEOK Inc Oracle Corp PACCAR Inc Parker-Hannifin Corp Patterson Cos Inc Paychex Inc Paypal Pentair Ltd. People's United Financial Inc PepsiCo Inc PerkinElmer Inc Perrigo Co Pfizer Inc 359 PCG 360 PM 361 PSX 362 PNW 363 PXD 364 PBI 365 PNC 366 RL 367 PPG 368 PPL 369 PX 370 PCLN 371 PFG 372 PG 373 PGR 374 PLD 375 PRU 376 PEG 377 PSA 378 PHM 379 PVH 380 QRVO 381 QCOM 382 PWR 383 DGX 384 RRC 385 RTN 386 O 387 RHT 388 REGN 389 RF 390 RSG 391 RAI 392 RHI 393 ROK 394 COL 395 ROP 396 ROST 397 RCL 398 R 399 SPGI 400 CRM 401 SCG 402 SLB 403 SNI PG&E Corporation Philip Morris International Phillips 66 Pinnacle West Capital (AZ) Pioneer Natural Resources Pitney Bowes Inc PNC Finl Services Group Polo Ralph Lauren Corp PPG Industries Inc PPL Corp Praxair Inc Priceline.com Inc Principal Financial Group Procter & Gamble Progressive Corp ProLogis Inc Prudential Financial Inc Public Service Enterprise Inc. Public Storage Pulte Group Inc PVH Corp Qorvo QUALCOMM Inc Quanta Services Inc Quest Diagnostics Range Resources Corp Raytheon Co Realty Income Corporation Red Hat Inc Regeneron Regions Financial Corp Republic Services Inc Reynolds American Inc Robert Half Intl Inc Rockwell Automation Inc Rockwell Collins Roper Industries Inc Ross Stores Inc Royal Carribean Cruises Ltd. Ryder System Inc S&P Global Inc. Salesforce.com SCANA Corp Schlumberger Ltd Scripps Networks Interactive 404 STX 405 SEE 406 SRE 407 SHW 408 SIG 409 SPG 410 SWKS 411 SLG 412 SJM 413 SNA 414 SO 415 LUV 416 SWN 417 SE 418 SWK 419 SPLS 420 SBUX 421 STT 422 SRCL 423 SYK 424 STI 425 SYMC 426 SYF 427 SYY 428 TROW 429 TGT 430 TEL 431 TGNA 432 TDC 433 TSO 434 TXN 435 TXT 436 TMO 437 TIF 438 TWX 439 TJX 440 TMK 441 TSS 442 TSCO 443 TDG 444 RIG 445 TRV 446 TRIP 447 FOXA 448 FOX Seagate Technology Sealed Air Corp Sempra Energy Sherwin-Williams Co Signet Jewelers Simon Property Group Skyworks Solutions Inc. SL Green Realty Smucker J.M. Co Snap On Inc Southern Co Southwest Airlines Co Southwestern Energy Co Spectra Energy Corp Stanley Black & Decker Staples Inc Starbucks Corp State Street Corp Stericycle Inc Stryker Corp SunTrust Banks Inc (GA) Symantec Corp Synchrony Financial Sysco Corp T. Rowe Price Group Inc Target Corp TE Connectivity Ltd. Tegna Teradata Corp Tesoro Petroleum Co. Texas Instruments Inc Textron Inc Thermo Fisher Scientific Tiffany & Co Time Warner Inc TJX Cos Inc Torchmark Corp Total System Services Inc Tractor Supply Company TransDigm Group Transocean Travelers Cos Inc TripAdvisor Inc. Twenty-First Century Fox Class A Twenty-First Century Fox Class B 449 TYC 450 TSN 451 USB 452 UDR 453 ULTA 454 UA 455 UNP 456 UAL 457 UNH 458 UPS 459 URI 460 UTX 461 UHS 462 UNM 463 URBN 464 VFC 465 VLO 466 VAR 467 VTR 468 VRSN 469 VRSK 470 VZ 471 VRTX 472 VIAB 473 V 474 VNO 475 VMC 476 WMT 477 WBA 478 DIS 479 WM 480 WAT 481 WFC 482 HCN 483 WDC 484 WU 485 WY 486 WHR 487 WFM 488 WMB 489 WLTW 490 WEC 491 WYN 492 WYNN 493 XEL Tyco Intl Tyson Foods Inc A U.S. Bancorp UDR Inc. Ulta Salon Cosmetics & Fragrance Under Armour Union Pacific Corp United Continental Holdings United Health Group Inc United Parcel Service Inc B United Rentals United Technologies Corp Universal Health Services Unum Group Urban Outfitters V.F. Corp Valero Energy Corp Varian Medical Systems Inc Ventas Inc VeriSign Inc Verisk Analytics Verizon Communications Inc Vertex Pharmaceuticals Viacom Inc B Visa Inc Vornado Realty Trust Vulcan Materials Co Wal-Mart Stores Walgreens Boots Alliance Walt Disney Co Waste Management Inc Waters Corp Wells Fargo & Co Welltower, Inc. Western Digital Corp Western Union Co Weyerhaeuser Co Whirlpool Corp Whole Foods Market Inc The Williams Companies Inc Willis Towers Watson Wisconsin Energy Corp Wyndham Worldwide Corp Wynn Resorts Ltd Xcel Energy Inc 494 XRX 495 XLNX 496 XL 497 XYL 498 YHOO 499 YUM 500 ZBH 501 ZION 502 ZTS Xerox Corp Xilinx Inc XL Capital Xylem Inc Yahoo Inc Yum! Brands Inc Zimmer Biomet Holdings Zions Bancorp (UT) Zoetis