Instructor spreadsheet for 8B15N006.

Excel spreadsheet for students.

The systematic analysis of an annual report of a large Canadian public company provides a framework and a set of skills and concepts to determine whether it is worth investing in the company. The detailed examination of the annual report includes an analysis of profitability - including return on capital employed, return on equity, return on sales, gross profit margin and asset turnover - and liquidity measures.

The equity analyst for a large investment bank is in the process of evaluating a potential takeover of Shoppers Drug Mart, Canada’s largest drugstore retailer, by Loblaw Companies Limited, Canada’s largest grocery retailer. Rumours of the takeover have been circulating for some time, and the analyst wants to provide her buy-side clients with both her comments on the proposed transaction and her assessment of a reasonable offering price.

The equity analyst for a large investment bank is in the process of evaluating a potential takeover of Shoppers Drug Mart, Canada's largest drugstore retailer, by Loblaw Companies Limited, Canada's largest grocery retailer. Rumours of the takeover have been circulating for some time, and the analyst wants to provide her buy-side clients with both her comments on the proposed transaction and her assessment of a reasonable offering price.