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

Instructor: Joe Weil
Product ID: 705914
  • Duration: 100 Min
This Microsoft excel training program will help attendees to understand the financial modeling concepts to model their capital expenditure projects and the methods for CAPEX analyses. Attendees will learn how to prepare and present outstanding, professional-level CAPEX models using special Excel tools.
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info.

Customer Care

Fax: +1-650-362-2367

Email: customercare@complianceonline.com

Read Frequently Asked Questions

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:
Joe Weil

Joe Weil
CEO, NCCE

Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. With over 25 years’ experience, Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO.

Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.

Follow us :
Reduce costs for compliance with data integrity: 21 CFR Part 11, SaaS/Cloud, EU GDPR
REACH and RoHS Compliance: Protecting Revenues with Advanced Compliance

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email customercare@complianceonline.com call +1-888-717-2436 (Toll Free).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading