Modern Financial Modeling Using Special Excel Tools for Budgets, Forecasts and Projections

Instructor: Joe Weil
Product ID: 705898
  • 6
  • February 2019
    Wednesday
  • 10:30 AM PST | 01:30 PM EST
    Duration: 100 Min
This training program will help attendees to understand the financial modeling concepts to construct powerful & effective templates and excel's linear regression analysis to model your firm's sales forecast, identifying key revenue and cost drivers and charting techniques for report forecasting results to top management.

Live Online Training
February 06, Wednesday 10:30 AM PST | 01:30 PM EST | Duration: 100 Min

$129.00
One Dial-in One Attendee
$349.00
Group-Max. 10 Attendees/Location
(For Multiple Locations Contact Customer Care)
Super Deal - Get CD/USB Drive Free!

recorded version

$149.00
1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section 48 hrs after completion of Live training

Training CD / USB Drive

$199.00
One CD/USB is for usage in one location only.
(For multiple locations contact Customer Care)
CD/USB and Ref. material will be shipped within 15 business days after completion of Live training

Combo Offers

Live + Recorded Version

$249.00

Live + Training CD/USB

$299.00

Customer Care

Fax: +1-650-362-2367

Email: customercare@complianceonline.com

Read Frequently Asked Questions

Why Should You Attend:

At the conclusion of this intense but fun, easy-to-follow, practical 100-minute webinar you'll understand and use professional modeling concepts and construct effective templates to model typical financial scenarios. You'll model sales forecasts, operating income and more! You'll also follow simple charting techniques that let you effectively report forecasting results to top management.

You'll instantly understand and use linear regression for forecasting and realize it's as simple to use as hand-drawing a picture. You'll also be able to determine fixed and variable costs using "What IF" sensitivity analysis. You'll use other Excel tools we clearly cover in this practical, one-hour “nuts-‘n-bolts” webinar to understand and isolate the key revenue drivers that determine your firm's revenues and profits. Determine and Model what drives your firm’s sales and revenues.

Areas Covered in the Webinar:

  • Financial Modeling Concepts - Construct Powerful, Easy-to-Use Templates
  • Linear Regression Analysis Using Excel (no prior statistical knowledge needed)
  • Modeling Your Firm’s Sales Forecast
  • Modeling the Income Statement Including Fixed and Variable Costs and Flexible Budgeting
  • "What If" Sensitivity Analysis Using Excel Data Tables for Robust Models and Scenarios
  • Connecting Excel Models to Excel Charts for Dynamic Professional Presentations
  • Forecasting Operating Income with Monte Carlo Simulations
  • Excel Tips ‘n Tricks – Modeling Techniques the Pros Use

Learning Objectives:

  • Build professionally designed, effective modeling templates using input cells for assumptions
  • Easily understand and use Excel's linear regression analysis to:
    • Model your firm's sales forecast - ideal for sales managers/directors as well as finance pros
    • Clearly identify your firm's key revenue and cost drivers (easily worth the entire cost of this webinar)
    • Use revenue and cost drivers for effective model construction via interactive input cells
    • Forecast fixed, variable and semi variable costs
    • Develop Excel flexible budgeting templates
  • Use the Excel Chart Wizard to illustrate and enhance your financial models
  • Dynamically link your model to charts
  • Understand Monte Carlo Simulations

Who Will Benefit:

This practical, nuts-'n-bolts webinar is ideal for accounting, business and financial professionals who want to master professional modeling techniques using state-of-the-art Excel tools specifically designed to make financial modeling quick, easy and professional in appearance. Included in the group are: CPAs, CFOs, Treasurers, Controllers, accounting managers and staff, financial directors, valuation professionals, budget directors, consultants, strategic planners, managers and analysts.

This on-the-job training is also ideal for administrators, general managers, division directors, sales and marketing managers and sales and marketing directors responsible for reporting, forecasting or budgeting sales.

Executive-level managers who work with financial models and need a refresher on modeling methods as well as experienced financial professionals who have not built models on a regular basis will benefit from this information-packed 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 :
21 CFR Part 11 Compliance for SaaS/Cloud Applications
FDA's GMP Expectations for Phase I and First-in-Man Clinical Trials

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