ADVANCED FINANCIAL MODELING

ADVANCED FINANCIAL MODELING

NEW ON-LINE SEMINAR

Dates
09th,10th,11th of November
16:00-20:00
(15 training hours)

ADVANCED FINANCIAL MODELING
Based on the FAST Modeling Standard

Upon finishing this seminar, you will be in position to “sit”
for the FAST Level 1 Certification, as our firm is one of the first offering preparation for the FAST

Who should attend
This hands-on workshop is designed for junior to senior business and finance professionals as well as general managers who need to use financial models to measure business performance, identify risk and perform sensitivity analyses, including: Directors, GMs, VPs, Senior Managers, Managers, with responsibility in the following functional areas:
• Business & Financial Analysts
• Investment & Corporate Bankers
• CFOs & Finance Managers
•Risk Managers and Portfolio Managers
• Financial Controllers and Accountants
• MBA’s and Business Undergraduates
• Anyone seeking to improve their financial and valuation modeling skill set
• Industry Consultants
• Project Managers and Risk Analysts
• Corporate Finance and Business Development Professionals
• Finance & Accounting staff
• Heads of Business Units & Business Planners
Free Takeaway
Participants will receive worksheets and templates that will allow them to review the models discussed during the Seminar and adjust them to their own day-to-day needs.
This seminar is designed to provide you with a range of techniques, concepts and methodologies that will take your financial modeling skills to the next level and allow you to gain maximum value on these vital issues:

• LEARN to measure, identify potential trends, interpret and forecast company performance using Excel modeling
• UNDERSTAND how to choose reasonable assumptions and discover how to prepare realistic financial forecasts so that to develop reliable and robust models.
• REVIEW the major components in each financial statement and build dynamic and easy to use financial statement models in Excel using real-life case studies.
• DISTINGUISH among the most common valuation methodologies (DCF, Comps, LBO), apply cash flow valuation and perform sensitivity analysis.
•CREATE meaningful management reports and charts for com-munication

This seminar builds on your existing financial modeling skills and and it is adjusted based on the globally recognized FAST Modeling Standard*, so that to learn how to build more flexibleand standardised models and better analyze financial data.

Once you are done with this seminar you will know how to model the three major financial statements (balance sheet, income statement and cash flow statement) based on the FAST Modeling Standard, as you are going to develop a full scale model and learn how to model all respective items (assets, debt, depreciation etc). In addition, through the hands-on training approach you will learn how to perform sensitivity analysis, build alternative scenarios and tackle issues like inflation, escalation, corkscrews, error checking etc.

SEMINAR OVERVIEW

The seminar is designed for those already having some experience in financial modeling and now seeking to further develop their practical skills by learning a range of new tools and techniques, master the fundamentals of discounted cash flow valuation and integrate uncertainty into their models.

It teaches the core financial model design and construction techniques that every modeler should know. This seminar will allow you to adopt a structured design strategy, applying FAST modeling principles to improve your financial models’ design, style and structure.

Participants follow the instructor, while building their own financial models on their own computers; in this way they immediately practice what they have been taught. Various templates are going to be offered in line with the methodology discussed, that will help participants to apply principles and techniques presented during the seminar. Participants will also cover how to build models accurately and efficiently through a series of best practice modeling rules.

Participants develop a financial model completely from scratch, inputting historical data and assumptions to forecast the income statement, balance sheet and cash flow of a business using a step-by-step approach on choosing, locating and developing the appropriate forecast inputs-drivers. Participants will also learn how to integrate all financial statements to produce a correctly balanced Balance Sheet, avoiding any circularity.

During each stage participants will get practical tips based on the FAST standard that will help them upgrade the level of their work.

By attending this seminar you will become more efficient in creating a financial model from scratch and know how to create models that are easily understood and maintained. Key issues in designing a model, controlling model risk, effective selection of the proper type of financial model, are just some of the key topics that are going to be developed during the seminar.

SEMINAR AGENDA

·         Introduction and Overview of the Seminar

·         Effective Model Design & Construction – Financial Modeling Best Practices

·         Advanced Excel techniques for creating automatically expanding charts and ranges

·         Timing Issues (Corkscrews, Base calculations etc)

·         Setting up the core financial statements

·         Links between financial statements

·         Preparing an Integrated three-way financial model

·         Modeling and presenting the cash flow statement

·         Derivation of Major Financial Ratios: Profitability, Efficiency, Liquidity and Debt ratios

 

Indicative Exercise: Analyse a set of data using a variety of financial, statistical and lookup functions and other Excel tools and techniques.

·         Balancing the model – excess cash and revolver – Cash Sweep Modeling

·         Financial Statements and Valuation Modeling (DCF , Comps, LBOs)

·         Modeling Inflation & Escalation

·         Sensitivity Analysis & Optimization techniques

·         The forecasting process and its applications – Basic forecasting techniques

·         Actuals vs Forecasts

·         Reporting, Presentation and Review of the Model

®            Scenarios & Sensitivity Analysis: Identify key input/variables

®            Stress testing and Auditing the Model

®            Modeling scenarios – what’s the best way to run scenarios?

Þ      Building a model framework that will accommodate multiple scenarios

Þ      Instant scenario switching with drop down boxes

®            Best Practices for Output presentation

Indicative Exercise: Plan, design and build a financial model, including P&L statement, Cash Flow including scenario analysis. Create a best, base and worst case scenario on your model. Select from a drop-down box and watch the results change. Build your own flexible report including a dynamic chart.

Requirements

Participants should bring their own laptop, ideally one they are accustomed to using, with a Microsoft Windows operating system and Microsoft Excel 2010 or 2013 installed and have a basic understanding of MS Excel (e.g. syntax of IF statement, purpose of $s for anchoring cell references).

This seminar presumes knowledge of financial accounting (at least 1 semester or equivalent).The Mac version of Excel is dramatically different and it is not advised to use it during the seminar.

 

DIMITRIS LEIMONIS
• Senior Key Corporate Accounts Manager at NBG Group
• Managing Director, Financial Arena, Financial Training & Consulting services
• Visiting Instructor, ALBA Graduate Business School, Investments, Advanced Portfolio Management, Derivatives seminars at Msc in Finance, MSc in Risk Management and MBA programmes, 2012-today
Certifications:
 Certified Financial Modelere (FAST Standard) by FAST Standard Organization
 Certified Investment Portfolio Manager by the Hellenic Capital Market Commission
 Certified Investment Consultant by the Hellenic Capital Market Commission
 Certified Insurance Consultant by Bank of Greece

 

Σχόλια

Αφήστε μας το σχόλιο σας