Purpose This task develops and evaluates student understanding and application of securities valuation, optimal investment decisions and modern portfolio theory

ByadminQuest

Purpose

This task develops and evaluates student understanding and application of securities valuation, optimal investment decisions and modern portfolio theory

Description

Students apply critical thinking and problem solving to answer four problem questions that require numerical calculation and clear written communication of results.

Assessment Criteria

The assignment will be graded against the following five (5) criteria:

  • Correct calculations.
  • Depth and relevance of analysis.
  • Logic and coherence in information evaluation and organisation.
  • Demonstrated understanding of theory and relevant concepts
  •  Clarity of written expression in communicating outcomes Topics Covered: Module 3 (Modern Portfolio Theory)

Write My Assignment

Hire a Professional Essay & Assignment Writer for completing your Academic Assessments

Native Singapore Writers Team

  • 100% Plagiarism-Free Essay
  • Highest Satisfaction Rate
  • Free Revision
  • On-Time Delivery

Tasks: This assessment involves undertaking four (4) main tasks as follows:

Task 1: Calculating Equity Beta 

Select a company (we shall call this Equity A) listed on a major stock exchange. Ensure that you can access and download historical share price data for the selected company and an appropriate benchmark (market) index. There are various sources of data available (for free) online, such as Yahoo Finance. Download the data (usually this downloads as a .csv file) and save it into an Excel Workbook.

a) Using Excel, calculate the returns on your selected equity and the benchmark index over the last 4 years (2 marks).

b) Calculate the Beta for your selected equity

c) Comment on the performance of your chosen company and the implications of the estimated Beta

d) Discuss potential problems associated with how you have calculated your Beta

Task 2: Calculating 3-Asset Portfolio Metrics (9 marks)

Select and download historical data (for the last 4-years) on the share prices of two additional companies (we shall call these Equity B and C) listed on the same stock exchange as Equity A. You now have data for three equities, which represent your 3-asset portfolio.

a) Calculate the individual returns, variance and standard deviation of returns on your (three) selected equities (note: you have already calculated the returns on Equity A in Task 1)

b) Calculate the covariances and correlation coefficients between your equities

c) Assuming an equally-weighted portfolio, calculate the portfolio rate of return, variance and standard deviation

Task 3: Evaluating Portfolio Risk and Performance

a) Calculate the Beta for your equally-weighted 3-asset portfolio (i.e. containing Equity A, B and C).

b) Utilising appropriate measures of portfolio performance, comment on the performance of your portfolio and the implications of the estimated portfolio Beta.

c) If you believe the stock market will begin to drift downwards over the next year, explain how you might ‘fine-tune’ your 3-asset equity portfolio to help safeguard investors’ wealth under your management? Assume that your fund can only invest in equities

Task 4: Individual Equity Selection 

Based on the preceding analysis, if you are only allowed to pick one equity (A, B or C) for investment, which asset will you prefer as a rational investor? Explain your reason(s)

Similar Posts

Assignment help- You have fine-tuned your identification of goals and objectives for both your targeted program and the evaluation you are prescribing. Your peers and supervisor have encouraged you to build

ByadminQuest

Exam Content You have fine-tuned your identification of goals and objectives for both your targeted program and the evaluation you are prescribing. Your peers and supervisor have encouraged you to build your presentation for the stakeholder’s meeting by spending more time on the implementation plan. Your goal is to prepare an additional 15–20 slides (with…

You have recently started a position as a department director with five managers reporting to you. Earlier today, one of your managers reports that a client expired on her unit. She suspects that a factor that may have contrib

ByadminQuest

ScenarioYou have recently started a position as a department director with five managers reporting to you. Earlier today, one of yourmanagers reports that a client expired on her unit. She suspects that a factor that may have contributed to the client’s demise maybe related to the actions of a nurse on her unit. This nurse…

RESEARCH PROPOSAL FORM – ABERTAY MBA PROGRAM Note: The Research Proposal will be the foundation of the research work being undertaken by the student. The Proposal will be approx. 1500 words; the distributio

ByadminQuest

RESEARCH PROPOSAL FORM – ABERTAY MBA PROGRAM Note: The Research Proposal will be the foundation of the research work being undertaken by the student. The Proposal will be approx. 1500 words; the distribution of word count for each section is given below against each section title. The research plan, annotated bibliography, timelines and the references…

Assignment Help- define the patient, family, or population health problem that will be the focus of your capstone project. Assess the problem from a leadership, collaboration, communication, change management, and policy perspective. Plan to spend approximately 2 direct practicum hours meeting

ByadminQuest

n a 5–7 page written assessment, define the patient, family, or population health problem that will be the focus of your capstone project. Assess the problem from a leadership, collaboration, communication, change management, and policy perspective. Plan to spend approximately 2 direct practicum hours meeting with a patient, family, or group of your choice to…

Strategy, Financing, HRIS, and Putting It All Together For this module’s SLP assignment, you will prepare a PowerPoint presentation that is similar in content to what an entrepreneur would present to a group of potential investors

ByadminQuest

Strategy, Financing, HRIS, and Putting It All Together For this module’s SLP assignment, you will prepare a PowerPoint presentation that is similar in content to what an entrepreneur would present to a group of potential investors. You will cover only one area of your Business Plan that the potential investors have concerns about: a strategic…

UNV 103 Choose three of these strategies and discuss how they will help your personal budget?

ByadminQuest

Grand Canyon University UNV 103 Choose three of these strategies and discuss how they will help your personal budget?-Step-By-Step Guide This guide will demonstrate how to complete the Grand Canyon University UNV 103 Choose three of these strategies and discuss how they will help your personal budget? assignment based on general principles of academic writing….