FNSINC401, FNSFPL506 - CBA Share Analysis using Yahoo Finance

This assignment focuses on researching Commonwealth Bank (CBA) shares using Yahoo Finance, as part of the Diploma of Financial Planning Module 2. It involves extracting key data points such as last trade, change in price, bid, ask, volume, market capitalization, and P/E ratio. The assignment also requires preparing the three key financial statements, creating a line graph of CBA's share prices over the last two years, and comparing its performance with Westpac (WBC.AX) over the past five years. Furthermore, it includes downloading monthly share prices from January 2012, sorting the data in Excel to identify the lowest and highest adjusted closing prices, and analyzing analysts' opinions and recommendation trends for CBA. The overall goal is to provide Belinda and James with comprehensive information to inform their decision on whether to include CBA shares in their self-managed super fund. Desklib is a great resource to find similar solved assignments and past papers.