Public Course

Financial Modeling - From Scratch

Regular price $850.00 USD
Regular price Sale price $850.00 USD
Sale Register Interest
Shipping calculated at checkout.
Dates
  • What you'll learn
  • Course Information
  • Prerequisites
  • Venues
  • What you'll learn
  • Financial Modeling - From Scratch 

    This session teaches participants how to build a three-statement forecast model starting from a blank Excel spreadsheet. We begin by setting up a roadmap to guide us through the modelling process and then we proceed to build up a model template which we populate with historical financial information drawn from the case company’s financial statements.  We analyse the company’s historical data by calculating financial ratios, which are then utilized as a basis to set the assumptions driving the financial forecasts. The full forecast model, comprising income statement, balance sheet and cash flow statement, is then built. As we build the model, we examine various forecasting techniques for the key elements of the financial statements. Once the model is complete, we test its integrity and we sanity-check the financial forecasts.

    Learning outcomes

    • Identifying relevant information in the company’s financial statements, management discussion and analysis, and notes
    • Isolating historical non-recurring income and expenses
    • Forecasting techniques
    • Revenues and operating costs
    • Operating working capital
    • Fixed assets - capital expenditure and depreciation
    • Intangible assets
    • Provisions
    • Effective tax rate, taxes payable and the various deferred tax items
    • Debt schedule
    • Equity and share repurchases
    • Balancing accounts (balance sheet plugs)
    • Building a cash flow statement from scratch
    • Documentation techniques
    • Integrity checking
    • Sanity-checking the financial forecasts
  • Course Information
  • 9.00am - 5.00pm GMT/BST/HKT

    1 day (non-exam)

  • Prerequisites
  • A solid understanding of Financial Statement Analysis and Financial Modeling using a template is required in order for this day to be beneficial.

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

       

      APAC - What is a Virtual Classroom?

      Virtual Classroom training is a highly engaging way of delivering programs remotely with enhanced levels of interactivity compared to conventional webinars. In AMT’s Virtual Classroom participants are encouraged to activate their own webcams and mics throughout the class allowing for real-time engagement, both verbal and non-verbal, with fellow participants and their trainer. Participants can also share their screens to get instant assistance in any technical exercise; just like asking the trainer to walk over and help in the classroom! We have seen a step-change in participant engagement with this new technology. The trainer’s ability to see a selection of their participants’ faces in real-time, and to react to their verbal and non-verbal cues creates a remarkably realistic classroom-like experience. 

      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