Category Archives: Excel

Charting new territories with FAST

In my experience making a good model requires you to spend time not modelling, but talking about it instead. With my immediate team, I can talk in front of the monitor with the model on it. But other project members do not talk in columns and rows; they prefer to talk with pictures. Pictures mean...
how to model foreign exchange

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

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