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

Hsa advantages , A HEALTH SAVINGS ACCOUNT AT FRONTLINE PR Susan Berry...

A HEALTH SAVINGS ACCOUNT AT FRONTLINE PR Susan Berry just returned from a national conference on compensation and benefits where she attended a session on Health Savings Accou

Depreciation, what are methods of calculating depreciation?

what are methods of calculating depreciation?

Calculate present value-current yield-interest rates bonds, Present Value o...

Present Value of a Bond 1. Assume that you wish to purchase a 20 year bond that has a maturity value of $1,000 and makes semiannual interest payments of $40.  If you require a

Expected opportunity loss decision criterion, The construction manager for ...

The construction manager for Acme, Inc. must decide whether to build single-family homes, apartments, or condominiums. She estimates annual profits will vary with the economy, as f

Explain statement of financial condition, Q. Explain Statement of Financial...

Q. Explain Statement of Financial Condition? Statement of Financial Condition -Elementary FINANCIAL STATEMENT, generally accompanied by appropriate DISCLOSURES which describe t

Method of accounting for securities, Settlement Method - Method of ACCOUNTI...

Settlement Method - Method of ACCOUNTING for SECURITIES whereby transactions are recorded on the date securities settle by delivery or receipt of securities and receipt or payment

Partnership accounting, How does ordinary shares and preference shares incl...

How does ordinary shares and preference shares included in the account

Cost of capital calculation, Cost of capital calculation Cost of equit...

Cost of capital calculation Cost of equity (Ke) Using the dividend valuation model, Ke=D 1 /P 0 + g Pretentious that dividend growth over the last five years is a good

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

How would errors affect the account balances, How would the following error...

How would the following errors affect the account balances and the basic accounting equation: assets = liabilities + owners' equity? How do the misstatements affect income? 1. 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