Calculating And Modeling Your Firm's Business Value Using Excel

Why Should You Attend:

Business Valuation - Understand Valuation Procedures

• Understand how to value a company of any size, public or private
• Understand the difference between public and private company valuations
• Differentiate between the income, asset and market-based valuation approaches; learn when and how to use each
• Understand the art of normalizing income
• Project income; justify the capitalization rate, growth rate, discount rate and terminal value of the business

Accurately Value a Business

• Identify the key drivers of value in any business - understand what enhances the value of a business
• Understand synergy and who should pay the synergy premium
• Use sanity checks to verify calculations
• Avoid rule-of-thumb pitfalls and common fallacies of business valuation
• Learn how to spot overpriced businesses; avoid overpaying
• Determine any firm's value based on different valuation models and assumptions

Understand Rate and Value Relationships

• Calculate the after-tax average cost of capital and use the capital asset pricing model (CAPM) as a basis of valuation
• Learn when to apply discount and capitalization rates to net income, NIBT, and no cost cash flow
• Understand and quantify terminal value
• Understand the relationship between the P-E Multiple and the Cap. Rate
• Learn when to capitalize earnings and cash flows instead of using DCF

Use Excel for Valuation Modeling

• Understand the keys to professional-level model design
• Use input cells to clarify assumptions and instantly "what-if" financial scenarios
• Link worksheets for interactive modeling
• Use Excel Tools for Powerful Valuation Modeling
• Use Goal Seek for instant for profit and valuation analysis
• Use Data Tables for Sensitivity Analysis: growth projections, rate analysis, optimal debt/equity and cost of capital decisions and M&A analysis
• Establish input cells for key assumptions - cost of debt, interest rate, risk premiums, tax rate, and more
• Use Excel Sliders to quickly analyze changes in key model variables
• Model your firm's optimal capital structure and cost of capital
• Model firm value using a detailed discounted cash flow model, incorporating sensitivity analysis for growth rate, discount rate and terminal value
• Use regression analysis to identify key value drivers to use as input cells
• Learn how to construct
• Present and future-value templates
• Cost of capital and CAPM templates
• Business valuation templates using DCF

The webinar is a practical, nuts-'n-bolts, on-the-job training program delivering more value in 100 minutes than any other comparable webinar.

Learning Objectives:

Two Major Learning Objectives: You Will Understand

• Business Valuation Techniques/Procedures
• Excel Tools for Rapid Business Valuations

Areas Covered in the Webinar:

• Business Valuation Terminology and Approaches: Asset, Income, Market
• Overview of Preliminary Procedures for the Valuation Calculation: Financial Analysis, Normalization and Adjustments
• The Mechanics of Business Valuation
• The Capital Asset Pricing Model (CAPM)
• Calculating the Weighted After-Tax Cost of Capital (WACC)
• Determining the Growth Rate and Discounted Cash Flow (DCF)
• Establishing and Supporting a Terminal Value
• Basic Principles of Financial Model Construction Using Excel Modeling Tools
• The Critical Importance of Input Cells
• Goal Seek and Data Tables for Sensitivity Analysis
• Regression Analysis - Quick and Easy
• Financial Functions
• Constructing Excel Sliders for Easy Input
• Modeling the Weighted Average After-Tax Cost of Capital (WACC)
• Modeling the Capital Asset Pricing Model
• Modeling Valuation Based on Discounted Cash Flow - Estimating Value

Who Will Benefit:

CEOs, CFOs, CPAs, Controllers, Treasurers, Auditors and Staff Accountants Financial Directors, Budget Directors, Financial Analysts, Tax Professionals and staff

Joe Weil
CEO, NCCE

Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. With over 25 years’ experience, Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO.

Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.

Follow us :