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

[Solved]Prepare a line graph of CBA share prices over the last 2 years.

  100% Pass and No Plagiarism Guaranteed

[Solved]Prepare a line graph of CBA share prices over the last 2 years.

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.

Instructions for Research Project: Yahoo Finance

 

These instructions show you how to access:

  • financial statements
  • charts showing share price history
  • an excel spreadsheet showing  share prices and trades volume over time
  • analysts’ comments

Please use the following instructions to complete this project for CBA.  (These instructions access data for Woolworths. You are required to follow the same instructions but access data for CBA.)

 

1. INTRODUCTION

1. Go to the homepage by entering  au.finance.yahoo.com

2. On the homepage enter the firm’s name in the Quote Lookup box which is on the right hand side of the screen. Enter the code WOW for Woolworth’s and you will be given a list. For shares on the Australian stock market, the code will be followed by .AX.

 

 

 

 

3. When we select WOW.AX the Summary for the share will appear.

 

The bar below the price shows different tabs with information about the share that has been selected.

         

          The summary shows the current pricing of the share.

             The statistics tab shows details of valuation measures and trading information

             From the financials tab, you can access the 3 types of financial statements for the last 4 periods.

             The historical data displays historical prices and dividends.

 

2. FINANCIAL STATEMENTS

To obtain any of the 3 key Financial Statements just select the Financials tab and click the name of the one that you want.

 

 

 

         

 

         

 

 

3. CHARTS

On the Summary tab, if we click on the  for WOW we obtain a graph of the actual share prices along with the trading volumes for these shares below it.

There are several options with this chart

Range:        This varies from one day (1d) to the whole period for which we have data (max)

Area:           We can have Bar, Line (as in this case) or Candle (where the length of the candles show the daily price range and the colour shows whether prices moved up or down that day).

Settings:     We can show the actual values (Linear) or the Log values. Typically we use Log values when we are interested in growth rates because the slope of the line graph of log values is equal to the growth rate of the values of the share prices.

 

 

 

 

We can also compare the Woolworth’s share prices to other values such as the S&P500, NASDAQ and Dow Jones,  price indices. In the chart on the next page we see that this will give us the graphs of

thepercentage changes in the initial price or index value over the initial level. To compare WOW prices with the Dow index we select and choose the symbol we want

    

 

  

We can also compare our selected share with other shares by entering their 3 letter code in the Compare symbol box.

          4. DOWNLOADING SHARE PRICES AND VOLUMES

 

Suppose we go to the main quote page and click Historical data. Here we see that we can choose between Daily, Weekly and monthly frequencies for WOW prices and trading volumes. We will start with the Weekly prices which are shown below. As you can see Yahoo Finance always starts with the value for the most recent date and then shows the values from earlier periods.

 

 

 

 

 

Or, we can choose to show dividends only. Each time you change your selection criteria you should click the Apply button to refresh the screen.

 

 

 

We can also download the data by selecting which is beneath the Apply button. This will download your data selection as a .csv file.

Using Excel on your computer, open this csv file. It contains a worksheet called table in which there are the following 7 columns:

Date contains the dates starting at the most recent one

Open, High, Low, Close & Adj Close   contain the Opening, High, Low, Closing, and Adjusted Closing Prices for each week

Volume   contains the Average of the Trading Volumes for the 5 days in that week

Save this file as a standard Excel file (rather than as a csv file)

 

To arrange these values starting with the earliest rather than with the most recent we highlight all 7 columns and click

                                Data / Sort

The Sort dialog box will now appear. In the Sort by box click Date, then in the Order box click Oldest to Newest. You will have the worksheet shown below. You should now save this sorted Excel file to your computer.

 

 

         

5. LOOKING AT ANALYSTS COMMENTS ON WOW

If we click on the Analysts tab and scroll down, on the right hand side we can see the recommendation trends and the recommendation rating. For the month of December most analysts believe that Woolworths is underperforming.

            

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 a line graph of CBA share prices over the last 2 years.
  • Price: £ 129
  • Post Date: 2024-08-28T18:23:38+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved]Prepare a line graph of CBA share prices over the last 2 years. [Solved]Prepare a line graph of CBA share prices over the last 2 years.
Reviews: 5

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

I have tried other sites for assignment help but the result that Insta Research has produced outweighs others. Since I am weak at writing and shaping the data logically, I am glad I took help from this site. Thanks to my writer for such a great quality of the assignment in Business.
Reviews: 5

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

Very professional and effective assignment writing service.