P&L (Profit & Loss) Constant Currency Analysis Excel Model
This best practice allows the user to analyse and understand the impact of Foreign Exchange movement on the P&L of a company which trades in multiple currencies.
After the foreword, the first tab presents a P&L with each fiscal year side by side for comparison. On the right of the table, movement in absolute numbers and in percentage are here to assess for each year the impact of historical FX vs. constant FX (ie. what was the impact of currency movement between historical rate and today's rate).
The second tab present side by side one P&L at historical FX rate and one P&L at Constant FX rate. This will allow the user to understand better the operational efficiencies or the movement in Margin with and without the impact of the FX movement.
The last three tabs, (one for each financial year), include a P&L broken down by original currency and allows to compute P&L by currency at historical rate and P&L by currency at constant FX rate.
Please note that the template has been built assuming P&L was reported in USD dollars, but everything can very easily be changed to suits your particular needs.
This will allow you to easily build bridges with a lot of insight, without being biaised by the currency impact.
