Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
12th Edition
ISBN: 9781259144387
Author: Richard A Brealey, Stewart C Myers, Franklin Allen
Publisher: McGraw-Hill 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 (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate), Chapter 9, Problem 1SQ , additional homework tip  1

Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate), Chapter 9, Problem 1SQ , additional homework tip  2

Excel Workings:

Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate), Chapter 9, Problem 1SQ , additional homework tip  3

Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate), 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
1. Give one new distribution channels for Virtual Assistance (freelance business) that is not commonly used.   - show a chart/diagram to illustrate the flow of the distribution channels.   - explain the rationale behind it. (e.g., increased market reach, improved customer experience, cost-efficiency).   - connect the given distribution channel to the marketing mix: (How does it align with the overall marketing strategy? Consider product, price, promotion, and place.).    - define the target audience: (Age, gender, location, interests, etc.).    - lastly, identify potential participants: (Wholesalers, retailers, online platforms, etc.)
An individual is planning for retirement and aims to withdraw $100,000 at the beginning of each year, starting from the first year of retirement, for an expected retirement period of 20 years. To fund this retirement plan, he intends to make 20 equal annual deposits at the end of each year during his working years. Assume a simple annual interest rate of 20% during his working years and a simple annual interest rate of 5% during retirement. What should his annual deposit amount be to achieve his desired retirement withdrawals? Please write down the steps of your calculation and explain result economic meaning.
Assume an investor buys a share of stock for $18 at t=0 and at the end of the next year (t=1), he buys 12 shares with a unit price of $9 per share. At the end of Year 2 (t=2), the investor sells all shares for $40 per share. At the end of each year in the holding period, the stock paid a $5.00 per share dividend. What is the annual time-weighted rate of return? Please write down the steps of your calculation and explain result economic meaning.
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