Question: Please note decimal places, thanks! Data pasted below for your help: Cola Co. Gas Co. January -0.0210 0.0280 February 0.0000 -0.0050 March -0.0200 -0.0180 April

Please note decimal places, thanks! Data pasted below for your help:

Cola Co. Gas Co. January -0.0210 0.0280 February 0.0000 -0.0050 March -0.0200

Please note decimal places, thanks!

Data pasted below for your help:

Cola Co. Gas Co. January -0.0210 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 2010 (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 55% invested in Cola Co. stock and 45% invested in Gas Co. stock. Calculate the volatility by: a. Using the formula: Var(Rp) = w} SP (R1) 2 + wsD(R2) +2Wqw2Corr (R1,R2) SD (R1) SD (R2) b. Calculating the monthly returns of the portfolio and computing its volatility directly. c. How do your results compare? a. Using the formula: Var(Rp) = w;SD (R2) 2 + w SD (R2) +2w2w2Cor (R1,R2) SD (R1) SD (R2) The volatility (standard deviation) of the portfolio is %. (Round to two decimal places.) b. Calculating the monthly returns of the portfolio and computing its volatility directly. The volatiliy (standard deviation) of the portfolio is %. (Round to two decimal places.) c. How do your results compare? (Select the best choice below.) O A. The portfolio volatility calculated using the Var (Rp) formula in part (a) is much smaller than the portfolio volatility calculated used the monthly portfolio returns. O B. This cannot be determined from the information given. OC. The portfolio volatility calculated using the Var (Rp) formula in part (a) is much larger than the portfolio volatility calculated used the monthly portfolio returns OD. The two portfolio volatilities, calculated using the Var(Rp) formula in part (a) and using the monthly portfolio returns, are the same or almost the same. Month Cola Co. Gas Co. 0.0280 January February March April May June July August September -0.0210 0.0000 -0.0200 0.0090 -0.0310 -0.0840 - 0.1190 -0.0160 0.0550 -0.0110 -0.0050 -0.0180 0.0280 0.0840 -0.0460 0.0820 0.0460 October 0.0300 0.0140 0.0290 November -0.0380 December -0.0220 0.0740

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The following table contains monthly returns for Cola Corporation and Gas Corporation for 2012: (The returns are shown in decimal form, i.e., 0.035 is 3.5%.) Using this table and the fact that Cola...

The following table contains monthly returns for Cola Corporation and Gas Corporation for 2012: Month Cola Corp. Gas Corp. January 0.0210 0.0280 February 0.0000 0.0050 March 0.0200 0.0180 April...

The following table contains monthly returns for Cola Corporation and Gas Corporation for 2012: EB (The returns are shown in decimal form, i.e., 0.035 is 3.5%.) Using this table and the fact that...

The foowing title contains only returns for Cola Corporation and Gas Corporation for 2012 (There are shown in een form ...038 351 Uurg is on the fact that lopen Gas Copentotho correlation of -0.0000,...

X Data table Month Cola Co. Gas Co. January -0.0210 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...

The following table contains monthly returns for Cola Corporation and Gas Corporation for 2012: EEB The raturns are shown in decimal form, i.e., 0.035 is 3.5%) Using this table and the fact that Cola...

PLEASE answer ALL parts of the question Month Cola Co. Gas Co. -0.0210 0.0280 January February 0.0000 -0.0050 -0.0180 March -0.0200 0.0090 0.0280 April May -0.0310 0.0840 June -0.0840 -0.0460 -0.1190...

The following table contains monthly returns for Cola Corporation and Gas Corporation for 2012: 5: (The returns are shown in decimal form, i.e., 0.035 is 3.5%.) Using this table and the fact that...

Why is it important to mark the solvent level on the chromatography paper as soon as you remove it from the Petri dish?

A company reports the following information about its sales and its cost of sales. Each unit of its product sells for $1,000. Use these data to prepare a scatter diagram. Draw an estimated line of...

2. State which colour of light has the highest frequency and which has the lowest?

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...