Calculate the monthly returns for each stock

Assignment Help Financial Accounting

Reference no: EM133206723

Assignment - Return and Risk Statistics Over 5 Years Project

Description - 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:

-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

Reference no: EM133206723

Questions Cloud

What is at least one strength of the study : What is at least one strength of the study? What is at least one weakness of the study? Explain or defend each point.

Conduct risk analysis : Conduct risk analysis in accordance with the Australian Auto Parts and Supply Risk Management's Plan and legal requirements by using a provided template

Explain adjusting of the income statement : Earnings are extremely important to a publicly traded company and the creditors and investors of that company. Explain adjusting of the income statement

Describe the importance for your future as an aprn : Describe the importance for your future as an APRN in the primary care setting to use and manage the levels of prevention appropriately in your practice.

Calculate the monthly returns for each stock : Use Yahoo! Finance or another site to get monthly pricing for the S&P 500 ETF (SPY), Coca-Cola, and Netflix. Calculate the monthly returns for each stock

Why is a colony not a state : What are the differences between a state, a nation, and a nation-state? Why is a colony not a state?

What is more important to the overall success : What is more important to the overall success of an organization - employee satisfaction, or, employee engagement. How do you define one

Examine the consequences of an unethical behaviors : Examine the consequences of an unethical behaviors in a nursing Master's program and in the nursing practice by providing one example for each.

Discuss best evidence for a healthcare challenge multimedia : HSC 243 university of lagos Nigeria. Discuss the Best Evidence for a Healthcare Challenge multimedia simulation and readings and construct a PICO (T) question.

User Account

All Pages