Compute the individual monthly returns

Assignment Help Finance Basics
Reference no: EM131348481 , Length: word count:2500

Assignment

Q1. Pick any three companies with shares currently listed on the ASX that have been trading for at least five years. Go to DatAnalysis (accessible via Deakin Library website) and download the adjusted month-end closing stock prices of these companies for the previous 61 months ended 31/10/2016 onto a MS Excel spreadsheet. Use the downloaded data and perform necessary calculations to answer the questions a) to c):

a) Compute the individual monthly returns, average monthly return, variance and standard deviation of the monthly returns for the stocks of the companies you have chosen.

b) Using the various statistics calculated in a), state which stock has the highest return, which stock has the highest total risk and which one has the highest return per unit of total risk.

c) Would the stock with the highest total risk in b) necessarily be the 'riskiest' of the three stocks? Discuss the components of total risk and circumstances in which you can minimize your portfolio risk.

Go to Yahoo Finance and download the adjusted month-end closing value of the ASX All Ordinaries Index (AORD) for last 61 months ended 31/10/2016. Perform necessary calculations to answer questions d) to f):

d) Use the month-end adjusted closing values of the AORD to compute individual monthly returns on the market index.

e) Briefly describe the beta estimation process as per the CAPM. Using the information in d) along with the individual monthly returns on each of the three stocks calculated in a), estimate their betas. What do these betas tell you about the riskiness of these three stocks relative to the market? Assuming a 2% p.a. risk-free rate, calculate the expected return on each of the three stocks using CAPM.

f) What would happen to the expected rates of return for a risk-free rate of 3.5% per annum? What would they be if the risk-free rate was 1.5%? Explain your observations in light of the risk-return relationship.

Q2. Assume you are a finance manager, you have a chance to implement a research project or further study a PhD, you need to write a short research proposal (no more than 3 pages) to apply funding or scholarship. What topic will you investigate? It needs to be fresh, cutting-edge, significant and fascinating by conducting some literature review using academic journals (Please see the List of Recommended Journals and Tips for Research Proposal).

Attachment:- Assignment.rar

Reference no: EM131348481

Questions Cloud

Effect on the size of the money supply : When the reserve requirement is increased, what is the effect on the size of the money supply? What is the practical justification of the reserve requirement, besides as a monetary policy tool?
Determine the isentropic pressure ratio of the engine : Determine the isentropic pressure ratio of the engine.- The isentropic compression ratio of the engine.- The isentropic outlet temperature of the engine's compressor.
Calculate the charge stored in the 8 µf capacitor : Three capacitors, of 6 μF, 8 μF and 10 μF respectively are connected in parallel across a 60 V supply.
Determine the net work output of the cycle in btu : The compressor pressure ratio is 12.0 and the turbine inlet temperature is 2500.°F. Using the hot air standard cycle analysis, Determine the Net work output of the cycle in Btu/hr and MW.- Hot ASC thermal efficiency of the cycle.
Compute the individual monthly returns : MPF753 T3 2016 - Assignment. Compute the individual monthly returns, average monthly return, variance and standard deviation of the monthly returns for the stocks of the companies you have chosen
Determine the p.d. across this capacitor : Determine the p.d. across this capacitor if the supply voltage between terminals AB is 500 V.
Different examples of economies in the world : Although there are many different examples of economies in the world, all of them demonstrate one or more of the four basic types of market structure. For this assignment, in your own words,
Compute the future value : Compute the future value of $2,000 compounded annually for 20 years at 4 percent. Compute the future value of $2,000 compounded annually for 15 years at 10 percent.
Determine the compression ratio : Determine the compression ratio, CR, The temperature at the end of the compression stroke.- The thermal efficiency of the cycle.

Reviews

len1348481

1/10/2017 3:49:56 AM

