Calculate monthly hprs using the adjusted closing prices

Assignment Help Finance Basics
Reference no: EM131208556

Learning Outcomes

This assignment has been structured in accordance with the following Graduate Attributes:
- Ability to demonstrate the quantitative skills taught in the unit.
- Use of computing skills to effectively present information.
- Ability to apply theoretical and statistical concepts in analysing information.
- Ability to apply critical thinking.
- Ability to provide recommendations based on research results.

General Instructions

i. Each student should select two companies from the excel file (ASX 100 Constituents by GICS.xlsx) available on blackboard under Assignment Instructions for the assignment. These two companies must belong to two different GICS. The companies have been selected from the top 100 listed firms trading on the Australian Stock Exchange.

ii. Your task in Part -A is to utilise the quantitative methods covered in the unit to demonstrate your analytic skills. This part has a weightage of 60% of the total assignment.

iii. You are required to submit a report along with an excel worksheet for Part-A of the assignment. For example, Q1(a) in part-A should have the HPRs and the Plot along with the formula used to calculate the returns.

iv. Part-A will be submitted via blackboard assignment submission. The specific link will be made available under Assignment on Blackboard.

v. Part B tests your research skills and requires you to write an essay on specific topics with some real world examples. This part has a weightage of 30% of the total assignment (10% weightage is for overall presentation of your final report and excel workbook). You are required to submit a separate report for Part-B of the assignment.

vi. Part B will be submitted via Turnitin. The specific link will be made available under Assignment on Blackboard.

vii. For timely completion, the assignment requires both Part-A and Part-B completed simultaneously.

viii. Observe ECU referencing conventions. Failure to acknowledge work from others is a serious act of Academic Misconduct and carries severe penalties. Apply in-text and end-text referencing methods as set out in the ECU Referencing guide.

ix. Your Turnitin similarity score for Part-B should be no more than 30%. Avoid taking direct quotations from your reference material as this will increase the score. Good writing and communication is evidenced by a student's ability to paraphrase their readings.

x. Ensure your final report is written and presented well. You should aim to produce high-quality work consistent with professional standards.

Part-A Quantitative Skills

You are required to perform quantitative analysis on two Australian company included in the S&P/ASX 100 Index over a period of two years, i.e. from July 2014 to June 2016. The list of companies is given in the file ASX 100 Constituents by GICS.xlsx available on blackboard under Assignment Instructions-ECF2226.2016.1. These two companies must belong to different GICS.
This part requires you to model/calculate all the solutions using excel and also present the results in a word file. The final submission requires a document (pdf or word file) and the excel workbook.

Question-1: HPR, AAR and GAR.

Select one company from the list and download monthly prices from July 2014 to June 2016 from DatAnalysis database and save the data in an excel workbook. You can select any company from the list. Calculate the following in an excel workbook and also copy paste the final answers in the Part-A document.

a) Calculate monthly HPRs using the adjusted closing prices for the company during the two year time period. Plot these results on a line graph.

b) Calculate the following summary statistics for your returns
i. Variance and Standard Deviation
ii. Minimum and Maximum returns

c) Calculate the Arithmetic Average and Geometric Average returns for the company.

d) Assume you had a savings of $50,000 and had invested the money in your selected company at the beginning of the period. Calculate the number of shares you bought given the brokerage fee of $30 for every transaction (buying or selling).

e) You decided to hold your position for these two years and now decide to sell your shares in the market. Calculate the amount you will gain or lose based on the last market price of the share. You must adjust the amount for brokerage fee as given in (d).

Question-2: Daily Value at Risk

Select another company from a different GICS than the company selected in Question-1 and download daily stock prices (adjusted closing prices) from 1 July 2014 to 30 June 2016 for both the companies. The data can be downloaded from Yahoo Finance or DatAnalysis for both companies. You must mention the source in your solutions and use only one source for both stocks.

a) Calculate the daily 1% and 5% Parametric VaR (based on normal distribution) along with 1% and 5% Historical VaR for time series returns for both the stocks.

b) Suppose you invested $50,000 each in both stocks. Express the VaR calculated in (a) as Dollar-VaR and compare the VaR for both stocks.

Question-3: Portfolio Selection

Use the daily stock returns calculated in Question-2 for the two stock and calculate the following

