Canadian Securities Institute, Moody's Analytics Training & Certification Services
Mobile Menu

Financial Modeling Course

 

What You Will Learn:

  1. Analyzing Financial Statements
  2. Students will learn the different methods of analyzing financial statements, including how to use financial ratios effectively to identify possible anomalies in company financial statements.

  3. Understanding Financial Modeling Best Practices
  4. Students will learn the best practices to adopt to minimize the potential for errors when building an earnings model. Key concepts include a discussion on financial model structure and formula complexity.

  5. GAAP to Non GAAP Reconciliation
  6. Students will learn the common non-recurring items reported by companies, as well as how to identify such items in company filings, and adjust for them to derive the recurrent earnings for the company.

  7. Restating the Income Statement
  8. Students will be taken through the steps of restating the income statement reported in a company filing to a standardized format that allows for the calculation of EBITDA and recurrent earnings.

  9. Identifying Revenue Drivers
  10. Students will learn the importance of identifying detailed drivers for revenue for companies operating in various industries. The course also includes a case study for students to identify revenue drivers for an assigned company.

  11. Assessing Cost Drivers
  12. Students will learn the importance of identifying detailed drivers for the operating costs for companies operating in various industries. The course also includes a case study for students to identify cost drivers for an assigned company.

  13. Understanding Operating Leverage
  14. Students will be taken through the basics of operating leverage, as well as the methods that could be adopted to understand the cost structure of a company. In addition, students will learn how the factors driving revenue growth could impact the earnings of the company.

  15. Forecasting Revenue and Operating Cost
  16. Students will be taken through a simple two-step approach to lessen the complexities of forecasting the earnings for a company. In addition, students will be provided general guidelines on information to research for the purpose of arriving at defensible forecasts.

  17. Forecasting Income Statement and Balance Sheet
  18. Students will learn how to analyze, model, and forecast key line items in the income statement and balance sheet, such as working capital, property and equipment, intangible assets, borrowings, and share repurchases.

  19. Balancing the Financial Model
  20. Students will learn the step-by-step process by which they can balance any financial model. This 11-step process can also be used to critique and identify errors in a financial model that prevent it being balanced.

  21. Calibrating Estimates with Consensus
  22. Students will learn the importance of calibrating their own forecasts with those of consensus, and how to source the data for consensus and broker-specific estimates.

  23. Using Scenario Analysis
  24. Students will learn the importance of conducting a scenario analysis, as well as building a detailed scenario analysis sheet in and earning model template.

Approximate Hours of Study**
Hours of Study 15 hours
QUIZ FORMAT
Quiz Format Online
Question Format Multiple Choice
Questions Per Quiz 30 questions
Attempts Allowed 2
Passing Grade 60%*
ENROLMENT PERIOD
Enrolment Period 6 months

Continuing Education (CE) Credits

Click the links below or the buttons at the top of the page on the right side to access CE accreditation information. To search for specific course information, press Ctrl+F and then enter the course name to search the document for the information you are interested in.

National/Provincial (Excluding Quebec)
Download CE Chart (PDF, 163 kb)

Quebec (IQPF/CSF)
Download IQPF/CSF Chart (PDF, 182 kb)

Please note: While CSI makes every effort to ensure that the information is up-to-date, we are unfortunately unable to fully guarantee its accuracy. The information listed in the charts above may be subject to change.

For details on the organizations and other information on CE Credits listed in the above charts, please click here.