Calculating And Modeling Your Firm's Business Value Using Excel

Instructor: Joe Weil
Product ID: 705965
  • Duration: 100 Min
This Microsoft Excel training will help attendees to understand the business valuation techniques, rate and value relationships, Capital Asset Pricing Model (CAPM), Valuation Modeling, CAPM templates and excel tools for rapid business valuations. It will also cover Weighted After-Tax Cost of Capital (WACC), Weighted Average After-Tax Cost of Capital (WACC), Growth Rate and Discounted Cash Flow (DCF).
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info.

Customer Care

Fax: +1-650-362-2367

Email: customercare@complianceonline.com

Read Frequently Asked Questions

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

Instructor Profile:
Joe Weil

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 :

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email customercare@complianceonline.com call +1-888-717-2436 (Toll Free).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading