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

Features of the torrens title system, Answer both parts of this question. E...

Answer both parts of this question. Each part is worth seven and a half marks each. (a) Describe the features of the Torrens Title system of land registration and compare them t

Compute the companys largest available depletion deduction, In May 2011, Yo...

In May 2011, Your Company purchased the rights to a natural resource for $4,125,000. The estimated recoverable units from the natural resource amount to 5,500,000 units. During the

Prospective financial information, Prospective Financial Information (forec...

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

Balance sheet preparation with a missing element, Balance Sheet Preparation...

Balance Sheet Preparation with a Missing Element The following data are available for Schubert Products Inc. as of December 31, 2012. Cash . . . . . . . . . . . . . . . . . . . . .

Retained Earnings and Capital, What happens to capital when a project is co...

What happens to capital when a project is completely funded by retained earnings?

Recording, explain the terms recording,classifying,summarizing and communic...

explain the terms recording,classifying,summarizing and communicating

BUDGETING, In the context of the public sector, discuss incremental system...

In the context of the public sector, discuss incremental system of budgeting and evaluate their strengths and weaknesses

Analyse daily prices-returns and volatility, Choose a share from a market s...

Choose a share from a market such as LSE, NYSE, NASDAQ, etc. [Data sources could be Datastream, Google Finance or others]. Prepare a report which involves the following aspects: -

Compute debt equity ratio and prepare a cash flow statement, 1.From the ...

1.From the following information you are required to prepare a cash Flow statement of XYZ Ltd for the year ended 31 st December 2009 LIABILITIES

Terms of trade, Terms of Trade Doe Ltd must negotiate agreed terms of tr...

Terms of Trade Doe Ltd must negotiate agreed terms of trade with its customers in order to encourage prompter payment. These terms of trade may tender discounts for early paymen

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