Excel Model Review Tools you need to know

It is well-documented that up to 90% of spreadsheets contain errors and although any individual mistake may be small, they can quickly add up. Checking for errors is an important part of the financial model build and there are many native Excel tools that can be used for this purpose. (more…)

Full 3-way Financial Modelling using Dynamic Arrays

Best practice financial modelling in Excel has always been to enter your formulas in blocks. Enter a formula, then copy this across and possibly down also, making sure you have your absolute and relative references set correctly.

This is very useful because it is faster to build a model, easier to enter lots of formulas, less error-prone and easier to audit, all very desirable things when you’re constructing a financial model! Excel’s dynamic array functions take this concept to a whole new level because they automatically copy themselves. The dynamic array functionality has improved recently & now, with a bit of thought & planning, it can be applied to building a full financial model.


Virtual Debate: Fractional, Virtual or Outsourced CFOs

What’s the difference between a fractional, virtual or outsourced CFO? How much strategic planning, forecasting and financial modelling do they actually do, or are they just glorified bookkeepers over-charging at CFO rates? A good CFO will build forward-looking financial models to help businesses make better decisions but an external consultant marketing themselves as a fractional, virtual or outsourced CFO can simply manage day to day cashflow, month end and process payroll, receivables and payables, so misrepresenting and devaluing the role of the CFO. (more…)

Building the Financial Model Dashboard (CPA Webinar)

Building the Financial Model Dashboard (CPA Webinar)Summarise the outputs of your financial model using standard Excel skills into a concise, dynamic and visually appealing one-page dashboard report which can effectively communicate the results of your model to be easily interpreted and understood by others at a glance. (more…)

Should you use Macros in Financial Modelling?

Macros in Financial Modelling

Many aspiring modellers think that they need to be proficient in macro building in order to become serious financial modellers. Whilst it’s not a bad idea to have a working knowledge of macros—and the language they are built in, Visual Basic for Applications (VBA)—it’s certainly not critical for a financial modeller to become a super VBA programmer. As we know, the best sort of financial model uses the simplest tools and introducing macros to a financial model brings a whole new level of complexity.


Checking a financial model

Checking a financial modelAs a consultant starting on a new project, I’d always prefer to start a new model from scratch – but that rarely happens! Normally we modellers have to take apart, check and validate a model that’s already been built by another modeller and when this happens, you can either start over and build your own model from the ground up or validate and verify the existing model to the extent that you’re comfortable to take responsibility for the calculations. Starting over to build your own model from scratch is inefficient and a waste of resources. Unless the model is in extremely poor shape, it’s usually far more efficient to use what you already have — but leave no cell untouched during the process of validation and verification.


Virtual Meetup I Are Excel’s Power Technologies suitable for Financial Modelling?

When people think about financial modelling or forecasting in Excel, what comes to mind is worksheets loaded with formulae, built in a report-focussed layout. Watch as Ken Puls showcases examples of using Excel’s Power Technologies to build Financial Models and Forecasts for clients. From data shaping with Power Query to DAX in Power Pivot, these tools play an essential role in modern financial modelling solutions.