Events

Spreadsheet work often entails seemingly unavoidable data entry tasks. However, very often tedious input tasks can be automated, or at least made easier. In this webinar, Excel expert David H. Ringstrom turns his attention to empowering you to work more effectively with getting data into your spreadsheets and transforming data when needed. Techniques include worksheet functions such as CONCATENATE, TEXTJOIN, UPPER, PROPER, and so on, as well as using Microsoft Word to extract text from PDF files. You’ll see how to use Excel on your mobile device to take a picture of a printed document that you then convert to text within an Excel spreadsheet. Other techniques include helpful aids such as custom lists, data validation, and much more.

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

  • Adding the hidden Form Command back to Excel 2007 and later.
  • Avoiding the need to merge cells—use the Text Box feature for paragraphs of text instead.
  • Change the cursor direction in Excel to Right instead of Down to facilitate faster data entry.
  • Combining words or other text together by concatenating.
  • Creating an in-cell list by way of Excel’s Data Validation feature.
  • Editing .PDF documents in Word 2013 and later—useful for unlocking data you wish to edit in Excel.
  • Extracting data from PDF files with Power Query in Microsoft 365.
  • Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets.
  • Minimizing data entry by taking a picture of a document in the mobile version of Excel that you convert to text on your phone.
  • Redacting portions of Social Security numbers by way of Excel’s TEXT worksheet function.
  • Removing the Table feature from a worksheet if it’s no longer needed.
  • Separating first/last names into two columns without using formulas or retyping.

Who Should Attend
Professionals seeking to use Microsoft Excel more effectively.

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 Ringstrom, 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:

  • 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

  • Comparison of Traditional Cash Flow Method (Net Income + Depreciation + Interest divided by Annual Debt Service) to the UCA model
  • Rules of Cash Flow
  • Accrual Basis versus Cash Basis of preparing financial statements, and how cash flow analysis links the two
  • How each amount on a Universal Cash Analysis is calculated and the meaning of each
  • A Fast Cash Analysis method that can achieve the same results in less time than the UCA method
  • Leave with a good understanding of how cash flow is calculated and more importantly, how to interpret its meaning.

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.

Registration Options
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

The Call Report for 2022 is impacted by new and recent reporting requirements related to the adoption of the lease accounting standard, reporting brokered deposits, sweep accounts, and international remittance transfers.

Consideration of the FASB’s Accounting Standard Update (ASU) 2022-02 with impact to Accounting Standard Codification (ASC) Topic No 326 related to the elimination of Troubled Debt Restructuring recognition and measurement is also impactful to future regulatory reporting.

Also, consideration of the FASB issued exposure draft related to the extended application of ASC Topic No 848 related to Reference Rate Reform will be discussed in this training.

Covered Topics

  • New and Recent Reporting Revisions for 2022 Call Reports
  • Elimination of the temporary increases in total assets measurement.
  • Key elements and new items for reporting related to CECL
  • A discussion on reporting TDRs
  • Reference Rate Reform matters
  • Reporting leases under ASC Topic No 842
  • Reporting HELOCs as closed-end in your 2022 reports
  • Reporting International Remittance Transfers
  • The changes related to the brokered deposit framework
  • Newly added items to Schedule RC-E on retail sweep accounts
  • Common questions and potential reporting errors
  • Realized and unrealized gains and losses on equity securities
  • Loan coding and reporting income on loans
  • Reporting multi-family loans in RC-C and RC-R
  • PPP reporting and risk weighting
  • Reporting unfunded commitments

Who Should Attend
Anyone responsible for preparing, reviewing, auditing, or signing the Call Report will find the program valuable. The seminar is designed for more experienced preparers and reviewers interested in new reporting requirements and up-to-date rulings impacting preparation of the Call Report.

Instructor Bio
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.

Registration Options
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

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

  • Real Estate Lien Note/Promissory Note: The note is enforceable against the borrower! Review of each section for content, purpose, rights of all parties and scope of language.
  • Mortgage & Deed of Trust: The mortgage or deed of trust is enforceable against the real property interest taken as collateral. Review of each section for content, purpose, rights of all parties, representations and warrantees, plus enforceability.
  • Title Commitment and Title Policy: The title policy protects the lender by assuring an acceptable lien position. Knowing what to expect and what to look for is essential to underwriting and closing real estate loans.
  • Guarantees: A guarantor of a real estate loan may have limited recourse and/or may execute a special environmental guaranty. Bankers need to understand the types of guarantees specific to real estate loans

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:

  • 12 Months OnDemand Playback + $110
  • 12 Months OnDemand Playback + CD + $140
  • Additional Live Access + $75 per person

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

  • Identifying the ideal data for analysis with Excel’s PivotTable feature.
  • Creating a pivot table to transform lists of data into on-screen reports.
  • Distinguishing the differences among pivot table-related menus in Excel 2013 and later versus older versions of Excel.
  • Adding rows to a blank pivot table to create instant reports.
  • Repositioning or removing subtotals within pivot tables.
  • Exploring the nuances of formatting numbers within pivot tables.
  • Avoiding the dreaded PivotTable Field Name Already Exists error prompt.
  • Filtering pivot tables to show fewer columns and/or rows of data.
  • Presenting the largest or smallest values in chart form by way of a Top 10 pivot chart.
  • Unlocking additional filtering capabilities in pivot tables by knowing where to position one’s cursor to re-enable the Filter command.
  • Utilizing the Tabular Format command to display pivot table data in two or more columns instead of a single column in Compact Form.
  • Resetting all filters at once within a pivot table by way of the Clear Filters command.

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:

  • 12 Months OnDemand Playback + $110
  • 12 Months OnDemand Playback + CD + $140
  • Additional Live Access + $75 per person

