# Finance-AW712

## Finance-AW712 Online Services

1. For the following companies listed below find and retrieve historical data on monthly stock prices over the last five years (January 2009 – December 2013). The source of your data must be cited.

• Lululemon
• Telus
• Barrick Gold
• Nexen
• TD Bank

Using the stock price data, perform the following in a spreadsheet

a) Calculate the average monthly return, variance and standard deviation for each stock over the last five years.

Annualize these numbers. Plot the annualized average returns against standard deviation. What pattern if any do you notice. Describe the pattern and explain what you believe to be the cause of the pattern.

b) Calculate all the pairwise covariances and correlations of the stock returns and report these in the form of a variance/covariance matrix and a correlation matrix. Which two stocks are most correlated, and why you think this is so?

c) Form a portfolio with 100 shares of each stock. What is the expected return and standard deviation of this portfolio? Show where this portfolio is on you initial plot.

d) Now, using the same stocks, form another portfolio of your choosing that is more efficient than that in c). Provide a rationale as to why you chose this portfolio and find its expected return and standard deviation. Show where it is on your initial plot.

e) For each of the companies, compute the excess returns of their stocks and on the excess returns of the market (index) using the 3 month T-Bill rates and S&P/TSX index data (again, the source of your data must be cited). Next, run regressions of the excess returns of the three companies chosen against the excess returns of the market index. What are the values of their beta coefficients? Give a verbal interpretation of what the regression lines and the beta coefficients show about the stocks’ volatility and relative riskiness as compared to those of other stocks.

You can read more about our case study assignment help services here.

## How it Works

#### How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to Case Id . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

## Case Approach

#### Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

## Related Services

2. Canadian Mid-Western (CMW) is a corporation with a market value of \$120 million. It consists of two SBUs which are expected provide quite different returns, depending on the economic environment. The first SBU is a real estate property management business (RPM) while the second SBU is an online media portal (OMP) which is publicly traded. OMP has 3 million shares outstanding and currently trades at a market price of \$25 per share. CMW is the majority shareholder of OMP, owning 64% of the company’s shares.

CMW is looking to boost the overall return of the corporation by focusing more on its online business. From historical data over several previous years, Shauna Benson, its CFO, has determined that CMW as a whole has had an average annual return of 12% and a variance of 13(%2). She has also been able to determine from market data that that the expected annual return on OMP was 20%, its variance was 30(%2) and its correlation with RPM was 0.55.

With these in mind Ms Benson wants to divest some of the company’s assets in RPM and use to proceeds to invest in OMP such that the newly rebalanced company will have an expected return of 14%. What will the new CMW look like? That is, what will its new percentage ownership of OMP be, how much capital will it still have invested in RPM, and what will be the estimated variance of the new overall company?

3. In 2004, Google Inc. went public with an IPO issued through a Dutch auction, ostensibly to avoid the underpricing problem prevalent in the usual underwritten IPO. However, Google’s IPO still “popped” on its first day of trading,indicating that it too may have been underpriced. In 300 words or less, discuss whether you think the Google IPO was underpriced and if so (not), then why (why not).

Product code: Finance-AW712