Reference no: EM13953123
An investor puts $15,000 in each of four stocks, labeled A, B, C, and D. The table below contains means and standard deviations of the annual returns of these 4 stocks.
A: Mean = .15 Standard Deviation = .05
B: Mean = .18 Standard Deviation = .07
C: Mean = .14 Standard Deviation = .03
D: Mean = .17 Standard Deviation = .06
1) Assume that the returns of these 4 stocks are independent of each other. Use a spreadsheet to calculate the mean and standard deviation of the total amount that this investor earns in 1 year from these 4 investments as a function of the information in the table.
2) Let "v" denote a market volatility index. The standard deviation of a stock "n" is now v*std dev of n, where std dev is its base volatility level. The volatility index impacts all stocks in the same way.
If v=1 then the std dev of the 4 stocks A, B, C, D are as shown in the table. In general, v can be lower than 1 (low volatility) or higher. For example, if v=1.1, then stock A has volatility 1.1*.05, stock B has volatility 1.1*.07, and so on.
Modify the spreadsheet above to accommodate the possibility of v not equal to 1. Use excel data table (1 dimensional) to check the sensitivity of the portfolio's std dev as a function of v. Vary v from .05 to 1.5 in .05 increments.
|
The probabilty that harry scored exactly 15 goals
: For events A and B, Pr(A intersection B) = p, Pr(A' intersection B) = P - 1/8 and Pr(A intersection B') = 3p/5. If A and B are independent, then the value of p is ___.
|
|
Problem-you won the lottery
: Problem: You Won the Lottery You have won a lottery! You will receive $200,000, after taxes, each year for the next five years.
|
|
Calculate odds ratio associated with decrease in ingestion
: The primary factors being investigated were vitamins A and E (measured in international units per month). Data for 1500 women over 54 years of age are given in Table E1.19. Calculate the odds ratio associated with a decrease (exposure is low consu..
|
|
Prepare your suggestion report on the ground of hih case
: You are required to prepare your suggestion report on the ground of HIH case to ensure that such a collapse cannot happen again if the organization systematically maintain and implement internal control procedure.
|
|
Means and standard deviations of the annual returns
: Modify the spreadsheet above to accommodate the possibility of v not equal to 1. Use excel data table (1 dimensional) to check the sensitivity of the portfolio's std dev as a function of v. Vary v from .05 to 1.5 in .05 increments.
|
|
Provide a brief explanation of the elements
: Read "A & P" p. 148 "Trifles" p. 1125. Pick one of these stories for the assignment. Using the "Elements of Fiction in "Story of an Hour" (below) as a model, you will provide a brief explanation of the elements listed below for the story you ch..
|
|
Calculate the percent of total deaths from each cause
: Calculate the percent of total deaths from each cause, and display the results in a pie chart. From the death rate (per 100,000 population) for heart disease, calculate the population for Minnesota for the year 1991.
|
|
Accounting principles and assumptions
: Genesis Corporation is now in its 30th year of business. The founder of the company is planning to retire at the end of the year and turn the business over to his daughter.
|
|
Calculate sensitivity and specificity of x-ray
: Calculate the sensitivity and specificity of x-ray as a screening test for tuberculosis.
|