PRIN.OF CORP.FINANCE-CONNECT ACCESS
PRIN.OF CORP.FINANCE-CONNECT ACCESS
13th Edition
ISBN: 2810023360757
Author: BREALEY
Publisher: MCG
Textbook Question
Book Icon
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
Check Mark
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:

PRIN.OF CORP.FINANCE-CONNECT ACCESS, Chapter 9, Problem 1SQ , additional homework tip  1

PRIN.OF CORP.FINANCE-CONNECT ACCESS, Chapter 9, Problem 1SQ , additional homework tip  2

Excel Workings:

PRIN.OF CORP.FINANCE-CONNECT ACCESS, Chapter 9, Problem 1SQ , additional homework tip  3

PRIN.OF CORP.FINANCE-CONNECT ACCESS, Chapter 9, Problem 1SQ , additional homework tip  4

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
Please help follow these guidelines pertaining to market audit amd competitive market analysis. With the super market name PUEBLO in St. Thomas U S Virgin Islands.
A company currently pays a dividend of $3.6 per share (D0 = $3.6). It is estimated that the company's dividend will grow at a rate of 19% per year for the next 2 years, and then at a constant rate of 6% thereafter. The company's stock has a beta of 1.4, the risk-free rate is 8.5%, and the market risk premium is 4.5%. What is your estimate of the stock's current price? Do not round intermediate calculations. Round your answer to the nearest cent.
I have attatched two related pictures to calculate a value of a compay using a DCF model. Please show how to get residual value like in the picture shown.
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage