- Go to https://money.tmx.com/en
This is the website for the Toronto Stock Exchange. Look up the stock market quote for Canada Goose Holdings Inc. (enter “GOOS” in the search box, then click on it when it appears).
Click on the Financials & Filings tab. This will bring up the most recent Income Statement. You can also access the cash flow statement and balance sheet by clicking the appropriate links.
a) Calculate all of the Chapter 2 ratios for all years from 2017 to 2021 and present your results in table format. Complete all calculations in Excel (you can download the financial statements as a .csv file which you can open in Excel and then save as an Excel file). Assume their tax rate is 25%. 10 marks
Note that some of the ratios require the share price. You can find the share price on the required date (eg. End of March 2017) by changing the time period on the chart to 5Y, scrolling to find the date closest (and prior) to March 31 2017. Several prices will be displayed: Open (O), High (H), Low (L) and Close (C). Use the close price. Rather than searching for the shares outstanding on previous dates, you may use the current shares outstanding for every year, which can be found in the statistics just below the chart, under “Listed Shares Out”.
Note that some of the terminology is different than what we use in the course: Total Revenue = Sales, Cost of Revenue = Cost of Sales, Cash Cash Equivalents and Short term investments = Cash + Marketable Securities
Use Excel to perform a ratio analysis of Canada Goose's Income Statements and Balance Sheets from 2017-2021. Calculate all of the ratios we used in class (see Chapter 2 slides) and present your results in table format. (10 marks)
Sample Solution