Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More!

Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More! is a webinar dedicated to financial modeling concepts to model their capital expenditure projects and the methods for CAPEX analyses.

Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More! covers topics such as:

  • Present and Future Value of an Amount
  • Effectively Using Excel`s Built-In Cap Ex Functions
  • Payment Amounts and Terms
  • Present and Future Value of an Annuity
  • Interactive Spinners and Sliders to Manipulate Interest Rate, Term and Charts
  • Net Present Value (NPV) and Internal Rate of Return (IRR)
  • Input Cells for Goal Seek
  • The Critical Importance of Using Input Cells for Cap Ex (or any) Financial Models
  • Constructing Excel Spinners and Sliders for Interactive, Dynamic Cap Ex Modeling
  • One and Two-Way Data Tables for Sensitivity Analysis
  • Capital Expenditure Modeling and Analysis for Business Decisions
  • Constructing a Simple Amortization Table and Using Excel Spinners and Sliders to Easily Change Assumptions
  • Payback and Illustration of Drawbacks
  • Non-Discounted Methods
  • Discounted Methodologies
  • Return on Investment (ROI) and Illustration of Drawbacks
  • Discounted Cash Flow (DCF) and Net Present Value(NPV)
  • Discounted Payback
  • Comparing Competing Projects with Excess Present Value Method
  • Internal Rate of Return (IRR)
  • Dynamic Capital Expenditure Excel Model Using Spinners, Sliders and Interactive Charts
  • Modified Internal Rate of Return (MIRR)
  • Connecting Dynamic Charts to Your Cap Ex Model Using Excel Spinners and Sliders
  • Combining Cap Ex Tools with Modeling Tools for Decision Making Purposes

Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More! is intended for:

  • Budgeting staff
  • Accounting staff
  • Project management professionals
  • Financial analysts
  • Municipal officials who approve or work with large Capital Expenditure Budgets. Engineers moving into management
  • Engineering/production staff and midlevel managers who need Excel tools and on-the-job training to make effective Capital Expenditure recommendations and decisions

Find Similar Events by Category