The course material includes model design, logic, construction, financial concepts and accounting treatment. During the seminar, participants will build a model that includes a forecast of a company's income statement, cash flow statement and balance sheet.

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

Applicable for

Anyone who uses, or wants to use, Excel for financial modeling

Learning Objectives

By the end of this course, participants should be able to:

Design and Structure a Financial Model

· Design a clear and logical financial model

· Discuss the need for a model to serve as a marketing tool

· Create clearly defined inputs and assumptions

· 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 build-up 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

Seminar Leader: TBA

Presented by PD Partner: The Marquee Group

What to Expect

· This is a Live Virtual Seminar where class size has been limited to allow for an interactive learning environment.

· This seminar will not be recorded.

· Course materials, links and credentials will be emailed to you two business days before the seminar. Once sent, the email will also be found in your Account Communication tab of the CPA Manitoba Member Portal.

· Live webinars have varying levels of expected interaction, and some may require webcam and microphone capabilities – if you have concerns about the interaction required for this course, please email [email protected]

CPA Manitoba PD Terms and Conditions