Question

I have been given historical closing prices from 01/01/2014 to 01/01/2019 for five different stocks. Please...

I have been given historical closing prices from 01/01/2014 to 01/01/2019 for five different stocks. Please explain how I can estimate expected returns and volatility from the 5-year time series.

Homework Answers

Answer #1

I assume that the returns given during the period are monthly returns, for the purpose of explanation.

1. The expected return for a particular month = (return during this month / return during the previous month) - 1

2. To calculate the volatility use the excel function stddev.s(select all the cells that contain the return)

To annualize the volatility multiply the above number by sqrt(12). If the returns were daily, multiply by sqrt(252).

Can you please upvote? Thank You :-)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
I have an excel spreadsheet with a list of stocks and their adjusted closing prices from...
I have an excel spreadsheet with a list of stocks and their adjusted closing prices from 1/1/2014 to 1/1/2019. Assuming I create a portfolio of $10M that is equally weighted, please walk me through how to calculate the five year total return of the portfolio. Also, please explain how I can calculate the volatility (sigma squared) during the time frame.
Returns earned over a given time period are called realized returns. Historical data on realized returns...
Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock. Consider the case of Blue Llama Mining Inc. (BLM): Five years of realized returns for BLM are given in the following table. Remember: 1. While BLM was started 40 years ago, its common stock has been publicly traded for the past 25 years....
3. Measuring stand-alone risk using realized (historical) data Returns earned over a given time period are...
3. Measuring stand-alone risk using realized (historical) data Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock. Consider the case of Blue Llama Mining Inc. (BLM): Five years of realized returns for BLM are given in the following table. Remember: 1. While BLM was started 40 years ago, its common stock has...
3. Measuring stand-alone risk using realized (historical) data Returns earned over a given time period are...
3. Measuring stand-alone risk using realized (historical) data Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock. Consider the case of Celestial Crane Cosmetics Inc. (CCC): Five years of realized returns for CCC are given in the following table. Remember: 1. While CCC was started 40 years ago, its common stock has...
Measuring stand-alone risk using realized (historical) data Returns earned over a given time period are called...
Measuring stand-alone risk using realized (historical) data Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock. Consider the case of Happy Dog Soap Inc. (HDS): Five years of realized returns for HDS are given in the following table. Remember: 1. While HDS was started 40 years ago, its common stock has been...
Answer the following questions given the following call option prices on Google (GOOG) and on Apple...
Answer the following questions given the following call option prices on Google (GOOG) and on Apple (APPL). Note that these are actual option prices on 2/21/13 and these contracts have 60 days till expiration. The 2-month T-bill rate is about 4.75%. Attach all work with your report. OPTION STRIKE EXP VOL LAST GOOG 800 APR 378 28.20 S=795.53 690 APRI 53 101.57 APPL 450 APR 530 18.55 S=446.06 480 APR 856 7.81 Part One Estimate the theoretical option values for...
4. Statistical measures of standalone risk Remember, the expected value of a probability distribution is a...
4. Statistical measures of standalone risk Remember, the expected value of a probability distribution is a statistical measure of the average (mean) value expected to occur during all possible circumstances. To compute an asset’s expected return under a range of possible circumstances (or states of nature), multiply the anticipated return expected to result during each state of nature by its probability of occurrence. Consider the following case: James owns a two-stock portfolio that invests in Blue Llama Mining Company (BLM)...
4. Measuring standalone risk using realized data Returns earned over a given time period are called...
4. Measuring standalone risk using realized data Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock. Five years of realized returns for Falcon Freight Inc. (Falcon) are given in the following table: 2012 2013 2014 2015 2016 Stock return 6.25% 4.25% 7.50% 10.50% 3.25% Also note that: 1. While Falcon was started...
SOME DRAWBACK OF BLACK-SCHOLES Briefly discuss here some difficulties associated with the Black Scholes formula, which...
SOME DRAWBACK OF BLACK-SCHOLES Briefly discuss here some difficulties associated with the Black Scholes formula, which is widely used to calculate the price of an option. For example, consider a European call option for a stock. This is the right to buy a specific number of shares of a specific stock on a specific date in the future, at a specific price (the exercise price, also called the strike price). If all these quantities are fixed, the question becomes: what...
You are part of the operational budgeting team at Global Bike U.S. (GB). You have been...
You are part of the operational budgeting team at Global Bike U.S. (GB). You have been asked to assist the production manager in budgeting for the following fiscal year. One estimate that has been troubling you is that of the cost of equipment maintenance. You have historical data that provide you with estimates of Repair Time (in hours), Time Between Repairs (in days), Cost of Labor (per hour fully burdened), Cost of Parts (per Repair), and Expected Life of Asset...