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

Website https://www.complianceonline.com/excel-took-kit-to-model-your-firms-capital-expenditure-budgets-webi | Edit Freely

Category

Deadline: February 27, 2019 | Date: February 27, 2019

Venue/Country: U.S.A

Updated: 2019-01-25 15:34:25 (GMT+9)

Call For Papers - CFP

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.