Preview

Finc5001 group assignment

Best Essays
Open Document
Open Document
5601 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Finc5001 group assignment
Executive Summary
Telstra Limited (TLS) is Australia's leading telecommunications and information services company, with one of the best known brands in the country. It offers a full range of services and competes in all telecommunications markets throughout Australia. (Telstra Financial Report, 2009) Ansell Limited (ANN) is a global leader in barrier protective solutions. It designs, develops and manufactures a wide range of hand and arm protection solutions, clothing and condoms (Ansell Financial Report, 2009). This report uses mean-variance method and CAPM approach, to form the portfolio combined two stocks TLS and ANN. By justifying five years (2005-2010) monthly data in using mean variance method to calculate the expected return (ANN 0.007488, TLS -0.004441), standard deviation (ANN 0.076531, TLS 0.053729), as well as beta (ANN 0.64, TLS 0.31). And then one year (2009) daily data to determine portfolio expected return in using CAPM method. With MV method, based on the justification and limitation, this report have not choose a optimize portfolio but only choose the portfolio number 29 with the smallest risk. However, under CAPM model, in evaluating the combination of its expected return and the beta, the report recommended portfolio number 29 based on 4 reasons. Firstly, the daily expected return calculated by CAPM model is much higher than daily risk free rate. Secondly, TLS is undervalued due to the SML. Thirdly, because the market is in dramatic change recently and low beta means low relation with market, so the number 29 is the most proper portfolio.
1.0 Mean Variance
According to Lai and Li (2008), the core of the MV is to take the expected return of a portfolio as the investment return and the variance of a portfolio as the investment risk. Consequently, the first step to using this method is to calculate the individual expected return and variance.
1.1 Data Selection
The data selected for calculate the individual expected return and variance is

