Public Course

Financial Modeling - Cash Sweep and Troubleshooting

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 - Cash Sweep

    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.

    Learning outcomes

    • Building a detailed debt schedule
    • The waterfall of debt repayments
    • Building a simple cash sweep
    • Modeling revolver
    • Modeling a price/volume revenue forecast

    Financial Modeling - Troubleshooting

    This session 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.

    Learning outcomes

    • Stabilizing a model
    • Making a model map
    • Sanity checking a model
    • Fixing a non-balancing balance sheet
    • Troubleshooting techniques for cash flow statements
    • Checking the model’s matrix
    • Finding unidentified hard numbers
    • Using Excel’s ‘Jump tool’ to trace through formulas with ease
    • Using Excel to show the formulas underlying output
    • Using Excel’s auditing tool to trace formulas
  • 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 the topics covered by our courses in Financial Statement Analysis is desirable:

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

      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