CPE Catalog & Events

2024 Tax Depreciation: Review & Update

Recent tax legislation, rules and developments related to capitalization and depreciation Capitalization of tangible property, including materials and supplies, building and improvements Small taxpayer safe harbor Section 179, including 2020 inflation adjustment Section 168(k) 100% bonus deduction

2024 Excel Essentials for Today's Accountant: Become an Expert in One Day

Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Enhance creativity in your approach to developing Excel models Computer software and application 

How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concepts

Properly assessing inherent, control, and fraud risk on an engagement, and linking the results to an appropriately tailored detailed audit plan based on risk assessment and client service goals, regardless of entity type (for-profit, nonprofit, governmental) Leveraging strong substantive analytic procedures as audit evidence to cut back on tests of details The most common efficiency opportunities for tailoring your audit approach based on risk How to use the workpaper review process as a tool for producing a more effective and efficient engagement Using audit documentation to enhance audit quality, while ensuring every workpaper has a purpose How to use the client to your advantage in planning and performing the audit Learn how to get the engagement out the door – on time and on budget! 

K2's 2024 Excel PivotTables for Accountants

PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables Formatting PivotTables Advanced PivotTable techniques and options, including consolidation PivotTables, user-defined calculations, and working with Power Pivot Analytical techniques available in PivotTables

Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements

Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards  Understanding the quality control standards and guidance related to a CPA firm’s responsibilities for its system of quality control Explain the importance of establishing, applying, and monitoring quality control policies and procedures related to audit documentation

The Single Audit from Beginning to End Update

Introduction Applicable AICPA standards Applicable OMB Circular Gathering information - determining the major programs Identifying risk – identifying the applicable compliance requirements Assessing risk – considering the internal controls over compliance requirements Designing procedures that are responsive to assessed risks – the tests of internal controls and compliance Evaluating single audit evidence

The Yellow Book: From Beginning to End

Introduction Foundation and principles General requirements for complying with Government Auditing Standards Ethics, independence and professional judgment Competence and continuing professional education Quality control and peer review Standards for financial audits Standards for attestation engagements and reviews of financial statements

Valuing Cannabis 2.0: Unique Marijuana Appraisal Challenges

The major topics covered in this course include:Updates to incorporate new and emerging data sources and industry trends in the value proposition for marijuana businessesReview of fundamental valuation concepts and methodsDiscussion of the value of license rights and related intellectual propertyUseful topics for practitioners and owner/operators involved in purchase price allocation work, economic damage assessments, estate planning and merger acquisition

Networking Works: Build Relationships to Build Your Business

Communication Relationship-building Active listening Public speaking

2024 New Client Ethical Challenges: The CPAs Guide

How the CPA can meet the challenges presented by a new client AICPA Code of Professional Conduct AICPA Statements on Standards for Tax Services IRS Circular 230 Case study illustration of how to bring the new client into ethical, proper financial and tax compliance

Becoming a Fraud Investigator

The major topics covered in this class include:Core concepts of fraudCommon workplace fraud schemesRed flags of occupational fraudEvaluating fraud tipsSkills of a fraud investigatorPlanning the fraud investigationBudgets, fees, and engagement letters

Analytical Procedures: Methods and Evaluation 2024

Review of the appropriate audit and review standards Identifying appropriate analytical procedures in the circumstances Developing expectations Designing and performing analytical procedures Investigating results of the procedures performed Introduction to data analytics

K2's 2023 Mastering Advanced Excel Functions

Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use “legacy” features and functions such as AGGREGATE Creating effective forecasts in Excel

Expand Your Analytical Toolbox More Tools for Success

5 step valuation process 2 specific valuation approaches The Gordon Model 10 thoughts on banker selection Rating your bank 10 hints for keeping your toolbox full

How Fraud Can Affect Smaller Organizations

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

Partnership and S Corporation - Basis and Distribution Issues

Audit 205: Auditing Liabilities and Long-Term Debt Risks

The major topics covered in this course include:Typical audit procedures related to accounts payable and accrued expenses, including the search for unrecorded liabilitiesKey controls related to liabilitiesAuditing long-term debt, including compliance with covenantsDetermining the proper classification of financing arrangementsProper form of noncompliance waiver lettersImpact of noncompliance on disclosures

Surgent's Handbook for Mastering Basis, Distributions, and Loss Limitation Issues for S Corporations, LLCs, and Partnerships

Timely coverage of breaking tax legislation Applicable coverage of any basis considerations within any recent tax legislation   Passthrough basis calculations required as attachments to certain individual returns  Executor’s form for disclosing basis in certain distributed property; what about the basis of a property distribution from a trust?  How §179 limitations affect basis and how tax-benefit rule is applied  Basis implications of personal assets converted to business use  How to calculate basis of inherited qualified and joint tenancy property  Tax basis capital account reporting requirements  S corporations: Beware of final IRS regulations regarding “open debt”; determine how to calculate basis; worksheets are included; understand the effect of stock basis and debt basis and IRS’s recent focus on “at-risk basis” for shareholders; recognize how AAA applies or doesn’t apply to S corporations; learn to apply the complex basis ordering rules and special elections that can have a big tax result; discuss loss limitation rules in depth; when you can have a taxable dividend in an S corporation; understand distributions of cash and property; understand the post-termination transition rules, and temporary post-termination rules for eligible corporations, which will be important for S corps returning to C corps  LLCs and partnerships: Learn the detailed rules of §704 for preventing the shifting of tax consequences among partners or members; learn to calculate basis under §704 & for “at-risk” under §465; recognize how recourse, nonrecourse, and qualified nonrecourse debt can create significantly different tax results; learn the difference between basis and “at-risk basis”; review §754 step-up in basis rules; the economic effect equivalence test or “dumb-but-lucky” rule; learn to apply the complex rules of distribution of cash vs. property, and the basis treatment of charitable contributions and foreign taxes paid 

The Ethics Hour: Thinking Through Decisions and Recognizing the Consequences

The high volume of ethical decisions we face every day The true value of paying attention Understanding how each decision we make will have consequences Are you prepared for the consequences? 

2024 The Psychology of Fraud

Fraud Fraud Triangle