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

April 16, 2019
Webinar

Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More! 2019 will be held on April 16, 2019.

Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More! 2019 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! 2019 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! 2019 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
129 US Dollar   (Early registration date: February 27, 2019)
No exhibition

Important

Please, check the official conference website for possible changes, before you make any traveling arrangements

Prices are for evaluation only.

Find Similar Events by Category

Business:   Finance    Management