Training Course Syllabus:

Financial, Valuation, and M&A Modeling OnSite Training

In this 3-day seminar, you 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, you 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, you will build a merger model to reflect the pro forma impact of various acquisition scenarios.

What to Bring: Laptop, Notepad, and Calculator.
 

How You Will Benefit

• 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
   

What You Will Cover

• Review key Excel skills for financial modeling
• Build core statements – cash flow statement, balance sheet, income statement
• Build supporting schedules – debt schedule, working capital, interest schedule, retained earnings, PP&E analysis
• Perform scenario and sensitivity analyses using drop-down menus and data tables
• Derive unlevered earnings and unlevered free cash flows
• Handle working capital items, deferred taxes, and long-term accruals
• Derive the cost of capital using CAPM and select the correct discount rates
• Estimate terminal values using exit multiple and growth in perpetuity approaches
• Calculate enterprise value
• Perform scenario and sensitivity analyses
• Understand the differences between asset sales (including 338h10 elections) and stock sales
• Learn taxation issues, including deferred taxes created by the step-up of asset values
• Gain insight into legal considerations in acquisitions
   

Who Should Attend

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.

Prerequisites
•Financial Accounting
•Excel, Beginner level
•Access to Wall Street Prep's Excel Crash Course is included in enrollment.

What to Bring: Laptop, Notepad, and Calculator.
 

Credits:

27 CPE

TRAINING CLASS TIME:

9:00 AM–5:00 PM

Available for OnSite Training ONLY.  Submit request for OnSite Training

Seminar Summary:

Develop a comprehensive three-statement forecast model using various supporting schedules, modeling best practices, and dynamic scenario analysis (see full course description)

print this agenda