a) Correlation and Covariance for the stock returns
b) Use various weight combination to plot an efficient frontier.
c) Minimum Variance Portfolio weights for the portfolio with these two stocks.

Question-4: The Capital Asset Pricing Model

Download daily stock index values for ASX-All Ordinaries for the same period as of the two stocks. The data can be downloaded from Yahoo Finance, Google Finance, Quandl etc1. You must mention the source in your solutions. Assuming the risk free rate of 2.25% per annum;

a) Calculate the value of ?? for both the stocks using regression analysis.
b) Plot the security characteristic line for both the stocks.
c) Compare the level of market risk ?? of both of your stocks.

Part-B

Write an essay on the following topics. The maximum page limit for this part is 6 pages, excluding references. You are required to paraphrase the relevant literature to demonstrate your understanding of these topics. You should be able to refer to relevant literature and other material using ECU referencing guidelines.

The final submission requires a document (pdf or word file) submitted via the Turnitin link.

1. Modern Portfolio Theory

Write a short note on Modern Portfolio Theory and minimum variance portfolio. Discuss the benefits of efficient diversification with examples from Part A (Question-3) and other sources.

The discussion should highlight the benefits of diversifications as a result of MPT. The actual Markowitz portfolio model should be presented with all important formulas/equations with a thorough understanding of all the components. You must discuss the results of

Question-3 (Part-A) as an example.

2. The Capital Asset Pricing Model

Discuss the Capital Asset Pricing Model with examples from Part A and other sources.

You should be able to critically examine the Capital Asset Pricing Model and discuss the results from Question-4 (Part A) as an example. The discussion should include the major assumptions and components of CAPM and its advantages over MPT.

3. The CAPM and Multifactor Models

Discuss the Fama-French factor model. Compare and contrast CAPM and the Fama-French three factor model.

You should discuss the Fama French factor models including its components and major results. There should be a clear understanding of all the risk factors included in the Fama-French Model and its major assumptions. The discussion should compare The Fama French Model with the CAPM.

Attachment:- ASX-100-Constituents-by-GICS.xlsx

Reference no: EM131208556

Questions Cloud

What is the mrs at the optimal consumption bundle : Assume that you can spend a budget of $18.50 on two products, Apples and Bananas. What is the MRS at the optimal consumption bundle
Give an example of a time when social influencers affected : Write a paper of approximately 250 words in response to these statements: Give an example of a time when social influencers affected your buying decision. Give an example of a time when individual influencers affected your buying decision.
Calculate the rated power of the transformer bank : Three single-phase transformers, each is rated at 10 kVA, 400/300V are connected as wye- delta configuration.
How would you handle an unhappy client : What is the relationship between the account management team and the client? What is the relationship between the account management team and the other teams within an agency?
Calculate monthly hprs using the adjusted closing prices : ECF2226 Investment Finance - Calculate monthly HPRs using the adjusted closing prices for the company during the two year time period. Plot these results on a line graph.
Compute the voltage of the secondary winding : A single-phase transformer has a turns ratio of 10,000/5,000. A direct current voltage of 30V is applied to the primary winding, compute the voltage of the secondary winding.
An early extinguishment of bonds payable : An early extinguishment of bonds payable, which were originally issued at a premium, is made by purchase of the bonds between interest dates. At the time of reacquisition, A debt instrument with no ready market is exchanged for property whose fair ma..
Calculate average voltage across the load : A resistive load of 5Ω is connected to an ac source of 120V (rms) through a back-to-back SCR circuit (two parallel SCRs, with the anode of each one connected to the cathode of the other).
Create learning goal statement to address healthy nutrition : Create a learning goal statement to address the healthy nutrition, preparing food, and exercise. - Describe how you will know if the goal(s) of your learning statement has been met.

Reviews

len1208556

9/16/2016 3:19:15 AM

Question-2 Discuss the Capital Asset Pricing Model with examples from Part A and other sources. You should be able to critically examine the Capital Asset Pricing Model and discuss the results from Question-4 (Part A) as an example. The discussion should include the major assumptions and components of CAPM and its advantages over MPT. Demonstrates the capacity to conduct relevant and wide research. Follows ECU Referencing convention for in-text and end-text citations Question-3 Discuss the Fama-French factor model. Compare and contrast CAPM and the Fama-French three factor model. You should discuss the Fama French factor models including its components and major results. There should be a clear understanding of all the risk factors included in the Fama-French Model and its major assumptions. The discussion should compare The Fama French Model with the CAPM. Demonstrates the capacity to conduct relevant and wide research. Follows ECU Referencing convention for in-text and end-text citations

