Financial Modeling Skills to Advance Your Career: 2-Day Online Training
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
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.
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.