Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 4 Marks Visit the Australian Stock Exchange website at www2.asx. com.au. Type in the ASX code AGL (AGL Energy Limited), and find out

image text in transcribed
Question 1 4 Marks 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.) I 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. I 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)? I 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_2

Step: 3

blur-text-image_3

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

Calculus Single Variable

Authors: Deborah Hughes Hallett, Andrew M Gleason, William G McCallum

8th Edition

1119783836, 9781119783831

More Books

Students also viewed these Mathematics questions

Question

How easy the information is to remember

Answered: 1 week ago

Question

The personal characteristics of the sender

Answered: 1 week ago