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

  Computing company ending inventory

Hay Company had January 1 inventory of $100,000 when it adopted dollar-value LIFO. During the year, purchases were $600,000 and sales were $1,000,000. December 31 inventory at year-end prices was $126,500, and the price index was 110. What is Hay ..

  Labor and overhead costs for one unit of product

If direct materials for one unit of product are $9.00, direct labor for one hour is $15.00, manufacturing overhead costs are $5.00 per direct labor hour, and one-fourth hour of direct labor is required to produce one unit of product, how much are ..

  Distinguish between upstream and downstream sales

Why is it important to distinguish between upstream and downstream sales in the analysis of intercompany profit eliminations?

  Problem on cost of goods sold and gross profit rate

At the beginning of the year, Wildcat Athletic had an inventory of $200,000. During the year, the company purchased goods costing $800,000. If Wildcat Athletic reported ending inventory of $300,000 and sales of $1,050,000, their cost of goods sold..

  Balance in eve prepaid insurance

Eve's Apples opened business on January 1, 2010, and paid for two insurance policies effective that date. The liability policy was $36,000 for eighteen-months, and the crop damage policy was $12,000 for a two-year term. What was the balance in Eve..

  Holding sales constant

By how much must the assets be reduced to bring the TATO to the industry average, holding sales constant?

  Discuss why a buyer may want to order on a bill

Discuss why a buyer may want to order on a bill and hold basis. Why might a seller want to classify an order as bill and hold if it does not meet the above criteria?

  Present value of future sales

A new ice cream machine has been added to Dairy Queen - It is expected to add $100,000 in sales in year 1 increasing by $25,000 per year thru year 10 ( 10years total) what is the present value of these future sales if interest is 8%

  What are the revenues

Income from operations for Division B is $165,300, total service department charges are $399,200 and operating expenses are $2,626,000. What are the revenues for Division B?

  What was the cost of the machine

A machine is purchased by making payments of $5,000 at the beginning of each of the next five years. The interest rate was 10%. The future value of an ordinary annuity of 1 for five periods is 6.10510. The present value of an ordinary annuity of 1 fo..

  What was the stockholders equity

On January 1, 2010, NWK, Inc.'s assets were $300,000 and its stockholders' equity was $140,000. During the year, assets increased $15,000 and liabilities decreased $10,000. What was the stockholders' equity on December 31, 2010?

  Accounting for troubled debt restructuring

Ludwig, Inc., which owes Giffin Co. $2,400,000 in notes payable, is in financial difficulty. To eliminate the debt, Giffin agrees to accept from Ludwig land having a fair value of $1,830,000 and a recorded cost of $1,350,000.

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