Compute daily returns on the two stocks

Assignment Help Financial Accounting
Reference no: EM131147765

Identify two stocks and name them as first and second stock. Download into an excel worksheet the historical price data on the two stocks from January 1, 2015 to July 22, 2016 from www.finance.yahoo.com. Compute daily returns on the two stocks for each trading day.

Now, using the CORREL function in MS Excel, compute the correlation between the returns on the two stocks. Also compute the expected return and the standard deviation of returns on each of the two stocks using the AVERAGE and the STDEV function in MS Excel. Annualize the expected returns and the standard deviations of the two stocks by assuming that the number of trading days in the year is 252.

Now suppose Ms. X has 9000 shares in the first stock and Mr. Y has 4500 shares in the second stock. Ms. X and Mr. Y decide to get married, and want to allocate their combined wealth between the two stocks in such a way that the standard deviation of the returns on their portfolio is minimized.

(a): Work out the number of shares in each of the two stocks that the risk minimizing portfolio will contain.

(b): Work out E(Wealth1), the expected value of their portfolio at t=1 (one year from today)

(c): Work out the range within which their t=1 wealth will lie with a probability of 95% assuming that the future wealth is normally distributed.

(d): Check that your answer for the risk minimizing portfolio weights does in fact minimize the risk with the help of the MS Excel file "2-Security Portfolios.xls" on bspace by entering your solution in an appropriate row in that file, and showing that the portfolio risk increases if the portfolio weights differ from the optimal by 0.001 in either direction. Print out the appropriate area of the Excel file and attach it with your solution. Note that you will lose 60% of the credit for this homework if you do not attach a printout of the appropriate part of Excel spreadsheet that shows that you have verified that your portfolio weights in fact minimize the risk.

The lower end of the 95% confidence interval is [E(Wealth1) - 2*SD(Wealth1)] and

the upper end is [E(Wealth1) + 2*SD(Wealth1)].

Reference no: EM131147765

Questions Cloud

How do the cultural concerns and influences affect justice : Consider the following questions to help you build your argument. How do the cultural concerns and influences affect justice and security administration and practice? What contemporary methods are used in societies of mixed cultures?
What rules for plotting the root locus : What rules for plotting the root locus are the same whether the system is a positive- or a negative-feedback system?
What is the forecast for each season of the next year : Demand at Nature Trails Ski Resort has a seasonal pattern. Demand is highest during the winter, as this is the peak ski season. However, there is some ski demand in the spring and even fall months. The owner of Nature Trails would like to make a fore..
Sketch the root locus for system : which is the denominator of the closed-loop transfer function, is given by s3 + 2s2 + (20K + 7) s + 100K. Sketch the root locus for this system.
Compute daily returns on the two stocks : ompute the expected return and the standard deviation of returns on each of the two stocks using the AVERAGE and the STDEV function in MS Excel.
What are the challenges faced by entrepreneurs : Entrepreneurship is the process of starting new businesses, generally in response to opportunities. What are the challenges faced by entrepreneurs? What are some solutions to these challenges/issues
Firm manufacturing processes is firm competitive advantage : However, in the given situation, the US firm's manufacturing processes is the firm's competitive advantage, and it is allowing the firm to be extremely profitable by cutting costs by 50%. Would you be concerned that the firm abroad would obtain insid..
Provide a general overview of your select healthcare system : Provide a general overview of your select healthcare system. Discuss the demographics of your select location. Discuss the advantages of using each marketing tool at your healthcare system and location.
Competitive advantage from proficiency in supply management : What are the challenges facing operations managers in obtaining competitive advantage from proficiency in supply management? Use examples from a heavy manufacturing industry (e.g. steelmaking), a light manufacturing industry (e.g. televisions), a ser..

Reviews

Write a Review

 

Financial Accounting Questions & Answers

  Sales volume variance-actual volume

Assuming actual volume is 11,000 units and planned volume is 10,000 units, the sales volume variance

  Approval of the budget before the commencement

Development of assumptions and plans about the factors influencing next year's budget in advance of the budget year starting - Approval of the budget before the commencement of the budget year;

  Free trade credit firm receive during the yearfilbeck

free trade credit firm receive during the year.filbeck company buys on terms of 215 net 30 days. it does not take

  Why net income does not equal net cash inflow

Develop an income statement for O'hare for 2014 - Determine the amount of the net cash inflow for O'hare for 2014 and explain why net income does not equal net cash inflow.

  Analyse profitability liquidity and gearing financial ratios

Analyse the profitability, the liquidity and the gearing of Sessegnon Ltd based on the information above and using appropriate financial ratios. Would a new supplier be willing to give them credit?

  Will the data be stored for at least five years

Will the data be stored for at least 5 years? Are participant recruitment and data collection steps adequately described, such that the study's risks and burdens can be discerned?

  What rate of return did mike earn over year

During the year he received dividends of $1.45 per share. The stock is currently selling for $60 per share. What rate of return did Mike earn over the year?

  Statements of changes in equity of platypus

Consolidation worksheetand detailed calculation of non-controlling interest balance; and consolidated financial statements and statements of changes in equity of Platypus Limited and its controlled entities.

  Reaching a financial goal

Erika and Kitty, who are twins, just received $45,000 each for their 28th birthdays. They both have aspirations to become millionaires. Each plans to make a $5,000 annual contribution to her "early retirement fund" on her birthday, beginning a year f..

  Find out the amount of depreciation expense for years end

Find out the amount of depreciation expense for the years ended Dec 31, 2009, 2010, 2011 and 2012 by the straight-line method,

  Compute the net present value of the new machine

Compute The net present value (NPV) of the new machine and The effects on the cash flow each year, including year 0, if the new machine is purchased.

  Factory seeks to allocate rent

assume that a factory seeks to allocate rent to several departments that occupy the factory.

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