Blog

Category
Archive

Support

Working with Function Keys in Financial Modelling
Tempting as it is to entitle this blog “All twelve function keys in Excel – ranked!”, I’m going to rein in my enthusiasm to share with you a more sober reflection on the utility (or not) of the 12 keys at the top of your keyboard. I’m restricting my comments to how they work in Excel –...
Business,Conference Financial Modelling | F1F9

Training

Getting back to the classroom

It’s with a sense of delight, relief and excitement that we announce that we're running in-person courses again this year.

A reminder: in-person courses means you get to:

travel to a venue; meet an instructor and other course participants in real...
Corporate budgeting in Excel - how we do it at F1F9

Build, Data, Support

Corporate budgeting: understanding the complexities
The budgeting process is often criticised for being time-consuming, adding far too little value and being out of date before the printer ink is dry. Arguments are also made against forecasting: either the outturn result is known (in which case why bother forecasting in the first place?) or the...
how to model foreign exchange

Training

Modelling foreign exchange gains and losses
If any financial modelling topic requires clear thinking then it is foreign exchange (“forex”). That’s because it calls upon domain knowledge from at least three different areas. You need to have a working understanding of accounting (noting that accounting standards in in respect of forex...
Financial model maintenance

Build, Data, Support

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...
f1f9 header photo for blogs

Build, Review

Using F11 quick charts
Most financial modellers create graphs to visualise data or to check trends. While building finance 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...
Support with building financial models

Build, Training

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

Training

The 6 Must-Have Skills for a Successful Financial Modelling
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

Build, Training

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...