Financial Modeling Seminar 

CFA Winnipeg is pleased to offer a 1 day Financial Modeling Seminar with our Guest Instructor, Ian Schnoor, CFA. Ian is the Principal & Founder of The Marquee Group. http://marqueegroup.ca/index.php?id=45

Overview: This hands-on course focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. During the seminar, participants will build a model that includes a forecast of a company’s income statement, cash flow statement and balance sheet.

The course material includes model design, logic, construction, financial concepts and accounting treatment. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the day.

Prerequisites: Participants should have a solid grasp of basic accounting fundamentals and proficiency with Excel prior to taking this course.

Learning Topics:
Design and Structure a Financial Model
- Design and layout a financial model clearly and logically
- Discuss the need for a model to serve as a marketing tool
- Create clearly defined inputs and assumptions sections
- Connect strings of data to create assumptions and footnotes
Build Powerful Scenarios and Financial Statements
- Use switches to create effective scenarios and value drivers
- Forecast and buildup a company’s revenues and expenses
- Design and incorporate a company’s income statement, balance sheet and cash flow statement
Incorporate all Relevant Schedules
- Construct all necessary schedules, including:
- Depreciation / CAPEX Schedule
- Working Capital Schedule
- Income Tax Schedule
- Debt and Interest Schedule
- Shareholders’ Equity Schedule
- Use Lookup functions within the model to effectively extract information
- Properly incorporate Senior Term Debt with an amortizing repayment schedule
- Create a robust Bank Operating Line (or Revolving Credit Facility)
- Design and incorporate a cash sweep for a company’s Bank Operating Line
- Balance the company’s balance sheet

 * Seating limited, registration required before 4:00 PM, Monday, October 22, 2012.

Please note that computers will be provided. Please bring a USB flash or CD to copy the working file from the course.  A laptop with a full working version of Microsoft Excel is Optional.

Registered Members & Candidates - $425.00 + GST

Non-Member - $490.00 + GST