Presented by
Falconbury

Financial Modelling for Bids and Tenders Masterclass

This programme will show your team how to submit winning, profitable tenders supported by a financial modelling process which reliably captures and evaluates all costs, identifies and manages key risks and provides an integrated priced proposal to deliver the best deliverable financial returns.

Find out more

  • Format: Bespoke training

Course Overview

In an increasingly competitive world you need to ensure your team have a sufficient grasp of the financial tools and techniques available to maximise and add value to your financial modelling process. This intensive In-house programme has been developed to deliver everything your team needs to know about financial modelling in the bids and tender environment.

Benefits of this programme

This programme will ensure the team can:

  • Understand and utilise financial model building best practice, and leverage Excel functionality to optimise speed of base model build
  • Construct a reliable accessible finance model centred on the 3 commonly understood financial statements
  • Rigorously interrogate internal models for errors, accuracy, completeness and sensitivity
  • Apply rigorous standards to external models to ensure reliability and robustness of submissions
  • Compare competing financial tendering proposals, utilizing financial investment ratios
  • Run sensitivity analysis on preferential tender solutions, on variation in key parameters and determine level of risk and returns involved
  • Recognise risks, and minimise their impact into your tender
  • Review Service Level Agreements and mitigate, examine key contractual terms and identify areas for negotiation that will increase your success rate and secure your best financial returns

Programme - Day 1

  • Financial modelling foundation
  • Setting up Excel modelling environment
  • Build the foundation model
  • Split model over new framework
  • Modelling definitions
  • Model and sheet structure
  • Best practice model building techniques
  • Protect and unprotect – How to, why, why not
  • NPV and IRR – how to, strengths and weaknesses
  • Alternative functions – XNPV/XIRR
  • Building Cashflow – The direct method
  • Absolute and relative cell –uses in model, where and when
  • Circular references – definitions, who uses them, why, what to do if you get one. How to trace, when to cut and run

Programme - Day 2

  • Build The Advanced Model
  • Key working schedules
    • Sales, price and margin
    • Variable costs
    • Employment costs
    • Operating costs
    • Depreciation
    • Cash, interest and tax
  • Improving data integrity via lookups and drop down lists
  • Pricing methodologies, what behaviour these drive.
  • Break even analysis – principles and uses

Programme - Day 3

  • Balance Sheet, funds flows and KPI’s
  • Populate the Balance Sheet (including debtors, creditors, capital, cash)
  • Funds flow setup and integration
  • Effective use of control accounts
  • Building a check sheet
  • Maintaining Model integrity over time
  • Financial KPI’s
  • Financial Ratios in reporting
  • Ratios as model drivers
  • Fixing a broken model
  • Identification of error
  • Importance of version control

Programme - Day 4

  • Subcontractor’s financial submission control
  • Setting Standards
    • Use of mandated templates
    • Use of mandated standards (FAST)
  • Stage 1: Arithmetic Test
  • Stage 2: Principles Test
  • Tools and techniques
    • Precedents
    • Dependents F2, F9
    • Formula checking
    • Links
    • Inconsistent formulas
  • Excel functionality
    • Shortcut keys, Use of $
    • Conditional formatting

Programme - Day 5

Financial risk management

  • How to recognise key risks and mitigate their impact on your proposal

Risk and contracts

  • Key contract clause review
  • Risks ownership
  • Service Level Agreements
  • Client dependency schedules

Financial risk management – how it works in reality

Real example of successful risk management throughout a contract life cycle: from tender stage , through winning, negotiation, contract operation and exit.

Review of course objectives

  • Delegate specific queries, financial modelling review and exam

Peter Gillon

Peter Gillon is the Founder of Gillon Financial Training. He has over 30 years’ experience in the private sector. Peter is a Fellow of Chartered Management Accountant (FCMA) and Chartered Global Management Accountant (CGMA) and has established himself through 12 years in major manufacturing companies, followed by 5 years as a small business finance turnaround specialist. The last 9 years, Peter was part of the rapid growth of Vertex to be one of the UK’s leading outsourcing service providers and was the finance specialist, bidding, winning and delivering, new business including bids of over £200m. He has built financial business models in multiple sectors, and evaluated over 70 different investment scenarios before presenting capital investment strategies with different risk profiles. Recent clients include the world renowned Manchester Business School (MBS), The Knowledge Group (Malaysia), a UK High Street Financial Services Company.
Peter’s previous clients include Sun Life of Canada, Marlborough Sterling Financial Services, United Utilities, Atos, Defra, DWP (UK Central Government Sector). He has also provided expertise in manufacturing companies such as British Gypsum, Georgia Pacific and UKAEA the nuclear research sector in the UK.

More details

We don't have any currently scheduled dates for this course but we can customise it to your requirements and deliver it on an in-house basis for any number of your staff or colleagues.

See below or contact us to discuss your requirements.

Multiple colleagues?
Talk to one of our training experts to discuss how to:

Run this course conveniently and cost-effectively in-house for your staff and colleagues

Aleksandra BEER
Training expert

+44 (0)20 7749 4749

inhouse@ipi.academy