Single registrationBuy Now
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
The Critical Importance of Using Input Cells for Cap Ex (or any) Financial Models
Capital Expenditure Modeling and Analysis for Business Decisions
Dynamic Capital Expenditure Excel Model Using Spinners, Sliders and Interactive Charts
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.
Physical CD-DVD of recorded session will be despatched after 72 hrs on completion of payment
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.