Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Visit the Australian Stock Exchange website at www2.asx.com.au. Type in the ASX code AGL (AGL Energy Limited), and find out details about the company. Also,

image text in transcribed
Visit the Australian Stock Exchange website at www2.asx.com.au. Type in the ASX code "AGL" (AGL Energy Limited), and find out details about the company. Also, type in the ASX code "ORG" (Origin Energy Limited), 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 AGL and ORG shares for every quarter from January 2013 to December 2021 (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 2013 to 2021 (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 AGL and the other for ORG. Then construct a stem-and-leaf display with one stem value in the middle, and AGL leaves on the right side and ORG leaves on the left side. (Must use EXCEL or similar for the plot.) 1 mark b) Construct a relative frequency histogram for AGL and a frequency polygon for ORG on the same graph with equal class widths. Use two different colours for AGL and ORG. Graph must be done in EXCEL or similar software. 1 mark c) Draw a bar chart of market capitals (or total assets) in 2021 (in million Australian dollars) of 6 companies listed in ASX that trade in similar products or do similar business as AGL or ORG with at least AUD 1 billion in market capital. Graphs must be done in EXCEL or with similar software. 1 mark d) If one wishes to invest in AGL or ORG, 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

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

Recommended Textbook for

Graphical Approach To Precalculus With Limits A Unit Circle Approach, A

Authors: John E Hornsby, Margaret L Lial, Gary K Rockswold

5th Edition

0321899806, 9780321899804

More Books

Students also viewed these Mathematics questions

Question

1. Empirical or factual information,

Answered: 1 week ago

Question

1. To take in the necessary information,

Answered: 1 week ago