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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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