Project Description .pdf

Excel Template for Part 1, Some of the Spreadsheet fails to function (Regression and Printing) when placed on the web.  For the Regrssion, note the y range for the regression is D3:D63, the x range is E3:E63, check the Label box, and check the Output Range box and give the location a A72.  Your will also need to adjust the Print Output range to A65:I91.

Cost of Capital Worksheet

Ticker Symbols for Fall 2011,  Last Date to Change companies is October 27.  Only one person per company.  First come, first serve.

AIR(=R Scarbrough) ANCX ACU(=C Jackson) ALE AM(=D Barrett) AMN ANH AIT(=J Ennis) ARJ AGII AROW ATNI(=H McFarland) AVA(=B Blanchard) AZZ BBSI(=I Aiken) BWS(=S Zhang) BGFV(=C Lu) BOBE(=N Vogt) CALM(=J Scott) CATO(=K Barnett) CEC JVA COHU CMTL CNSL CPA(=I Feather) CJREF CPY(=Y Chen) CBRL(=A Holland) CTS DDIC DGAS(=T Hice) DIIBF DCO DLX ELNK ENH EBF EVOL(=L Lyons) FHCO THFF FMER FRS FRO FUL GKSR EGAS(=J Wong) GLT(=J Gao) ASR HGIC HTLF HMN IDA MAIL LG(=Z Ding and C Sun) LINC TAXI MDP(=J Smith) MGEE(=Y Zhang) MCRL(=B Mattox) NC NAFC(=F Teng) NATL NPK(=S Ju) NM NNI NWN(=C Herring) NEW NUS(=B Wright) MKSI ORRF PDLI(=R Acquesta) PETS(=B Adams) RSH(=A Alley) RWT RLRN RNST RSO RLI SGK(J Bass) SHLM SWM(=R Spikes) SPTN(=M Paintin) SCL(=T He) STRA(=J Ren) TSH TESS(=H McFarland) THO(=K Holland and Z Zou) TWGP TRMK UNS UNTD(=R Burns) USTR(=M McCloud) UVV(=T Liu) UVSP WWE(=H Hu) ABVT ABAT(=D Stephens) AES AOB AMSF ANDE AP(=Z He) APAC ATSG BCPC(=Y Zou) CE CQB CBB(=F Mao) CORE GLW DO DOLE DST EXC FCX(=J Kendrick) GLBL HTCO IPSU(=Y Luo) KALU LLY(=J Singleterry) MFW MIR NAVG NTY NEU(=R Zhang) NL NWPX OSG(=J Deng) PDLI PLPC PRIM PEG(=K Flood) QKLS RINO SATS SB SNTS SRE SKYW(=Q Fan) STEC STRL SUNH SNX TRK(=R Lytten) VSEC WLP(=J Xiao) WDFL

Note, not all companies on this list have all of the required information. You need at least five years of stock data.  You should avoid banks, finance companies, and insurance companies. If your company is missing information, you must either change companies or possibly receive a lower grade on the report. The first person to choose a company receives the company. Only 1 person may choose each company.