Cuesys Infotech :: Consulting | Corporate Training

By attending Financial, Valuation, and Mergers and Acquisitions Modeling workshop, Participants:

Present a financial statement model
Learn what makes good assumptions and how to integrate them into financial models
Learn how the cash flow statement, income statement, and balance sheet are linked
Build projection drivers
Apply automatic “balance checks”
Understand treatment of non-recurring charges and tax implications on financial models
Format and structure financial models to limit errors and simplify auditing
Learn intrinsic valuation, including DCF and LBO (floor) valuation and market-based valuation
Identify and analyze the elements of the financial statement that are key to the value of an enterprise
Derive WACC by deriving the cost of debt and the cost of equity
Learn about various competing terminal value approaches
Present valuation results using sensitivity analysis and data tables
Build a pro forma income statement and make appropriate deal-related adjustments to arrive at accretion/dilution per share
Error-check a merger model and insert circuit breaker switches where appropriate
Allocate purchase price and calculate goodwill
Calculate sources and uses of funds
Understand pre-tax synergies required to break-even and break-even PE analysis

In Financial, Valuation, and Mergers and Acquisitions Modeling training course , participants will gain an understanding of the conceptual underpinnings of the valuation framework, and will be introduced to the intuition and mechanics of complex valuation methodologies, including DCF analysis using free cash flows already projected.

In addition, participants will learn how to estimate the weighted average cost of capital (WACC), including several approaches to calculating terminal value, and to use data tables to analyze a broad range of scenarios, given different assumptions. Finally, participants will build a merger model to reflect the pro forma impact of various acquisition scenarios.

Financial Accounting
Excel, Beginner level

Finance professionals working across all levels in treasury, accounting, financial planning & analysis (FP&A), corporate development, business development, M&A, budgeting and forecasting, and controllers who would like to gain new/sharpen their existing financial, valuation, and M&A modeling skill set.

financial, valuation, mergers and acquisitions modeling

COURSE AGENDA

Understand the differences between asset sales (including 338h10 elections) and stock sales

Perform scenario and sensitivity analyses

Calculate enterprise value

Estimate terminal values using exit multiple and growth in perpetuity approaches

Derive the cost of capital using CAPM and select the correct discount rates

Handle working capital items, deferred taxes, and long-term accruals

Derive unlevered earnings and unlevered free cash flows

Perform scenario and sensitivity analyses using drop-down menus and data tables

Build supporting schedules - debt schedule, working capital, interest schedule, retained earnings, PP&E analysis

Build core statements - cash flow statement, balance sheet, income statement

Review key Excel skills for financial modeling

Learn taxation issues, including deferred taxes created by the step-up of asset values

Gain insight into legal considerations in acquisitions