0 Items Total: $0
Financial modelling using Excel
Financial modelling using Excel
Financial modelling using Excel

This course is aimed at both intermediate and experienced staff and includes the construction of an integrated set of simplified financial statements and subsequent investment appraisal. You will learn key tools of Excel which are useful for business analysis and how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).

Financial modelling using Excel

This course is aimed at both intermediate and experienced staff and includes the construction of an integrated set of simplified financial statements and subsequent investment appraisal. You will learn key tools of Excel which are useful for business analysis and how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).

For additional information please contact us

Financial modelling using Excel

This course adopts a case study approach and minimizing the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.

Financial modelling using Excel

The course is ideal for anyone looking to improve their skills in Excel. It will be of particular benefit to corporate and project financiers, finance managers, accountants and bankers.

By the end of this course, participants will understand :

  • Improve their efficiency in using Excel shortcuts
  • Use several of the support tools and techniques in spreadsheet programs
  • Build a robust financial model
  • How to forecast working capital using excel
  • Analyse results from excel sheet based on financial statement input.

We have three discount options available, however please check with us directly for details as discounts are limited to certain cities.

  • 5% early bird discount for registrations completed one month before session date
  • 10% corporate discount for a minimum of 3 registrations : Contact us directly
  • 15% discount for groups of 4 or more delegates

The discounts cannot be combined.

Course structure

Financial modeling introduction

  • Model benefits
  • Model best practice

Basic financial modeling tools

  • Excel overview and keyboard shortcuts
  • Some relevant financial functions
  • Some relevant created functions using VBA
  • Some relevant logical functions
  • Some relevant lookup functions
  • Some relevant date and time functions
  • Building charts
  • Naming conventions, formatting conventions, organisation of spreadsheets and use of range names
  • Using spinners for sensitivity analysis
  • Using solver vs. goal seek
  • Data validation and creating a drop down menu
  • Sheet protection
  • Hiding items, calculations, etc.…
  • Hyperlinks
  • Inserting notes
  • Conditional formatting

Basic application models with basic Excel and VBA functions

  • Investment decision criteria (FV, PV, NPV, IRR, MIRR, Payback, Discounted Payback, XIRR and XNPV)
  • Breakeven and sensitivity analysis
  • Differential analysis 
  • Mortgage
  • Using macros
  • Recording macros
  • Creating functions using Visual Basic Applications (VBA®)
  • Application examples using VBA®

Want to run this in-house?
Schedule
Schedule

There are no scheduled dates for this course. Fill out the form to check future dates or deliver the course in-house

Trainers
Frequently asked questions

Enquire now