In-depth with Excel Names (1st Ed.)

Overview

Tax-focused discussion on changes in the transaction structure of merger and acquisition (M&A) deals can significantly impact after-tax cash flows. Gain a significant competitive advantage by understanding how taxes affect M&A and divestiture transaction structures. Further, examine the mechanics of M&A deals; the structures of taxable assets and stock acquisitions; triangular and reverse triangular mergers; practical issues in structuring and pricing; types of tax-free reorganizations; tax planning for divestitures; and key elements of purchase and sale documents. Plus, dive into a complex case study and a couple of different approaches to the net tax cash flow for an S corporate deal. Updated for new tax Reform and impact on M&A deals.

Highlights

• Named ranges
• Named contstants
• Named formulas

Designed For

Accountants using Excel for Windows.

Objectives

• Recall the steps for using the Name Box.
• Recognize the dialog box to manage named references.
• Determine the feature that allows you to name a cell.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.