View the step-by-step solution to:

Visit the Australian Stock Exchange website, www.au and from "Prices and research" drop-down menu, select "Company information".

Visit the Australian Stock Exchange website, www.asx.com.au and from "Prices and research" drop-down menu, select "Company information". Type in the ASX code "MQG" (Macquarie Group Limited), and find out details about the company. Also, type in the ASX code "PPT" (Perpetual Limited), and find out the details about that company. Both these companies belong to financial sector. Information available in the ASX website will be inadequate for your purpose, you will need to search the internet for more information. Your task will be to get the opening prices of MQG and PPT shares for every quarter from January 2008 to December 2017 (unadjusted prices). If you are retrieving the monthly prices, read the values in the beginning of every Quarter (January, April, July, October) for every year from 2008 to 2017 (Total 40 observations). To provide you with some guidance as to what the unadjusted prices look like, two charts accompany this question obtained from ANZ Share Investing, Australia. After you have researched share prices and financial sector, answer the following questions:

(a)     List all the quarterly opening price values in two tables, one for MQG and the other for PPT. Then construct a stem-and-leaf display with one stem value in the middle, and MQG leaves on the right side and PPT leaves on the left side. (Must use EXCEL or similar for the plot.)                                            

(b)    Construct a relative frequency histogram for MQG and a frequency polygon for PPT on the same graph with equal class widths, the first class being "$0 to less than $10". Use two different colours for MQG and PPT. Graph must be done in EXCEL or similar software.                                            

(c)     Draw a bar chart of market capitals (or total assets) in 2017 (in million Australian dollars) of 6 companies listed in ASX that trade in financials with over AUD500 million in market capital. Graphing must be done in EXCEL or with similar software.                                               

(d) If one wishes to invest in MQG or PPT, what is the market recommendation (for example, from Morningstar, Fatprophets, InvestSmart, etc.)? If you cannot find the information, what would be your recommendation based on your research of these two companies (trend, P/E ratio, dividend yield and Beta)?

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question