Assignment Task:
This assignment will require you to source the share price movements for five (5) listed companies, graph and statistically analyze the companies and compare your portfolio of five shares to the ASX200.
Problem 1: Select 5 companies listed on an International Stock Exchange.
a. One ASX Bank
b. One ASX Mining Company
c. One ASX Food and Staples i.e. Woolworths
d. One International Share
e. One company you have a particular interest in.
Problem 2: Write a one paragraph, brief description for each company. At least covering the company's main activities, its size (Capital and Total Assets). For the company that you have an interest in, write half a page, explaining why this business is interesting to you.
Problem 3: Using "Yahoo Finance", download to an Excel spreadsheet the month end share price for each share, for the last five years. ie 60 data points per company. Plus, for the same time period, the ASX200 month end data.
Problem 4: Using the first month as the base, calculate the percentage (%) change each month, for each share and the ASX200.
Problem 5: Graph all the percentage data on one graph. ie 5 shares and the ASX200.
Problem 6: If, 5 years ago, you invested $100,000 evenly ($20,000/share) into a portfolio, what would your portfolio be worth now? Calculate and show this on your spreadsheet.
Problem 7: Then create another graph comparing the 5 year monthly portfolio changes against the ASX200. Did your portfolio do better than the ASX200 index?
Problem 8: Using Excel, calculate the Standard Deviation and Mean for each share, your portfolio and the ASX200. Explain what the Standard Deviations are telling you about risk?
Assume you will be presenting your results to management, in a report.
Note: Require 1000 words and there is calculation and graphs as well and also need the references in Harvard Style.
Our Shares and Portfolio Assignment Help service encompass a dedicated panel of professional tutors, who are highly qualified, having Masters and Ph.D. credentials and have years of industry experience.
Tags: Shares and Portfolio Assignment Help, Shares and Portfolio Homework Help, Shares and Portfolio Coursework, Shares and Portfolio Solved Assignments, International Stock Exchange Assignment Help, International Stock Exchange Homework Help, International Stock Exchange Coursework, International Stock Exchange Solved Assignments, Capital and Total Assets Assignment Help, Capital and Total Assets Homework Help