Financial Modeling and Analysis teaches students how to conceive of and build a financial model from beginning-to-end, followed by due diligence. This course demonstrates how financial models guide commercial discussions. Participants will learn how to negotiate off the financial model.
- Learn efficient modeling for specific financial analysis - Build financial models to guide negotiations and decision-making - Apply Excel shortcuts and hot keys to get you off the mouse - Learn effective auditing techniques on existing models - Employ Monte Carlo Simulations - Engage in relevant commercial discussions with active project developer/financial advisor
WHO SHOULD ATTEND Financial Analysts, Investment & Evaluation Professionals, Business Development Planners, Mergers & Acquisitions Specialists, Accountants, Valuation Professionals
This course will utilize a Discounted Cash Flow ("DCF") pro forma approach derived from a full suite of financial statements: 1) Income Statement, 2) Statement of Retained Earnings, 3) Balance Sheet and, 4) Statement of Cash Flow. Participants use "hot keys" and page-setup techniques to build a fully integrated pro forma DCF model from a list of assumptions. The "mouseless" Excel techniques employed dramatically reduce model coding time. Next, delegates learn how to integrate all financial statements to produce a correctly-balanced Balance Sheet, without circularities. The class will use this model as a guide to review commercial issues, negotiate strategies and analyze financial ratios. Finally, the course demonstrates the power of Monte Carlo simulation analysis creating a dynamic decision-making tool and elevating beyond simple static input and output spreadsheets.
This course is indispensable to the effective use of financial spreadsheets for any industry or sector. (NB: A working knowledge of financial accounting is helpful but not essential.)
OUTLINE Part 1 Introduction to Excel Part 2 Introduction to Financial Statements Part 3 Introduction of a Pro Forma Model Part 4 Assets: Purchasing versus Leasing Part 5 Operational Worksheets Part 6 Debt Part 7 Coding Full Financial Statements Part 8 Discussion on Valuation Part 9 Discounted Cash-Flow Modeling Part 10 Using the Model to Price the Asset Part 11 Monte Carlo Simulation Analysis
MORE INFORMATION Please visit our website for a detailed syllabus and registration details http://vaircompanies.com
CONTACT US Toll Free: +1 866 410 VAIR (8247) within the United States & Canada International: +1 770 853 0362 E-mail: info@vaircompanies.com
DISCLAIMER: Our aim is to continuously provide our
progressive audience with an open and interactive medium to view
and share relevant,
beneficial and interesting "career, economic, lifestyle and
networking" listings, ads, content and resources.
While the above information may be accurate and viable, the role
of Minority Professional Network, Inc. (MPN) is
strictly as a communications medium, and we do not
accept any responsibility for
cancellation, changes, errors, omissions, inconveniences, or any other form
of liability for any content
displayed or disseminated via our web sites, or e-marketing or social media
promotional services.
If there are any
doubts, we
encourage you to conduct additional research or contact the listed host or responsible entity.
CLICK HERE to inform us about any ads, listings or content
which appear to be
inappropriate,
fraudulent or misleading, or inconsistent with our theme and focus.