CPE & Event Catalog

Risks and uncertainties. Scope of disclosures. Nature of operations. Illustrative examples from ASC Topic 275. Illustrative examples from public business entities.

The need for divestitures. The spin-off option. The asset trade. Transition service agreements. Accounting issues. Human resources issues. IT issues. Marketing issues. Supply chain issues.

Divorce transfers and settlements. Selected asset divisions.

Tax cuts and jobs act. Filing status. Innocent spouse issues.

Lease definition. Is there an identified asset? Consideration of substitution rights. Right to substantially all of the economic benefits. Right to control use of the asset. Decision-making rights. Final determination. Short-term lease exception. Determining whether a contract contains a lease.

The tax implications of flipping a dwelling.

Dashboard mockup. Chart overview. Creating charts. Chart basics. In-cell charts. Linking charts and cells. Camera tool. Sparklines. Creating mini charts. Dynamic charts.

Overview of new functions. Dynamic arrays. XLOOKUP. Overview of text functions. SWITCH. THE PLURALS.

E-commerce phenomenon. Technology advances. Cyber threats and security strategies.

Earned income credit rules. Due diligence requirements. EIC disallowance.

Define ESG integration. Explain how ESG integration and ESG investing are different, as well as how they may complement one another. Analyze how ESG factors or company initiatives may impact its financial results. Translate company-provided sustainability information into model assumptions. Integrate a company's ESG initiatives into a financial model and see how they may affect company valuation. Explore advanced modeling techniques to improve your Excel skills and to create more dynamic models.

Overview of employee ownership forms. Benefits and challenges of employee ownership. Role of the employee ownership advisor.

Structure, purpose, and features of ESOPs. Tax advantages. Legal considerations.

Structure, purpose, and features of co-ops. Tax advantages. Legal considerations.

Structure, purpose, and features of EOTs. Tax advantages. Legal considerations.

Cost and timelines. Financial analysis. Buy-in from staff and clients.

Lending prerequisites. Funding sources. Financing options.

Documentation and forms. Filing procedures. Ongoing compliance.

Implementation strategy. Communication and guidance.

ESOP types. ESOP benefits. Resources.