Verify your results using the two-factor portfolio equation

Assignment Help Accounting Basics
Reference no: EM13316471

QUESTION 4: PORTFOLIO ANALYSIS

The attached file contains (Returns data S2, 2014) daily returns for twenty five securities drawnfrom the NZX50 Index for the period 26th June 2013 and 24th June 2014.

4.1 Choose any two securities at random and determine (using Excel functions) the average daily returns for each company for the 12 months along with the variance and standard deviation of these returns. Next construct an equally weighted portfolio made up of the same two securities, and determine the series of daily returns. On this basis determine the average return for the portfolio and the associated variance and standard deviation.

(The averages, variances, and standard deviations can be derived using the relevant Excel functions. Utilise the Excel specification for population variance and standarddeviation - STDEVP and VARP - in the calculations).

Verify your results using the two-factor portfolio equation recalculate the average return and standard deviation of the portfolio. Explain why the portfolio standard deviation is less than the average standard deviation of individual securities. 

4.2 Choosing securities at random form equally weighted portfolios of 2, 3, 5,9, 15and 24 Securities and determine the standard deviation of these portfolios. Next plot your results for the standard deviations against the number of securities in the portfolios. Comment on your results and compare these with the results of the studies of naïve diversification. (In undertaking this analysis you can derive the results for each of the portfolios using the Excel spread-sheet).

Attachment:- Returns data.xlsx

Verified Expert

Reference no: EM13316471

Questions Cloud

Compulsive and obsessive behavior moods and mood swings : Which of the following is NOT a characteristic of a psychotic individua Compulsive and obsessive behavior Moods and mood swings A grossly distorted conception of reality A marked inefficiency in getting along with others and caring for oneself
Describe naturally-occurring food : Describe a naturally-occurring food that could be used as a PRE-, DURING-, and POST- training (or competition) nutritional aid to endurance athletes whose goal is optimal performance.
Describe what happens to each type of carbohydrate : Describe what happens to each type of carbohydrate (simple/complex) as it is consumed and processed. Your answer should contain the terms “glycemic index”, “blood insulin”, and “blood glucose”
Level of exposure to lead appears to be a reliable predictor : The level of exposure to lead appears to be a reliable predictor of all but which of the follow The number of juvenile offenses The seriousness of juvenile offenses The number of adult offenses The seriousness of adult offenses
Verify your results using the two-factor portfolio equation : Verify your results using the two-factor portfolio equation recalculate the average return and standard deviation of the portfolio. Explain why the portfolio standard deviation is less than the average standard deviation of individual securities.
What are fundamental techniques of scheduling : What are the fundamental techniques of scheduling? In your opinion, which one is better than the others?
What is the laplace transform : What is the Laplace transform of f(t) when f(t) = t2 ? s2 – 1 1/s2 – 1 2/s3 2/s2 None of the above; see Problem Work.
Laplace transform gives you the impulse response : What would be the best reason for using the Laplace Transform as a means to solve a complex system analysis problem? (Points : 7) This is the only way to solve complex time functions. The Laplace Transform gives you the most accuracy. Algebra problem..
Analyze methods utilized for external-internal recruitment : A hospital in your community is looking for a CLO to head the HR department to create a learning organization as the hospital moves to be a teaching facility. Analyze the methods utilized for both external and internal recruitment and determine which..

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Prepare the consolidation entry in connection

What balances would need to be considered in order to prepare the consolidation entry in connection with these intercompany bonds at December 31, 2008, the end of the first year of the intercompany investment?

  Prepares financial statements quarterly

The following are selected transactions of Winsky Company. Winsky prepares financial statements quarterly. Prepare journal entries for the above transactions and events

  What is the total cost to be allocated to city department

Sanilac County has a lease on a lawn mower for $2500 per month and $.02 per minute of operation. Operating costs for fuel, oil, technicians, and so on are all variable at $.03 per minute. Departments had projected a need for 100,000 minutes per mo..

  How should clyde treat the payment

Clyde agreed to surrender his Red stock in exchange for $600,000. clyde's basis in his shares was $143,000 and he held the shares for 17 years. the agreement made no explicit allocation of any of the $600,000 to clyde's agreement not to compete ag..

  Determining the starting date of credit period

Merchandise is ordered on June 13; the merchandise is shipped by the seller and the invoice is prepared, dated, and mailed by the seller on June 16; the merchandise is received by the buyer on June 18; the entry is made in the buyer's accounts on ..

  Journal entries and t-accounts for decort company

DeCort Company had these adjusting entry situations at the end of December:May 1-paid $960 for a two -year insurance policy. The policy was for the period May 1-April 30(for 2yrs). This is the first year of the policy-Transaction was recorded as i..

  Determine the amount of dividends paid each year

Determine the amount of dividends paid each year to each of the two classes of stockholders.

  Preparation of the manufacturing entries

Describe 1 ethical issue that could result from the preparation of these manufacturing entries.

  Opportunity cost of capital

Suppose the opportunity cost of capital is 10 percent and you have just won a $1 million lottery that entitles you to $100,000 at the end of each of the next ten years.

  Evaluate the cost recovery

Hazel purchased a new business asset (five-year property) on November 30, 2009, at a cost of $100,000. This was the only asset acquired by Hazel during 2009. On January 7, 2010, Hazel placed the asset in service. She did not elect to expense any o..

  Explain any differences between your calculation and rusty

Compute Rusty's correct gross income for the year, and explain any differences between your calculation and Rusty's.

  Suspended losses from activities

Hazel has investments in two nonrental passive activities: What is the total of Hazel's suspended losses from these activities?

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