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
- Which of these are ways in which Big Data creates value ?
- Darrin is a good piano player . When he is alone and bored his arousal is low and he often gets distracted and makes mistakes . When he is in a recital with
- United Borova Laboratories Inc . has a national competitive advantage in the pharmaceutical industry . This means that the country