CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
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
Business Consulting for CPAs
-
Online
4.00 Credits
What is Business Consulting? Identify the types of Management services your firm could offer. How to become the trusted advisor – identification of client’s needs? Learn how client expectations may create different performance and understanding levels for CPAs in business consulting engagements. Know what it takes to create a valuable outcome for the client. Understand the competitive advantages/disadvantages that your firm has versus non-CPA business consultants. Learn techniques to become a more effective consultant. Professional standards application
Forensic Accounting: Investigating Divorce Cases
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The role of a forensic accountant in divorce proceedingsThe marketing of forensic accounting services to family law attorneysHow to conduct a financial investigationCommon areas to uncover hidden assets or incomeThe basic calculations in evaluating marital assetsTestifying in depositions and divorce court
LLC's & S Corps -- A Comparative Analysis
-
Online
4.00 Credits
Comparative analysis of LLCs and S Corporations Entity formation, compliance, and operational structures Self-employment tax and its implications for LLCs and S Corporations Form 2553 preparation and relief for late filings Rev. Proc. 2022-19 and Rev. Proc. 2023-3: analysis and application S Corporation eligibility errors and corrective measures Corporate governance and formalities for both entity types Shareholder stock and debt basis for S Corporations Forms 1120S, 1065, and related schedules (K-1, K-2, K-3) Officer reasonable compensation and general partner guaranteed payments Audit strategies, estate planning, and business continuation planning
Taxation of the Cannabis Industry
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Industrial hemp vs. marijuana.Income definitions under I.R.C. §61.Tax code restrictions: §280E and §471.State-specific marijuana laws.Cash management in cannabis businesses.Federal court case analysis.
K2'S Tech Update
-
Online
2.00 Credits
Trends in AI and machine learning Applications of quantum computing in accounting and finance The growing role of blockchain and digital currencies in accounting Innovations in software and hardware
The Bookkeeper Goes to Prison
-
Virtual
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Surgent's Introduction to Forensic Accounting
-
Virtual
4.00 Credits
Review of the different aspects of forensic accounting The civil litigation process as it relates to forensic accounting Litigation services provided by forensic accountants Fraud detection and prevention Various types of fraud Training and certifications in forensic accounting Forensic accounting in bankruptcy proceedings Forensic accounting in family law proceedings Calculating damages for use in litigation Valuations Ethical issues pertinent to forensic accounting
Conducting a Remote Audit
-
Virtual
4.00 Credits
Leveraging the benefits of remote auditing Managing the team, client, and audit process remotely Identifying engagement-wide procedures from client acceptance through report issuance when remote auditing Understanding narrow-topic considerations when remote auditing
Reasonable Compensation for S Corps
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the payroll tax advantage of taking distributions over wagesReview key court cases that shape todays reasonable compensation landscapeHow to use court factors to stress test reasonable compensationBest practices for determining reasonable compensationReview of the IRS’s enforcement on reasonable compensation; past, present and future
Building a Better Budget in a Time of Uncertainty
-
Virtual
4.00 Credits
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
Surgent's Weekly Expert Hour
-
Virtual
1.00 Credits
Each week’s topics will change based on the most critical issues affecting financial professionals
K2's Optimizing Your Tech Stack For Efficiency And Cost-Effectiveness
-
Online
2.00 Credits
Conducting a tech stack assessment, including an inventory of current tools and applications Identifying essential and redundant tools Exploring cost-effective alternatives Calculating your total cost of ownership
Tax Procedure
-
Online
2.00 Credits
Filing a tax return IRS audit RS Appeals Collections and litigation at courts of original jurisdiction
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Surgent's Exploring Client Advisory Services: Tax Due Dates and Penalties/Where Do I Need To File?
-
Virtual
2.00 Credits
Estimated taxes and deadlines Tax due dates for common returns and filings Potential penalties and interest Information return penalties Penalties applicable to pass-through entities Accuracy-related penalties First-time abatement (FTA) FTA eligible returns Reasonable cause Nexus: sales tax vs. income tax Sales tax nexus with state specific examples Remote work and sales tax nexus Income tax nexus with state-specific examples Remote work and income tax nexus Sales factor: throwback rules
White-Collar Crime: What Every CPA Should Know
-
Online
2.00 Credits
Definitions of white-collar crime White-collar crime characteristics and statistics The CPA’s role in combating white-collar crime
Analyzing Financial Statements
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
Linking Risk Management to Strategy
-
Virtual
1.00 Credits
Enterprise risk management Strategic planning Key challenges organizations face The finance professional's expanding role Black Swan events
The Psychology of Fraud
-
Online
1.50 Credits
Fraud Fraud Triangle
