Public Course

Financial Modeling - Fundamentals

Regular price $850.00 USD
Regular price Sale price $850.00 USD
Sale Register Interest
Shipping calculated at checkout.
  • What you'll learn
  • Course Information
  • Venues
  • Prerequisites
  • Reviews
  • What you'll learn
  • Financial Modeling - Fundamentals Part 1

    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. This session uses simplified teaching models as well as a real company forecast model.

    Learning outcomes

    • Setting Excel up for maximum efficiency
    • Best-practice keyboard shortcuts for modelling
    • Key modeling formulas
    • Alternative model layouts
    • Structure of an integrated three statement forecast model
    • Constructing the income statement, balance sheet and cash flow statement
    • Balancing the forecast balance sheet using cash and revolver
    • Incorporating interest income and expense
    • Introduction to checking methodologies
    • Performing audit trails

    Financial Modeling - Fundamentals Part 2

    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. We then teach participants how to build a forecast cash flow statement from scratch, using income statement and balance sheet inputs. The last part of this session focuses on interest calculations and circularities, where we teach participants the difference between using beginning, ending or average debt/cash balances and how to work safely and effectively with or without circular formulae in a model This session can be taken as a stand-alone module, or as a follow-up to the Part 1 session.

     Learning outcomes

    • Review of the structure and key components of a forecast model
    • Review of the modelling steps to build a three statement integrated model
    • Modeling operating cash (require cash) and excess cash
    • Building a forecast cash flow statement from scratch
      • Links to forecast income statement and balance sheet
      • The 4 rules of cash
      • Calculating the balance sheet plugs (cash and revolver)
    • Calculating interest on cash and debt balances
      • Using beginning, ending or average balances
    • What is a circular formula?
    • Working with intentional circular references
      • Excel settings
      • How does the iterative process work?
      • Building and using circularity switches
    • Avoiding non-intentional circular references
  • Course Information
  • 9.00am - 5.00pm GMT/BST/CET

    1 day (non-exam)

  • Venues
  • London: Tenter House, 45 Moorfields, London EC2Y 9AE


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

  • Prerequisites
  • A solid understanding of financial statement accounting is needed for this course. AMT's Financial Statement Analysis courses will provide the knowledge you require:

    • Accounting Fundamentals, the Income Statement and Working Capital
    • Non-Current Assets, Cash Flow Statements, Debt and Equity
    • Reviews
    • Find our reviews here:


      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