Two

You will have to submit two different files 1 Excel page, and 1 Word document page.

Assignment Description

The Investment Policy Committee of your firm is considering adding International Securities to their groups of portfolios. They have requested that you, as a Financial Analyst perform some research to aid them in the decision-making process. Specifically the committee would like to see some comparisons of returns, and other relevant portfolio theory statistical data of domestic stocks with international stocks. They would also like to read a report of your recommendations with regard to your findings.

Deliverables:

Visit this finance Web site, and select two Large Cap Growth stocks. Select 1 company where the stock primarily trades in the US domestic financial markets, and select another that is an International Company that primarily conducts business outside of the US borders. Obtain the last 10 months of closing stock prices, and then compute one average price for each month.

Using the average price data, create an Excel file and use the appropriate Excel functions to determine the average return, standard deviation, variance, and correlation for the two stocks for the last 10 months.

Create a Word document using APA Style and discuss each of these financial metrics, and interpret your results. Also consider potential currency risks as part of your discussion.

Reference

Yahoo! finance. (n.d.). Retrieved from http://finance.yahoo.com/

Please submit your assignment.

Your assignment will be graded in accordance with the following criteria. Click here to view the grading rubric.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Reading Assignment

Melicher, R. and Norton, A., 10-12

Assignment Objectives

Explain the role of exchange rates and the world economy as well as financial exchange derivatives.