Explain what is the average monthly holding period return

Assignment Help Accounting Basics

Reference no: EM131617621

Assignemnt

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.

ii. For each investment, what is the average monthly holding period return?

iii. For each investment, what is the annual holding period return?

iv. Calculate the standard deviation of the monthly rates of return for each share and the market.

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

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.

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

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

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.

Reference no: EM131617621

Questions Cloud

Critique the interpersonal communication : How did you think the woman with cancer, Tracey Miller, perceived herself? How do you think the representative, Sheila Jackson-Lee, perceived herself?

Discuss non experimental research methods : Discuss the advantages and disadvantages of the following non experimental research methods

What is the effective tax rate : What is the correctly calculated corporate income tax for the company? What is the effective (average) tax rate?

Mainstream workplace environment : The individual is of a cultural background that is perceived as very different from the mainstream workplace environment.

Explain what is the average monthly holding period return : For each investment, what is the annual holding period return and what is the average monthly holding period return?

Discuss examples of when a naturalistic observational study : Discuss examples of when a naturalistic observational study would be the most appropriate design to select

Explain the concept of the operational auditing : The primary difference between operational auditing and financial auditing is that in operational auditing.

The social worker would only be interacting with ruth : the social worker would only be interacting with Ruth, how would the social worker respond and what theories would be guiding him/her

What needs to be done to improve morale on the first shift : If you were the vice president (VP) of operations, how would you ensure that Carl understands what needs to be done to improve morale on the first shift?

User Account

All Pages