Transcription
Financial Modellingand Advanced Excel CoursesFebruary 27, 28 and March 1, 2018UBC Robson Square800 Robson StreetVancouver, BCCFA Society Vancouver604-985-9889 info@cfavancouver.com www.cfavancouver.com
Who Should Attend?These courses are designed for investment professionals with practical experience ininvestment management, financial valuation, private capital or quantitative analysis.They will be most valuable to individuals working with asset managers, pension funds,investment banks, family offices, investment counselors, insurance companies andother financial services organizations.The Marquee Group has conducted financial modelling seminars for a number oforganizations, including CFA societies in Canada, such as CFA Society Toronto and CFASociety Calgary. Past participants taught by the Marquee Group include:Portfolio ManagersSecurities AnalystsInvestment BankersCommercial BankersInvestment OfficersFinancial ValuatorsInvestment ConsultantsCorporate Finance ProfessionalsFEES:Members Candidate MembersAll 3 Days: 1,475Days 1 & 2 or 2 & 3: 1,150Single Day Only: 600Candidates Non-Members3 Days: 1,675Days 1 & 2 or 2 & 3: 1,350Single Day Only: 700Fee includes a light breakfast, lunch, and refreshments throughout the day.Register online with Visa, MasterCard or American Express.The Marquee GroupThe Marquee Group is Canada’s leading provider of financial modelling trainingprograms. Since 2002, Marquee has trained thousands of professionals globally atfinancial institutions, corporations, professional organizations and universities. Theircore modelling, valuation and Excel courses are now standard training at numerousmajor financial institutions. Marquee’s principals are experienced financialpractitioners with investment banking, equity research and management backgroundswho are passionate about teaching.These are hands-on seminars. Registrants need to bring a laptop withWindows-based Excel (any version) installed.The seminars are not intended for macOS-based Excel.To ensure delivery of the highest quality program,these seminars will be limited to their optimal size.
Day 1: Building a Financial Model(of a Company)This hands-on course focuses on the skills required to design and create an interactivefinancial model of a company that adheres to the highest industry standards.The course material includes model design, logic, construction, financial concepts andaccounting treatment. During the seminar, participants will build a model that includesa forecast of a company’s income statement, cash flow statement and balance sheet.Prerequisites: Participants should have a solid grasp of basic accounting fundamentalsand proficiency with Excel prior to taking this course.Schedule: 8:30 am – 5:00 pmLEARNING TOPICS:Design and Structure a Financial Model Design and layout a financial model clearly and logicallyDiscuss the need for a model to serve as a marketing toolCreate clearly defined inputs and assumptions sectionsConnect strings of data to create assumptions and footnotesBuild 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 cashflow statementIncorporate 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 informationProperly incorporate Senior Term Debt with an amortizing repayment scheduleCreate a robust Bank Operating Line (or Revolving Credit Facility)Design and incorporate a cash sweep for a company’s Bank Operating LineBalance the company’s balance sheet
Day 2: Data Manipulation with Excel – Part 1(Intermediate/Advanced)This hands-on course is an intensive program that will transform participants into Excel“Power Users”. The course is focused on the pertinent Excel tools that are required in abusiness environment to efficiently analyze and manipulate data and to createcompelling financial analyses.This course covers intermediate and advanced level Excel topics. As such, participantsshould have a good working knowledge of Excel prior to taking this course.Assignments, handouts and examples will be used throughout the day.Schedule: 8:30 am – 5:00 pmLEARNING TOPICS:Data Analysis Use numerous built-in Excel functions to interpret and manipulate data Use various filters in conjunction with specific arithmetic functions to summarizelarge volumes of data Learn to use many features of the Advanced Filter, one of the most helpful and leastutilized tools in Excel Incorporate widely used financial and arithmetic functionsLookup Functions Use a variety of intermediate and advanced Lookup functions to efficiently extractspecific information Learn multiple uses of the Vlookup and Offset functions, including ways toautomate these functions Create nested formulas to expand the flexibility of various functionsManaging Text Use powerful Text functions to manipulate non-numeric variables Convert non-recognizable values into useable numbers with the use of TextfunctionsPivot Tables Become proficient with Pivot Tables, one of the most powerful tools in Excel,to quickly analyze large quantities of data Learn to use some of the most effective and lesser known Pivot Table featuresLearn numerous other tips, tricks and keyboard shortcuts to increase efficiency.
Day 3: Data Manipulation with Excel – Part 2(Advanced)This hands-on course is intended for anyone who uses Excel extensively and who isalready comfortable with the skills that were taught in “Data Manipulation with Excel –Part 1”.This session covers advanced level Excel topics that are required to manage andanalyze data.Assignments, handouts and examples will be used throughout the day.Schedule: 8:30 am – 5:00 pmLEARNING TOPICS:Database Functions Use Excel’s Database functions so that Excel can be used instead of Access Learn common uses for the Database functions, some of the most underutilizedtools in ExcelStatic and Dynamic Naming Discuss the rationale for using Static Names when building formulas Learn to create Dynamic Named Ranges, one of the most powerful concepts inExcel which allows users to automatically update graphs, Lookup functions andPivot TablesLookup Functions Use some of Excel’s more advanced Lookup functions, including the INDEXfunction, and learn helpful applications for their useConditional Formatting Use advanced conditional formatting tools to enhance the caliber of analyticaloutputSecuring Data Review Excel’s security features, including some lesser-known techniques toprotect a spreadsheet Use Excel’s Data Validation tool to restrict a cell’s contents
The Marquee Group is Canada’s leading provider of financial modelling training programs. Since 2002, Marquee has trained thousands of professionals globally at financial institutions, corporations, professional organizations and universities. Their core modelling, valuatio
