ACCT 606 Financial Management For Accountants Assignment
Are you looking for the most trustworthy assignment expert writer? If yes, then your research ends at Assignmenttask.com Get the best solution of ACCT 606 Financial Management for Accountants Assignment from experts. If you have any queries regarding the assignment help material provided to you, then connect with us through our 24/7 live chat support facility.
ASSIGNMENT DETAILS:
- Referencing Styles: APA
- Words: 1750
- Course Code: ACCT 606
- Course Title: Financial Management for Accountants
- University: Auckland University of Technology
- Country: NZ
QUESTION:
Suppose you are considering an investment in a two-factor portfolio. You wanted to analyze the stock return data for five years from August 2016 to July 2021 of four companies listed on the New Zealand Stock Exchange (www.nzx.com). In any possible two-factor portfolio, the weight of each security in the portfolio will be 50%.
The possible portfolio combinations are A&B; B&C; A&C; C&D; A&D, and B&D. Four companies: Sky City Entertainment Group Limited (SKC) Fletcher Building Limited (FBU) and any TWO (2) NZ listed companies of your choice. Air New Zealand Limited (AIR.NZ) The Warehouse Group Limited (WHS.NZ) Calculate monthly stock returns for the above four companies for the period from August 2016 to July 2021. Stock return can be calculated using the formulae: Ri= (Pt – Pt-1)/Pt-1).
Stock price data can be obtained either from click on Historical prices. Required: Using the appropriate Excel function (see fx), determine the average monthly return, the standard deviation, and variance for each company. (Use 60 month returns data and use Excel functions “Variance P” and “Standard Deviation P.”) Graphically show the stock price performance of the four companies for the periods from August 2016 to July 2021. Comment on the companies’ stock price performance trend since April 2020.
- Determine, using the appropriate Excel function, the covariance between securities.