Course curriculum

    1. How to use the Platform

      FREE PREVIEW

    2. Download your Exercise Files

    3. Before we Begin

    4. Ask The Trainer

    1. Course content

    2. Who is a financial modeler

    3. The 3s Modeling Framework

    4. Credit Enhancements

    5. What is a Cash Sweep

      FREE PREVIEW

    6. What is a Cash Flow Waterfall

    7. 5 Steps to implement a cashflow waterfall with cash sweeps

    1. Setting up your sheet structure

    2. Inputting Assumptions

    3. Building the Debt Schedules

    4. Modeling the Cash sweep

    5. Modelling the Default

    6. Calculating DSCR and PLCR

    7. Review of Scenario Analysis

      FREE PREVIEW

    1. Identifying Key Metric and charts

    2. Linking your critical scenario inputs

    3. Building Scenario Controls

    4. Conclusion

    1. Evaluation & Digital Certificate

About this course

  • $99.00
  • 23 lessons
  • 2 hours of video content

Overview

Financial Modeling and Analysis are highly respected skills in the business world and hugely sought after in the job marketplace

This course has been developed to cover the entire body of knowledge issued by the Financial Modeling Institute for Level One; Advanced Financial Modeler Designation. It is a highly intensive certificate course, it is structured as a blended course: online pre-work, face-to-face classroom, a mock exam and a preparation guide for the AFM Exams for those registered to take it

Other courses for you

  • $99.00

    $99.00Report Automation in Modern Excel

    Buy Now

  • $99.00

    $99.00Reporting Automation with PivotTables and Charts in Excel

    Buy Now

  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now

Other Financial Modeling Courses

View more courses

FAQ

  • How does Virtual Training Work?

    You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.

  • How long is each Virtual Session?

    Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.

  • How long do I have access to the course content and platform?

    You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.

  • Can I defer my Session?

    Deferral requests are treated on a case by case basis. Please email [email protected] with your request.

  • Are the videos available offline?

    Our videos are only available for streaming online. But you can download all exercise files and materials.

Instructor

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.

Some of our Clients