Background

Belinda and James have a self-managed super fund.  They are thinking of purchasing some Commonwealth Bank shares (CBA) to include in their super fund.  Belinda and James emailed you asking if you can provide some information on CBA so they can make a decision as to whether or not they will go ahead with the purchase of the CBA shares.  You agree to conduct some research and provide answers to their questions in readiness for your meeting with them scheduled for next Monday.

Note: In many instances your dealer group (or licensee) can provide you with access to research houses such as Lonsec, Morningstar etc where this information can be found easily. However, clients don’t have access to this, so if you know how to access public information, you can always show clients how to do it themselves.

Your task:

Use au.finance.yahoo.com to access the information your clients require about CBA shares.

We have provided you with step by step instructions about how to use finance.yahoo.com to access this information.  The instructions relate to Woolworths but you are required to follow the same steps to access information about CBA.

Please save all parts to this assessment activity and upload these to the LMS when submitting your assignment for grading.

Required:

Follow the detailed instructions provided at the end of this assessment activity in order to complete the following tasks:

1. Prepare the summary screen for CBA that shows information about CBA’s Last Trade, Change in Price, Bid, Ask, Volume, Market Capitalisation, and P/E ratio. Copy the screenshot such as using the Print Screen (PrtSc) function on your keyboard and paste it below:
2. Prepare the 3 key financial statements. Copy the screenshots for each of the three key financial statements such as using the Print Screen (PrtSc) function on your keyboard and paste it below:
3. Prepare a line graph of CBA share prices over the last 2 years. Copy the screenshot of the graph such as using the Print Screen (PrtSc) function on your keyboard and paste it below:
4. Compare CBA’s share price performance with that of Westpac (WBC.AX) over the past 5 years. Copy the screenshot of the graph such as using the Print Screen (PrtSc) function on your keyboard and paste it below: 
5. Download all available CBA monthly share prices starting from 1 Jan  2012 and save the data as an excel file.  Save the excel file.
6. Using the Data tab in excel, sort the data by the column containing Adjusted Closing Prices.  (Make sure you highlight the whole data set before you sort, otherwise only the Adjusted Closing Prices will get sorted and the remaining columns will not match up.) What date was CBA’s lowest Adjusted Closing Price? Type your answer in the box below.
7. What date was CBA’s highest Adjusted Closing Price? Type your answer in the box below.
8. Prepare the Analyst’s Opinion for CBA, showing the Recommendation trends and the Recommendation rating. Copy the screenshot such as using the Print Screen (PrtSc) function on your keyboard and paste it below:
9. Three months ago what was the recommendation of analysts for CBA  - did most analysts suggest CBA was a buy or sell or a hold? Type your answer in the box below.
10. This month, what is the recommendation of analysts for CBA? - did most analysts suggest CBA was a buy or sell or a hold?  Type your answer in the box below.