GROUP FORMATION
Form a group of 5 people
Choose your group wisely – join with people you know you can trust to work with
Once you are part of the group, you will all be responsible to navigate all group dynamics, behaviour, and politics
All group members will receive the same grade
Groups must be formed in D2L (Course Tools > Groups)
BE very sure of your group BEFORE you enter it in D2L
Once your name has been added in D2L, it CANNOT be changed by you. You will need to see your instructor to make the change
Wait until you are sure of your group before entering the information in D2L
Groups must be formed by Thursday, January 23
REPORT
For this report you will use Refinitiv Software to access financial information about the company you have been assigned.
You will be guided through this process during regular lab time
Half of you will attend the lab for the first hour; the remaining half will attend for the second hour.
Watch for a notification email for your time to attend.
Refinitiv software is also available in the Accounting Help Centre for you to use
Use the excel template in the dropbox of your D2L shell to complete the assignment
Assignment Requirements:
Ensure your group is formed and entered in D2L (5 per group) by Thursday, January 23.
Use Refinitiv software to obtain:
Financial statement information for your assigned company for the two most recent years
o Download and save these statements to the excel sheet provided in the assignment dropbox
Do an internet search to obtain:
Industry standards or norms for the industry to which your assigned company belongs
Market share price for the company you have chosen
Using the excel template provided in the dropbox, and the financial statements saved in this same spreadsheet, calculate the required ratios for both years.
Use formulas in excel (linking to the financial statements) to calculate amounts. For example:
If there are values that are not available in your statements, clearly indicate on your spredsheet – it will be confirmed from the uploaded statements.
Make sure all areas of the spreadsheet are formatted so that ALL information is easily readable and can be seen clearly (no hidden text because of formatting).
Using what you have learned in chapters 3 and 4, prepare a financial analysis of the company. Once the ratios are calculated for both years, use this data to:
Compare the company’s performance from the most recent year to the previous year.
Compare the current year to the industry standard.
Provide well rounded, comprehensive answers
o What does this ratio itself indicate?
o Comment on the company’s financial performance for the most recent year as compared to the previous year as well as to the industry standard or norm for that industry.
o What do these changes tell you?
o Did they increase or decrease, and what does this mean?
o Are they improving or doing worse than the previous year?
o How do they compare to the industry overall?