Compare courses
Register
Fitch Learning

Advanced Financial Modeling

Jun 19—20
2 days
Dubai, United Arab Emirates
GBP 1295 ≈USD 1630
GBP 647 per day
Jun 20—21
2 days
London, UK
GBP 1295 ≈USD 1630
GBP 647 per day
Jul 18—19
2 days
Singapore, Singapore
USD 1495
USD 747 per day
+5 more options

How it works

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with Fitch Learning.

Full disclaimer.

Description

This course will develop the best practice approaches to structuring fully flexible and auditable models whilst cultivating the most efficient data analysis tools and solve other common modeling problems.

Key Learning Outcomes:

  • Harness Excel’s tools within a best practice framework
  • Add flexibility to their models through the use of switches and flexible lookups
  • Work efficiently with large data volumes
  • Model debt effectively
  • Approach modeling for tax, debt, pensions and disposals with confidence
  • Build flexible charts and sensitivity analysis to aid the presentation of results

Content

Flexible Forecasting

  • Using Excel’s forecasting tools
  • Using maths and modeling best practice to create flexible fade formulae

Quarterly Modeling and period consolidation

  • Eomonth, Edate, etc. for date functionality
  • Changing the start/transaction date; changing the length of forecast periods
  • Consolidating monthlies into quarterlies and annuals

Auditing

What to look out for on opening

  • Finding and killing circularity
  • Finding and killing links

Coding clarity index

Troubleshooting

Auditing tools

  • F2 v Ctrl-[ v Auditing toolbar
  • F5-Special

Building Consistent Checks

  • Consistent formulae for checks – the use of Abs and Round
  • Use of and 1 flags
  • Summarising checks

Debt Modeling and Structuring

Finding the debt capacity and optimising the debt structure

Debt amortisation schedules

  • Switching between payback profiles
  • Cash vs non-cash interest
  • Cash waterfall

Planning to avoid circularity

Revolver, minimum cash balances and cash sweeps

Modeling Taxes, NOLs and Deferred Taxes

Calculation of taxable profit

Carry forward of losses, use of loss relief and derivation of deferred tax

Accounting for taxes

  • Cash vs accruals
  • Balance sheet impacts
  • Deferred tax movements

Large Volume Data Analysis

  • Quick and flexible fixes for dirty data
  • Extracting key data points – use of wildcards
  • Text functions – Len, Right, Find, etc
  • Sumif and its variants
  • Array formulae

Modeling Pensions

Pension accounting refresher and update

Building a pension forecast model

  • Service costs
  • Interest costs
  • Plan asset returns
  • Model drivers
  • 3 statement impacts

Dynamic Charting

Quick fixes using charts

Making charts dynamic for

  • Changes in input source
  • Changes in start and end dates
  • Flexible titles and labels

Dynamic value bridges

Sensitivity Analysis

Use of the camera

Basic data tables – one and two dimensional

Self-centring data tables

  • Ensure tables automatically coincide with model drivers and outputs

Free Course Reference Guide

The Complete Financial Modeler is included as part of the programme (Normal RRP £80).

This 150+ page reference guide, taken from Fitch Learning’s “Complete Investment Banker” manual, is designed to act as a comprehensive and practical Excel and modeling reference guide. It helps users become more proficient at taking an idea or objective and turning it into a robust, flexible model. It is relied upon globally by our clients to support further training after their course. The guide is applicable for professionals at every level, from Intern through to Managing Director. It contains the clearest explanation and application of technical Excel content in a way that makes it accessible to all.

The programme also includes our Excel Short Cut that includes quick access to 40 of the most commonly used shortcuts.

Who should attend

This course is aimed at financial modelers, M&A analysts and associates with significant financial modeling experience who have identified problems adapting their own models and also wish to take their skills to the next level.

Files

Detailed Description
Detailed Description

Next dates

Jun 19—20
2 days
Dubai, United Arab Emirates
GBP 1295 ≈USD 1630
GBP 647 per day
Jun 20—21
2 days
London, UK
GBP 1295 ≈USD 1630
GBP 647 per day
Jul 18—19
2 days
Singapore, Singapore
USD 1495
USD 747 per day
+5 more options

How it works

Show more
Get free assistance in program selection