We're Open
+44 7340 9595 39
+44 20 3239 6980

Prepare the summary screen for CBA that shows information about CBA’s Last Trade, Change in Price, Bid, Ask, Volume, Market Capi



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

Assessment Activity 1 Research Project Yahoo Finance – CBA

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.



Price: £ 139

100% Plagiarism Free & Custom Written, Tailored to your instructions

Details

  • Title: 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
  • Price: £ 139
  • Post Date: 2018-11-06T10:56:31+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

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 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
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

The writer 0223 is really helpful. He gave me the best essay ever. Love you loads for such a great job and thanks again.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Writing is not my field. I take help from this website for my accounting assignment. The work is good and I scored good grades in it. Thank you from the bottom of my heart.

Write your Feedback

Your email address will not be published. Required fields are marked *