Webinars

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. David 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 David points out traps and teaches you tricks to help ensure your reports are always accurate.

This 2-part webinar is tailored for Call Report preparers, reviewers, and auditors, with a specific focus on loan related schedules within the Call Report. We’ll provide in-depth knowledge and guidance on accurately reporting loan-related data in the Call Report.

Regulations governing how loans are coded on Schedule RC-C dictate their reporting across all loan schedules within the Call Report. In this webinar, learn to report the four risk-based capital categories of loans on Schedule RC-C accurately to provide greater visibility in your institution’s portfolio and overall health for more informed decision-making.

While many users rely on VLOOKUP to return data from other locations in a worksheet, that’s not always the most efficient approach. In this comprehensive presentation, David reveals alternatives to VLOOKUP, including the HLOOKUP, INDEX and MATCH, XLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, IFNA, FILTER functions and more.

This 2-part webinar is tailored for Call Report preparers, reviewers, and auditors, with a specific focus on loan related schedules within the Call Report. We’ll provide in-depth knowledge and guidance on accurately reporting loan-related data in the Call Report.

Economic forecasting is one of the most important components for CECL. Take this course to gain the skills and strategies needed to correctly forecast and update your CECL allowance.

With incorrect reporting having serious consequences, now is the time to upskill and take control of your financial reporting process. Join us as we delve into the reporting requirements and guide you through the proper & accurate completion of the RC & RI schedules.

This webinar will demonstrate how to utilize ratio analysis to determine the financial impact on changing metrics such as a change in the Working Capital Assets Turnover and Working Capital Liabilities Turnover and changes in the Gross Profit Operating and Net Profit Margins, This analysis will also allow the lenders to structure loans appropriately by determining the amount of funding needed to replace the cash flow losses caused by negative financial trends. When this specialized analysis is mastered, the lender can add the “WOW” factor to their analysis by not only describing trends but also the cash flow financial impact of those changing trends.

Welcome to a 2-part series dedicated to unraveling the complexities of Schedule RC-R within the Call Report—a critical aspect of regulatory compliance for financial institutions. Part 1 will focus on essential reporting requirements in the first section of Schedule RC-R, while Part 2 will delve into the intricacies of the second section. Join us as we navigate through the nuances of regulatory capital reporting, providing clarity and guidance along the way.