Introduction to Financial Modelling

Summary

When done well, Financial Models are powerful tools that can be used to help organisations make good business decisions.

This course is provided by a third party provider accountingcpd.net and the fee charged is exclusive of VAT. 

Venue details:  
Online EU, ,
Start date & time:  
01 January 2019 00:00
End date & time:  
01 January 2022 00:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
Strategic finance and management reporting

Booking with a training ticket

Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed.

Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification

Course overview 

What is a Financial Model?

  • What is a financial model?
  • Why do businesses use models?
  • How do we do financial modelling?
  • What do we use models for?
  • What skills do I need to do financial modelling?
  • Where can things go wrong?

Standards

  • What are standards?
  • Why do we use standards?
  • When should I use a standard?
  • Why is FAST significant?
  • What are the key characteristics of FAST?

Setting up a Model

  • How do I set up a model?
  • Why have a standard structure for each model?
  • What goes on the input sheet?
  • What goes on the working sheet?
  • What goes on the output sheet?
  • What is the standard recommended format for each sheet?

Concept Diagrams

  • What are concept diagrams?
  • Why use concept diagrams?
  • What am I trying to model?
  • When should I use concept diagrams?
  • How are concept diagrams used?

Building a Calculation

  • What are we trying to model?
  • What are the ingredients?
  • How shall I lay out the calculation block?
  • What are the operators I could use?
  • What functions are commonly used in financial modelling?
  • What Excel shortcuts can I use?
  • What other FAST principles should I use to build the block?
  • How can I produce a graph to show the balance?