Excel Took Kit To Model Your Firm`s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More! 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.

Topics

• 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

Who should Attend

• 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