CFA Vancouver Financial Modeling Course
CFA VancouverFinancial Modeling CourseMarch 6, 7, & 8, 2012SFU Graduate School of Business500 Granville StreetVancouver, BCCFA Vancouver604-985-9889 info@cfavancouver.com www.cfavancouver.com
Who Should Attend?This seminar is designed for investment professionals with practical experience in investmentmanagement, financial valuation, private capital or quantitative analysis.It will be most valuable to individuals working with asset managers, pension funds, investmentbanks, family offices, investment counselors, insurance companies and other financial servicesorganizations.The Marquee Group has conducted financial modeling seminars for a number of organizations,including CFA societies in Canada, such as CFA Toronto and CFA Calgary. Past participantstaught by the Marquee Group include:Portfolio ManagersSecurities AnalystsInvestment BankersCommercial BankersInvestment OfficersFinancial ValuatorsInvestment ConsultantsCorporate Finance ProfessionalsSchedule: 8:30 am – 4:30 pmSeminar fee includes coffee, lunch, and refreshments throughout the day.Members/Candidates (3 Days): 1,400Members/Candidates (Days 1 & 2): 1,100Members/Candidates (Day 3 only): 575Non-Members (3 Days): 1,600Non-Members (Days 1 & 2): 1,300Non-Members (Day 3 only): 675Register online with Visa, MasterCard.Course InstructorTim Benson is a senior financial services professional with extensive experience in the capitalmarkets. Prior to joining The Marquee Group, Tim was part of the senior management team atRetirement Residences REIT, a TSX listed real estate investment trust.He also worked in equity research at UBS Securities and investment banking at BMO NesbittBurns. Tim holds an MBA from the Richard Ivey School of Business, a Bachelor of Commercedegree from the Haskayne School of Business and the CFA designation.To ensure delivery of the highest quality program,this class will be limited to its optimal size.Participants will be required to bring their own laptopsand will be expected to have the correct software installed.This course is taught in Excel 2007
Financial Modeling 2 Day CourseThis intensive course focuses on designing and creating an interactive financial model of acompany that adheres to the highest industry standards. The course material includes modeldesign, construction, financial concepts, best practices and accounting treatment for stand-aloneand discounted cash flow models.Numerous Excel tools along with helpful keyboard shortcuts to increase efficiency will also becovered throughout the course.DAY 1 AGENDA CREATING A DYNAMIC STAND-ALONE COMPANY MODELLearning 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 sheetand cash flow statement 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 (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
Financial Modeling 2 Day CourseThe second day of the course is focused on using valuation tools and concepts to value acompany. A Discounted Cash Flow (DCF) analysis will be discussed and incorporated into thefinancial model that was created during the first day of the course. Participants will learn torecognize and avoid the most common mistakes that people make when creating a DCF analysis.DAY 2 AGENDA VALUATION METRICS AND ANALYSISLearning Topics: Discuss various valuation methodologies and the appropriateness of using adiscounted 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 Review critical terminal year assumptions including Capex, working capital,margins and income taxes Calculate the tax impact of unlevering a company’s cash flows Use two common styles to create a discounted cash flow (DCF) analysis Calculate the company’s cost of capital and choose an appropriate weighted averagecost of capital (WACC) range Discount the cash flows in the forecast period and ensure that the cash flows arediscounted to the correct period Review the distinction between using Excel’s NPV and XNPV functions Discuss various methodologies to value the terminal period Discuss common discounting errors and review the magnitude of discounting thecash 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
Advanced Data Manipulation with Excel 1 Day CourseThis one day course is an enhancement to Days One and Two and will appeal to participants whoalready have a strong foundation in Excel. Day Three is an intensive program that will transformparticipants into Excel “Power Users”. The course is focused on the pertinent Excel tools that arerequired in a corporate environment to efficiently analyze and manipulate data and to createcompelling financial analyses.This course covers intermediate and advanced level Excel topics. As such, students should havea good working knowledge of Excel prior to taking this course. Assignments, handouts andexamples will be used throughout the day.DAY 3 AGENDALearning Topics: Use numerous built-in Excel functions to interpret and manipulate data Use various filters in conjunction with specific arithmetic functions to summarize largevolumes of data Learn to use many features of the Advanced Filter, one of the most helpful and leastutilized tools in Excel Use a variety of intermediate and advanced Lookup functions to efficiently extractspecific information Learn multiple uses of the Lookup and Offset functions, including ways to automatethese functions Create nested formulas to expand the flexibility of various functions Use powerful Text functions to manipulate non-numeric variables Convert non-recognizable values into useable numbers with the use of Text functions Learn to use some of the most effective and lesser known Pivot Table features Use advanced conditional formatting tools to enhance the caliber of analytical output
Advanced Data Manipulation with Excel 1 Day Course This one day course is an enhancement to Days One and Two and will appeal to participants who already have a strong foundation in Excel. Day Three is an intensive program that will transform participants into Excel “Power Users”. The course is focus
VII: Responsibilities as a CFA Institute Member or CFA Candidate . A: Conduct as members/candidates in the CFA program . Do not cheat on, nor compromise the validity of, the CFA exam . B: Reference to CFA Institute, the CFA Designation, and the CFA Program . Do not make promotional promises or guarantees tied to the CFA designation. Do not:
1900 NW Bliss Rd, Vancouver 13003 SE 7th St, Vancouver 2623 NW Sierra St, Camas 9201 NW 9th Ave, Vancouver 2921 Falk Rd, Vancouver 512 SE Ellsworth Ave, Vancouver 2700 NW 119th St, Vancouver 12001 NE 9th St, Vancouver 21609 NE 72nd Ave, Battle Ground 3800 SE Hiddenbrook Dr, Vancouver 3301 Fruit Valley Rd, Vanco
CFA candidates come from different educational backgrounds and many walks of life. What is the Structure of the CFA Program? CFA Institute, the governing body that creates and administers the CFA exams, is headquartered in Charlottesville, Virginia. In July of each year, CFA Institute :
An estimated 2.5 million dogs visit Metro Vancouver's regional parks annually. Metro Vancouver Parks has established a procedure to collect and treat the dog waste. In the current . the ity of Vancouver, the ity of North Vancouver, the District of North Vancouver, the District of West Vancouver, the Township of Langley, the ity of Port
CFA recommendation: Adoption of the CFA Level 1 as the standard accreditation for all financial advisers in Australia. CFA Level I (Level I)1 is the first part of the three part CFA charter holder program. The Level I is a core component of the program
An Age of Imperialism: the Spanish-American War 12 The World Theatre Enters Vancouver 15 On the Homefront during the Spanish-American War 20 Moving Overseas: the Philippine War 23 The Buffalo Soldiers Come to Vancouver 26 Vancouver As a Military Town 35 China Relief Expedition 37 Domestic Modernity in Vancouver 47 American Lake 49
BNY Mellon christopher R. Foti, cFA BNY Mellon George R. hoguet, cFA, FRM State Street Global Advisors 2013 – 2014 Boston secuRity AnAlysts society BoARD oF DiRectoRs AnD stAFF thomas linkas, cFA stacey l. Marino, cFA, cAiA George s. Mellman, cFA, cipM, FRM, cFp lawrence F. pohlman
CFA Designation and the CFA Program? A. A Level III candidate referring to herself as CFA, Level II. B. A Level III candidate awaiting results referring to himself as CFA, expected 2009. C. An investment manager stating, “Complet
