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 the Finance
website and select two Large Cap Growth stocks. Select one 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.

TheInvestment 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

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 the Finance
website and select two Large Cap Growth stocks. Select one 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.

TheInvestment 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