Help with the question and answer
Please also help with reference APA 7th

FIN 510 / FIN 205
Marks: 30 (15% weight of total assessment)

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
Company Description:

How to answer this question?

Choose a company from the link bellow.
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.
08 Marks
How to answer this question?
Steps in downloading stock price from
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
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.

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.

Your chosen company
(1 January 2017 – 31
March 2022)
ASX 200
(1 January 2017 –
31 March 2022)
Return (most
recent period)
Mean (average
*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
Calculate dividends growth rate and the return on share investment. 05 Marks

Dividends Growth Rates {(D1 – D0)/D0}Annual rate of return using Gordon Model
(P0 = D1/r-g)
2022 (D6)
2021 (D5)
2020 (D4)
2019 (D3)
2018 (D2)
2017 (D1)
2016 (D0)

For stock price information (P0) 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 BI 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

You are required to submit assignment files (word file, excel file, power BI file and PowerPoint
with audit) by the submission deadline of 20 May, Friday, 5.00 pm (Darwin time).
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.
8. Attend or listen to the recorded session on how to prepare your assignment.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more