Concept explainers
Using the data shown in the table below that contains historical monthly prices and dividends (paid at the end of themonth) for Ford Motor Company stock (Ticker: F) from August 1994 to August 1998, compute the:
a. Average monthly return over this period is --%. (Round to two decimal places.)
b. Monthly volatility (or standard deviation) over this period. (Round to two decimal places.)
c. compute 95% confidence interval of the estimate of the average monthly return.
Date Stock Price Dividend Return 1+Rt
Aug-94 $29.250 $0.000
Sep-94 $27.750 $0.000 -5.13% 0.949
Oct-94 $29.500 $0.260 7.24% 1.072
Nov-94 $27.125 $0.000 -8.05% 0.919
Dec-94 $27.875 $0.000 2.76% 1.028
Jan-95 $25.250 $0.260 -8.48% 0.915
Feb-95 $26.125 $0.000 3.47% 1.035
Mar-95 $26.875 $0.000 2.87% 1.029
Apr-95 $27.125 $0.310 2.08% 1.021
May-95 $29.250 $0.000 7.83% 1.078
Jun-95 $29.750 $0.000 1.71% 1.017
Jul-95 $29.000 $0.310 -1.48% 0.985
Aug-95 $30.750 $0.000 6.03% 1.06
Sep-95 $31.125 $0.000 1.22% 1.012
Oct-95 $28.750 $0.350 -6.51% 0.935
Nov-95 $28.250 $0.000 -1.74% 0.983
Dec-95 $28.875 $0.000 2.21% 1.022
Jan-96 $29.500 $0.350 3.38% 1.034
Feb-96 $31.250 $0.000 5.93% 1.059
Mar-96 $34.375 $0.000 10.00% 1.1
Apr-96 $35.875 $0.350 5.38% 1.054
May-96 $36.500 $0.000 1.74% 1.017
Jun-96 $32.375 $0.000 -11.30% 0.887
Jul-96 $32.375 $0.385 1.19% 1.012
Aug-96 $33.500 $0.000 3.47% 1.035
Sep-96 $31.250 $0.000 -6.72% 0.933
Oct-96 $31.250 $0.385 1.23% 1.012
Nov-96 $32.750 $0.000 4.80% 1.048
Dec-96 $32.250 $0.000 -1.53% 0.985
Jan-97 $32.125 $0.385 0.81% 1.008
Feb-97 $32.875 $0.000 2.33% 1.023
Mar-97 $31.375 $0.000 -4.56% 0.954
Apr-97 $34.750 $0.420 12.10% 1.121
May-97 $37.500 $0.000 7.91% 1.079
Jun-97 $38.000 $0.000 1.33% 1.013
Jul-97 $40.875 $0.420 8.67% 1.087
Aug-97 $43.000 $0.000 5.20% 1.052
Sep-97 $45.125 $0.000 4.94% 1.049
Oct-97 $43.688 $0.420 -2.25% 0.977
Nov-97 $43.000 $0.000 -1.57% 0.984
Dec-97 $48.563 $0.000 12.94% 1.129
Jan-98 $51.000 $0.420 5.88% 1.059
Feb-98 $56.563 $0.000 10.91% 1.109
Mar-98 $64.813 $0.000 14.59% 1.146
Apr-98 $45.813 $23.680 7.22% 1.072
May-98 $51.875 $0.000 13.23% 1.132
Jun-98 $59.000 $0.000 13.73% 1.137
Jul-98 $57.000 $0.420 -2.68% 0.973
Aug-98 $44.625 $0.000 -21.71% 0.783
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 5 images
- On March 9, 2009, the Dow Jones Industrial Average reached a new low at a close of 6,847.20, which was down 86.04 that day.What was the return (in percent) of the stock market that day? (Negative answer should be indicated by a minus sign. Round your answer to 2 decimal places.) Return of Stock Market : _____.__%arrow_forwardThe following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet.) Month January February March April May June July August September October November December The average monthly return for Cola Co. is%. (Round to two decimal places.) Cola Co. - 6.80% 7.40% -2.10% 4.30% 11.30% 1.40% 4.10% - 0.60% 0.80% 1.90% 0.70% - 2.90% Gas Co. - 3.00% - 7.70% 0.20% 3.10% - 1.00% 0.00% 4.80% - 3.80% - 5.80% 1.20% - 2.30% 4.70%arrow_forwardYou’ve observed the following returns on Pine Computer’s stock over the past five years: 13 percent, −13 percent, 20 percent, 25 percent, and 10 percent. a. What was the arithmetic average return on the company’s stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b-1. What was the variance of the company’s returns over this period? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .16161.) b-2. What was the standard deviation of the company’s returns over this period? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Average return % b-1. Variance b-2. Standard deviation %arrow_forward
- (Related to Checkpoint 7.2) (Calculating the geometric and arithmetic average rate of return) Marsh Inc. had the following end-of-year stock prices over the last five years and paid no cash dividends Time 2 Marsh $10 10 20 4 5 10 (Click on the icon in order to copy its contents into a spreadsheet) 7 a Calculate the annual rate of return for each year from the above information. b. What is the arithmetic average rate of retum earned by investing in Marsh's stock over this period? C. What is the geometric average rate of return earned by investing in Marsh's stock over this period? d. Considering the beginning and ending stock prices for the five-year period are the same, which type of average rate of return (the arithmetic or geometric) better describes the average annual rate of return earned over the period? a. The annual rate of return at the end of year 2 is%. (Round to two decimal places.) GILEarrow_forwardSunset Corporation currently has an EPS of $2.38, and the benchmark PE for the company is 17. Earnings are expected to grow at 7.5 percent per year. a. What is your estimate of the current stock price? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. What is the target stock price in one year? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. Assuming the company pays no dividends, what is the implied return on the company's stock over the next year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.2. a. Stock price today b. Stock price in one year c. Implied returnarrow_forwardHistorical nominal returns for Company A have been 8% and -20%. The nominal returns for the market index S&P500 over the same periods were -15% and 28%. Calculate the beta for Company A. Please include equations used. Thanksarrow_forward
- The average annual return on the S&P 500 Index from 1996 to 2005 was 13.27 percent. The average annual T-bill yield during the same period was 3.92 percent. What was the market risk premium during these ten years? (Round your answer to 2 decimal places.)arrow_forwardA company's stock price rose 2.8% in 2011, and in 2012, it increased 79.7%.a. Compute the geometric mean rate of return for the two-year period 2011-2012. (Hint: Denote an increase of 79.7% by .797.)b. If someone purchased $1,000 of the company's stock at the start of 2011, what was its value at the end of 2012?c. Over the same period, another company had a geometric mean rate of return of 10.7%. If someone purchased $1,000 of the other company's stock, how would its value compare to the value found in part (b)?arrow_forwardMeadow Dew Corporation currently has an EPS of $4.00, and the benchmark PE for the company is 39. Earnings are expected to grow at 5 percent per year. a. What is your estimate of the current stock price? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the target stock price in one year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. Assuming the company pays no dividends, what is the implied return on the company's stock over the next year? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) a. Current stock price b. Target stock price c. Implied return of stock %arrow_forward
- Gee-Gee common stock returned a nifty 21.77 percent rate of return last year. The dividend amount was $1.96 a share which equated to a dividend yield of 2.05 percent. What was the rate of price appreciation for the year? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forwardThe following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet.) Month January February March April May June July August September October November The average monthly return for Cola Co. is%. (Round to two decimal places.) Cola Co. -7.10% -2.10% -3.80% -4.10% 1.50% 1.20% -21.10% - 14.50% - 28.80% 22.90% -13.40% Gas Co. -8.10% -2.00% -2.60% -5.00% -4.70% -3.20% 6.70% -8.50% - 12.60% 16.50% -6.10%arrow_forwardThe CWI for common stocks (S&P 500) for 1926-2010 (85 years) was $5364.78 based on a geometric mean of 9.6% for that period. The average dividend yield for those 85 years was 5.99 %. a) Calculate the CDY b) Calculate cumulative price changearrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education