CPE & Event Catalog

Classifying receipts between "income" and "corpus" under the Uniform Principal and Income Act. Calculation of DNI utilizing three different methods, a "forms" method (Schedule B), a "code" method, and a "shortcut" method, utilizing a worksheet of common income and expenses. Proper W-2 preparation and procedures in the year of death. Forgetful fiduciaries of simple trusts. Fluctuating trusts: Simple one year, complex the next. Dividing income in the year of death. Overview of Subchapter J. Form preparation issues: Filing requirements and line-by-line explanations of Form 1041. Taxable income of estates and trusts and expense allocation issues. Specific deductions and miscellaneous itemized deductions. Income in respect of a decedent. The income distribution deduction calculation. Relation of principal and income law to DNI. Understanding how to handle capital gains and losses. Other considerations: Excess deductions on termination. Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation. Comprehensive trust and estate case studies, with filled-in forms.

Understanding formula conventions. Working with functions. Examples of powerful Excel formulas.

The power of keyboard shortcuts. Often used features with more capability than meets the eye. New helpful features.

Using Excel for graphical output and dashboard reporting. Data tools and the Data Analysis ToolPak. Advanced functions and complex formulas. Working with Excel tables and PivotTables.