Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started