CPE Catalog & Events

Health and Wellness Burnout Stress Management Employee Engagement

Introduction to Form 7203 Introduction to the calculation of stock basis Introduction to the calculation of loan basis Taxable and nontaxable S corporation distributions to shareholders The election to reduce basis by deductible losses and expenses before reducing basis by nondeductible expenses

529 to Roth: who, what, when, and how SECURE Act 1.0 and the 10-year rule Roth IRA beneficiary options Where the stretch IRA really ends The new limitations for spouse IRA beneficiaries The new spouse options for spouse beneficiaries New RMD rules for Roth 401(k)s Overriding the 10-year rule for an eligible designated beneficiary How the age of death affects beneficiary options The new early distribution penalty exceptions Rollovers vs. transfers for spouse beneficiaries Qualified charitable distributions (QCDs) for owners and beneficiaries The “at least as rapidly” (ALAR) rule New reduced rate for excess accumulation penalty on RMD failures How to avoid unlimited accrual of the 6% excise tax How to avoid unlimited accrual of the 25% excise tax Clarifying the definition of disability for an exception to the 10% additional tax The new starting ages for RMDs Designated vs. eligible designated beneficiaries and their options Catch-up contributions for ages 50 and over Catch-up contributions for ages 60 to 63 When the 60-day deadline is missed When the one-per-year rollover limit is about to be broken Retaining qualifications for exceptions to the 10% additional tax

Detailed coverage of any new legislation affecting basis computations and distributions and changes to the schedule K-1s (including the NEW Form 7203 – S Corporation Shareholder Stock and Debt Basis Limitations) Line-by-line analysis of the Schedule K-1s to determine how the items affect a S shareholder’s stock and debt basis and a partner/member’s outside basis and where the items get reported on Federal individual income tax return The three loss and deduction limitations on the owner’s individual income tax return (i.e. basis, at-risk and other Form 1040 limitations) How cash or non-cash distributions affect the basis calculations and whether or not they are taxable to the owners Compare the tax treatment of the sale of a shareholder’s stock in a S corporation and a partner’s interest in a partnership What constitutes debt basis for a S corporation shareholder under the final regulations The tax ramifications of repaying loans to S corporation shareholders and on open account debt How recourse and non-recourse debt effect a partner or member’s basis calculations and amount at-risk

The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage  data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.

Accounting Finance Auditing

"Tales from the Front" - practice issues CPAs are dealing with in these extraordinary times Review of AICPA Code of Professional Conduct Review of IRS Circular 230 Review of client tax return disclosure rules (Sec. 6103) Crisis impacts on engagement letters, contingent fees, independence, consulting services, attest and non-attest services, billing, and collections

The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.

The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.

What is Yellow Book? What is different because of Yellow Book? When might Yellow Book apply to a business? Common application of concepts to businesses Answers to common questions  

The major topics that will be covered in this class include:2021/22 legislation impacting business taxpayersExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions

Reality of Excel use Gartner - Magic Quadrant of tools for data analysis Will Excel go away? Two essential Lean principles Misuses of Excel APIs (Automated Program Interfaces) Relationship between Excel and data analytics Excel tips and tricks

Accounting Finance

Determining an appropriate sense of quantitative and qualitative materiality Identifying the critical components of the financial statements that matter most to financial statement users Evaluating where the financial statements are most likely to contain material fraud and error, and ensuring adequate internal control and monitoring to mitigate those risks

Show Value As Sorting Filtering PivotTable alternatives (GROUPBY, PIVOTBY, and PERCENTOF) Text Functions (TEXTJOIN and TEXTSPLIT)

What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models

Common errors made involving the following: Form 1065 Schedules K and K-1 Schedules M-1 and M-2 Calculating recourse and nonrecourse liabilities Partner inside and outside basis Partner's capital account analysis Sections 704(b), 704(c), 721, 722, 732(b), 734(b), 737, 743(b)

The major topics that will be covered in this course include:The five principles of ethical intelligenceHow to make the right decisions in a range of challenging situationsThe fundamental ethical principal, "Do No Harm"

The impact of recent tax legislation on the real estate industry Depreciation and recapture Determining the basis when acquiring real estate Passive activity losses Calculation of gain or loss on sale of real estate Rental operations Installment sales

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