Book Online Tickets for Excel Took Kit To Model Your Firm Capita, Palo Alto. 
Excel Took Kit To Model Your Firm\'s Capital Expenditure Budgets: Discounted Pay Back, ROI, DCF, NPV, IRR and More!

 
 

This Microsoft excel training program will help attendees to understand the financial modeling concepts to model thei

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

 

  • One Dial-in One Attendee

    Sale Date Ended

    USD 129
    Sold Out
  • Group-Max 10 Attendees or Location

    Sale Date Ended

    USD 349
    Sold Out
  • 1x Person - Unlimited viewing for 6 Months

    Sale Date Ended

    USD 149
    Sold Out
  • One CD or USB is for usage in one location only

    Sale Date Ended

    USD 199
    Sold Out
  • LIVE + RECORDED VERSION

    Sale Date Ended

    USD 249
    Sold Out
  • LIVE + TRAINING CD or USB

    Sale Date Ended

    USD 299
    Sold Out

Invite friends

Contact Us

Page Views : 2

About The Event

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

 
 
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.

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.

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.

 

More Events From Same Organizer

Similar Category Events