Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
Available Upgrades:
- 12 Months OnDemand Playback + $110
- 12 Months OnDemand Playback + CD + $140
- Additional Live Access + $75 per person
Determining an entity’s ability to generate cash flow is essential whenever repayment of a loan will extend beyond one year. Cash flow analysis measures an entity’s ability to generate sufficient cash to operate successfully and have excess cash to service annual debt payment requirements. Understanding how to calculate and interpret cash flow is essential for successful financial institutions.
Learn how to calculate cash flow using the Universal Cash Flow Analysis method (UCA), which determines the flow of cash into and out of a business entity. First, we’ll define cash flow and identify potential sources and uses of cash. Next we’ll illustrate how cash flow analysis is actually the process of converting an Accrual Basis financial statement into a Cash Basis financial statement. We’ll cover the Rules of Cash Flow when determining cash flow generation from changes in asset, liability and capital accounts on balance sheets over time. We’ll culminate by using a full UCA from beginning to end.
Covered Topics
Who Should Attend
Senior Loan Officers, Senior Credit Officers, Commercial Loan Officers, Branch Managers, Credit Analyst, Loan Review Personnel, and Consumer Loan Officers.
Instructor Bio
Jeffery W. Johnson started his career with SunTrust Bank in Atlanta as a management trainee and progressed to vice president and senior lender of SouthTrust Bank and senior vice president and commercial banking division manager for Citizens Trust Bank of Atlanta.
Most of his career has been spent in Credit Administration, Lending, Business Development, Loan Review, Management, and Training & Development. He has managed loan portfolios representing a cross section of loan types including: Large Corporate, High Net Worth Individual, Middle Market Companies, Small Business, Real Estate, and Non-Profit Organizations.
Mr. Johnson is now a training professional in the financial industry by leading various seminars covering important topics relating to issues in financial institutions. He teaches actively for fifteen state banking associations in the United States, Risk Management Association (RMA) and individual financial institutions nationwide. He co-authored a training course entitled “Lending to Service and Other Professional Organizations” for RMA in 2001.
Mr. Johnson earned a B.A. in accounting from Morehouse College in Atlanta; a MBA in finance from John Carroll University in University Heights, Ohio; banking diploma from Prochnow School of Banking at the University of Wisconsin and a Graduate Certificate in bank management from the Wharton School of Business at the University of Pennsylvania.
Available Upgrades:
In the ever-evolving world of finance, the call report undergoes constant change. Over recent years, we’ve adapted to extensive transformations and faced the impact of economic, accounting, and regulatory shifts. As we begin 2024, it’s crucial to acknowledge the journey and prepare for what lies ahead.
This 2-hour webinar will provide participants with insights into regulatory and accounting changes affecting the financial landscape, as well as proposed changes set to take effect in 2024. To ensure participants are well-informed and up-to-date, any newly emerging regulatory matters will be incorporated into the agenda, making this training as relevant as possible for the March 31, 2024, reporting period. Participants will receive handout materials to include a PDF version of the presentation and additional documentation required to support the topics covered in the webinar.
What You’ll Learn
Who Should Attend
This program provides significant value for a wide range of individuals involved in Call Report preparation, review, or approval, regardless of their level of experience. Whether you’re a newcomer or a seasoned professional, the updates and discussions on accounting and financial reporting issues are tailored to enhance your knowledge and skills. This webinar aims to benefit a diverse audience by addressing current and relevant topics in the field of financial reporting.
Instructor Bios
Cynthia Dopjera, a Certified Public Accountant, has 38 years of experience focused on accounting and regulatory reporting for financial institutions. During the first 18 years of her career, Ms. Dopjera held various positions with responsibility across all operational areas, to include accounting, internal audit, Call Report preparation and review while working for community as well as regional banks.
In 2000, Ms. Dopjera joined the public accounting firm of Harper & Pearson Company, P.C., where she served as Practice Leader for the Firm’s financial institutions practice covering community and regional institutions. The Firm’s services included financial statement audit, accounting, tax preparation and filing, internal control audit, Call Report audit, loan and asset quality review, and design and implementation of internal controls over financial reporting frameworks for institutions regulated under FDICIA and Sarbanes-Oxley. In 2018, Ms. Dopjera retired from Harper & Pearson Company, and currently provides accounting, consulting, and training services to financial institutions.
Andrea Lambert is currently lending her skills as a trainer and consultant as a member of the 3PR staff. Andrea has over 20 years of banking experience with a broad range of financial and operational skills. She began her banking career as a part-time teller and bookkeeper as she completed her B.S. in Finance from Illinois State University. In 2005, she started a seven-year career with the Office of the Comptroller of the Currency as an associate national bank examiner, becoming familiar with rules and regulations, best practices, and success strategies as they relate to the call report process and the banking industry as a whole. In 2012, Andrea filled the cashier position at a local community bank. During the ten years she worked there, she was responsible for ensuring the accuracy of various operational components of the bank, with a focus on call report preparation.
Available Upgrades:
This webinar was developed by a lawyer who has been teaching loan documentation for more than 25 years. Taught at a basic level (for bankers, not lawyers), the instructor will lead participants through all sections of the various required real estate loan documents. The purpose is to create a deeper understanding of why certain documents are required, plus the significance of various sections and verbose language (often referred to as “boilerplate”). Being able to explain document content will add much to customer relationships.
Covered Topics
Who Should Attend
Lenders, loan assistants, loan operations personnel, credit analysts and personnel involved in real estate loan review, internal audit, and compliance.
Instructor Bio
Robin Russell has practiced law for 30 years and is licensed in Texas, New York, and Massachusetts. She is a fellow in the American College of Bankruptcy and of the American Law Institute. She combines a depth of experience in bankruptcy restructuring and litigation with financial transactions. She has represented corporate debtors, independent directors, liquidating trustees, bondholders, unsecured creditors’ committees, bank groups, private equity funds, landlords, trade creditors, and bidders for estate assets in Chapter 11 and Chapter 7 bankruptcy proceedings. She has also represented banks, institutional lenders, and corporate borrowers in commercial loan transactions and debt restructurings.
Russell is the principal author of Thomson Reuters’ Texas Practice Guides for both Creditors’ Rights and Financial Transactions and the Texas Bankers Association’s Texas Secured Lending Guide, Texas Problem Loan Guide, Texas Real Estate Lending Guide, and Texas Account Documentation Guide. She is a frequent speaker on banking, bankruptcy, and financial restructuring-related topics and has served as a Chapter 7 Trustee. Russell received her LL.M. in Banking Law from Boston University and her J.D. from Baylor University where she was Editor-in-Chief of the Baylor Law Review and the highest-ranking graduate in her class. She clerked for the Texas Supreme Court before beginning her legal career.
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
Available Upgrades:
Excel expert David H. Ringstrom, CPA, focuses on the basics of using Excel pivot tables in this comprehensive presentation. Pivot tables empower you to easily create reports from complex data, simply by using your mouse. Ringstrom explains how to initiate a pivot table from a list of data, expand and collapse pivot table elements, dig deeper into the numbers with the Report Filter command, and much more. As is the case with many features in Excel, pivot tables have nuances that can trip you up, so Ringstrom points out traps and teaches you tricks to help ensure your reports are always accurate.
Ringstrom demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. Ringstrom draws your attention to any differences in the older versions of Excel (2021, 2019, 2016, and earlier) during the presentation as well as in his detailed handouts. Ringstrom also provides an Excel workbook that includes most of the examples he uses during the webcast.
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
Covered Topics
Who Should Attend
Professionals who need to create actionable reports from lists of data with minimal effort.
Instructor Bio
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. Ringstrom’s mantra is “Either you work Excel, or it works you”, so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).
Registration Options
Live Access, 30 Days OnDemand Playback, Presenter Materials and Handouts $279
Available Upgrades:
Topics in analyzing source documents, recording business transactions in a journal and posting entries in a ledger. How to prepare a trial balance, gather adjustment data and complete a worksheet are covered, as well as how to prepare financial statements and post-closing entries.
This course is the recommended prerequisite for Analyzing Financial Statements.
Audience: Bank personnel at any level with little or no accounting background
The required textbook for this course is College Accounting, 13th Edition.
IMPORTANT: Be sure to order the required book for this course. We recommend that you FIRST select and add your course session to the shopping cart, then select your preferred format of book from the “Recommended Training” options that appear alongside the shopping cart
Price: $471
Topics in analyzing source documents, recording business transactions in a journal and posting entries in a ledger. How to prepare a trial balance, gather adjustment data and complete a worksheet are covered, as well as how to prepare financial statements and post-closing entries.
This course is the recommended prerequisite for Analyzing Financial Statements.
Audience: Bank personnel at any level with little or no accounting background
The required textbook for this course is College Accounting, 13th Edition.
IMPORTANT: Be sure to order the required book for this course. We recommend that you FIRST select and add your course session to the shopping cart, then select your preferred format of book from the “Recommended Training” options that appear alongside the shopping cart
Price: $471
Ideal for those new to consumer lending, as well as current lenders who want to enhance their knowledge. The course covers forming a loan policy, generating applications, learning about the credit investigation, and understanding the evaluation of and decisions that go into every loan application.
Audience: Entry-level consumer lenders, consumer credit personnel, and bank employees who need to understand consumer credit.
The required textbook for this course is Consumer Lending, 7th Edition.
IMPORTANT: Be sure to order the required book for this course. We recommend that you FIRST select and add your course session to the shopping cart, then select your preferred format of book from the “Recommended Training” options that appear alongside the shopping cart.
Price: $405
Ideal for those new to consumer lending, as well as current lenders who want to enhance their knowledge. The course covers forming a loan policy, generating applications, learning about the credit investigation, and understanding the evaluation of and decisions that go into every loan application.
Audience: Entry-level consumer lenders, consumer credit personnel, and bank employees who need to understand consumer credit.
The required textbook for this course is Consumer Lending, 7th Edition.
IMPORTANT: Be sure to order the required book for this course. We recommend that you FIRST select and add your course session to the shopping cart, then select your preferred format of book from the “Recommended Training” options that appear alongside the shopping cart.
Price: $405
A review of the fundamental skills needed to begin to undertake credit analysis, loan structuring and monitoring for agricultural customers. The course also provides guidance on dealing with problem loans. This course was developed in conjunction with the Schools of Banking, Inc., a jointly-owned subsidiary of the Kansas and Nebraska Bankers Associations.
Audience: Those new to agricultural lending or with limited experience
Price: $475
A review of the fundamental skills needed to begin to undertake credit analysis, loan structuring and monitoring for agricultural customers. The course also provides guidance on dealing with problem loans. This course was developed in conjunction with the Schools of Banking, Inc., a jointly-owned subsidiary of the Kansas and Nebraska Bankers Associations.
Audience: Those new to agricultural lending or with limited experience
Price: $475
This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.
OKLearn more×We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.
We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds:
You can read about our cookies and privacy settings in detail on our Privacy Policy Page.
Terms of Use