len1208556

9/16/2016 3:19:09 AM

Question-1 Write a short note on Modern Portfolio Theory and minimum variance portfolio. Discuss the benefits of efficient diversification with examples from Part A (Question-3) and other sources. The discussion should highlight the benefits of diversifications as a result of MPT. The actual Markowitz portfolio model should be presented with all important formulas/equations with a thorough understanding of all the components. You must discuss the results of Question-3 (Part-A) as an example. Demonstrates the capacity to conduct relevant and wide research. Follows ECU Referencing convention for in-text and end-text citations

len1208556

9/16/2016 3:18:37 AM

Question-2 a) Calculate the daily 1% and 5% Parametric VaR (based on normal distribution) along with 1% and 5% Historical VaR for time series returns for both the stocks. b) Suppose you invested $50,000 each in both stocks. Express the VaR calculated in (a) as Dollar-VaR and compare the VaR for both stocks. Question-3 a) Correlation and Covariance for the stock returns b) Use various weight combination to plot an efficient frontier. c) Minimum Variance Portfolio weights for the portfolio with these two stocks. Question-4 a) Calculate the value of ß for both the stocks using regression analysis. b) Plot the security characteristic line for both the stocks. c) Compare the level of market risk ß of both of your stocks.

len1208556

9/16/2016 3:18:29 AM

Question-1 a) Calculate monthly HPRs using the adjusted closing prices for the company during the two year time period. Plot these results on a line graph. b) Calculate the following summary statistics for your returns i. Variance and Standard Deviation ii. Minimum and Maximum returns c) Calculate the Arithmetic Average and Geometric Average returns for the company. d) Assume you had a savings of $50,000 and had invested the money in your selected company at the beginning of the period. Calculate the number of shares you bought given the brokerage fee of $30 for every transaction (buying or selling). e) You decided to hold your position for these two years and now decide to sell your shares in the market. Calculate the amount you will gain or lose based on the last market price of the share. You must adjust the amount for brokerage fee as given in (d).

Write a Review

 

Finance Basics Questions & Answers

  Conduct extensive research on a publicly traded company

Required to conduct extensive research on a publicly traded company and submit a written analysis of that company.-

  What is the present value of the following uneven cash flow

directions answer the following questions on a separate document. explain how you reached the answer or show your work

  Effective interest rate be for these loans

The 2ndTD is for $125,000 @ 7.5% interest, 30/15 and the 3rd. TD is for $25,000 @ 9.0% interest only for 5 years. You are to work up the payment for all 3loans. Plus, what would the "effective" interest rate be for these loans?

  How much interest would you be paying in year 2

Your bank offers to lend you $100,000 at an 8.5% annual interest to start your new business. The terms require you to amortize the loan with 10 equal end-of-year payments. How much interest would you be paying in Year 2? Explain.

  Compute the forward discount or premium

Evaluate the forward discount or premium for the Mexican peso whose 90-day forward rate is $.102 and spot rate is $.10. State whether your answer is a discount or premium.

  Calculating the number of periods

Calculating the Number of Periods. Calculating Rates of Return. In 2011, an 1880-O Morgan silver dollar sold for $13,113. What was the rate of return on this investment?

  Financial manager researching investments

Imagine that you are a financial manager researching investments for your client that align with its investment goals. Use the Internet to research any U.S. publicly traded company that you may consider as an investment opportunity for your c..

  Options to be as profitable as an investment in the stock

The price of a stock is $36 and the price of a three-month call option on the stock with a $36 strike is $3.60

  Explain how rights differ from power or force and from

explain how rights differ from power or force and from

  Purchase and the sale of securities

The advance/decline line is be used to time both the purchase and the sale of securities.

  Church inc is presently enjoying relatively high growth

3. tco d church inc. is presently enjoying relatively high growth because of a surge in the demand for its new product.

  How much would you be willing to pay to purchase it

Given the following cash flow pattern, how much would you be willing to pay to purchase it? Assume an 8% APR discount rate.

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