CPE Catalog & Events

The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants:  This section teaches how simplify the use of static values called Array Constants

Accounting Finance Financial Statement Preparation

Taxable terminations Mismatch between available exemption and GST, and utilizing excess GST GST elections on Form 709 and automatic allocations

Update on significant business tax developments related to cases and rulings Business provisions of any recent legislation impacting business entities Depreciation changes in Sec. 179 and Sec. 168(k) bonus depreciation Recent developments impacting partnership and S corporations, including any changes to Forms 1065 and 1120S

Developing short-term cash flow projections How do we assure adequate cash availability without having idle cash?  Take advantage of your bank’s cash management services Working capital loans Controlled disbursement accounts Sweep accounts and other short-term investments ACH transactions Direct transfers Lock boxes Credit and collections Reconciliation frequency Managing cash short-falls

Broadly applicable ASU effective in 2024 and beyond Significant recent SAS

The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis

Asset sales and stock sales and their attendant results to buyers and sellers Section 1060 and using the residual method Consequences of making a Section 754 election with adjustments under Sections 743(b) and 734(b) Section 338 and Section 338(h)(10) elections Allocating some of the purchase price of a business to personal goodwill Partnership distributions to retiring partners under Section 736(a) and 736(b) Consulting agreements and employment agreements as between buyers and sellers Advantages of a C corporation having Section 1202 stock

Ethical Responsibilities for CPAs The AICPA Code of Professional Conduct PCAOB Ethical Standards The Sarbanes Oxley Act The Foreign Corrupt Practices Act Circular 230 for Tax Practitioners The Dodd-Frank Banking Reform Act

The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses

Primacy of the Form 990 as a "one size fits all" reporting mechanism Form 990 preparation sequencing and data gathering; and keys to getting Form 990 preparation right the first time Addressing presence of "related organizations" Identification of managers and measurements of their compensation 990 versus books-and-records financial statement detail Disclosures of governance inputs and Boards' employ of policies

Hiring and firing issues – What questions cannot be asked in an interview; how to document employee performance; establishing an annual review system; when an employer may and may not fire an employee, and much more Employment contracts – An analysis of the legal and planning issues in structuring employment contracts; when noncompetition agreements will and will not work Employment issues in the economy – Telecommuters and other special situations Legal liability issues – Recognition of age discrimination, sex discrimination, FLSA issues, minimum wage, overtime, sexual harassment, and more Fringe benefit issues – COBRA, Family and Medical Leave Act, and new developments in health care Medical plans – Who is a full-time employee?

The major topics that will be covered in this class include:How to use analytical procedures as a management tool to identify areas hindering the profitability of the entityHow to use analytical procedures to identify misstatements in financial informationTechniques for developing a "workable" business planRecasting GAAP financial statements into powerful management toolsDeveloping and using benchmarks to identify profitability problemsIdentifying profitability key factorsThe relationship of internal controls and the health of an entityCommon weaknesses in the internal controls of SMEs using the guidelines in the COSO Report on Internal Controls and common internal controls to address those weaknessesHow to create "goal" statements that achieve results

The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.

The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting

The audit risk model Risk assessment Linking risks to audit procedures Other responses to risks Documentation

Employee complaints Personality & attitude problems Performance counseling Personal hygiene problems Disability-related performance issues Misconduct due to mental conditions  

Definitions of white-collar crime White-collar crime characteristics and statistics The CPA’s role in combating white-collar crime

The major topics that will be covered in this course include:Introduction to ChatGPT and its Applications in Accounting.Custom Instructions (CI) for Persistent Context in Financial Conversations.Analyzing Financial Statements and News Releases using ChatGPT.Exploring Business Opportunities through Hyper-Local and Sectoral Analysis.Advanced Data Analysis for Financial Comparisons and Capital Asset Audits.Image Analysis for Asset, Space, and User Interface Design.Voice Interaction with ChatGPT for Enhanced User Experience and Accessibility.

Negotiations Business Management