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