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

Why Should You Attend:

Capital Expenditures are among the largest and most critical expenditures your firm will make. A poor decision in this area can have a deep, lasting impact on both the firm and careers.

You'll first learn to use ten essential Excel cap ex functions. We illustrate these functions with practical, easy-to-follow illustrations that are essential for CAPEX analysis and modeling.

You'll then learn the simple magic of Excel's Spinners and Sliders the pros use. These Excel tools allow users to easily vary assumptions such as interest rate or term without entering numbers into your spreadsheet cells.

You will learn how to model Capital Expenditure projects and the best methods for CAPEX analyses. You'll learn how to prepare and present outstanding, professional-level CAPEX models using special Excel tools. Your webinar hand-out material will serve as a valuable reference tool in the future.

Sophisticated discounted capital expenditure methodologies you'll learn include: (1) Discounted Payback, (2) Discounted Cash Flow (DCF) and Net Present Value (NPV), (3) Internal Rate of Return (IRR), and (4) Modified Internal Rate of Return (MIRR). You'll then learn how to use the Excess Present Value Method to rank competing cap ex projects.

We'll clearly show you how to use Excel's special features and functions to perform sophisticated CAPEX calculations with ease. You'll also learn how to model and produce user-interactive charts to illustrate your cap ex models. These interactive charts will change instantly as your assumptions change.

At the conclusion of this practical, 100 minute, nuts-'n-bolts webinar you'll have a crystal-clear understanding of the CAPEX budgeting and decision making process. You'll also have the ability to use the Excel tools needed for effective Cap Ex calculations and decisions, interactive models and related dynamic charts that update automatically. No one else delivers this much Cap Ex analysis and related modeling information in just 100 minutes.

Areas Covered in the Webinar:

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

Learning Objectives:

1. Understand Basic Financial Modeling Concepts and the Necessity for Input Cells
2. Use Basic Modeling Tools Such as Goal Seek and Sensitivity Analysis/Data Tables
3. Easily Master Two Professional-level Excel Interactive Modeling Tools: Spinners and Sliders
4. Use Excel's Built-In Functions to Instantly Make Cap Ex Decisions
5. Develop Models for Capital Expenditure Analysis and Professional Presentations
6. Prioritize Competing Capital Budgeting Items
7. Use Excel Functions for Easy Computation and Decision Making
8. Create Excel Spinners and Sliders for User Interactive Sensitivity Analysis
9. Create Interactive Charts That Dynamically Update with Excel Spinners and Sliders
10. Understand Which Capital Expenditure Tools to Use Under Different Circumstances
11. Professionally Present Cap Ex Data Visualization Results for User Interaction
12. Use Excel Tools to Calculate Net Present Value (NPV), Discounted Cash Flow (DCF), Internal Rate of Return (IRR) and Modified Internal Rate of Return (MIRR)

Who Will Benefit:

This webinar is ideal for all accounting staff, budgeting staff, financial analysts, project management professionals, engineering/production staff and midlevel managers who need Excel tools and on-the-job training to make effective Capital Expenditure recommendations and decisions. This webinar is especially appropriate for municipal officials who approve or work with large Capital Expenditure Budgets. Engineers moving into management will benefit greatly from this webinar. Instructor Profile: