Finance-AW223

Finance-AW223 Online Services

 

Portfolio Management
 

Instructions
 
1. This is a group assignment. Each group will consist of three students and each group will submit one joint report.
 

2. In doing this assignment, you are encouraged to refer to the texts, the reading material in Blackboard and any other material that may assist you in understanding what you are doing in this assignment. Group members are expected to actively discuss and work among themselves but not refer to the work of any other groups. Any collusion of this form will be treated seriously and penalised.
 

3. Please ensure that each member in a group makes an equal contribution to the assignment, as far as possible. Free riders should be reported to me and may be penalised.
 
4. You are expected to make this assignment an opportunity to develop you spreadsheet computational skills. Make use of Excel or any other computer spreadsheet of your choice to do your calculations and graphs.
 

5. Assignments must be typed and neatly presented in a professional report format. The results or summaries of your calculation and your comments must be shown in the body of the report. Make sure the formulas or methods used for your computations are clearly shown. The data collected and details of calculations can be shown as appendices to the report. Make your report look professional and reader friendly. The length of the report should not exceed 10 pages (Excluding the appendix). Use 12 point font size and standard margins.
 

6. Ensure that you give adequate cross references to the sources from which you have gathered data or information in compiling your report.
 
7. The criteria used in assessing your marks on this assignment will include:
 

Computational accuracy
 
Relevance and accuracy of the interpretation of results,
Demonstration of your understanding of the underlying theory,
Neatness and style of presentation.
 

Pick three stocks of your choice (Select stocks listed in the ASX or any other national Exchange), preferably from different industry groups. Go to the recommended websites or any other website that offers historical stock price data or to published information sources such as Yahoo Finance, or any other source of financial information. Extract weekly (for example, every Friday) closing share prices for the most recent 28 weeks
 

Extract also the values of the stock market index, (represented by the ASX 300 or ASX 200 Index in the case of Australia), on a weekly basis over the same time period.
 

Calculate the following
 

Part 1
 
(a) The rate of return in each week for each stock and for the stock market index for the 27 weekly periods. Calculate the discrete rate of return as well as the continuously compounded rate of return. Calculate the arithmetic mean return and the geometric mean return of each stock for the entire period. Use only the discrete returns for your calculations and for the calculations in the questions that follow.
 
(b) The variance of returns for each stock and the index and the covariances of returns between each pair of stocks, the covariance between each stock and the stock market index, and the corresponding correlation coefficients.
 

(c) Compare your results in (a) and (b) for each stock and the stock market index and comment on the risk return characteristics and performance of each of your stocks and the index. Illustrate with tables/charts as appropriate. Comment on the results, relating to what you have learnt in this course. Relate the risk return pattern and the performance of the market index and your stocks to relevant events that took place during this period. Draw on economic, political, industry and company related events that took place over this period that may have impacted on the performance of your stocks and the market index. Give bibliographic references to the sources of your information.
 

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

 

Part 2
 

(a) Based on the discrete returns calculations in Part 1, compute the weekly rate of return and the variance of an equally weighted portfolio formed from the three stocks. Make use of your knowledge of matrix algebra in your calculations.
 
(b). Examine and compare the pattern of the returns of your portfolio with those of the individual stocks, and the stock index. Compare the corresponding variances. Comment on your observations, relating to material learnt in this course.
 
Part 3
 
(a) Extract for each week, the yield of the 26-week Treasury bill (or equivalently the 90 day or 180-day bank accepted bill (BAB) rate) from the financial media (i.e. RBA website http://www.rba.gov.au/statistics/tables/index.html#interest_rates) over your sample period. (Remember that reported yields are usually annualised figures.) Convert the yields to weekly numbers. Use these as a proxy for the risk free rate.
 

(b) Estimate the Security Characteristic Line (SCL) for each of your stocks and the equal weighted portfolio, based on the ‘Market Model’, using excess returns (discrete returns less the risk free rate), using Excel regression analysis functions. Show your results graphically. From your results, compute the Beta and the Jensen’s Alpha of each stock and the portfolio.
 
(c) Calculate the total risk (the return variance) of each stock and the portfolio. Partition the total risk to their respective systematic and unsystematic risk components.
 
(d) Based on your observations and results in parts (b) and (c) above, comment on each of your stock’s and portfolio’s performance, and on their risk characteristics, comparing and contrasting the magnitude and the proportions of their systematic and unsystematic risk components. What further insights can you gain on the characteristics and behaviour of your stocks and portfolio compared to the analysis and observations you made in Part 1 (c) and Part 2 (b)?
 

Part 4
 
From the point of view of an investor who wishes to evaluate whether the stocks that you examined are worth investing in, how useful was the analysis you carried out on these stocks? What limitations do you see in your analysis and results for investment decision making purposes? What further analysis would you wish to carry out? Explain briefly.
 
product code: Finance-AW223
 
Looking for best Finance-AW223 online ,please click here
 

Summary