Hi, Here’s my question… 3. Analytical procedures Present the


Question Description:

35

Hi, Here’s my question… 3. Analytical procedures Present the result of key analytical review procedures and impact on your audit approach. Refer to Appendix 5A p. 184 in SB and to Exhibit 3-2 p.25 in LC for guidance. Summarize your findings in the report and include clean summary tables in the body of the text. (Please provide an electronic copy of your detailed analysis on an excel spreadsheet / usb memory stick or by email). We need to get the information from the canadian National railway website (http://www.cn.ca) and use their financial information available as well as the sedar database (http://www.sedar.com/)).) An excel sheet is requieres to show the calculations and a word document to interpret the results from the ratios in details. the two exhibits are attached.. Let me know if you can do it. thanks List of ratios.docx List of ratios: Balance sheet ratios: -Current asset -days sales in receivables -doubtful aacount ratio -Days sales in inventory -Debt ratio Operations ratios: -Receivables turnover -Inventory turnover -Cost of goods sold ratio -Gross margin ratio -Return on beginning equity Financial distress ratios: – Z = 1.2T1 + 1.4T2 + 3.3T3 + 0.6T4 + 0.999T5. T1 = Working Capital / Total Assets T2 = Retained Earnings / Total Assets T3 = Earnings Before Interest and Taxes / Total Assets T4 = Market Value of Equity / Total Liabilities T5 = Sales/ Total Assets

Answer

35