Category Archives: Excel

Build, Training

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

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

Build, Review

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