SPECIALISTS IN FINANCIAL MODELLING

Virtual Meetup: Cash Flow Liquidity Planning and Forecasting in Excel

The COVID-19 crisis has made it even more obvious that companies that fail to plan and monitor their cash flow liquidity are planning to fail! Insightful, responsive and dynamic liquidity planning is a must-have for a robust business. Off-the-shelf software can be time-consuming and expensive to implement and does not always provide the necessary flexibility required for dynamic and transparent cash flow planning.

The solution is an Excel-based tool. (more…)

Why every Excel model you build makes you a better modeller

There’s nothing quite like experience to really hone and sharpen your Excel modelling skills. Every hour that you spend nutting through a problem on the job means that the next time you come across a similar problem, you’ll solve it in a matter of minutes, not hours. This is especially true for creating complicated Excel formulas, or for model design and layout. So often I come across a problem when building a modelling solution for a client and I know I’ve seen this problem before.  Whilst it might have taken me half an hour to model it out the first time, often using trial and error but the next time it’ll only take a few minutes. The more experience you’ve got, the quicker and better modeller you’ll be.

(more…)

Should I put “financial modelling” on my resume?

I’m often asked what degree of skill level one needs to be able to include financial modelling as a skill on your resume or LinkedIn profile.  Once you’ve got an idea of exactly what is financial modelling, what is involved in the modelling process and you feel like you’ve got a good knowledge of financial modelling skills that you have used in the workplace then – yes – “Financial modelling” definitely needs to go on your resume and on LinkedIn. (Hint: no one can endorse you for a skill unless you list it on your profile, so be sure to keep your skills listing up to date).

(more…)

Modelling the Future | Full Stack Modeller

Recently our friends at Full Stack Modeller conducted the biggest ever survey of the financial modelling profession, and the results were published in February 2021. What are financial modeller’s biggest frustrations? How much do modellers earn? What add-ins and tools beyond Excel do modellers use? Covering tools, standards, risk management and more, the 2021 survey paints a picture of the current state of play in financial modelling.

(more…)

FMI Level 1 Mock exam three-way model

Learning to build a fully dynamic three-way model is an important part of becoming a financial modeller, and a pre-requisite to being certified by the Financial Modeling Institute (FMI). A three-way model refers to the three financial statements of a company; the P&L (Income Statement), Cashflow and Balance Sheet. An FMI certified financial modeller should be able to build these statements, and link them dynamically so as to be able to perform scenario analysis;.. all in under four hours!

(more…)

Getting a Financial Modelling Qualification

FMI QualificationIf you’re planning to pursue a career in financial modelling, there is no shortage of free resources to help you improve your financial modelling skills.

There are also hundreds of financial modelling training courses to choose from; most will give you a certificate of attendance, and an opportunity to claim Continuing Professional Development (CPD) points from your professional body.

Some will even give you a Certificate of Completion (note the capital C!)

(more…)

Do You Really Need an ‘Advanced Excel’ Course?

Excel is the backbone to any custom built financial model, and one of the core attributes of a financial modeller is to have good technical Excel skills.  When struggling with their financial models, some managers’ first reaction is to send their staff on an advanced Excel course to improve their modelling skills.  However, with training budgets under constant scrutiny you really need to make sure that you get the best value out of your training options.

(more…)