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

What is the cash flow from assets for 2010, The following question are base...

The following question are based on above table:- Question 1 What is the change in net working capital from 2009 to 2010? Question 2 What is net capital spending for 20

Need help completing self assessment return, I am an AAT student studying l...

I am an AAT student studying lvl 3 AAT at college. I wish to learn how to complete self assessment end of year tax return forms for other people. That is because I have already bee

Prepare journal entries to record the borrowing, On December 1, 2013, Colon...

On December 1, 2013, Colonel Wilder borrowed $400,000 at 12% interest and pledged $500,000 in accounts receivable as collateral. Additionally, Colonel Wilder was charged a finance

Condition of joint return, Surviving Spouse - This is a person whose wife o...

Surviving Spouse - This is a person whose wife or husband died during tax year. A surviving spouse can file a JOINT RETURN for the year in which death occurred. Additionally a join

Cash budget, What is a cash budget? How it is useful in managerial decision...

What is a cash budget? How it is useful in managerial decision making?

Case law & study, Bakers Bagels LLC produces and sells 20 types of bagels b...

Bakers Bagels LLC produces and sells 20 types of bagels by the dozen. Bagels are priced at $6.00 per dozen (or $0.50 each) and cost $.020 per unit to produce. The company is consid

Trade credit, Trade credit creates accounts or debtors receivables. Trade c...

Trade credit creates accounts or debtors receivables. Trade credit is utilized as a marketing tool to expand competitive advantage over trade rivals. A firm's investment in account

Assignment, 1- Journalize May transactions. Entry: 1. May 1 Owner H.Hadi...

1- Journalize May transactions. Entry: 1. May 1 Owner H.Hadi invested $40,000 in the business. 2. May 4 Equipment was purchased at a cost of $7,000; a three-month, 10% note pa

Lease or buy, La Favorite Pastry Shop has been in business since 1985 and s...

La Favorite Pastry Shop has been in business since 1985 and started with a large commercial oven that was built in 1955. Max, the owner is debating whether or not to purchase a new

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