Calculate the optimal allocation of stocks, Financial Accounting

Assignment Help:

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.)  

 


Related Discussions:- Calculate the optimal allocation of stocks

Gaap - generally accepted accounting principles, ACCOUNTANCY PRINCIPLES (GA...

ACCOUNTANCY PRINCIPLES (GAAP - GENERALLY ACCEPTED ACCOUNTING PRINCIPLES) Accounting values, rules of conduct and action are explained by a variety of terms for instance convent

Money, if you inherited 45,000 today and invested all of it in a security t...

if you inherited 45,000 today and invested all of it in a security that paid a 7 percent rate of return how much would you have in 25 years

Partnership and sole trader, what are the advantage and disadvantage to mr ...

what are the advantage and disadvantage to mr fish, mr Lobster of forming a partnership rather than a close corporation or a company?

Adjustments, Is goodwill a fictitious asset?

Is goodwill a fictitious asset?

#Profitandloss, How other income is different from revenue from normal oper...

How other income is different from revenue from normal operations under the vertical format

Calculate the sales needed to earn a profit of 20% on sales, Question: ...

Question: The following data are obtained from the record of a factory:                                                        £                   £ Sales 4,000 units @ £2

Corporation accounting oversight board, PCAOB - Public Corporation Accounti...

PCAOB - Public Corporation Accounting Oversight Board, a private-sector, non-profit corporation created by Sarbanes-Oxley Act of 2002, to oversee AUDITORs of public companies in or

Admission of a new partner, Admission of a new partner When a new partn...

Admission of a new partner When a new partner joins the firm/partnership, the new partner will enjoy the benefits arising as a result of goodwill created by the old existing pa

Sugar and Spice bakery, Perform a business size-up of Sugar and Spice Baker...

Perform a business size-up of Sugar and Spice Bakery. 2. Qualitatively analyze the opportunity of closing the storefront to cater events.

Prepare traditional income statement, Scottsdale Fine Piano%u2019s purchase...

Scottsdale Fine Piano%u2019s purchases pianos from a well-known manufacturer and sells them through their retail store. The Baby Grand Pianos sell, on average, for $2,500 each. The

Write Your Message!

Captcha
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