SPECIALISTS IN FINANCIAL MODELLING

Understanding Incremental Cash Flows and Sunk Costs

We recently held a Meetup for the Brisbane Modellers’ Meetup group and I’m pleased to say that the video is now available below.  The speaker  Eris O’Brien is a highly experienced modeller and at this informative presentation he took a look at the...

Webinar: Scenario Tools in Excel

The recording & transcript of our first Plum Webinar is now available!  This hour-long webinar was free to attend and during Part One of this webinar, online trainer, Danielle Stein Fairhurst led us on a short technical demonstration of how to create scenarios...

Skills Needed for Financial Modelling

When you decide your financial models are not as good as they should be, should you immediately send your team on an advanced Excel training course? Whilst this is certainly helpful, there’s a great deal more to financial modelling than being good at Excel! When...

Which version of Excel am I using?

No, it’s not a silly question and since the “Modern Excel” was introduced in 2010, the changes have been pretty subtle and it can be a little difficult to tell the difference. Open up your version of Excel.  If it looks like the image below, then...

The Golden Rules for Model Design

There are a few rules for model design that should be followed when designing the layout of a model. Most experienced modellers will follow these instinctively, as they are generally common sense. Extract from Using Excel for Business Analysis, Chapter Two Separate...

The Workbook Anatomy of a Model

Model design and structure can be one of the most difficult parts of building a financial model.  Typically, modellers will work from back to front when building their model. The output, or the part they want the viewer or user to see, will be at the front,...

What’s the difference between a Formula and a Function in Excel?

Ever been guilty of using Excel as a fancy calculator?  If so, you’d just be using a formula in Excel.  If you entered a calculation such as =A1+A2 or =452*12, then that’s just a formula.  If a formula is all you need, then that’s fine.  But Excel can do...

Excel Top 10 Tricks

I’ve been showing this video supplied by Microsoft in my training recently, and lot of people have asked me for a copy, so here it is! Some of my favourite new features in Excel 2016 are: Forecast Sheet.  The ordinary FORECAST or TREND functions are very useful...

Using Tables in Financial Modelling

Structured Reference Tables have been around for a while, but have become a lot more powerful in recent versions of Excel.  They can be extremely useful when using Excel for the purpose of data analysis and modelling but I’m always surprised by the number of people...