PRIN.OF CORPORATE FINANCE
PRIN.OF CORPORATE FINANCE
13th Edition
ISBN: 9781260013900
Author: BREALEY
Publisher: RENT 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 CORPORATE FINANCE, Chapter 9, Problem 1SQ , additional homework tip  1

PRIN.OF CORPORATE FINANCE, Chapter 9, Problem 1SQ , additional homework tip  2

Excel Workings:

PRIN.OF CORPORATE FINANCE, Chapter 9, Problem 1SQ , additional homework tip  3

PRIN.OF CORPORATE FINANCE, 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 don't use Ai solution
ng Equipment is worth $998,454. It is expected to produce regular cash flows of $78,377 per year for 20 years and a special cash flow of $34,800 in 20 years. The cost of capital is X percent per year and the first regular cash flow will be produced in 1 year. What is X? Input instructions: Input your answer as the number that appears before the percentage sign. For example, enter 9.86 for 9.86% (do not enter .0986 or 9.86%). Round your answer to at least 2 decimal places. percent
3 years ago, you invested $6,700. In 5 years, you expect to have $12,201. If you expect to earn the same annual return after 5 years from today as the annual return implied from the past and expected values given in the problem, then in how many years from today do you expect to have $25,254?
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