EXCEL Guide: FX Forwards, Carry and Options

Get yourself ahead of the line of candidates queuing up to join the most prestigious Financial Markets Division of banks. 

We demystify John Hull on Interest Rates Parity and FX Options. Sure, Interest Rates Parity may be intuitive and options relatively easy to grasp but plug in real world numbers and away from theory, and it is not that simple anymore.

Ever stared at a complicated math formula and got lost in mathematical notation? When professors explain a concept through lines and lines of equations and you just think it isn't intuitive. Welcome to my life!

I never really GOT it until I sat on a desk in S&T and started modelling on EXCEL.

If you are like me, this is the cheat sheet for you.

I will take you through step by step on how FX Forwards and Options are calculated done via EXCEL formulas.

I will give you tips on how FX Forwards are traded and how Forwards and Options are linked to Interest Rates. Definitely a good way to impress on the desk by being more intuitive than the next analyst or intern.

This spreadsheet includes 6 tabs where I take you through step by step on how to calculate Forward points, carry and option pricing, all using the same data set as before.

This is a MUST-HAVE, and will help you stand out much more quickly than other interns or analysts on the desk.