CPE Catalog & Events

An introduction to the data analysis process flow and how it is your pathway to becoming a data analysis expert A comprehensive discussion of building a data model and calculating metrics How visualizations can present data in a more insightful and impactful manner

The key requirements, options, and best practices seen in each of the basic financial statements Today’s core accounting and reporting requirements related to contributions and how to effectively and efficiently apply them How to analyze and incorporate the needs of financial statement users into a not-for-profit’s financial statements and disclosures

The key requirements, options, and best practices seen in each of the basic financial statements Today’s core accounting and reporting requirements related to contributions and how to effectively and efficiently apply them How to analyze and incorporate the needs of financial statement users into a not-for-profit’s financial statements and disclosures

The psychology of perception Preparation checklist for networking Presenting your best self Perception management Preparing oneself for networking Setting expectations and limits  Seamless self-introductions How to introduce others Overcoming anxiety How to start conversations Situational questions   The art of conversation flow Listening skills Topics to avoid Graceful exits Body language Navigating large events/conferences One-on-one meetings Cocktail party etiquette Remembering names Strategies for introverts Follow up recommendations How to maintain and sustain relationships long term

The core concepts of data modeling in Power BI, including integration of various data sources Techniques to establish and manage relationships between different data sets Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures When to use calculated columns and when to opt for measures The difference between and appropriate applications of explicit and implicit measures in data analysis Creating and utilizing hierarchies to enhance data analysis and reporting Practical skills in using pivot tables within Power BI to validate and refine measures

Determining the acquisition date Recognizing and measuring the identifiable assets acquired, the liabilities assumed, and any noncontrolling interest in the acquiree Acquisition of contingencies Noncontrolling interests Recognizing and measuring goodwill or gain from a bargain purchase Measurement period adjustments

Marketing plans and how they provide direction and strategy for business growth Fundamentals of an effective website The growing importance of social media Strategies for obtaining and cultivating referral sources The benefits and challenges of networking organizations Creating a niche in saturated industries Using online publishing to meet your growth objectives

Networking organizations  Obtaining referral sources

Managing interruptions   The role of to-do lists  Creating an effective time management plan  Staying on track of your time management plan  Blocking out time

Contract principles Partnerships and limited liability entities Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Intellectual property Real property law Bankruptcy basics Environmental Law Merger Basics

Contract principles Partnerships and limited liability entities Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Intellectual property Real property law Bankruptcy basics Environmental Law Merger basics

Contract principles Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Real property law

Contract principles Legal issues related to various types of business organizations Worker classification Employee rights and the duties of employers Real property law

An overview of the business evaluation process Negotiation points and goals from buyer and seller standpoints An overview of confidentiality agreements, memorandums of understanding, and asset purchase agreements Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The use of “F reorganizations” in lieu of §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Changes in strategy under the new tax laws Liquidation as an alternative to the sale of a business Planning to avoid double taxation Special problems and opportunities when an S corporation is the buyer or seller Special problems and opportunities when a partnership is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities

An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill

An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill

Differences between planning and budgeting Building change into the planning process The business model Strategic plan, marketing plan, and technology plan Financial forecasting and financial risk analysis Five-year operating plan and the sales/income plan Intermediate planning and capital equipment planning One-year operating plan and monthly planning Cash plan and risk plan

The CFO’s expanding role in organizational leadership Leading innovation in finance and beyond Navigating economic challenges and uncertainties Effective risk management frameworks for CFOs CFOs as agents of change: aligning finance with broader organizational strategy The intersection of finance, technology, and innovation

Why businesses operate as C corporations Why businesses operate as pass-through entities Adopting C corporation status Why businesses choose S corporation status. Tax and business situations that impact entity selection.

Introduction to Power Query in Power BI: the interface and basic functionalities Removing duplicates, handling null values, and data type conversions Advanced methods for manipulating data, including pivoting, merging, and appending queries Efficiently loading data into the Power BI data model Setting up details for each step in the process so you can document what is happening and why