Attend this proactive webinar and gain an understanding of the often complex and confusing topic of TAXES!

Bank personnel are required to obtain and properly interpret tax returns for both commercial and consumer lending purposes. The first part of this webinar will concentrate on personal tax return analysis while the second part will focus on the analysis of various business tax returns.

Covered Topics

  • The objectives of the first part of the webinar consist of the following:
  • Review the basic structure of the personal 1040 federal tax return (including the various schedules and K-1 forms)
  • Use analysis techniques to prepare a personal cash flow from information gleaned from the 1040 and the related schedules
  • Discuss recent changes in the tax code including the “Tax Cuts and Jobs Act” (TCJA), the CARES Act, and proposed tax legislation and how they affect the bank’s individual borrowers/guarantors, and
  • Describe how the 1040 tax return can be used to market the bank’s products and services.

The second part includes:

  • Discuss the structure of a C corporation, S corporation, and Partnership (including LLC) tax return
  • Analyze business tax returns and prepare cash flows for these entities
  • Draw additional information from the business returns including identifying fraudulent tax returns
  • Discuss updates in the tax code including the TCJA, CARES, and proposed tax legislation as they apply to businesses.

Who Should Attend
Commercial lenders, credit analysts, consumer lenders, mortgage lenders, loan documentation specialists, branch managers, assistant branch managers, private bankers, and business development officers.

Instructor Bio
David L. Osburn, MBA, CCRA, is the founder of Osburn & Associates, LLC, a Business Training & Contract CFO Firm that provides seminars, webinars, and keynote speeches for bankers, CPAs, credit managers, attorneys, and business owners.

His extensive professional background of over 30 years includes 20 years as a Business Trainer/ Contract CFO and 16 years as a bank commercial lender including the position of Vice President/Senior Banking Officer. Mr. Osburn has also been an adjunct college professor for over 30 years including College of Southern Nevada.

Registration Options
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

The WBA Credit Analysis Boot Camp will start on Wednesday, June 22, 2022 at 9:00 a.m. and adjourn on Thursday, June 23, 2022 by 3:00 p.m.

Financial statement, cash flow, and tax return analyses are all important components of understanding your business borrower and helping your bank make a good credit decision. This two-day boot camp is designed to be hands-on and interactive through case study analysis and classroom discussions. New and experienced staff will benefit from this program.

Day 1 Schedule (9:00 a.m. – 4:00 p.m. CT)

  • Basics of Bank Lending – Setting the Foundation
    • Reviewing the 5 C’s of Credit
    • Role of the Credit Analyst in the lending decision
    • Exposure to concepts of loan structure, loan support, and documentation issues
  • Key Ratio Analysis: Calculating and Interpreting the Numbers Correctly!
    • Learn a “five-step” analysis plan to calculate the key ratios covering liquidity, activity, leverage, operating performance, and cash flow analysis and correctly interpret the financial condition of the business client
    • Discuss “negotiating” with other financial professionals using the ratios
    • Review the Z-score and sustainable growth models
    • Case study analysis: applying the concepts!

Day 2 Schedule (8:00 a.m. – 3:00 p.m. CT)

  • Basic Personal Tax Return Analysis
    • Review the basic structure of the personal 1040 federal tax return (including the various schedules and K-1 forms)
    • Use analysis techniques to prepare a personal cash flow from information gleaned from the 1040 and the related schedules
    • Discuss recent changes in the tax code including the “Tax Cuts and Jobs Act” (TCJA) and how they affect the bank’s clients
    • Describe how the 1040 tax return can be used to market the bank’s products and services.
  • Basic Business Tax Return Analysis
    • Discuss the structure of a C corporation, S corporation, and Partnership (including LLC) tax returns
    • Analyze business tax returns and prepare cash flows for these entities
    • Draw additional information from the business returns including identifying fraudulent tax returns
    • Discuss updates in the tax code including the TCJA as they apply to businesses.

Speaker: David L. Osburn, MBA, CCRA

Who Should Attend? This boot camp is designed for credit analysts and others in the bank who are responsible for reviewing financial statements and tax returns. New and experienced credit analysts will benefit from this program.

Registration Information: The registration fee of $495/attendee includes program registration, instruction and materials, and a daily lunch buffet and refreshment breaks.

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