PRIN.OF CORP.FINANCE-CONNECT ACCESS
13th Edition
ISBN: 2810023360757
Author: BREALEY
Publisher: MCG
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
What is the general problem statement of the leaders lack an understanding and how to address job demands, resulting in an increase in voluntary termination?
Refer to the article of Bank leaders discovered from customer surveys that customers are closing accounts because their rates are not competitive with area credit unions. Job demands such as a heavy workload interfered with employee performance, leading to decreased job performance.
Don't used hand raiting
1
2
Fast
Clipboard
F17
DITECTIONS.
BIU-
Font
B
X
C
A.
fx
=C17+D17-E17
E
F
Merge & Center -
4
$ - % 9
4.0.00
Conditional Format as
.00 9.0
Alignment
Number
Cell
Formatting - Table -
Table Styles -
Styles
Insert Delete Fe
Cells
H
Mario Armando Perez is the kitchen manager at the Asahi Sushi House. Mario's restaurant offers five popular types of sushi roll. Mario keeps
4 careful records of the number of each roll type sold, from which he computes each item's popularity index. For March 1, Mario estimates 150
5 guests will be served.
6
8
9
10
11
04
At the end of the day, Mario also records his actual number sold in order to calculate his carryover amount for the next day.
7 Based on his experience, and to ensure he does not run out of any item, Mario would like to have extra servings (planned overage) of selected
menu items available for sale. Using planned overage, the popularity index of his menu items, and his prior day's carryover information, help
Mario determine the amount of new…
Chapter 9 Solutions
PRIN.OF CORP.FINANCE-CONNECT ACCESS
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
1-1. Define marketing and outline the steps in the marketing process. (AASCB: Communication)
Marketing: An Introduction (13th Edition)
Fundamental and Enhancing Characteristics. Identify whether the following items are fundamental characteristics...
Intermediate Accounting (2nd Edition)
The flowchart for the process at the local car wash. Introduction: Flowchart: A flowchart is a visualrepresenta...
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
E6-14 Using accounting vocabulary
Learning Objective 1, 2
Match the accounting terms with the corresponding d...
Horngren's Accounting (12th Edition)
Real options and its types. Introduction: The net present value is the variation between present cash inflows v...
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
The Warm and Toasty Heating Oil Company used to deliver heating oil by sending trucks that printed out a ticket...
Essentials of MIS (13th Edition)
Knowledge Booster
Similar questions
- Your company is planning to borrow $2.75 million on a 5-year, 16%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Amortization Loan amount $2,750,000 Term in years 5 Annual coupon rate 16.00% Calculation of Loan Payment Formula Loan payment = #N/A Loan Amortization Schedule Year Beginning Balance Payment Interest Principal Ending Balance 1 2 3 4 5 Formulas Loan Amortization Schedule Year Beginning Balance Payment Interest Principal Ending Balance 1 #N/A #N/A #N/A #N/A #N/A 2 #N/A #N/A #N/A #N/A #N/A 3 #N/A…arrow_forwardYour father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $45,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 5%. He currently has $180,000 saved, and he expects to earn 8% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Required annuity payments Retirement income today $45,000 Years to retirement 10 Years of retirement 25 Inflation rate 5.00%…arrow_forwardDon't used hand raitingarrow_forward
- Article: Current Bank Problem Statement The general problem to be surveyed is that leaders lack an understanding of how to address job demands, resulting in an increase in voluntary termination, counterproductive workplace outcomes, and a loss of customers. Bank leaders discovered from customer surveys that customers are closing accounts because their rates are not competitive with area credit unions. Job demands such as a heavy workload interfered with employee performance, leading to decreased job performance. Healthcare employees who felt the organization’s benefits were not competitive were more likely to quit without notice, resulting in retention issues for the organization. Information technology leaders who provide job resources to offset job demand have seen an increase in (a) new accounts, (b) employee productivity, (c) positive workplace culture, and (d) employee retention. The specific problem to be addressed is that IT technology leaders in the information technology…arrow_forwardHow to rewrite the problem statement, correcting the identified errors of the Business Problem Information and the current Bank Problem Statement (for the discussion: Evaluating a Problem Statement)arrow_forwardDon't used hand raiting and don't used Ai solutionarrow_forward
- 3 years ago, you invested $9,200. In 3 years, you expect to have $14,167. If you expect to earn the same annual return after 3 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 $28,798?arrow_forwardPlease Don't use Ai solutionarrow_forwardEnds Feb 2 Discuss and explain in detail the "Purpose of Financial Analysis" as well as the two main way we use Financial Ratios to do this.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
