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 “NAB” (National Australia Bank), and find out details about the company. Also, type in the ASX code “WBC” (Westpac Banking Corporation), and find out the details about that company. 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 NAB and WBC shares for every quarter from January 2009 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 2009 to 2017 (Total 36 observations). After you have researched share prices, answer the following questions: (a) List all the quarterly opening price values in two tables, one for NAB and the other for WBC. Then construct a stem-and-leaf display with one stem value in the middle, and NAB leaves on the right side and WBC leaves on the left side. (Must use EXCEL or similar for the plot.) 1 mark (b) Construct a relative frequency histogram for NAB and a frequency polygon for WBC on the same graph with equal class widths, the first class being “$14 to less than $16”. Use two different colours for NAB and WBC. 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 similar products or do similar business as NAB or WBC with at least AUD50 million in market capital. Graphs must be done in EXCEL or with similar software. 1 mark (d) If one wishes to invest in NAB or WBC, 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, debt and Beta)? 1 mark
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Order Over WhatsApp
Place an Order Online