Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Section 1: Preliminary Work (4 marks) Choose five investments listed on the Australian Stock Exchange, one from each of the categories given inthe following table,

Section 1: Preliminary Work (4 marks) Choose five investments listed on the Australian Stock Exchange, one from each of the categories given inthe following table, to complete a set of 10 investments. Real Estate C1 Industrial Goods C2 Consumer Products & Media C3 Financial C4 Healthcare C5 1. Lendlease Group (LLC.AX) 2. Cleanaway Waste Management Limited (CWY.AX) 3. Blackmores Limited (BKL.AX) 4. Suncorp Group Limited (SUN.AX) 5. Ansell Limited (ANN.AX) 6. Your choice of stock 7. Your choice of stock 8. Your choice of stock 9. Your choice of stock 10. Your choice of stock

MIS775 Decision Modelling for Business Analytics Page 2Assignment 1 Trimester 1, 2023 To access the Stocks, click Industries on the ribbon menu (via the home page), and select a category. Then click on the symbol for the asset you want to include in your portfolio. After you have selected a Stock, click Historical data on the ribbon menu, then set Time period to 1 February 2019 28 February 2023 and Frequency to Monthly, then press the Apply button, and download the data. Delete any rows showing dividends. We are only interested in the opening price, listed in the column headed Open. Discard the rest of the data. The chosen stocks must satisfy the following general requirements: Each have 49 consecutive months of opening prices, up to and including 1 February 2023. They should be selected from the five industry categories (C1 to C5) listed in the table above, namely Real Estate, Industrial Goods, Consumer Products & Media, Financial, and Healthcare. You must choose only one asset from each of these five categories. For each of the 10 assets (i.e., the five given assets and the five you chose), calculate monthly returns, average return and then use their standard deviation to find their risk. The 10 assets should span a reasonable range of volatilities/risk. For this reason, you might try several assets in a category before settling on a final choice. Classify each of the 10 assets (i.e. the five given stocks and the five you chose) into one of four risk groups R1, R2, R3, and R4, where R1 < R2 < R3< R4. It is up to you to determine the basis for the risk classification, but you must have at least two assets in each risk group. Each asset must belong to one of the five industry categories and one of the four risk categories. See below template. Once you determined what risk group they belong to, you can write the asset/company name in the body of the table below

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

Optimization Of Logistics And Supply Chain Systems Theory And Practice

Authors: Turkay Yildiz

1st Edition

1540716198, 978-1540716194

More Books

Students also viewed these General Management questions