Skip to product information
1 of 3

Public Course Bundle

EMEA Frankfurt - Financial Modeling and Valuation week

Regular price $3,825.00 USD
Regular price Sale price $3,825.00 USD
Sale Register Interest
Shipping calculated at checkout.
Dates
  • Overview
  • Courses include:
  • Venue
  • Prerequisites
  • Overview
  • AMT Training's Financial Modeling and Valuation week offer five courses spread across one week, to enhance your knowledge in valuation and M&A accounting, at a reduced price.

  • Courses include:
  • Financial Modeling - Fundamentals

    This session teaches participants how to build a three statement integrated financial model, comprising income statement, balance sheet and cash flow statement. Best-practice modelling techniques are demonstrated, to ensure maximum accuracy and efficiency. Participants also learn how to stress-test the assumptions used, to check the model for mistakes and to document it.

    During the second half of the course, while using a real company forecast model, we start the session by reviewing the structure and key components of an integrated three statement forecast model. We then focus on modeling operating cash (required cash) and separating it from excess cash. 

    Financial Modeling - Cash Sweep & Troubleshooting

    In this session we build a three statement operating model for a real company, which incorporates a detailed revenue forecast based on price and volume drivers. We set up a hierarchy of a series of debt items and we learn how to model the sequential debt paydown using a ‘cash sweep’ approach. Best practice modeling techniques are emphasized throughout.

    This session also covers a range of error-checking techniques to find and correct the most common errors found in financial models. We use a series of financial models to allow participants to practice error-checking.

    Valuation Fundamentals and Trading Comparables

    The session lays the foundations to build a solid understanding of corporate valuation in the context of investment banking. The most common valuation methodologies are introduced, explaining the difference between a company's fundamental value, and how much an acquirer would pay for the business. 

    The session focuses on the details of comparable company analysis. Multiples are calculated on both a historical and forecasted basis and participants will assess the value of the case company based on a given set of comparables. Public Information Books (“PIBs”) are used throughout the session.

    LBO Modeling

    Delegates learn how to structure an LBO and model the impact of the new financing structure. This session concentrates on understanding the implications (both modeling and deal) of finance structuring. Delegates complete a fully integrated model with an income statement, balance sheet and cash flow statement.

    Excel Masterclass

    This program covers a range of tools and techniques in Excel designed to improve effectiveness and efficiency. The program covers building scenarios into models using a variety of functions, along with adding in on sheet controls, sensitivity analyses and flexible output tables. The topics in this menu can be chosen according to delegates’ needs.

      Courses can be purchased individually.

    • Venue
    • Frankfurt: Mercure Hotel Frankfurt Eschborn Helfmann Park, Helfmann Park 1, 65760 Eschborn, Germany

    • Prerequisites
    • There are no prerequisites for this course

      Pre-Requisites

      Who should attend?

      New hires who have joined the firm late and missed the in-house program

      Individuals looking to fill a knowledge gap

      Experienced bankers looking to refresh their technical skills

      Teams employed in financial strategy roles from non-banking corporations

      Graduates preparing to interview for a role in the finance sector

      Students at business school and looking for a career in finance

      What to use

      You need to use a Windows-based laptop for the training with Excel and Adobe installed on your system to access your course files. Our teaching materials are designed for PCs and not MAC based systems. Download details for the necessary files will be emailed a few days before the course. You can use any version of MS Excel in class. Please inform us of your Excel version when booking your course.

      Ask our trainers

      If you have any questions about the course content, you can email our experienced trainers for any further questions

      Contact a trainer

      Contact us