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

Virtual learning expects net revenues, Virtual Learning Inc., an Ontario-ba...

Virtual Learning Inc., an Ontario-based company on the cutting edge of technology, is analyzing the possibility of providing university-level courses for York University. This virt

Conclusion on overtrading, Q. Conclusion on Overtrading? The majority o...

Q. Conclusion on Overtrading? The majority of the evidence suggests that our company is moving into an overtrading situation, although the evidence is not conclusive. Current p

Value added tax, 1. discuss how VAT system works by using relevant examples...

1. discuss how VAT system works by using relevant examples. 2. list and explain the VAT supply categories; provide relevant examples of each category. 3. provide a recommendation r

Americans with disabilities act - ada, Americans With Disabilities Act - AD...

Americans With Disabilities Act - ADA  legislation passed in 1990 that bans discrimination against people who are having disabilities. According to this Act, discrimination against

Preference share capital in subsidiary-group accounts, Preference share cap...

Preference share capital in subsidiary (irredeemable) Investment in preference shares does not lead to ownership and therefore, if the holding company owns part of the preference

Ethics and Social Responsibility, Select a publicly traded company for whic...

Select a publicly traded company for which an Accounting and Auditing Enforcement Release (AAER) was published on the U.S. Securities and Exchange Commission (SEC) website at http

Determine arbitrage-free rate of interest, The government of a country has ...

The government of a country has just issued a series of zero-coupon bonds maturing at the end of years 1, 2, 3 and 4. Suppose the spot rates (or continuously compounded yields per

Which is not necessary in order for corporation to pay cash, Q. Which one o...

Q. Which one of the following is not necessary in order for a corporation to pay a cash dividend? a. Adequate cash b. Approval of stockholders c. Declaration of dividends by the bo

Prepare all journal entries for 2013, A summary of Jarvis Company's Decembe...

A summary of Jarvis Company's December 31, 2013, accounts receivable aging schedule is presented below along with the estimated percent uncollectible for each age group: Age Gro

#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

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