This activity will help you gather and analyze data relating to returns and standard deviations.
Use Yahoo! Finance or another site to get monthly pricing for the S&P 500 ETF (SPY), Coca-Cola, and Netflix for the past five years. Then, calculate the following using Excel and the provided instructions PDF:
- Monthly returns for each stock
- Average monthly return for each stock
- Annualized returns based on the monthly average return for each stock
- Standard deviation of monthly returns for each stock
- Annualized standard deviation based on standard deviation of monthly returns
Compare the differences in returns and standard deviations in the three sets of data, and discuss their investment implications using a cell within the spreadsheet document.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