Q2 Analysis, proposal, discussion, literature review & referencing -- DGLO1: Discipline - specific knowledge and capabilities DGLO3: Digital Literacy -- The topic is clearly introduced and it is new and interesting! Well identified the important research gap and logically discussed significant research idea. They are logically supported by the evidence and the process of analysis. A number of strong contributions and significance were well identified, discussed and specifically related to the topic. Sources are broadly cited when specific statements are made. Uses appropriate, relevant, and compelling content to illustrate mastery of the subject. Clear evidence of accessing relevant information sources to identify hypotheses or expected outcomes. The proposal flows in a smooth and excellent manner. Transitions fluently and exceptionally tie paragraphs together. Writing is very crisp, clear, and succinct. Uses language that skillfully and effectively communicates meaning to readers with clarity and fluency, and is virtually error-free. There is excellent citation of relevant literature. Referencing is excellent and wholly consistent.

len1348481

1/10/2017 3:49:49 AM

1d) Data acquisition & calculation -- DGLO3: Digital Literacy -- Prescribed data on the end-of-month AORD values have been collected and presented professionally. Calculation of the individual monthly returns on the AORD is correct and methodology is correct with immaculate explanation. 1 e) Calculation & interpretation -- DGLO1: Discipline - specific knowledge and capabilities -- Provides an excellent description of the beta estimation process. Betas are calculated correctly and the calculation methodology is exactly appropriate. The beta measure is interpreted correctly. The calculations of expected return are correct and correctly applies the CAPM.

len1348481

1/10/2017 3:49:39 AM

1 a) Data acquisition & calculation -- DGLO3: Digital Literacy -- Prescribed data on the end-of-month stock prices has been collected and presented professionally. Calculation of the monthly stock returns is correct and the methodology is appropriate and explained very well. Provides a response that demonstrates outstanding ability to perform the prescribed statistical calculations. 1 b) Identifying financial information -- DGLO1: Discipline- specific knowledge and capabilities -- All three financial measures have been correctly identified, calculated and also briefly explained. c) Explanation -- DGLO1: Discipline - specific knowledge and capabilities. Required explanation is given in a manner that is not only exactly correct but also evidently erudite.

Write a Review

Finance Basics Questions & Answers

  What is the formula for calculating residual income

What is the formula for calculating residual income? I have sales #'s, invested capital #'s, net operating profit after taxes #'s and minimun required return percentage.

  Determine gibson cost of capital and required rate of return

Determine Gibson's cost of capital and required rate of return for the joint venture in Brazil. Determine the discrete probability distribution of Gibson's Net Present Value for this joint venture and calculate the Expected Net Present Value. Would y..

  Calculate the data point

a)The z-score that corresponds to a particular data point (x) is 1.42. Calculate the data point. Give your answer to 2 decimal places.

  Net present value at an percent discount rate

a. What is the net present value at an 8 percent discount rate? b. What is the internal rate of return? c. In this problem, would you make the same decision under both parts a and b?

  Specifically the entire forward curve is more volatile

natural gas prices exhibit seasonal volatility. specifically the entire forward curve is more volatile during the

  You are buying a bond at a clean price of 1180 the bond

you are buying a bond at a clean price of 1180. the bond has aface value of 1000 a 9 percent coupon and pays interest

  What happens to roe for firm u and firm l if ebit falls to

assume you have just been hired as a business manager of pizzapalace a regional pizza restaurant chain. the companys

  What would your index rate of return be

You have accumulated data on three stocks (see below). You have decided to use the information on these stocks to form an index. You want to find the average earned rate of return for 2011 on your index.

  Determine the expected return and beta for the portfolio

Multiple choice questions using beta, expected return and bond values and determine the expected return and beta for the portfolio.

  Evidence against the null hypothesis

Why do very small p-values indicate that the evidence against the null hypothesis is strong?

  The strategy underlying price discrimination

The strategy underlying price discrimination is a. to charge higher prices to customers who have good substitutes available to them.

  Discuss the five elements of negotiations

Discuss the following statements then respond to at least two of your fellow students' posts. a. Discuss the Five Elements of Negotiations and provide at least one example of how each are used in the negotiation process.

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