Instructional Delivery Method: Group Live-Seminar

CPE Credit: 8 Hours

NASBA Field of Study: Specialized Knowledge and Applications

This seminar is ideal for CPAs and financial professionals who want to clearly understand valuation procedures and mechanics and want to model valuation scenarios with state-of-the-art Excel tools specifically designed to make valuation modeling quick and easy. Practitioners will leave this intensive one-day seminar with the training and templates they need to model different valuation scenarios.

  • Overview of Valuation Principles and Terminology


  • Clearly Understand When To Use the Different Valuation Approaches


  • Master Business Valuation Mechanics and Techniques


  • Design Excel Valuation Models Incorporating the Key Drivers of Value


  • Differentiate Between Normalized Income, Excess Earnings and Free Cash Flow


  • Model Your Firm’s Weighted After Tax Cost of Capital (WACC)


  • Master Excel Modeling Tools Including Data Tables, Scenario Manager, Solver and Goal Seek


  • Understanding Business Valuation Situations


  • Business Valuation Terminology and Approaches: Asset, Income, Market


  • Starting the Valuation Calculation: Financial Analysis, Adjustments, Normalization


  • The Mechanics of Business Valuation: WACC, CAPM, and Terminal Value


  • Basic Principles of Financial Model Construction and Excel Modeling Tools
    • Excel Tools for Modeling: Data Tables, Sensitivity Analysis, Goal Seek, Scenario Manager and Solver - Regression Analysis and Financial Functions
    • Constructing Spinners and Sliders Based On Key Drivers of Value


  • Modeling the Weighted Average After-Tax Cost of Capital (WACC) and CAPM

Who should attend:

  • CFOs, CPAs, Controllers, Treasurers, Auditors and Staff Accountants
  • Financial Directors, Budget Directors, Financial Analysts and staff
  • The Entire M&A Team and the Strategic Planning Department

Prerequisites: Basic Knowledge of Excel and Finance

Program Level:

Advance preparation: None

For a comprehensive course description and to view a brochure click a link below:

To register for this In-House Seminar, please fill out this questionnaire to help pinpoint your group's in-house needs, and assist NCCE in putting together a top-notch in-house seminar for your organization.


Cost effective for 10 or more employees. Click here for more information on in-house seminars.

NCCE is only holding in-house seminars right now but NCCE will offer our seminars including Business Valuation and Modeling Using Excel 2010 to the public starting in 2013.


Click here to be put on a notification list for NCCE's public seminars starting in 2013.

The National Center for Continuing Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:
For more information regarding administrative policies such as complaint and refund,
please contact our offices at 850-561-6081.

National Center for Continuing Education

967 Briarcliff Drive - Tallahassee, FL - 32308 - Fax: (850) 222-4862

Phone: (850) 561-6081 -