EBK PRINCIPLES OF CORPORATE FINANCE
12th Edition
ISBN: 9781259358487
Author: BREALEY
Publisher: MCGRAW HILL BOOK COMPANY
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 9, Problem 1SQ
(VAR.P and STDEV.P) Choose two well-known stocks and download the latest 61 months of adjusted prices from finance.yahoo.com. Calculate the monthly returns for each stock. Now find the variance and standard deviation of the returns for each stock by using VAR.P and STDEV.P. Annualize the variance by multiplying by 12 and the standard deviation by multiplying by the square root of 12.
Expert Solution & Answer
Summary Introduction
To determine: The variance and standard deviation of two stocks.
Answer to Problem 1SQ
Company AL’s variance is 0.0008497 and standard deviation is 2.91%. Company NX’s variance is 0.0014812 and standard deviation is 3.85%.
Explanation of Solution
Determine the variance and standard deviation of Company AL
Excel Spreadsheet:
Excel Workings:
Therefore the Company AL’s variance is 0.0008497 and standard deviation is 2.91%. Company NX’s variance is 0.0014812 and standard deviation is 3.85%.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
The last four years of returns for a stock are as shown here: E
a. What is the average annual return?
b. What is the variance of the stock's returns?
c. What is the standard deviation of the stock's returns?
Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format.
.....
Data table
(Click on the icon located on the top-right corner of the data table below in order to
copy its contents into a spreadsheet.)
Year
1
2
3
4
Return
- 4.3%
+ 27.9%
+ 12.3%
+ 3.6%
he last four years of returns for a stock are as shown here:
LOADING...
.
a. What is the average annual return?
b. What is the variance of the stock's returns?
c. What is the standard deviation of the stock's returns?
Note:
Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format.
Question content area bottom
Part 1
a. What is the average annual return?
The average return is
enter your response here%.
(Round to two decimal places.)
Part 2
b. What is the variance of the stock's returns?
The variance of the returns is
enter your response here.
(Round to five decimal places.)
Part 3
c. What is the standard deviation of the stock's returns?
The standard deviation is
enter your response here%.
(Round to two decimal places.)
Time Remaining: 00:26:16
pop-up content starts
Data table
(Click on the following icon
in order…
Here are the percentage returns on two stocks.
Digital
Executive
Fruit
Cheese
14%
4%
Month
January
February
March
April
May
June
July
August
6
8
Variance
Standard deviation %
Digital Cheese
2
4
14
a-1. Calculate the monthly variance and standard deviation of each stock. (Do not round intermediate calculations. Round your
answers to 1 decimal places.)
-3
47.5
69X
Executive Fruit
23 2
4.8 X
Chapter 9 Solutions
EBK PRINCIPLES OF CORPORATE FINANCE
Ch. 9 - (VAR.P and STDEV.P) Choose two well-known stocks...Ch. 9 - (AVERAGE, VAR.P and STDEV.P) Now calculate the...Ch. 9 - (SLOPE) Download the Standard Poors index for the...Ch. 9 - Definitions Define the following terms: a. Cost of...Ch. 9 - True/false True or false? a. The company cost of...Ch. 9 - Company cost of capital Quark Productions (Give...Ch. 9 - Company cost of capital The total market value of...Ch. 9 - Company cost of capital You are given the...Ch. 9 - Company cost of capital Nero Violins has the...Ch. 9 - WACC A company is 40% financed by risk-free debt....
Ch. 9 - WACC Binomial Tree Farms financing includes 5...Ch. 9 - Prob. 10PSCh. 9 - Measuring risk The following table shows estimates...Ch. 9 - Prob. 12PSCh. 9 - Asset betas Which of these projects is likely to...Ch. 9 - Asset betas EZCUBE Corp. is 50% financed with...Ch. 9 - Prob. 15PSCh. 9 - Prob. 16PSCh. 9 - Prob. 17PSCh. 9 - Fudge factors John Barleycorn estimates his firms...Ch. 9 - Prob. 19PSCh. 9 - Prob. 20PSCh. 9 - Certainty equivalents A project has a forecasted...Ch. 9 - Certainty equivalents A project has the following...Ch. 9 - Prob. 23PSCh. 9 - Beta of costs Suppose that you are valuing a...Ch. 9 - Fudge factors An oil company executive is...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Problems encountered while comparing companies based on the ratios. Introduction: Ratio establishes the relatio...
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Whether callable bonds have a higher or lower yield than otherwise identical bonds without a call feature. Intr...
Corporate Finance (4th Edition) (Pearson Series in Finance) - Standalone book
The value of the shareholders equity account of a firm. Introduction: Shareholders’ equity refers to the residu...
Corporate Finance (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
CHAPTER CASE
S&S Air’s Mortgage
Mark Sexton and Todd Story, the owners of S&S Air, Inc., were impressed by the ...
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
The current stock price. Introduction: Stock price is a price of a share on the number of saleable stock of a c...
Fundamentals of Corporate Finance
Knowledge Booster
Similar questions
- Here are the returns on two stocks. A. Calculate the variance and standard deviation of each stock. Which stock is riskier if he'll on its own? B. Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks C. Is the variance more or less than halfway between the variance of the two Individual stocks?arrow_forwardThe last four years of returns for a stock are as shown here: a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format.arrow_forwardThe last four years of returns for a stock are as shown here: LOADING... . a. What is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format. Question content area bottom Part 1 a. What is the average annual return? The average return is enter your response here%. (Round to two decimal places.) Part 2 b. What is the variance of the stock's returns? The variance of the returns is enter your response here. (Round to five decimal places.) Part 3 c. What is the standard deviation of the stock's returns? The standard deviation is enter your response here%. (Round to two decimal places.) figure Year: 1, 2, 3, 4 Return: -4.2%, +27.9%, +11.8%, +3.8%arrow_forward
- Attached in images are the returns on two stocks: a. Calculate the variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Digital Cheese Return Executive Fruit Return Variance: Standard Deviation: b. Which stock is riskier if held on its own? Digital Cheese or Executive Fruit c. Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Jan. Feb. March April May June July August d. Is the variance more or less than halfway between the variance of the two individual stocks?arrow_forwardThe following shows the expected percentage returns on three stocks over the next six years:Stock Percentage Return (%)Year 1 2 3 4 5 6A 10 5 6 8 12 15B 8 4 4. 80 6.4 9.6 12C 5 10 12 10 6 6 Required:(i) Find the expected return for each of the stock.(ii) Compute the variance and standard deviation for stock A, B and C. Show your working.(iii) Justify how can you minimize the risk of the above combination of stocks. (Must show working method as well)arrow_forwardThe following shows the expected percentage returns on three stocks over the next six years: Stock Percentage Return (%) Year 1 2 3 4 5 6 A 10 5 6 8 12 15 B 8 4 4.8 6.4 9.6 12 C 5 10 12 10 6 6 Required: i Find the expected return for each of the stock. ii Compute the variance and standard deviation for stock A, B and C. Show your working. iii Justify how can you minimize the risk of the above combination of stocks.arrow_forward
- The following table reports the percentage of stocks in a portfolio for nine quarters: a. Construct a time series plot. What type of pattern exists in the data? b. Use trial and error to find a value of the exponential smoothing coefficient that results in a relatively small MSE. c. Using the exponential smoothing model you developed in part (b), what is the forecast of the percentage of stocks in a typical portfolio for the second quarter of year 3?arrow_forwardAn analyst gathered daily stock returns for Feburary 1 through March 31, calculated the Fama-French factors for each day in the sample (SMBt and HMLt), and estimated the Fama-French regression model shown in Equation 6-21. The estimated coefficients were ai = 0, bi = 1.2, ci = 0.4, and di = 1.3. On April 1, the market return was 10%, the return on the SMB portfolio (rSMB) was 3.2%, and the return on the HML portfolio (rHML) was 4.8%. Using the estimated model, what was the stocks predicted return for April 1?arrow_forwardThe following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period. Month Madison Cookies Sophie Electric 1 -0.04 0.07 2 0.06 -0.02 3 -0.07 -0.10 4 0.12 0.15 5 -0.02 -0.06 6 0.05 0.02 Compute the following: a. Average monthly rate of return, Ri, for each stock b. Standard deviation of returns for each stock c. Covariance between the rates of return d. The correlation coefficient between the rates of return What level of correlation would you have expected before performing your calculations? How did your expectations compare with the computed correlation? Would these two stocks be good choices for diversification? Why or why not?arrow_forward
- Suppose the index model for stocks A and B is estimated with the following results: rA = 2% + 0.8RM + eA, rB = 2% + 1.2RM + eB, σM = 20%, and RM = rM − rf . The regression R2 of stocks A and B is 0.40 and 0.30, respectively. Answer the following questions. Total: (a) What is the variance of each stock? (b) What is the firm-specific risk of each stock? (c) What is the covariance between the two stocks?arrow_forwardWhat is the average annual return? b. What is the variance of the stock's returns? c. What is the standard deviation of the stock's returns? Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format. Year 1 2 3 4 Return (%) Year1: -4.1% Year2: 27.6% Year 3: 12.3% Year 4: 3.6%arrow_forwardHere are the returns on two stocks. January February March April May June July August Digital Cheese +14 -4 44449 +6 +8 -5 +4 -3 -9 Executive Fruit +8 +2 +5 +12 3643 +3 +6 -4 -3 Required: a-1. Calculate the variance and standard deviation of each stock. a-2. Which stock is riskier if held on its own? b. Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks. c. Is the variance more or less than halfway between the variance of the two individual stocks?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning