CPE Catalog & Events

Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations

How SECURE Act 1.0 and SECURE Act 2.0 changed the RMD rules What is an RMD? Who is subject to RMDs? The types of accounts subject to RMDs How to calculate an RMD How to determine if a distribution can be an RMD How to determine which life expectancy table must be used when calculating an RMD The rollover and transfer rules during an RMD year IRS penalties for non-compliance with RMD regulations Applying RMD strategies to different plan types When RMDs can and cannot be aggregated How to correct an RMD shortfall How to get a waiver of the excise tax on an RMD failure The tax implication of an RMD How to donate an RMD tax-free How to determine the RMD rules that apply to a beneficiary

Marginal tax rates effective in 2025 and beyond The QBI deduction Qualified residential interest Child Care Credit Miscellaneous itemized deductions, including the educator deduction Rollovers from 529 plans to ABLE accounts Additional expenses treated as qualified higher education expenses for purposes of 529 accounts Termination of credits for environmentally clean autos and expenditures Other timely topics

Lower marginal tax rates made permanent New, more generous depreciation rules for bonus and Section 179 Qualified production property and bonus depreciation Full expensing of domestic research and experimental expenditures Rev. Proc. 2025-28 and options for small taxpayers Taking advantage of the QBI deduction Taking advantage of the SALT cap and the pass-through entity tax Form 1099 reporting changes Deducting business interest and business losses Taking advantage of the new Section 1202 tax regime

Consolidation accounting framework Voting control  Variable Interest Entities Business combinations Control case examples Business combination case examples Disclosures

ABC's of how generative AI tools (e.g. ChatGPT, Copilot, Gemini) work

Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables

Mandatory automatic enrollment for new plans Part-time worker eligibility expansion Higher catch-up limit to apply at age 60, 61, 62, and 63 Change in the credit for small employer pension plan startup costs $2,000 saver’s match Changes in pooled employer plans Multiple employer 403(b) plans Increase in age for required beginning date for mandatory distributions Indexing IRA catch-up limit Treatment of student loan payments as elective deferrals for purposes of matching contributions Application of credit for small employer pension startup costs to employers who join an existing plan Small immediate financial incentives for contributing to a plan Withdrawals for certain emergency expenses Starter 401(k) plans for employers with no retirement plans Recovery of retirement plan overpayments Tax treatment of IRAs involved in a prohibited transaction Clarification of substantially equal periodic payment rule

Adding user-defined calculations to PivotTables

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

Fundamental principles of AI and data ethics Importance of ethics in AI adoption Relevance of data ethics in accounting practices Frameworks for ethical AI implementation Ethical implications of AI in auditing and accounting Maintaining independence and objectivity Ensuring professional skepticism with AI tools Addressing ethical dilemmas in AI-driven audits Algorithmic bias and fairness in AI systems Identifying and understanding algorithmic bias Strategies to ensure fairness in AI models Case studies on bias and fairness issues in accounting Regulatory requirements and guidelines Overview of national and international regulations (e.g., GDPR, HIPAA) Compliance with ethical standards in AI use Emerging guidelines from accounting bodies on AI ethics Strategies for ethical AI use in accounting Implementing ethical AI frameworks and tools Promoting transparency, accountability, and fairness Developing a culture of ethics in AI-enhanced accounting practices

SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions  SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters

Taking a strategic perspective relative to risk management and crisis management Reviewing the impact uncertainty and risk at the operational level relative to short- and intermediate-term decision making Determining the safety and soundness of the financial plans for your organization in an uncertain economic climate specifically as it relates to capital adequacy and strategic direction Managing the debt and equity mix for your organization in a rapidly changing economic landscape Determining the impact that competing in a global marketplace has on an organization and how to take steps to become more competitive globally Evaluating the impact of federal, state, and municipal deficits and unfunded mandates as it relates to tax planning Evaluating retirement programs with Social Security funding for your employees Determining the safety and soundness of your credit and collections processes and selection of customers in an uncertain environment Influencing growth through acquisition of distressed organizations The economic way ahead for the CFO/Controller 

