Find monthly holding period returns

Assignment Help Financial Management

Reference no: EM132012290

This question relates to material covered in Topics 1-5. This question addresses the 1st, 2nd and 3rd subject learning outcomes.

i. Find the monthly holding period returns for 2016 for National Australia Bank (NAB), BHP Billiton (BHP) 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: Opening price MUST equal previous month closing price.

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.

vi. If the 10 year government bond rate is 2.95% and the long term return on the market is 6.5%, assuming the beta (?) for NAB is 1.23 and for BHP is 0.90, use the Capital Asset Pricing Model (CAPM) to find the expected returns for NAB and BHP.

vii. Construct and graph the Security Market Line (SML) showing where NAB and BHP lie.

viii. Based on your findings construct a portfolio made up of 30% CBA and 70% RIO. Calculate the estimated return and ? for this portfolio.

ix. 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: EM132012290

Questions Cloud

What paradoxe about cultural globalization tyrell illustrate : What paradoxes about cultural globalization does Tyrell illustrate through the case of the Indian cinema industry?

A conflict resolution or problem solving method : Based on this topic's readings, select a model for conflict resolution or problem solving that you will use to resolve this conflict.

Decide whether to overhaul tractor and scraper or replace it : Bumps Unlimited, a highway contractor, must decide whether to overhaul a tractor and scraper or replace it.

What were the results of your decisions : What were the results of your decisions? What changes will you make in future quarters? Please insert a screen shot of the Quarter #1 results in your paper.

Find monthly holding period returns : Find monthly holding period returns for 2016 for National Australia Bank (NAB), BHP Billiton (BHP) and the market (MKT) as proxied by the All Ordinaries index.

Effective for some smaller businesses : Micro-marketing strategy even though it can be effective for some smaller businesses, can larger businesses benefit from the same strategy?

Develop a set of questions to be asked during interview : Develop a set of questions to be asked during an in-depth interview of a professional in the field of child and/or family development.

What is a communication plan : What is a communication plan? What are the different forms and how can you use this for an organization involving changing their management?

Judge braden of the court of federal claims : What is the citation from the official reporter for the 2008 case citation in which Judge Braden of the Court of Federal Claims granted the protester

User Account

All Pages