Securities Analysis and Portfolio Management

the word document is the hw, it has two questions. the seccond question will need more data, which is in other two excel files