Find the monthly holding period returns for 2016 for Commonwealth Bank

Question 1 (60 marks)

i. Find the monthly holding period returns for 2016 for Commonwealth Bank (CBA), Rio Tinto (RIO) and the market (MKT) as proxied by the All Ordinaries index. The monthly holding period return is the return you would receive if you bought an asset on the first day of the month (opening price) and sold it on the last day of the month (closing price). Using Excel, graph your % return results on one graph with returns on the y axis and time on the x axis to enable comparison between options. (Use ‘Close’ rather than ‘Adjusted Close’ for the selling price) Note: Monthly opening price MUST equal previous month closing price. When calculating return students should use the previous period closing value as the opening value for their next calculation. It is recommended that students use a line graph within the Excel chart options to allow effective comparison of performance between the different securities(15 marks).

ii. For each investment, what is the average monthly holding period return? (6 marks).

iii. For each investment, what is the annual holding period return? (6 marks).

iv. Calculate the standard deviation of the monthly rates of return for each share and the market (9 marks).

v. Using Excel plot your results from (iii) and (iv) above with risk on the x axis and return on the y axis (3 marks).

v. If the 10 year government bond rate is 3.25% and the long term return on the market is 7%, assuming the beta (ß) for CBA is 1.11 and for RIO is 0.95, use the Capital Asset Pricing Model (CAPM) to find the expected returns for CBA and RIO (6 marks).

vi. Construct the Security Market Line (SML) showing where CBA and RIO lie (5 marks).

vii. Based on your findings construct a portfolio made up of 60% CBA and 40% RIO. Calculate the estimated return and ß for this portfolio (4 marks).

viii. Based on your understanding of the CAPM and the SML, which of these asset(s) or portfolio(s) would you invest in and which would you not invest in. Explain your choice (6 marks).

The post Find the monthly holding period returns for 2016 for Commonwealth Bank appeared first on Homeworkacetutors.com.



CLICK HERE TO ORDER THIS PAPER………………………NO PLAGIARISM Get 100% Original papers from the writing experts Logo     CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS……

Comments

Post a Comment

Popular posts from this blog

Create Thread”. Do not create a new forum.

Image
This assignment allows students to develop exam study guides, while also helping classmates. Students have been divided into groups (approximately 4 people in each group). To work with your group, and post the two required postings, go to the Blackboard course website and choose “My Groups” from the left side menu. Click on the group, then, under “Group Tools” click “Group Discussion Board”. For further instructions regarding how to use/post to the discussion board, I have attached instructions to this assignment. Students may only consult, and cite, the textbook, the assigned supplemental readings/video, and the narrated lectures for this assignment.    Part 1: The first part of this assignment is to post to your GROUP DISCUSSION BOARD (not the class discussion board), an open-ended question (requiring more than a yes or no answer) from the chapter you have been assigned. Do not post an answer; just a question. To post, click on the Student Study Guide assignment in your group disc
Read more

Discuss the notion that firms should stop doing business with customers who constantly generate losses versus the notion that the customer is always right.

Image
  Discuss the notion that firms should stop doing business with customers who constantly generate losses versus the notion that the customer is always right.   Assignment status :    Get solution from our writing team CLICK HERE TO ORDER THIS PAPER AT PrimeWritersBay.com PAPER COMPLETED BY OUR WRITING EXPERTS    FREE FROM PLAGIARISM  
Read more

Access AHIMA: What is Health Information

Image
  Reflection Students are encouraged to create portfolios and begin to "manage" their careers. When you began a college education you took the first step. You now need to begin to reflect on the next goal, then medium, and long-term goals. I did not complete my final degree until well into my 50's. And that is fine, I loved my health care career. I was eager to care for patients and did not leave direct patient care for many decades. I did know the time would come to do so however, and began to earn the college degrees I would need at the proper time. This is what is meant by managing your career. This is an entry level program. It is designed to assist you in getting your "foot in the door" where you can learn valuable clinical skills. A common and important degree is the Bachelor of Health Information Management (BS-HIM). This is a reflective assignment. After you have earned your Associate Degree, what would you like to do next? Explore your next step in Care
Read more