Contact Customer Support at: 800-964-6033

Financial Modeling Skills to Advance Your Career: 2-Day Online Training

Summary

Live Webinar Recording

Recording Price: $699.00

(Includes Proprietary Materials)

As a controller or financial analyst, advanced financial analysis is a critical piece of the job, and presents fantastic opportunities to demonstrate your skills and talents to leadership. But do you really know how to exhibit your expertise within your financial modeling reporting? In this two-day, interactive training, our expert speaker, Miles Hutchinson will address how to evaluate complex business decisions involving major asset acquisitions, new business start-ups and new product additions, optimizing existing production and adding to Excel's already rich analysis tools with custom functions, as well as:

  • Advanced financial models that will improve your business analysis reporting
  • Financial forecasting techniques that enable management to make informed decisions
  • How to apply strategic risk analysis techniques to compensate for forecasting uncertainty
  • Apply methods that can improve your company's profit picture & your stockholders' investment
  • Discover the tools for raising capital, gauging profitability and analyzing budget and metrics
  • Live demonstration of sensitivity tools, scenario manager, GUI tools & advanced Excel functions

Program Highlights

  • Day 1, Part 1 (Strategic Financial Planning Concepts & Best Practices)

    • How to exhibit basic time value of money concepts using a simplified story line & Excel model
    • Keys to mastering FV, PV, NPV, IRR, MIRR, Payback and Discounted Payback
    • Best practices for setting hurdle rates - Why WACC is not the best choice
    • Strategies for ranking projects that compete for limited resources
  • Day 1, Part 2 (Demonstration of Excel's Power Tools: Rules for Effective Model Design):

    • How to apply scroll Bars to key variables in your reporting structure
    • How to best utilize goal seek to reverse engineer model results
    • Navigating the ins and outs of essential Data Tables (1 and 2-input)
    • Solver & Scenario Manager: Tools for effective analysis modeling
  • Day 2, Part 1(Analysis Case Study: How to Deliver Results to Higher Ups)

    • Design and application essentials using real-life business analysis tools
    • Demonstration of advanced macros, group boxes & option buttons
    • What are the critical custom functions for advanced sensitivity modeling?
  • Live Question & Answer Session - Have your questions answered by the expert!

About The Speaker

Miles Hutchinson is a CGMA who is an experienced CFO and businessman. He has been an auditor with PriceWaterhouseCoopers and the Chief Financial Officer of a one billion dollar real estate development company.

  • Miles is a professional speaker and consultant who has presented over 2,000 seminars and training sessions on a myriad of business and financial topics, including leadership, strategic planning, financial analysis and modeling, accounting, and compliance with the Sarbanes-Oxley Act.
  • He is recognized as an expert in payroll and sales & use tax as well as financial modeling & analysis, business strategy and communications. He is the author of several useful accounting and tax tools available at www.soxpolicies.com and www.salestaxadvisors.com.
  • His clients include, Abbott Labs, Bank of America, Boston Scientific, Citicorp, Corning, the FBI, the FDA, the Federal Reserve, GE, Pfizer, Siemens, US Marine Corps, and the US Army. Please visit his web sites to see how you can further benefit from his expertise.

Program Benefits

In this interactive, 2-day online training program, you will be equipped with advanced analysis and forecasting modeling tools that will improve your visibility as a controller or financial manager within your organization, and provide you with the strategic tools to strengthen your reporting practices.