Bottom-up Betas Assignment-

Nike, which currently views itself as operating in the sporting wear (shoes and clothes) segment, is considering an expansion into the fashion apparel business, producing highpriced casual clothing for teenagers and young adults.

In this assignment, you will estimate a bottom-up, unlevered beta for investments in the apparel industry. Submit a spreadsheet in which you do the calculations. Clearly indicate your answer. (A minimum requirement for this assignment is that I can tell what you did.)

Attached is data for the 58 publicly-traded U.S. companies who identify themselves as being in the apparel industry. Use this data as the basis of your analysis.

Attachment:- Data.rar