Sign In
Manage PermissionsManage Permissions
|
Export Event

Title

Financial Modeling (2 Day Course)

Event Description

Financial Modeling (2 Day Course) – Building a Financial Model and Valuation Analysis

 

Event details:

 

CFA Society Ottawa is partnering with The Marquee Group to offer financial modeling training courses in 2018.  The Marquee Group's training mission is to ensure that everyone preparing financial models has the skills to do so in the most efficient and effective way possible. Professionals trained by Marquee provide their companies with greater financial insight and more accurate decision-making tools.

Dates: 

Session 1: Monday, March 5th and Tuesday, March 6th

Sessions will run from 8:30AM to 4:30PM each day.

 

Participants will be required to bring their own laptops with Microsoft Excel installed

 

Location:

Ottawa Conference and Event Centre

http://ottawaconferenceandeventcentre.com/

200 COVENTRY RD. – ROOM 212

OTTAWA, K1K 4S3, CANADA

Parking is complementary

Morning snack will be provided; no outside food or beverages permitted

 

Cost:  

Members/candidates/students:  $1,100

Non-members: $1,300

 

Space is limited, please register early!

Please contact admin@cfaottawa.ca with any questions.

 

Day 1 – Building a Financial Model

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. 

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.

Learning Topics:

  • Design and layout a financial model clearly and logically
  • Develop useful inputs and assumptions schedules
  • 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
  • Construct all necessary schedules, including:
  • -  Depreciation / CAPEX, Working Capital, Income Tax, Debt and Interest, Shareholders' Equity
  • 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 (Revolving Credit Facility)
  • Design and incorporate a cash sweep for a company's Revolver
  • Balance the company's balance sheet
  • Rid a model of undesirable error messages

 

Day 2 – Valuation Analysis

This hands-on course is focused on the practical implementation of a Discounted Cash Flow ("DCF") analysis.  The skills required to build a DCF analysis will be discussed and incorporated into a financial model.  Participants will learn to recognize and avoid the most common errors that finance professionals make when creating a DCF analysis.

Learning Topics:

 

  • Discuss various valuation methodologies and the appropriateness of using a discounted
  • cash flow methodology to value a business
  • Properly calculate a company's levered or unlevered free cash flows
  • Build a terminal year in the model to create a steady-state perpetual cash flow
  • Calculate the tax impact of unlevering a company's cash flows
  • Use two common styles to create a discounted cash flow analysis
  • Calculate the company's cost of capital and choose an appropriate weighted average
  • cost of capital (WACC) range
  • Discount the cash flows in the forecast period and ensure that the cash flows are
  • discounted to the correct period
  • Discuss various methodologies to value the terminal period
  • Discuss common discounting errors and review the magnitude of discounting the cash
  • flows to the wrong time period
  • Use a number of powerful Excel tools to sensitize the outputs
  • Incorporate appropriate credit ratios that impact a company's covenants
  • Create "flags" to warn the user when a covenant has been tripped
  • Conditionally format output tables to highlight specific results 

 

Speaker

 

Event Type

Society; Educational

Education Topic

Performance Measurement and Evaluation

Start Time

3/5/2018 8:30 AM

End Time

3/5/2018 4:30 PM

Event City

Ottawa

Event State/Province

ON

Event Country

Canada

Event Region

Americas

Location Info

Ottawa Conference and Event Centre

http://ottawaconferenceandeventcentre.com/

200 COVENTRY RD. – ROOM 212

OTTAWA, K1K 4S3, CANADA

Parking is complementary

CE Credits

 

SER Credit

 

Currency

CAD

Member Price

1100

Non-Member Price

1300

Candidate Price

1100

Registration

Click here​ to register.   Registration deadline is February 19th, 2018.


All Day Event

 

Recurrence

 

Date

3/5/2018

Attachments

Content Type: MyCFA Calendar
Created at 12/23/2017 9:24 AM by admin@cfaottawa.ca
Last modified at 12/23/2017 9:52 AM by admin@cfaottawa.ca