Advance Business Financial Analysis, Modelling using Excel (ABFAME)

Description

Introduction

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