Zurich, Switzerland: +41 - 43 434 80 33   |   US: (510) 962-8903   |   support@traininng.com

Webinar Price Details

Overview

This critical Excel and financial training covers five key topics:

  • Using Excel Spinners and Sliders for Financial Modeling and Dynamic Charts
  • DuPont Analysis to Evaluate Firm’s Financial and Operational Functions
  • Use an Excel Template to Calculate, Evaluate and Model Your Firm’s Weighted Average Cost of Capital (WACC) 
  • Create and Optimize Your Firm’s Annual Cap Ex Budget
  • Calculate and Model Your Firm’s Business Valuation

Major Topics in Slightly More Detail

  • Excel Spinners and Sliders. Financial Modeling Using Excel Spinners and Sliders to Instantly (Dynamically) Change Assumptions and Outcomes – and Dynamic Charts That Change Instantly with Assumptions. These Tools are the Ultimate “What-If” Scenario Planner
  • DuPont Analysis. Use Excel to Calculate and Dynamically Model Your Firms DuPont Analysis. This tool has been in use for almost a century. It will be deconstructed, explained and linked on a spreadsheet to the Balance Sheet and Income Statement. 
  • Weighted Average Cost of Capital (WACC). Understand, Calculate and Dynamically Model Your Firm’s Cost of Capital Using Excel. This section will also compare a relatively new financial concept, Economic Value Added (EVA) to the Dupont Analysis. Surprisingly, these metrics give us the exact same financial message as the century old DuPont Analysis
  • Cap Ex. Create an Excel Toolkit to Dynamically Model Your Firm’s Capital Expenditure Budget: Payback, ROI, DCF, NPV, IRR, MIRR, More! We’ll look at 10 Excel Present Value Tools and Related Dynamic Modeling Financial Professionals Use Daily. Excellent, easy-to-follow examples.
  • Business Valuation. Calculate and Dynamically Model Your Firm’s Business Value Using Excel. You’ll Learn Business Valuation Methodology and Get Easy-To-Follow Excel Instructions to Make This Understandable and Easy

Why you should Attend

This fast-paced, intensive, six-hour webinar is designed to illustrate and teach you 30+ tools and techniques commonly used by sophisticated financial professionals to make decisions for their firms or clients. Each financial decision making tool is first clearly described to participants and then participants are shown how to use Excel to perform the financial calculations in a rapid and effective manner.

In today’s fast paced, rapidly changing financial environment, dynamic financial modeling plays a crucial role in achieving your firm’s optimal financial results and maximizing firm value. The most valuable accounting and financial professionals are those who can advance from “scorekeeper” to top management’s strategic partner. The accounting professional who does this will have a sophisticated background in financial decision making, modeling and data analysis. This financial decision making and financial modeling workshop delivers that ‘must-have’ knowledge and skill. 

In six fast-paced hours participants will examine the key aspects of financial decision making and modeling including financial principles merged with practical Excel techniques and crystal-clear examples. Modeling methodology illustrated in this webinar will show participants the best way to design, build and test successful, dynamic financial models. 

This practical nuts-‘n-bolts virtual seminar is designed to deliver essential on-the-job training that can make a difference in an individual’s career and a company’s performance. Participants will develop modeling skills that can immediately be used at their job and contribute to their firm’s performance. 

Participants will explore a wide variety of critical financial modeling techniques, methodologies applications and tools including: Excel’s built-in modeling tools; The Dupont Analysis on a spreadsheet, Capital Expenditure Analysis with special Excel tools, Business Valuation and more!

Areas Covered in the Session

Overview of Excel Tools Designed for Modeling

  • Excel’s Solver and Data Tables for Easy Data and “What-if” Analysis
  • Excel Spinners and Sliders for Forecasts and Modeling
  • Detailed Explanation of Excel Spinner and Slider Controls
  • Basic Principles of Financial Model Construction Using Excel Modeling Tools
    • The Critical Importance of Input Cells
    • Goal Seek and Data Tables for Sensitivity (What-if) Analysis
    • Constructing Excel Sliders for Easy Input
  • Explanation of Excel Spinners and Sliders for Financial Modeling
  • Examples Including Dynamically Updated Charts

