Financial Modelling for Bids and Tenders Masterclass

This In-house 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

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.

This programme will ensure the team can:

  • Understand and utilize financial model building best practice, and leverage Excel functionality to optimize 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
  • Recognize 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

Your next step is to call us now on +44 (0)20 7729 6677 or email us at or use our contact form and find out how we can help. There are no commitments, and if we cannot help our advice and recommendations are free of charge.

Sample Programme Day 1 - Financial Modelling Foundation

  • 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

Sample Programme Day 2 – Financial Modelling Foundation

  • 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

Sample Programme Day 3 – Financial Modelling Integration

  • 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

Sample Programme Day 4 – Making Sure of Your Commercial Rights

  • 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

Sample Programme Day 5 – The Commercial Financial Framework

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

Recommended Trainer

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.