Find the total return over the 36-month period

Assignment Help Other Subject
Reference no: EM131232026

The following table (Table 1) represents CLOSING prices for America Online (AOL), Anheuser Busch (BUD), Coca-Cola (KO), and TransWorld Airlines (TWA). Assume the return on a Treasury Bill is 4% per year (.33% per month). Clearly indicate your answers by underlining or putting them in a box.

The data in Tables 1 and 2 can be downloaded in spreadsheet form from the class Blackboard site.

1. (a) Calculate the MONTHLY returns for each asset (AOL, BUD, KO, TWA).

(b) Calculate the variance and standard deviation of RETURNS for each asset (AOL, BUD, KO, TWA) over the 36-month period from 7/96-6/99.

(c) Comment on the difference between expected return and realized return.

(d) Find the total return over the 36-month period for each stock. Which stock had the highest and lowest returns? Was this expected? Are these results consistent with the general risk-return relationship?

(e) Are these the actual closing prices or prices adjusted for changes in capitalization, i.e. stock splits, etc.? How do you know?

2. (a) Calculate the COVARIANCE and CORRELATION matrix for all pairs. Display your answers in a 4x4 table.

(b) Verify that covariance between the asset and itself is equal to its variance (there may be some rounding error).

(c) Verify that the correlation between all pairs of assets falls in the range [-1,1]. Verify that the correlation with an asset and itself is 1.

(d) Do all assets move together? Interpret your results.

3. Graph the Capital Allocation Line for BUD and the risk-free asset. Extend the line past the 100% investment in BUD, i.e. short the risk-free asset. How do you interpret a weight in the risk-free < 0%?

4. (a) Graph the Efficient Frontier for only 2 assets, AOL and TWA. Use the formula VAR(w1X + w2Y) = w12VAR(X) + w22VAR(Y) +2w1w2COV(X,Y).

(b) What is the Minimum Variance portfolio? Identify by weight in each asset to the nearest 0.1%

5. Verify that the portfolio weights (in Table 2) sum to 1 for EACH of the 50 portfolios.

6.Calculate the Expected Return for each of the 50 portfolios.

7. Calculate the Variance and Standard Deviation for each portfolio. Since the assets are not independent, i.e. COV?0, you must use following formula:

VAR (w1X + w2Y + w3Z + w4W) =

w12VAR(X) + w22VAR(Y) + w32VAR(Z) + w42VAR(W) +2 w1 w2COV(X,Y) + 2 w1 w3COV(X,Z) + 2 w1 w4COV(X,W) + 2 w2 w3COV(Y,Z) + 2 w2w4COV(Y,W) +2 w3w4COV(Z,W),

where w1, w2, w3, and w4 are arbitrary constants. Note: w1 + w2 + w3 + w4 = 1.

8. Plot all the portfolios and identify the Efficient Frontier. List ALL portfolios that lie on the Efficient Frontier.

9. Identify the following portfolios by number:

(a) Equally-weighted portfolio
(b) The single-security portfolios (#1- #4)
(c) The minimum variance portfolio
(d) The "market" portfolio for the 4 securities (ignore the single security portfolios #1-#4). Hint: To identify the market portfolio, use the slope, i.e. Sharpe Ratio

10. Plot the CAL using the Treasury Bill. For this question, assume the annual T-bill rate is 12% to make the graph easier to read.

EXTRA CREDIT (although you should want to know how do this anyway!)

Using solver, create the efficient frontier using the concept of duality. In particular, identify MVP. Then incrementing in whole numbers, e.g. 6%, 7%,etc, maximum return subject to the risk level, e.g 6%, then 7%, etc.

Presentation

Answers the questions briefly and to the point. Summarize your answers briefly in word file and email your actual spreadsheet,. Remember to circle or underline your final answers.

Attachment:- homework.zip

Reference no: EM131232026

Questions Cloud

Define what each of these constructs means : Tannen points out that a common communication strategy is to convey intended messages indirectly. What points does she make about this? Why do people convey messages indirectly? What are its advantages? What are its disadvantages? Illustrate your ..
Describe current status in your leadership development : Leadership is creativity in action. It is the ability to see the present in terms of the future while maintaining respect for the past. Based on the above definition, describe for me your current status in your leadership development.
Create the child process and wait for it to terminate : In Exercise 3.21, the child process must output the sequence of numbers generated from the algorithm specified by the Collatz conjecture because the parent and child have their own copies of the data. Another approach to designing this program is ..
Evaluate the role of ethical decision-making in business : Discuss the key countries that might be associated with the risk. Evaluate the role of ethical decision-making in business organizations. Analyze the impact of business ethics on stakeholder relationships.
Find the total return over the 36-month period : FIN 132 - Efficient Frontier (Risk and Return) - Find the total return over the 36-month period for each stock. Which stock had the highest and lowest returns? Was this expected? Are these results consistent with the general risk-return relationshi..
Design the wl ratios of the transistors : Design the W/L ratios of the transistors to provide symmetrical switching times equal to the basic CMOS inverter with (W/L)n = 2 and (W/L)p = 4.
Describe the negative impact the project would face : Identify at least four significant team communication challenges she would be facing on this project that would be tied to the fact that she was working with a virtual team. Explain carefully the problems associated with each challenge.
Determine the logic function performed by the circuit : Determine the logic function performed by the circuit in given Figure. - Determine the W/L ratios to provide symmetrical switching times equal to the basic CMOS inverter.
Create your revised companys mission statement : Create your revised NAB company name and explain its significance. Develop your revised company's Mission Statement and provide a rationale for its components.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd