Resources

Explore our ebooks, reports, free online courses and more for information about our approach to financial modelling. You'll find plenty of insights that we offer in the spirit of sharing our knowledge as widely as we can - and we'll add more content as soon as it's ready.
Forex webinar | F1F9

Webinar recording: Tackling the complexities of foreign exchange

In this webinar Andrew Berkley explains how to deal with foreign exchange in financial models. He covers the different types of currency, timing of flows and the gains / losses arising. You can also download the file shown during the session.
free download - example renewables model

Example models

Example Renewable Development Model

We developed this example renewables development model to demonstrate our approach to financial modelling. It makes our models easy to read and review, and straightforward to operate and amend.
How to build a financial model Cover photo

How to build a financial model

Find out what we think are the key steps to take as you build a financial model using best-practice principles. There are links to lots more free resources and a pdf version is downloadable if you need it.
Excel Proficiency Skills - free online course

Free Course

Excel Proficiency Skills

Join thousands of people who use our Excel Proficiency Skills online course to help them prepare for an F1F9 classroom course. Our 16 short videos will help you practise your skills as you work towards being a fluent Excel user.
Free course: Model Construction Skills

Free Course

Model Construction Skills

Join thousands of people who use our Model Construction Skills online course to help them prepare for a live F1F9 course. You will learn the basic principles of how to put a best practice financial model together, understand the benefits of a standardised approach, and improve your productivity.

F1F9's Example Financial Model

There’s no shortage of blogs, articles and opinion pieces on how we should go about building a financial model, but they only really scratch the surface and need some imagination to go from principles to practicality. That’s why we’ve put together an example financial model to share with anyone who’s interested in taking a look.
F1F9 Renewable Energy modelling webinar

Optimising Renewable Energy Models: webinar recording, download and Q&A

Did you miss our Optimising Renewable Energy Models webinar? You can watch the recording, download the VBA guide and read our Q&A here.
31 days course icon

Free Course

Transform Your Financial Modelling in 31 Days: A Journey to Excellence

In around 10 minutes per day for 1 month, this free financial modelling online course will teach you practical and highly effective new modelling skills (based on the FAST Standard).

Financial modelling guide

Technical notes on Escalation

At one level, financial modelling boils down to just two challenges: first, placing values correctly in time, and secondly, adjusting these values correctly for ‘the passage of time’. Download our Escalation notes to learn more - no form-filling required.
How to run an effective modelling team

Ebook

Managing Modelling

How to run an effective modelling team. 'Managing Modelling' uses real examples of how to run an effective modelling team with case studies from F1F9 customers and partners.
Guide - using the Trim function in Excel

Financial modelling guide

Guide: Using the TRIM function

If your working day includes taking a large data-set from a source (like TBs and other reports downloaded from SAP etc) and dumping it in Excel ahead of doing something useful with it, then you’ll be familiar with frustrations associated with raw data. Here's how we use the TRIM() function to help clean things up.
The oil and gas modelling checklist

Ebook

The oil and gas modelling checklist

This ebook will help you scope out the model build requirements for an Oil and Gas project.
Capitalism

Report

Capitalism's Dirty Secret

A research report into the uses and abuses of spreadsheets.
10 Signs that spreadsheets are killing your finance function

Ebook

10 Signs that spreadsheets are killing your finance function

What are the symptoms of a serious spreadsheet infection?
10 practical tips for new negotiators

Ebook

10 practical tips for new negotiators

A blood, sweat and tears list.
How to standardise modelling

Ebook

How to standardise modelling

Professionalising modelling in your organisation is not just about running a training course - it's about change management, and that can be hard work.
How to build & use tornado charts in Excel

Ebook

How to build & use tornado charts in Excel

Is your forecast precise enough to make a confident decision?
Essential Model Optimisation

Ebook

Essential Model Optimisation

A large part of project finance modelling is about finding a financial solution that works. The optimisation process is an important part of finding that solution.
10 principles of agile financial modelling

Ebook

10 principles of Agile financial modelling

When applied to most financial modelling assignments a traditional lifecycle approach to financial model build doesn't work, this ebook will explain why.
White paper - author John Richter

White Paper

What skills must university students learn?

In evaluating job candidates, employers are all about skills: all skills - both academic skills and professional trade-craft. They are influenced less by the “knowledge” imparted by a specific degree. John Richter considers how we might do a better job of equipping graduates with skills required in the workplace.
A practical guide to opex modelling in oil and gas

Ebook

A practical guide to opex modelling in oil and gas

This guide will help you understand the types of opex that you are likely to encounter in oil and gas projects.
Business Analysis Lifecycle

Ebook

Business Analysis Lifecycle

Your model exists to answer business questions. It is not an end in itself. This ebook defines the role of modelling in decision making.
Dirty Dozen: 12 Modelling Horror Stories

Ebook

Dirty Dozen: 12 Modelling Horror Stories

It has been reported that 88% of spreadsheets have some sort of error in them. Here is our list of the top 12 financial modelling horror stories.
CAPEX Modelling in Oil and Gas

Ebook

CAPEX Modelling in Oil and Gas

In this ebook we explain the origin and application of the S-curve, and provide you with flexible worked example modules in Excel, built to the FAST Standard.
Valuation Modelling Standards

White Paper

Valuation Modelling Standards

Guidelines for spreadsheet modelling in the mining industry - by Dennis Cowen