Principles of Corporate Finance
Principles of Corporate Finance
13th Edition
ISBN: 9781260465099
Author: BREALEY, Richard
Publisher: MCGRAW-HILL HIGHER EDUCATION
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:

Principles of Corporate Finance, Chapter 9, Problem 1SQ , additional homework tip  1

Principles of Corporate Finance, Chapter 9, Problem 1SQ , additional homework tip  2

Excel Workings:

Principles of Corporate Finance, Chapter 9, Problem 1SQ , additional homework tip  3

Principles 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
D. (1) Consider the following cash inflows of a financial product. Given that the market interest rate is 12%, what price would you pay for these cash flows? Year 0 1 2 3 4 Cash Flow 160 170 180 230
Explain why financial institutions generally engage in foreign exchange tradingactivities. Provide specific purposes or motivations behind such activities.
A. In 2008, during the global financial crisis, Lehman Brothers, one of the largest investment banks, collapsed and defaulted on its corporate bonds, causing significant losses for bondholders. This event highlighted several risks that investors in corporate bonds might face. What are the key risks an investor would encounter when investing in corporate bonds? Explain these risks with examples or academic references. [15 Marks]
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