you will prepare a full set of financial statement analysis calculations (trend, common size, and ratios) and submit them in Excel format. These calculations will form the basis of the group's final report.

It is important that your spreadsheet make proper use of Excel formulas for subtotals (e.g., current assets, taxable income) and totals (e.g., total assets, net income). This will help you catch data entry errors, because you will be able to see if your subtotals and totals do not match the annual report. Do not enter subtotals and totals as numbers. Use formulas.

You will need to enter four years of balance sheet information and three years of income statement and cash flow statement information. The extra year of the balance sheet is needed for the denominators of some formulas.

Use the most recent three annual reports available. If your organization has not yet released its financial statements for this year, that's okay. Use the most recent one you can get. Do not use quarterly reports. They are not audited and they do not represent a full year of data.

The company is Lassonde