Definition of data analytics and big data; challenges and goals; establishing an environment for success; governance; common uses of analytics and current examples Behavioral forces that impact decisions; examples of inaccurate forecasts; identifying strategic measurements (KPIs); data sources Statistical tools, including median, mode, moving average, ratio analysis, Pareto analysis, trend analysis, regression, z-score, and simulation Software tools that are readily available and can assist in visually exploring data, expanding the scope of available data, as well as collecting, analyzing, and presenting results Specific ideas for using data analytics for accountants and financial managers, including current examples and areas for further consideration Lists of readings and next-level software for a participant’s future reference

What stock options are and why they are growing in popularity How stock options work, including the process of conveyance and vesting How to exercise stock options and the implications from doing so The risks associated with stock options and how to manage exposure Tax consequences and updates regarding stock options Strategies for selecting the best time to exercise stock options The difference between the two types of stock options: non-qualified and incentive The basic terminology relevant to owning and exercising options

Challenges of marketing CPA firms Developing marketing strategy  Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels  Marketing channel statistical analysis  Developing marketing metrics

Comprehensive coverage of the One Big Beautiful Bill Act Review of key components of President Trump's tax bill, including a tip income exemption, overtime pay relief, Social Security tax exemption, auto loan interest deductibility, SALT deduction modifications, a lower corporate tax rate, restoration of 100% bonus depreciation, immediate R&D expensing, and permanent extension of select TCJA provisions Tariff policy and implementation - analyze the use of tariffs as a fiscal and trade policy tool Digital assets and tax implications - understand the new Form 1099-DA for reporting digital asset transactions, along with updated IRS guidance on cryptocurrencies, NFTs, and broker responsibilities Artificial intelligence - discover how AI and generative tools are transforming tax practices, as well as how the IRS is leveraging AI to enhance audit selection Form 1099-K reporting requirements - understand the evolving IRS thresholds and rules for third-party payment platforms The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges, reporting responsibilities, and the impact of the 2024 Department of Labor Final Rule on worker status Timely coverage of breaking tax legislation Real Estate professional requirements Review of pertinent cases and rulings affecting taxpayers Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas

Extensive review of the partnership tax laws with an emphasis on any new legislative changes and Form 1065 (and related schedules) preparation issues Overview of different forms of business entities, including the check-the-box regulations Formation issues, including the mandatory allocation of the §704(c) pre-contribution gain or losses back to the contributing partner/member Schedule K and K-1'preparation issues including separately and non-separately stated income and expense items (including the 20% qualified business income (QBI) deduction, 3.8% net investment income tax, business interest deduction limitations, fringe benefits and entertainment expenses) Calculating the tax and §704(b) book capital accounts Understand the substantial economic effect requirement to have special allocations to the partners/members Allocation of recourse and non-recourse debt to the schedule K-1s Deductibility of fringe benefits, including health insurance premiums Guaranteed payments & self-employment tax issues and pitfalls Overview of how partnership losses and deductions can be limited to calculating a partner/member's outside basis and at-risk rules §754 election for optional basis adjustments triggering §743 (transfer of interests) and §734 (distributions) Partnership liquidation and distribution tax ramifications at both the partnership and partner level

Recently issued FASB Accounting Standards Updates, PCC Update, and items on the FASB’s Technical Agenda Recently issued ASUs covering derivatives, credit losses under ASC 326, government grants, and expense disaggregation FASB Final PIR Report for Leases (Topic 842) Statement on Quality Management Standards: SQMS 1, SQMS 2, and SQMS 3 Proposed SAS on the auditor’s responsibility relating to fraud Recently issued SASs and other AICPA activity Recently issued PCAOB standards and SEC rulemaking activities Other important A&A practice matters

Blockchain technology primer