Understanding and Analyzing the DuPont Formula

  • Disaggregated 3 Step Analysis of Return on Equity Fully Explained
  • Overview of Dupont Analysis on Animated PowerPoint Flowchart
  • Excel Flowchart Referenced (Linked) to Financials for Automatic Dupont Analysis
  • Financial Modeling of the Dupont Analysis for “What If” Scenarios and Strategic Planning

Calculating and Modeling Your Firm’s Cost of Capital

  • Overview: Microeconomics v. GAAP
  • Calculating the after-tax average weighted cost of capital (WACC)
  • Calculate the Capital Asset Pricing Model (CAPM) with Excel
  • Calculate Economic Value Added (EVA) with Excel
  • Economic Value Added (EVA) Concepts and Model
  • Calculating the after-tax average weighted cost of capital (WACC)
  • The Capital Asset Pricing Model (CAPM)
  • ROIC and the EVA formula
  • DuPont formula v. EVA using Excel
  • Model Your Firm’s Optimal Cost of Capital with Excel with Excel Spinners and Sliders
    • The Capital Asset Pricing Model (CAPM)
    • Calculating the Weighted After-Tax Cost of Capital (WACC)
    • Modeling the Weighted Average After-Tax Cost of Capital (WACC)
    • Modeling the Capital Asset Pricing Model 

Cap Ex: Present Value Calculations for Capital Expenditure Decisions Using Excel

  • Excel Present Value Functions and Related Compound Growth Rates
    • Input cells and models
    • Future and present value calculations
    • Fixed and variable annuities
    • Discounted cash flow (DCF)
    • Net present value (NPV)
    • Internal rate of return (IRR)
    • Modified internal rate of return (MIRR)
  • Use Excel’s Function Wizard to Instantly Calculate: 
    • Present and Future Values of an Amount 
    • Present and Future Values of an Annuity 
    • Net Present Value (NPV) and Internal Rate of Return (IRR) 
    • Modified Internal Rate of Return (MIRR)
  • Use Excel’s Goal Seek to “back into” Your Answer for Financial Decisions
  • Use Excel’s Data Tables function for financial decisions
  • Evaluate Capital Expenditure Proposals
    • Non Discounted: Payback and Return on Investment (ROI) 
  • Discounted: 
    • The Logic Behind Hurdle Rates - Understand Appropriate Hurdle Rates
    • Discounted Payback and ROI
    • Net Present Value (NPV) and Discounted Cash Flow (DCF)
    • Internal Rate of Return (IRR) - Modified Internal Rate of Return (MIRR)
  • Lease v. Purchase decision on a spreadsheet
  • Modeling Present Value Calculations for Financial Decisions
    • Input cells and modeling
    • Excel present value functions, charts and Goal Seek

Comprehensive Introduction to Business Valuation

  • 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
    • Determining the Compound Growth Rate and Discounted Cash Flow (DCF)
    • Free cash flow, DCF, risk, the discount rate, capitalized cash flow and terminal value
  • The Basics of Business Valuation Modeling
    • The critical importance of input cells
    • Business Valuation and Modeling Using Excel
    • Modeling Valuation Based on Discounted Cash Flow - Estimating Value
    • Using Excel Spinners and Sliders to Model Business Value

Who Will Benefit

  • CFOs
  • CPAs
  • Treasurers
  • Controllers
  • Financial and Security Analysts
  • Budget Directors

Speaker Profile

Joseph Weil has a Master of Accounting Degree from Florida State University and is an actively licensed Florida CPA. Joe’s work experience includes staff accountant with large CPA firm, corporate controller, state agency director of auditing and former municipal CFO. Joe also started and sold his own CPA firm. Joe is the owner and CEO of the National Center for Continuing Education, a nation-wide financial and technology training firm. Joe has led over 500 seminars and over 100 webinars.

Past in-house seminar/webinar clients have included Harley-Davidson, Hewlett-Packard, General Mills, Oracle, Burger King, Deloitte, Florida Power and Light and many similar organizations.