Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.) 1 mark (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. 1 mark (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. 1 mark (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)?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

What is topology? Explain with examples

Answered: 1 week ago