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

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