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.
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.
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
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.
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
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.
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.
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.
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.
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.
Ebook
The oil and gas modelling checklist
This ebook will help you scope out the model build requirements for an Oil and Gas project.
Ebook
10 Signs that spreadsheets are killing your finance function
What are the symptoms of a serious spreadsheet infection?
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.
Ebook
How to build & use tornado charts in Excel
Is your forecast precise enough to make a confident decision?
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.
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
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.
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.
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.
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.
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.
White Paper
Valuation Modelling Standards
Guidelines for spreadsheet modelling in the mining industry - by Dennis Cowen