Advance Business Financial Analysis, Modelling using Excel (ABFAME)


This is a full-venue event. Training tools, Certificates and refreshments will be provided. Should you be interested in the online version or your in-house delivery? Please contact us.





It is a critical decision-making tool used by management to make accurate and informed financial decisions about a company or project. It is multidisciplinary, requiring expertise in Accounting, Finance, Financial Analysis, Valuation and Microsoft Excel.

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

Course Content

  • Business Financial modelling fundamentals using Excel
  • Model Building Mechanics
  • Building Blocks of Financial Models
  • Revenue & Cost Modelling
  • Capital investment structure modelling
  • Modelling a Company
  • Restructuring the Balance sheet
  • Building Assumptions
  • Building the calculation sheet
  • Model Build mechanics
  • Finalise your model
  • Exam Simulation by step Process

Learning Outcomes

  • Use Excel to structure an advanced valuation model in the most efficient way
  • Set up all the assumptions and drivers required to build out the DCF model
  • Apply best practice techniques & rules to build 3 Statement models from scratch.
  • Apply core and advanced spreadsheet functions and techniques in order to construct effective models
  • Design a modern model structure based on pre-determined model outputs & requirements.
  • Build a clear revenue schedule to forecast company sales
  • Master CVP (Cost, Volume, Price) analysis to appropriately identify and capture fixed and variable costs of a company
  • Apply best practices in capital structure modelling; Debt schedules, Cash Flow Sweeps, Equity and dividend calculations.
  • Build and incorporate Operating & Financial Schedules.
  • Perform sensitivity and scenario analysis
  • Recall the techniques for model auditing tax and deferred tax treatment, depreciation calculations, integrity & error checking and more.
  • Generate multiple operating scenarios to explore a range of outcomes and values for the business
  • Perform sensitivity analysis on key assumptions and assess the overall impact of the transaction

Event Details

NOTE: For our customised events all you need to do is provide us with what you want to achieve or tell us about the training requirements of the group and we will agree on a date, venue and produce a course proposal for you along with the costs. Discounts may be applicable for group booking or early birds.

Start date: 1 July 2024

End date: 5 July 2024

Start time: 09:00 BST

End time: 17:00 BST

Venue: Lagos, Nigeria

Phone: '+44 1582 414 144


Product Enquiry