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
- 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?
