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

[Solved]Prepare the summary screen for CBA that shows information about CBA’s Last Trade, Change in Price, Bid, Ask, Volume, Mar

  100% Pass and No Plagiarism Guaranteed

[Solved]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.



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


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: [Solved]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: £ 129
  • Post Date: 2021-10-15T12:58:31+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved]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 [Solved]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

Insta Research is a very helpful place to buy a resume in the first place. I gave them my details and did not expect that they would come up with such an exclusive design. My personality is professionally enhanced through the resume made by them. I am thankful for the depth of my heart as I would have never approached that level of excellence in my resume. Wish you good luck ahead and again thank you!
Reviews: 5

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

The rates are a bit expensive for me of the essay writing service but the overall look is amazing. The references and formatting are done beautifully. So, I feel that the high rates are worth all these qualities. I want to thank you for great help.