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

  Describe an incentive conflict in your company

Describe an incentive conflict in your company. What is the source of the conflict, and how is it being controlled? Could you control it in a less costly way?

  Value of the stock for that investor

a. If the market's required yield is 1111 percent, what is the value of the stock for that investor? b. Should the investor acquire the stock?

  The expected return on the market is 14 and the yield on us

dexter inc. has just paid a dividend of 2.00. its stock is now selling for 48 per share. the firm is half as volatile

  Compute the present value of a perpetuity

1.Compute the present value of a perpetuity that pays $ 7,142 annually given a required rate of return of 8 percent per annum. (Round your answer to 2 decimal places; record your answer without commas and without a dollar sign).

  What price per bond should suresafe be able

It estimates that, in current market conditions, the bonds should provide a (nominal annual) return of 14 percent. What price per bond should Suresafe be able to realize on the sale?

  You must understand how the income statement balance sheet

harvard business publishing working capital simulation managing growth assignmentacting as the ceo of a small company

  Gains from selling futures

Gains from Selling Futures: -Explain how sellers of financial futures contracts can offset their position. - How is their gain or loss determined?

  What volume of patients per month

If the center needs to make a profit of $75,000 per month, what is the new volume per month?

  Dividend payments are expected to continue

Dividend payments are expected to continue at 60% of earnings. (Assume that rr = rs.). Calculate the after-tax cost of debt. Calculate the cost of preferred stock. Calculate the cost of common stock. Calculate the WACC for Dillon Labs.

  What is the hospital corporate cost of capital

St Vincent's Hospital has a target capital structue of 35 percent debt and 65 percent equity. its cost of equity(fund capital) estimate is 13.5 percent and its cost of tac -exempt debt estimate is 7 percent. what is the hospital's corporate cost o..

  A companys current stock price is 8510 and it is likely to

a companys current stock price is 85.10 and it is likely to pay a 4.10 dividend next year. since analysts estimate the

  Cost an investor to buy a long strangle

What will it cost an investor to buy a long strangle today?

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