Beacon
FinRecruit
FinConsult
Future of Finance
Linkedin

Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course Overview

To make your way in this AFM preparation program, there is a minimum required level of Excel, you have to be familiar with and regularly using Microsoft Excel, comfortable with using formulas, and know their way around the basic functions of Excel. It is assumed that students will know how to link between worksheets, and create some formulas.

Learning Outcome

Build a set of integrated financial statements based on financial accounting principles

Use of Excel functions required for integrated financial statements and performance measures

Structuring error check networks

Build scenarios and sensitivities into models

Course Outline

  • What Is Financial Modeling?
  • What is a Financial Model Used For?
  • What do you need to be competent at to be a financial modeler?

  • Logical Functions
  • Lookup and Reference Functions
  • Working with Text and Dates
  • Macros in Financial Modelling

  • Main Section in every model
  • Front End
  • Cover page
  • Executive summary
  • Headers & Footers
  • Inputs and assumptions
  • Assumptions Documentation Methods
  • Custom Formatting
  • Data Validation

  • Building Up the Engine Scenarios
  • Scenarios
  • Sensitivities and What-if Analysis
  • Building Scenarios (Model Application)
  • Revenue Schedule
  • Setting up the Revenue Schedule
  • Completing the Revenue Schedule

  • All Different Types of Costs
  • Operating Costs
  • Cost Schedule
  • Operating Leverage
  • Semi Variable Costs
  • Repeat, Build and Link approach

  • Building the Tax Schedule
  • Forecasting Income Taxes
  • Current versus Deferred Tax
  • Tax Calculation Example
  • Income Tax Schedule

  • Why do we need a depreciation schedule?
  • Forecasting a company’s depreciation expense
  • Building the Depreciation Schedule
  • Capex with HLOOKUP
  • Automating
  • HLOOKUP
  • Capex with SUMIF
  • Capex with TRANSPOSE
  • Depreciation Schedule Waterfall
  • Fully Depreciating Asset
  • Declining Balance Method
  • Including PP&E: Converting depreciation schedule into a Fixed Assets Schedule

  • Setting up Working Capital Assumptions
  • Forecasting
  • Working Capital
  • Working Capital Days
  • Working Capital Schedule
  • Automating Days per Year
  • Deriving working capital Days
  • Calculating Working Capital balances

  • Linking together the final components of the financial statements
  • Income Statement
  • Cash Flow Statement
  • Balance Sheet

  • Debt Definitions
  • Building the Debt Schedule
  • Forecasting
  • Debt and Equity
  • Forecasting Cash
  • Long Term Debt
  • Revolving Credit Facility
  • Modeling the Revolver
  • The Equity Schedule

  • Model Troubleshooting
  • Summery Page Setup
  • Formatting and presentation
  • Model Printing

Who Should Attend

Finance professionals with strong finance and accounting knowledge and intermediate modeling skills=investors, analysts, accountants, and any other finance professionals responsible for maintaining and developing unfamiliar models or those who want to be able to solve advanced modeling problems

Register Now