Introduction to Financial Modelling

Course

Online

£ 75 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Class hours

    4h

  • Duration

    Flexible

  • Start date

    Different dates available

Financial Models (when done well) are powerful tools that can be used to help organisations make good business decisions. However, building robust and relevant financial models is not always easy.
This online training course in financial modelling provides a solid introduction to financial modelling. The course explores why and how models are used by businesses and how the standards (FAST) that exist can ensure that the financial models you develop work for your businesses.
This course also looks in detail at:
• how financial models are set-up
• how concept diagrams can be useful and
• the different considerations that feed into building calculations.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Understanding Introduction to Financial Modelling
enables the learner to:
• Understand what constitutes a financial model, why businesses use models and some of the inherent limitations
• Recognise what standards are, why they are used and examples of commonly accepted standards
• Establish how to set up and structure input sheets, working sheets and output sheets
• Understand how to make concept diagrams
• Learn the best practice calculation block structure and key excel functions that are commonly used

Accounting and finance professionals in practice and in industry.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Financial Training
  • Financial Modelling
  • Financial Reporting
  • Capital Investment
  • Capital Budgeting
  • Banking Investment
  • Investment Management
  • Portfolio Management
  • Project Finance
  • Property Investment
  • Risk Assessment
  • Risk Management
  • Strategic Finance
  • Transactions

Teachers and trainers (1)

Financial  Fluency

Financial Fluency

Online Learning

Course programme

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?

Concepts 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?

Introduction to Financial Modelling

£ 75 + VAT