Speaker(s)
Michael Hunstad, PhD
Senior Quantitative Research Analyst
Allstate Investments, LLC

The ability to analyze data accurately and efficiently is the cornerstone of good financial modeling. This course helps the experienced Excel user understand how to use the more advanced data analysis features of the product including functions, macros, pivot tables and the Visual Basic for Applications language. Through hands-on examples, participants will learn to extract business insights from their spreadsheet applications and enhance their analytical capabilities of treasury related applications.

Learning Objectives:

• Use intermediate and advanced analytical techniques in Excel
• Understand various types of quantitative analytical methods in Excel

• A basic understanding of fundamental treasury and finance principles
• A thorough understanding of basic Excel spreadsheet functions
• A minimum of one year experience in corporate treasury, accounting or finance operations
• Access to Excel 2007 is recommended

• PDF copies of course slides
• Excel spreadsheet templates

Click here for information on CTP/CCM and CPE credit requirements.

Speaker(s)
Mark Krawczyk
Principal
CZYK & Associates

Current market conditions demand strict overview of bank service fees and costs. Few processes require more diligence than bank relationship management. What are the best practices for managing your banking relationships? Explore the topics of:

• Preserving access to liquidity
• Determining the criteria for “fair and reasonable” service pricing and costs
• Structuring appropriate RFPs and reviewing and assessing responses
• Assessing the quantitative and qualitative factors that should be used in a thorough evaluation process after implementation

• Understand how service pricing by service providers is accomplished
• Assess their company's own internal cost structures to effectively measure costs
• Implement "best practices" in relationship management "back home" on the job

• PDF copies of course slides
• A checklist for a generic internal costing process for those processes that fall in the scope of bank relationship management
• A resource guide to provide an opportunity for attendees to "read more about it"

Click here for information on CTP/CCM and CPE credit requirements.

Speaker(s)
James C. Lam
President
James Lam & Associates

Financial and treasury professionals are challenged to manage financial risks (interest rate risk, FX risk, equity risk, commodity risk, liquidity risk, and credit risk) at their institutions. This session will provide an overview of financial risk management and the key trends and developments in this field:

• Objectives of financial risk management (FRM)
• The role of financial risk within an overall enterprise risk management (ERM) framework
• Key trends and developments in ERM and FRM
• Expected benefits of best-practice risk management
• Lessons learned from the global financial crisis

• Implement effective risk management processes and procedures
• Measure the risk-return tradeoff of popular financial instruments and related applications with respect to economic, operational, and structural attributes
• Deal with practical implementation issues such as data selection, valuation, and hedge effectiveness testing

• PDF copies of course slides and handouts
• AFP's "Risk Mapping Guide"
• Excel Models

Click here for information on CTP/CCM and CPE credit requirements.

Speaker(s)
Larry De Palma, CTP
President/CEO
TDG-Phenix, Inc.

Given the rapid development and adoption of electronic alternatives for disbursing and collecting payments, what are the right choices to improve your company's processes and ultimately the balance sheet? You need to have a solid understanding what the options are, how they work and how they are used. This fast-paced, instructor-led course is designed to provide a nuts and bolts understanding of ACH, wire, and card payment instruments and the process from origination to settlement. Topics will cover the most popular domestic and cross-border payments options for business-to-business and business-to-consumer applications from the corporate treasury management perspective. Whether you are truly a payments novice or just need to get up-to-speed on the current payments environment, this seminar offers high-level value.

Learning Objectives:

• Use basic concepts and terminology related to electronic payment collections and disbursements
• Recognize the most popular types of non-paper-based payment instruments, their formats and mechanisms
• Identify how each payment type is originated and settled and the participants involved
• Consider speed, finality, remittance data, transaction costs, limitations and risk when selecting payment mechanisms

• PDF Copies of course slides and handouts

Click here for information on CTP/CCM and CPE credit requirements.