Problem 1: Choose a publicly traded company from the Australian Securities Exchange (ASX). Provide the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 1: Choose a publicly traded company from the Australian Securities Exchange (ASX). Provide the following information of your chosen company and what is the product or service the company produce? 02 Marks Company Name: Stock Ticker Symbol: Stock Information: Most recent price Market capitalization Daily volume Number of ordinary securities published on ASX Most recent dividend Annual dividend yield P/E ratio EPS Company Description: How to answer this question? Choose a company from the link bellow. https://www.asx.com.au/asx/research/listedCompanies.do Click on the key statistics and note down as required in question 1. Problem 2: Find the beta of the stock from January 2017 till March 2022 (download weekly price information) from the yahoo finance and write a summary of your analysis indicating the stock price trend during the analysis period. How to answer this question? Steps in downloading stock price from https://au.finance.yahoo.com/ a. Type the name of your chosen company in yahoo finance search option b. Click on the historical data c. Choose time for 5 years data (for example 1 January 2017-31 March 2022) period. d. Show: historical price, Frequency: Weekly e. Download the excel spread sheet and save it. f. Keep date and Adj closing price columns and delete open, high, low and volume columns. g. Now go back to yahoo finance home page and click on the ASX 200 stock index. Then click on the historical data and collect data for the same for the stated periods (weekly data) for the ASX 200 index. h. Download the ASX 200 index data and only choose Adj closing price. Copy Adj closing price and past it next to your chosen company's stock price. Follow the above two videos to collect data for your chosen company and ASX 200 index. https://www.youtube.com/watch?v=Byx4hQOIRrM&t=276s i. Now arrange the data in 3 columns in you excel file. Column 1 (date), column 2 (your chosen company's adjusted closing price, ASX200 adjusted closing price. Now select the data in 3 columns and click data icon in you excel sheet and then click Z to A arrow sign to arrange data from 2022 to 2017 period. j. Now compute returns (returnt = (Pt-Pt-1)/Pt-1) of the chosen stock and ASX 200 index for the stated (weekly data) period. Variables Your chosen company (1 January 2017-31 March 2022) ASX 200 (1 January 2017- 31 March 2022) Return (most recent period) Mean (average returns) Variance Standard Deviation *Slope (Beta) *Slope = covariance (returns of X company, returns of ASX 200)/ variance of ASX returns. You can either type (=slope (return of X, Returns of ASX 200) in excel or the above slope formula. J. Now calculate beta by regressing the share's returns on the returns to the index chosen. Report both excel results and regression result with beta. Your calculated slope and beta will be exactly the same. Copy the regression table from the excel sheet and paste it on your assignment word file. For regression analysis, you have to use the analysis tool pack available in excel. Problem 3: Now calculate the information required in Problem 2 to check the impact of COVID 19 on your chosen company from 1st March 2020 to August 2021 period and discuss the changes during the COVID 19 period only. 04 Marks How to answer this question? Repeat the procedure of problem 2 for the COVID 19 period (from 1st March 2020 to March 2022 period) only and then explain your analysis. You may compare the beta calculated in problem 3 with the beta of COVID 19 period. You may also include the company specific factors (sales, export, production, supply chain etc) that has been impacted by COVID 19 and their related impact on stock price performance. Try to enrich your answer with related factors you think has had an impact on stock. Problem 4: Collect the 5 years period dividends information of the company from the yahoo finance website. Calculate dividends growth rate and the return on share investment. 05 Marks Dividends Growth Rates ((D₁-Do)/Do} Annual rate of return using Gordon Model (Po-D₁/r-g) 2022 (DG) 2021 (DS) 2020 (D₂) 2019 (D₂) 2018 (D₂) 2017 (D₁) 2016 (Do) For stock price information (Po) check yahoo finance. You can do this section along with question number 2 Problem 5: Now visualize the analyses you did in solving problem 2, 3 and 4 in graphs and charts by using Microsoft power Bl software. 9 Marks How to solve: To solve the problems, follow the solution video uploaded in Learnline. Problem 6: Now prepare the presentation of your assignment with a power point file with audio (maximum 5 minutes). 02 marks Explain the result of problem 4 and 5 on power point slides (2 to 3 slides) and record your audio on power point. Now upload the recorded power point file to student media upload on Learnline. Check the link for adding audio on your power point slides https://support.microsoft.com/en-us/office/video-add-and-record-audio-eeac1757-5f20-4379- 95f2-0d0cd151d5b8 Strategies for finishing the assignment on time: 1 Choose a company following the selection criteria. Once you have selected a company, declare the company name in the FIN 510/FIN 205 forum with your student ID (in the forum write student ID and name of your selected company) so that other students do not select the same company. Before choosing a company check the FIN 510/ FIN 205 assignment forum whether your chosen company has been selected by others. 2. Read about the company from ASX and company's website. 3. Complete assignment questions step by step and check if you are in right direction according the requirements of the questions. Make sure you practice excel while doing this assignment. 4. Finalize word file (12 font, calibri (body), line spacing single). 5. Finalize excel file with regression results. Upload both the excel file and the assignment file via assignment submission point. (Please keep a copy of yours excel sheet as a future reference. I might ask you to send me a copy of yours excel file). 6. Proof-read your assignment prior to the submission. 7. Submit the assignment prior to the submission deadline. Make sure you have submitted the assignment on time, as there will be penalty for late submission. & Attend or listen to the recorded session on how to prepare your assignment. Problem 1: Choose a publicly traded company from the Australian Securities Exchange (ASX). Provide the following information of your chosen company and what is the product or service the company produce? 02 Marks Company Name: Stock Ticker Symbol: Stock Information: Most recent price Market capitalization Daily volume Number of ordinary securities published on ASX Most recent dividend Annual dividend yield P/E ratio EPS Company Description: How to answer this question? Choose a company from the link bellow. https://www.asx.com.au/asx/research/listedCompanies.do Click on the key statistics and note down as required in question 1. Problem 2: Find the beta of the stock from January 2017 till March 2022 (download weekly price information) from the yahoo finance and write a summary of your analysis indicating the stock price trend during the analysis period. How to answer this question? Steps in downloading stock price from https://au.finance.yahoo.com/ a. Type the name of your chosen company in yahoo finance search option b. Click on the historical data c. Choose time for 5 years data (for example 1 January 2017-31 March 2022) period. d. Show: historical price, Frequency: Weekly e. Download the excel spread sheet and save it. f. Keep date and Adj closing price columns and delete open, high, low and volume columns. g. Now go back to yahoo finance home page and click on the ASX 200 stock index. Then click on the historical data and collect data for the same for the stated periods (weekly data) for the ASX 200 index. h. Download the ASX 200 index data and only choose Adj closing price. Copy Adj closing price and past it next to your chosen company's stock price. Follow the above two videos to collect data for your chosen company and ASX 200 index. https://www.youtube.com/watch?v=Byx4hQOIRrM&t=276s i. Now arrange the data in 3 columns in you excel file. Column 1 (date), column 2 (your chosen company's adjusted closing price, ASX200 adjusted closing price. Now select the data in 3 columns and click data icon in you excel sheet and then click Z to A arrow sign to arrange data from 2022 to 2017 period. j. Now compute returns (returnt = (Pt-Pt-1)/Pt-1) of the chosen stock and ASX 200 index for the stated (weekly data) period. Variables Your chosen company (1 January 2017-31 March 2022) ASX 200 (1 January 2017- 31 March 2022) Return (most recent period) Mean (average returns) Variance Standard Deviation *Slope (Beta) *Slope = covariance (returns of X company, returns of ASX 200)/ variance of ASX returns. You can either type (=slope (return of X, Returns of ASX 200) in excel or the above slope formula. J. Now calculate beta by regressing the share's returns on the returns to the index chosen. Report both excel results and regression result with beta. Your calculated slope and beta will be exactly the same. Copy the regression table from the excel sheet and paste it on your assignment word file. For regression analysis, you have to use the analysis tool pack available in excel. Problem 3: Now calculate the information required in Problem 2 to check the impact of COVID 19 on your chosen company from 1st March 2020 to August 2021 period and discuss the changes during the COVID 19 period only. 04 Marks How to answer this question? Repeat the procedure of problem 2 for the COVID 19 period (from 1st March 2020 to March 2022 period) only and then explain your analysis. You may compare the beta calculated in problem 3 with the beta of COVID 19 period. You may also include the company specific factors (sales, export, production, supply chain etc) that has been impacted by COVID 19 and their related impact on stock price performance. Try to enrich your answer with related factors you think has had an impact on stock. Problem 4: Collect the 5 years period dividends information of the company from the yahoo finance website. Calculate dividends growth rate and the return on share investment. 05 Marks Dividends Growth Rates ((D₁-Do)/Do} Annual rate of return using Gordon Model (Po-D₁/r-g) 2022 (DG) 2021 (DS) 2020 (D₂) 2019 (D₂) 2018 (D₂) 2017 (D₁) 2016 (Do) For stock price information (Po) check yahoo finance. You can do this section along with question number 2 Problem 5: Now visualize the analyses you did in solving problem 2, 3 and 4 in graphs and charts by using Microsoft power Bl software. 9 Marks How to solve: To solve the problems, follow the solution video uploaded in Learnline. Problem 6: Now prepare the presentation of your assignment with a power point file with audio (maximum 5 minutes). 02 marks Explain the result of problem 4 and 5 on power point slides (2 to 3 slides) and record your audio on power point. Now upload the recorded power point file to student media upload on Learnline. Check the link for adding audio on your power point slides https://support.microsoft.com/en-us/office/video-add-and-record-audio-eeac1757-5f20-4379- 95f2-0d0cd151d5b8 Strategies for finishing the assignment on time: 1 Choose a company following the selection criteria. Once you have selected a company, declare the company name in the FIN 510/FIN 205 forum with your student ID (in the forum write student ID and name of your selected company) so that other students do not select the same company. Before choosing a company check the FIN 510/ FIN 205 assignment forum whether your chosen company has been selected by others. 2. Read about the company from ASX and company's website. 3. Complete assignment questions step by step and check if you are in right direction according the requirements of the questions. Make sure you practice excel while doing this assignment. 4. Finalize word file (12 font, calibri (body), line spacing single). 5. Finalize excel file with regression results. Upload both the excel file and the assignment file via assignment submission point. (Please keep a copy of yours excel sheet as a future reference. I might ask you to send me a copy of yours excel file). 6. Proof-read your assignment prior to the submission. 7. Submit the assignment prior to the submission deadline. Make sure you have submitted the assignment on time, as there will be penalty for late submission. & Attend or listen to the recorded session on how to prepare your assignment.
Expert Answer:
Answer rating: 100% (QA)
Problem 1 Company Profile I chose to work on Abacus Property Group for this assignment ABP incorporated in 1996 deals in investment activities in selfstorage industrial properties retail and office It ... View the full answer
Related Book For
Business Analytics and Statistics
ISBN: 978-0730363330
1st edition
Authors: Ken Black, John Asafu Adjaye, Paul Burke, Nelson Perera, Carl Sherwood, Saleh A. Wasimi
Posted Date:
Students also viewed these economics questions
-
What is a product or service value proposition? How does it affect customer purchase decisions?
-
1.How does the primary processing of mRNA differ between bacteria and eukaryotes? 2.What are the main post-transcriptional modifications in eukaryotic mRNA and state their functions 3.Discuss the...
-
Choose a publicly traded company and calculate its cash flow ratios. Demonstrate your calculations in your post, and explain what the cash flow ratios indicate about the company.
-
Evaluate the limit or state that it does not exist. lim (x,y) (1,-3) In(3x + y)
-
What is motivation, and why is it important to know how to motivate employees?
-
A continuous flow reactor vessel contains a liquid reacting mixture with a density of $0.85 \mathrm{~g} / \mathrm{cm}^{3}$ and a viscosity of $7 \mathrm{cP}$ at $1 \mathrm{~atm}$ pressure. Near the...
-
You collect a random sample of the number of children per household in a region. The results are listed below. Find the sample mean and the sample standard deviation of the data set. 1 3 1 1 1 1 2 2...
-
Pet acquired 80 percent of the common stock of Sul for $4,000,000 on January 2, 2011, when the stockholders' equity of Sul consisted of 5,000,000 euros capital stock and 2,000,000 euros retained...
-
2. Is aacccdcc in the language generated by the following grammar? If so, draw the parse tree. If not, show why. a c | | b c | C d | 4
-
Determine the internal normal force, shear force, and moment at points E and F of the compound beam. Point E is located just to the left of 800 N force. 1200 N 800 N 400 N/m 3. A |E B F -1.5 m--1 m-2...
-
Using the following independent situations, answer the following questions: Required: Situation 1 Kerry received property from an aunt with a FMV of $45,800 on the date of the gift. The aunt had...
-
Your company wants to raise $11 million by issuing 10-year zero-coupon bonds. If the yield to maturity on the bonds will be 7% (annually compounded APR), what total principal amount of bonds must you...
-
After the global financial crisis, the central banks that fall within the framework of the Bank of International Settlement (BIS) set up the Basel III agreement in 2010. This new agreement includes...
-
Suppose you purchase a 30-year, zero-coupon bond with a yield to maturity of 4%. You hold the bond for five years before selling it. a. If the bonds yield to maturity is 4% when you sell it, what is...
-
Several multilateral or regional development banks have been created since World War II. The last born is the Asian Infrastructure Investment Bank (AIIB) created effectively in January 2016. It...
-
Suppose you purchase a 10-year bond with 11% annual coupons. You hold the bond for four years, and sell it immediately after receiving the fourth coupon. If the bonds yield to maturity was 9.94% when...
-
Find the decimal expression for 7 101 using long division, and without a calculator. Give all steps of working out.
-
What are some of the features of the Unified Process (UP)?
-
A study reveals that the average amount withdrawn at automatic teller machines (ATMs) is $160 per withdrawal. This figure was determined using a random sample of 91 withdrawals at ATMs. The sample...
-
The table summarises the unit sales and prices for a food manufacturer from 2017 to 2020. Using 2017 as the base year, construct an unweighted price index, a Laspeyres index and a Paasche index....
-
A hire car company is interested in summary statistics that are useful in describing travel times between the CBD and the domestic terminal at Sydney Airport. The company locates a report that...
-
What are the issues surrounding smartphones, social media, and cybersecurity confronting modern organizations?
-
How can one engage in effective cross-cultural communication in organizations?
-
Can you think of any barriers that impacted communication effectiveness in this situation? How might one attempt to alter how they communicate to address or eliminate any of these barriers?
Study smarter with the SolutionInn App