Financial Modeller

Contract summary

Industry

• Recruitment services - 79600000

Location of contract

United Kingdom

Value of contract

£55,748.28

Procurement reference

TIS0486

Published date

21 October 2021

Closing date

6 October 2021

Closing time

12pm

Contract start date

20 October 2021

Contract end date

31 March 2022

Contract type

Service contract

Procedure type

Call-off from a framework agreement

Contract is suitable for SMEs?

Yes

Contract is suitable for VCSEs?

No

---

Description

Financial Modeller

The Financial Modeller will provide key support to the Financial Planning and strategy project teams, leading development of the financial models and analysis needed to inform the strategy implementation and 5-year Strategic Business Plan. The role will require strong financial modelling and accounting skills and experience, use of excel to produce and maintain multi-year spreadsheet models, and an ability to work with colleagues from finance and across operations to interpret data and explain modelling requirements and outputs and produce graphics for senior managers.
Deliverables:
• Develop financial models. Developing and implementing financial forecasting and budgeting model.
• Develop reporting tools that automatically imports Business Plans into a consolidation model.
• Develop models into an integrated reporting suite.
• Creating a series of Excel and PowerPoint that could update charts and tables in presentation packs
• Provide support to fix and develop financial models.
• Work with the finance/Ops team to understands the complex requirements and accurately implemented data in various modules.
• Utilise data manipulation techniques in Excel to populate models with accounting data.
• Develop investment appraisal model that allow for the potential cost or revenue benefits to be compared with the costs of the project.
o Decision models whereby answering a series of questions determine the level of authority, e.g. board, committee or delegated authority, required for making an investment or accepting a customer.
• Developed best practice model build, version control and model review methodologies

---

Award information

Awarded date

13 October 2021

Contract start date

20 October 2021

Contract end date

31 March 2022

Total value of contract

£55,784.28

This contract was awarded to 1 supplier.

ROBERTSON BELL LTD

---

About the buyer

Contact name

Jane Cooper

Address

18 Priory Queensway
BIRMINGHAM
B4 6FD
England

Email

jane.cooper@insolvency.gov.uk