Blog

Category
Archive
Financial model maintenance

Five reasons to outsource financial model maintenance

We work with plenty of clients on building data-heavy enterprise models to meet their needs. The models include functionality to accommodate actual financial figures, budgets and forecasts. A recent example is a large business model with five subsidiaries. It has the ability to store budget copies...

Using F11 quick charts

Most financial modellers create graphs to visualise data or to check trends. While building models, a good modeller will keep asking themselves whether their results are looking sensible. A good financial modeller will regularly chart line items and analyse the resulting trends - even while they...
Support with building financial models

Time to call in the financial modelling experts?

Why take a driving test if you have no intention of ever driving a car? Answer: you wanted to acquire the knowledge, skills and experience to confirm that this activity wasn’t for you. The more informed you are, the more likely you are to make sensible decisions. At F1F9 , we have been...
financial modelling skills - 6 that you should have

6 skills every financial modeller should have

It’s frustrating to struggle at something only to discover that, after much hard work, there was an easier way.  That’s why people seek out formal training courses in financial modelling. I frequently hear comments like: “I wish I’d done this course years ago” or “You do not...
How to use flags in financial models

Put out more flags

Every forecast model we build in F1F9 has a Time sheet: a worksheet dedicated to important dates e.g. when the model starts, when the model ends, when the project starts, when the project ends, when the project moves from one phase to another. The Time sheet is a foundation sheet: bringing together...

Adding actuals to a financial model

We had a great question from one of our online course subscribers asking about the design of financial models with historical data at their heart, a.k.a. "actuals".   “This is the bit I find daunting: when you start an assignment, you don’t always have a set of actuals ready for...
F1F9 live online training

F1F9 financial modelling courses now live and online

Our tutor-led distance learning courses are typically delivered over 12 one-hour live, interactive sessions. We timetable them over a number of days to give you time to absorb and revisit the tutorials, undertake assignments and consume targeted video content. Your tutor teaches you as part of a...
Financial modelling skills checklist

5 reasons to invest time in your basic Excel skills

I meet lots of people on F1F9 training courses who are looking to improve their financial modelling skills. Some have excellent knowledge and abilities when it comes to operating Excel: it is obvious that they have put in the practice. Others struggle. There are plenty of other skills-based activities in life where time spent acquiring the basics can open up endless possibilities - so here are five reasons why you should invest time in your basic Excel skills.
Financial modelling for renewables

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...
Best practice financial modelling

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.
data modelling blog

Deliverable Management Information Systems

Why did substantive changes to the MS Excel spreadsheet end 20 years ago? Not even a simple tweak to the LOOKUP function to allow exact-match with a FALSE argument? That on its own would unify a batch of sub-optimal approaches available through all the alternatives, with INDEX/MATCH combinations...