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

Benefits of sell some goods at a local music festival, 1. You have decided ...

1. You have decided to sell some goods at a local music festival. You have hired a sales stand for $500. Your cost per item is $3 and you will sell each item for $5. When you did y

Journal entry for company, 1. Think about the transactions listed below. a....

1. Think about the transactions listed below. a. A company obtains a $10,000 loan from a bank. b. A company purchases $15,000 of inventory from its suppliers. They paid $5,000 toda

How much salary should zorn receive during the period, zorn conducted his p...

zorn conducted his professional practice through zorn, inc. the corporation uses a fiscal year ending september 30 even though the business purpose test for a fiscal year cannot be

Prepare income statement and analysis of retained earnings, You are prepari...

You are preparing and income statement and analysis of retained earnings for Pacioli Wholesale Corporation for the years ended June 30, 2011 and 2012 based on the following informa

Balance sheet, 1. Consider the following balance sheet: Bes...

1. Consider the following balance sheet: Best Care HMO                  Balance Sheet               June 30, 2007 Assets  / Current Assets*

Explain irs, The IRS is conducting a transfer pricing examination of USAco,...

The IRS is conducting a transfer pricing examination of USAco, a wholly-owned U.S. subsidiary of FORco. USAco purchases widgets from FORco for resale in the United States. The IRS

Subsidiary company exclusion features, Subsidiary company exclusion feature...

Subsidiary company exclusion features 1) The standard does not require consolidation of a subsidiary acquired when there is evidence that the control is intended to be temporar

Interest is deductible on schedule a, Heather & Terry have a mortgage on th...

Heather & Terry have a mortgage on their primary residence of $750,000 and a mortgage on their vacation home of $410,000. In 2013, they incurred $46,400 of mortgage interest expens

Case study, It is the month of april for rand company a producer of gold an...

It is the month of april for rand company a producer of gold and silver commemorative medallions. Rand company has one job, job A a special minting of 1000 gold medallions which st

What is the interest receivable and interest revenue, Journalize the entrie...

Journalize the entries to record the receipt of the amounts due on Notes (5) and (6) in January. Date Face Amount Term Interest Rate 5. Nov. 15 $54,000 60days 6% 6. Dec. 27 $40,500

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