The following table contains monthly returns for Cola Co. and Gas Co. for 2013 (the returns...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following table contains monthly returns for Cola Co. and Gas Co. for 2013 (the returns are shown in decimal form, i.e., 0.035 is 3.5%). Using this table and the fact that Cola Co. and Gas Co. have a correlation of -0.0969, calculate the volatility (standard deviation) of a portfolio that is 50% invested in Cola Co. stock and 50% invested in Gas Co. stock. Calculate the volatility by: a. Using the formula: Var (Rp) = w² SD (R₁)²+w2 SD (R2)² + 2w₁ w₂ Corr (R₁.R₂) SD (R₁) SD (R2) b. Calculating the monthly returns of the portfolio and computing its volatility directly. c. How do your results compare? Data table - X a. Using the formula: Var()()}, SD (M₂)² + 2w, wy Car (R, A₂) SD (R₁) SD (R₂) The volatility (standard deviation) of the portfolio is %. (Round to two decimal places.) (Click on the following icon in order to copy its contents into a spreadsheet.) Cola Co. -0.0210 Month Gas Co. January 0.0280 February 0.0000 -0.0050 March -0.0200 -0.0180 April 0.0090 0.0280 May -0.0310 0.0840 June -0.0840 -0.0460 July -0.1190 0.0820 August -0.0160 0.0460 September 0.0550 0.0300 October -0.0110 0.0140 November -0.0380 0.0290 December -0.0220 0.0740 The following table contains monthly returns for Cola Co. and Gas Co. for 2013 (the returns are shown in decimal form, i.e., 0.035 is 3.5%). Using this table and the fact that Cola Co. and Gas Co. have a correlation of -0.0969, calculate the volatility (standard deviation) of a portfolio that is 50% invested in Cola Co. stock and 50% invested in Gas Co. stock. Calculate the volatility by: a. Using the formula: Var (Rp) = w² SD (R₁)²+w2 SD (R2)² + 2w₁ w₂ Corr (R₁.R₂) SD (R₁) SD (R2) b. Calculating the monthly returns of the portfolio and computing its volatility directly. c. How do your results compare? Data table - X a. Using the formula: Var()()}, SD (M₂)² + 2w, wy Car (R, A₂) SD (R₁) SD (R₂) The volatility (standard deviation) of the portfolio is %. (Round to two decimal places.) (Click on the following icon in order to copy its contents into a spreadsheet.) Cola Co. -0.0210 Month Gas Co. January 0.0280 February 0.0000 -0.0050 March -0.0200 -0.0180 April 0.0090 0.0280 May -0.0310 0.0840 June -0.0840 -0.0460 July -0.1190 0.0820 August -0.0160 0.0460 September 0.0550 0.0300 October -0.0110 0.0140 November -0.0380 0.0290 December -0.0220 0.0740
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Read the following current state and discuss why this scenario is highly compatible with RPA: When a vendor sends an invoice, the Accounts Payable Clerk opens the email, reviews the attachment, and...
-
As per the following data: Calculate net monetary asset balance, 1/1/24 in PGK
-
Which of the following are valid in a Java file, listed in the order in which they are declared? (Choose two.) A. A package-private class declaration and a public interface declaration B. Two package...
-
Deanna Nardelli started her own consulting firm, Nardelli Consulting, on May 1, 2019. The trial balance at May 31 is as follows. In addition to those accounts listed on the trial balance, the chart...
-
Report Journal Entries by using Sage 50 software 5. Issue a single payroll check dated Oct 15, 2024 (for Oct 1- Oct 15, 2024) using the information noted below. The employee is taking courses and...
-
Indicate the circumstances that may necessitate direct testing of income statement balances.
-
The Kitakyushu, Japan, plant of Nissan Motor Corporation assembles two types of cars (Teanas and Muranos). Separate assembly lines are used for each type of car. Classify each cost item (A H) as...
-
On 28 April 20X2, Peele Realty purchased land and building for $6.55 million and $4.69 million, respectively. The company uses the revaluation model for the land and building. Assume that the land is...
-
what's the history of metro (the grocery store), and what is their retail concept?
-
Job Order Costing Completing this activity will help you learn to: Determine amounts in a job order cost accounting system for a manufacturing business. Extract information from a data set using...
-
The owner of Mobile Select, Bruce Smith, has had discussions with a camping outfitter in Glasgow about selling the companys mobile homes and recreation vehicles in the U.K. The camping outfitter,...
-
Consolidation Eliminating Entries, Several Years Since Acquisition In July 2019, IBM Corporation acquired all of the outstanding stock of Red Hat Software. Cash paid for outstanding Red Hat stock...
-
An investment portfolio is a crucial element in the financial planning process. In this activity, you will develop investment portfolios for three clients based on their risk tolerance. Prompt For...
-
As a professional accountant, you are responsible for adherence to accounting principles and methods when working with clients. Depending on your specific market that you will work in, it is...
-
Luke receives a property distribution from Vader Enterprises, Inc. (he inherited the corporation from his father). The property has a FMV of $625,000 and the corporation had a basis in it of...
-
What is the shape of the exponential distribution?
-
Suppose a firms tax rate is 35%. a. What effect would a $10 million operating expense have on this years earnings? What effect would it have on next years earnings? b. What effect would a $10 million...
-
You observe a portfolio for five years and determine that its average return is 12% and the standard deviation of its returns is 20%. Can you be 95% confident that this portfolio will not lose more...
-
What was your dividend yield from investing in the stock in Problem 8? What was your capital gain?
-
In your own words ,explain why as sort ativity could be important to System of Systems theory.
-
Design an undirected network with N=7 and L=12. Based on how you drew your network, classify it as either fully connected ,random, or scale-free. Justify your decision with a short paragraph response.
-
Design a network with an average degree of 2.
Study smarter with the SolutionInn App