You May Also Find These Documents Helpful

  • Powerful Essays

    Fin 421 Case

    • 4576 Words
    • 19 Pages

    The following case provides an analysis of six publicly traded stocks for the purpose of determining which amongst them would be prime candidates for a portfolio in terms of optimal return. Specifically, this paper discusses what options should be written or bought and exercised on the qualifying stocks to maximize profits. In order to accomplish this task the stocks will be measured and compared based on their market performance in terms of returns, betas and volatility, using historical data (recorded stock prices) and regression analysis. Initially the stocks are analyzed using historical returns to derive expected returns and standard deviations, or deviations from the mean or average market return.…

    • 4576 Words
    • 19 Pages
    Powerful Essays
  • Good Essays

    Finc5001

    • 855 Words
    • 4 Pages

    This assignment requires you to examine different approaches for determining the expected risk and return of a two stock portfolio. Each group will need to choose two companies listed on the Australian Securities Exchange (ASX) from an Excel spreadsheet (provided on Blackboard). Using data that the group collects, which must include data from March 2013, you will be required to examine the risk and return profiles of various portfolio combinations of these two stocks. Failure to use recent data that includes March 2013 will result in a mark of zero. The group will then be required to make a decision about which portfolio to invest in, and justify that decision with reference to appropriate academic literature.…

    • 855 Words
    • 4 Pages
    Good Essays
  • Best Essays

    The assessments of these portfolios combine portfolio evaluation, market efficiency, and whether or not CAPM and Fama-French Model are adequate.…

    • 2719 Words
    • 10 Pages
    Best Essays
  • Powerful Essays

    Stock Case

    • 1156 Words
    • 5 Pages

    Our goal was to create an optimal diversified portfolio consisting of the Dow Jones Index. We used the modern portfolio theory which maximizes expected portfolio return for the amount of risk taken by taking the stock weights in to consideration. Our group consisted of risk averse investors; therefore we diversified our portfolio with all 30 Dow Jones stocks because we wanted to achieve an acceptable return with a limited amount of risk. We implemented Excel’s Solver to figure out the stock weights in our optimal portfolio and then by tracking the portfolios performance over time.…

    • 1156 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    a. Objective(s). It is out of doubt that no matter how diversified the portfolio is, systematic risk can never be eliminated. The risk associated with individual stocks can be reduced, but general market risks affect almost every stock. So it is important to diversify between different asset classes and industries as well. The key is to find a medium between risk and return. The objective of this paper is to discuss importance of diversification of investment portfolio within industries and project the theory on the example of two portfolios. The first portfolio tends to be undiversified and consists of shares of companies from banking sector. The undiversified portfolio is as follows:…

    • 3195 Words
    • 13 Pages
    Powerful Essays
  • Good Essays

    Existing models such as CAPM, along with additional forms of regression will be used to compare with additional methods, not covered in the duration of the class to identify the better methods of portfolio creation. We will use learning tools and models to predict the rates of return and risk for each stock that will allow us to build portfolios to suit needs. We will carry out uncertainty analysis using resampling techniques and attempt to use Bayesian methods as well. The performance will be tested using future rates of return on these portfolios.…

    • 471 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    It is an opportunity and great pleasure for us to prepare a term paper on “Portfolio Performance evaluation & Analysis, for our course (F-407) portfolio management according to your order.…

    • 2847 Words
    • 12 Pages
    Powerful Essays
  • Powerful Essays

    Bibliography: 1. From the following websites: www.mutualfundsindia.com www.google.com www.valueresearchonline.com www.amfiindia.com www.idbibank.com www.investmentz.com 2. From IDBI Bank IDBI fund Reckoner 3. Books and magazines Security analysis & Portfolio management by Prasanna Chandra Value research Portfolio Management by S. Kevin…

    • 9847 Words
    • 40 Pages
    Powerful Essays
  • Satisfactory Essays

    Once, the simple returns have been calculated for all the stocks of choice in the portfolio; average returns should also be computed. It is essential to compute the covariance matrix for the selected stocks. This matrix can be used to determine the relatively consider the amounts of different assets that one should choose to hold in a context of diversification. The Matrix can be evaluated using MMULT and TRANSPOSE functions in excel. Furthermore, using known risk-free rate we can solve the optimal weightage (including short-selling) for each stock in the portfolio in accordance to the covariance matrix. By multiplying the above matrix yields expected return on this passive portfolio as well as other statistical tools like variance and standard deviation. Hence, Sharpe ratio is computed and indicates the risk-adjusted return on the portfolio 2.…

    • 339 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Tata Power

    • 624 Words
    • 3 Pages

    CAPM model has been used to calculate the cost of equity (Ke). β (systematic risk) has been calculated using the formula…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Group 5 Assignment

    • 1612 Words
    • 6 Pages

    Now-a-days marketing practices have been shifted from traditional media to digital media due to the remarkable rise in the field of social media. Present and prospective customers are now smarter than past, they are now become more aware, communicate and respond faster and their choices are now become more personalized. One of the major shortcomings of the traditional form of marketing is that, the marketers wouldn’t be able to know how many people saw or heard about their products or services. But with the blessings of digital media marketing they are now able to know the exact statistics about prospective customers. This creates new challenges and opportunities for marketers. Many companies are now taking the advantage of this digital media marketing to market their products and services. The companies are now become more focused on customers and more passionate to understand and satisfy their needs. Digital marketing has created a new momentum in building value based customer relationship.…

    • 1612 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    In this chapter we will study that how more than one factor which is associated with expected return, are evaluated on capital asset pricing model. We have described earlier that beta specifies the inclination level or slope of characteristic line and this is denoted by βj. Extended capital asset pricing model evaluates many factors other than beta, to calculate the expected return of a security. We can add or include some other factors to the equation of expected return of a security, to gain more information about expected returns and the effects of certain financial institutions on securities.…

    • 484 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    The study period was from December 2005 to November 2007. The monthly closing prices of 6 companies (2 companies each from 3 sectors) of companies were taken for testing and moving average was taken to find the return to investor. Lastly Relative strength index analysis was drawn to find the moment of security with index.…

    • 11576 Words
    • 47 Pages
    Powerful Essays
  • Satisfactory Essays

    This is to certify that Mr. Ankit S. Lapsiwala has satisfactorily completed the project work entitled, “Portfolio Management of CNX Midcap Index Companies”. Based on the declaration made by the candidate and my association as a guide for carrying out this work, I recommended this project report for evaluation as a part of the MBA programme of Veer Narmad South Gujarat University.…

    • 25744 Words
    • 103 Pages
    Satisfactory Essays
  • Powerful Essays

    I hereby declare that this Project Report titled EQUITIES AND PORTFOLIO MANAGEMENT submitted by me to the Department of Business Management, O.U., Hyderabad, is a bonafide work undertaken by me and it is not submitted to any other University or Institution for the award of any degree diploma / certificate or published any time before.…

    • 4326 Words
    • 18 Pages
    Powerful Essays

Related Topics