FIN 340 Module Two Activity Guidelines and Rubric

Overview

This activity will help you gather and analyze data about returns and standard deviations.

Prompt

Use Morningstar and the Module Two Activity Instructions to complete this activity.

Specifically, the following critical elements must be addressed:

1. Calculate the standard deviation for the 10-year period for the S&P 500 ETF SPY, Coca-Cola, and Netflix. Support each calculation by showing the work involved.
2. Calculate the annualized return for the 10-year period. Support each calculation by showing the work involved.
3. Compare the differences in returns and standard deviations of the three sets of data. Based on your analysis, explain which one of the three investment products you would choose to invest in and why.

What to Submit

You must submit a completed Excel spreadsheet that fulfills the requirements outlined in the Module Two Activity Instructions document.