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

  Differences in the financial ratios

Why might you expect to see differences in the financial ratios (E.g., debt ratios, current ratios, ROE, ROA) of firms in the banking versus the automotive industries?

  What effect did this eventually have on the money markets

What was the purpose motivating regulators to impose interest ceilings on bank savings accounts? What effect did this eventually have on the money markets?

  Purpose of internal and external assessments

Explain the four functions of management and the purpose of internal and external assessments. How would you convince upper management about the importance of internal and external assessments?

  Prepare a frequency distribution for pete

Pete's Variety Shop reported the following sales for the first 20 days of May. Prepare a frequency distribution for Pete.

  Do you suggest rajan to purchase the share

From the fifth year onwards, dividends are expected to grow at a normal rate of 12% per annum. If the required rate of return of Mr. Tiwari is 14% per annum, do you suggest him to purchase the share at the current price.

  Steps of the capital budgeting process

Discuss the pros and cons of applying different investment decision rules when faced with the choice of investing corporate funds. Provide at least two examples.

  What is new yorks fastest-growing category of expenditures

Answer Question 2 based on the review of the New York City Financial Plan: What is New York City's fastest-growing category of expenditures during the planning period? Justify the answer with examples.

  Manage credit analysis

Milford Bank and Trust Company is revamping its credit management department to more effectively manage credit analysis. As the credit manager for the bank, draft a 750-word report for the board of directors explaining the three C's of credit. Mak..

  What is the expected return on the market

If the risk-free rate is 2.5%, beta of the asset is 1.57, and the expected return of the asset is 13.25%, what is the market risk premium?

  Irrational inc is obligated to pay its creditors 7500

irrational inc. is obligated to pay its creditors 7500 during the year.a. what is the value of the shareholders equity

  Compute depreciation charge

Pemberton Corporation bought a machine costing $300,000 that had an estimate useful life of 6-years and residual value of $18,000. The machine is expected to produce 3,525,000 units during its useful life;

  What does the coefficient of variation reveal

What does the coefficient of variation reveal about an investment's risk that the standard deviation does not?

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