F1F9 blog | Full blog archive and subscription form

The best way to test a financial model is by splitting roles

"There is no software to my knowledge that can help with conceptual testing. For the moment we must continue to rely on our own intelligence and understanding."

Training

When is the right time to invest in the finance function?

"The Finance function is only being invested in when its failures are severely hurting the business"

Build, Review, Support, Training

In praise of charts

Smart use of quick charts can help turn a number cruncher into a chief executive

OPTIMISM BIAS - FINANCIAL MODELLING EXPERTS

Build

A quick and dirty test for optimism bias

"How can we, as project modellers, get comfort that the risk analysis has been factored into the base case assumptions?"

Build, Review

An introduction to checklists in modelling

"Years of knowledge, experience and organisational memory may be captured by a good checklist."

Training

What if my existing model isn’t FAST?

"Nobody likes my answer - which is to rebuild the model using a modelling standard"

Training

Spreadsheet Errors are avoidable

Why is it that in 2014 we are still talking about spreadsheet errors as if they were inevitable?

Training

Lessons Modellers Can Learn From the Design Professions

"I inherited an appalling, over complex, and, frankly untidy series of spreadsheets"

Build, Review, Support, Training

The advantages of the OFFSET function in Excel…

"My flight is being called and I still cannot think of a single advantage to using OFFSET"

Training

Embracing Innovation: How Will You React to a New Spreadsheet Model

"Interim FAST modelling is FAST modelling but undertaken in an existing non FAST model"

Training

Model Optimisation – Turning theory into practice

"FAST financial models, with transparency at their core, are designed to satisfy key stakeholders quickly and easily that their objectives are being met"

Training

New ebook: Business Analysis Lifecycle

"Communicating with people in the real world can be a challenge for those who live in the model world"

Build, Review, Support, Training

The Excel modelling guru

Like most stereotypes, the Excel modelling guru is an amalgam of different people that we all recognise

Blog