Author Archives: John Dimberline

John has 18+ years of experience and has led advisory teams on a large number of complex projects supporting both public sector procurers, private sector bidders and corporates.

Amnesia – 10 Signs Spreadsheets are Killing your Finance Function

The  following text is taken from our ebook – 10 signs spreadsheets are killing your finance function: #4 Amnesia SYMPTOMS: Last minute panic buying of birthday presents. Missed gym appointments. You hear ‘aren’t you meant to be somewhere else?’ more often than you’d like. Family members leaving curt messages on your answerphone. The school are […]

Building financial models using Agile – a quick introduction

Modelling is an inherently difficult and complex task. At F1F9 we build financial models using an Agile approach – here’s why: Most guidance on managing the model build process recommends a traditional life-cycle approach of Specify, Design, Develop, Test, Deploy. When applied to most financial modelling assignments this approach doesn’t work. It is too inflexible […]

Download F1F9’s example renewables development model here

Download here We are delighted to invite you to download this renewables development model. (And if you haven’t already seen our original example model, you may be interested in that one as well.) We’re sharing it with you to demonstrate our approach to building financial models, which makes our models easy to read and review, and straightforward to […]

Managing Modelling: Embrace an open and honest culture

Errors will happen. It is an unfortunate fact of life, whenever humans are involved with complex data manipulation and modelling, errors occur. A financial modelling manager needs to create an environment where any member of the modelling team can feel comfortable notifying them as soon as an error or mistake is identified. Having confidence in […]

Modelling best practice – actions speak louder than words

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 model to share with anyone who’s interested in taking a look.

New ebook on collaborative financial modelling

The article below is taken from our new ebook: Managing Modelling – How to run an effective modelling team, it’s available for you to download free of charge and with no form-filling. Financial modelling should be a collaborative team-based activity, not an individual activity. Building team spirit and a collaborative environment is fundamental to the […]

Simplifying renewable energy models

While the news often paints a gloomy picture – the Amazon is burning and Germany is struggling to make the economic and social transition away from brown coal – there are plenty of reasons to cheer when one reads the degree to which renewables are providing ever more of world’s energy.
This year, the UK has seen weeks where coal has played no part in the energy supply for the first time since 1882.

In my eyes there’s an inherent beauty in renewables projects, a beauty drawn from their simplicity – the sun shines; the wind blows and from that we get energy. Conversely, we’ve come across financial models underpinning such projects whose complexity defies the very simplicity of what they are seeking to quantify. Read more…