Calculate the optimal allocation of stocks, Financial Accounting

A) Suppose you have two stocks (A and B) in your portfolio, worth $400,000 and $600,000 respectively. The annual volatility is 0.30 and 0.35 respectively. The correlation between the two stocks is 0.42. Please calculate the 10-day, 95% VaR for the two positions separately and for the portfolio. How much is the VaR reduction in the portfolio? Re-calculate the portfolio VaR and VaR reduction assuming a correlation of 0.9. What can you conclude? (Hint: for accuracy and convenience, it is a good idea to set up the calculation in a spreadsheet. Also, assume 252 days in a year.) 

B) Suppose you add Stock C to your portfolio. Stock C has an annual volatility of 0.25. The correlations are ρAB=0.42, ρAC=0.20, and ρBC=0.33. Keeping the total investment at $1,000,000, and assuming that achieving the lowest VaR is the only objective, what is optimal allocation among the three stocks? (Hint: please Solver in Excel.)  

 

Posted Date: 3/25/2013 5:25:39 AM | Location : United States







Related Discussions:- Calculate the optimal allocation of stocks, Assignment Help, Ask Question on Calculate the optimal allocation of stocks, Get Answer, Expert's Help, Calculate the optimal allocation of stocks Discussions

Write discussion on Calculate the optimal allocation of stocks
Your posts are moderated
Related Questions
I have a case study due in one of my classes. There are 3 pages of information about the company in the case, and there are 12 questions I must complete. Each question is basically

Prospective Financial Information (forecast and projection) - Forecast: Prospective financial statements which present, to the best of responsible party's knowledge and belief, an

Brushy Mountain Mining Company's ore reserves are being depleted, so its sales are declining. Also, its pit is getting deeper every year, so its costs are rising. As a result, the

Purchases office supplies on account costing $12,600 during July. It pays $5,500 for these purchases during July and the remainder during August. Office supplies on hand on July 1

The IRS is conducting a transfer pricing examination of USAco, a wholly-owned U.S. subsidiary of FORco. USAco purchases widgets from FORco for resale in the United States. The IRS

You are a Senior Financial Manager in the recently privatised Sodor Railway Engineering Corporation Plc (SREC). (a) Subsequent to privatisation the Chief Executive Officer of SR

Red Herring -‘Pre-release' PROSPECTUS offering. An announcement of a future issuance of SECURITIES, given restricted circulation during waiting period of 20 days or other specified

The following items represent liabilities on a firm's balance sheet: a. An amount of money owed to a supplier based on the terms 2/20, n/40, for which no note was executed. b. An a

Q. Explain about Mutual Fund? Mutual Fund - Investment Companythat usually offers its shares to general public and invests the proceeds in a diversified portfolio of SECURITIES