FIND A SOLUTION AT Academic Writers Bay
Major Assignment – Marks -(20) Due week 10
CookMyProject
This assignment will require you to source the share price movements for Five(5) listed companies, graph and statistically analyse the companies and compare your portfolio of five shares to the ASX200.
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 ie Wooworths
d) One International Share
e) One company you have a particular interest in
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.
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.
4-Using the first month as the base, calculate the percentage (%) charges each month, for each share and the ASX200.
5- Graph all the percentage data on one graph, ie5 shares and the ASX200.
6- If, 5 Years ago, you invested $100000 evenly ($20000/share) into a portfolio, what would your portfolio be worth now? Calculate and show this on your spreadsheet.
7- Then create another graph comparing the 5 year monthly portfolio charges against the ASX200. Did your portfolio do better than the ASX200 Index?
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.
Marks will be awarded for;
1- Overall quantity and presentation of your report to management.
2- Quality of definitions and written analysis
3- Use of Excel Functions,
4 Qualty and Presentation of Graphs.
5- Accuracy.
Marks will be deducted for late submissions.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER
