Originally published: 24/11/2019 14:35
Last version published: 13/04/2020 09:22
Publication number: ELQ-16910-3
View all versions & Certificate
Last version published: 13/04/2020 09:22
Publication number: ELQ-16910-3
View all versions & Certificate
P&L (Profit & Loss) Constant Currency Analysis Excel Model
Best practice to assess the impact of FX on a P&L for a business trading in different currencies
by Pierre-Alexandre HEURTEBIZEConsultant - M&A, Modelling and Financial analyst - Investment Manager at HoriZen CapitalFollow 44
Further information
Assess the impact of exchange rate variation on profitability. Separate transaction effect vs. translation effect.
Financial due diligence. Reporting. Multiple currency analysis. Understanding operations on a constant currency basis.
Reviews
Write a review
People using this Best Practice also downloaded
Due Diligence P&L - Exhaustive Revenue and Costs analysis template
Due Diligence exhaustive P&L template for Revenue & Costs Analysis. Big-4 like playbook of due diligence analyses.233Discussadd_shopping_cart$249.00
by HEURTEBIZE
Best Practice to aggregate data from several tabs in excel
Looking to aggregate the data of multiples tabs into one clean tab? Look no further, this allows you to do just that!186Discussadd_shopping_cartfree
by HEURTEBIZE
P&L Due Diligence - Exhaustive Revenue Analysis model
Model for in depth understanding of high level P&L and Revenue Analysis. Big-4 like book of due diligence analyses.595Discussadd_shopping_cart$199.00
by HEURTEBIZE
Inventory Management and Analysis best practice with dynamic charts
Inventory Management and Analysis best practice. Useful to the Management team as well as to external financial analyst.1,2181add_shopping_cart$30.00
by HEURTEBIZE
Price-Volume-Mix Analysis
A comprehensive full-scope model to analyse revenue and profit changes1,593Discussadd_shopping_cart$50.00
by Andrei Okhlopkov
Power BI and Dashboards for the Busy Professional
How to build complex, insights-rich, interactive reports and dashboards in Power BI.287Discussadd_shopping_cart$39.00
by Michael Olafusi
Ratio Analysis, Financial Ratio Analysis in Excel
Learn all you need to know about ratio analysis, using a manufacturing firm as a case study.637Discussfree
by Finance Walk
Finance Toolkit
Extensive business financing toolkit including 6 excel tools129Discussadd_shopping_cart$4.00
by David Connaughton
2014 Round 1: Dealing with Data
Excel training/competition model from the 2014 Financial Modeling World Championships407Discussadd_shopping_cartDiscounted Cash Flow (DCF) Valuation Excel Model (Engineering and Construction)
Detailed Financial model for DCF valuation on Engineering and Construction Company3861add_shopping_cart$75.00
by Fin-Wiser Advisory
More Best Practices from Pierre-Alexandre HEURTEBIZE
Price Volume Mix Analysis (PVM) excel template with Charts - Sales mix and Gross Profit by Product
Price volume mix analysis (PVM) excel template to better understand your sales and improve pricing strategy.9,1758add_shopping_cart$60.00
by HEURTEBIZE
Multiple investing rounds Cap Table
Cap table for capital raise / buy in - by out and investor IRR and investment multiple forecast2,325Discussadd_shopping_cart$10.00
by HEURTEBIZE
Multiple rounds Cap Table including Safe, pro-rata rights and Management Option Pool
Multiple rounds cap table including SAFE conversion, Management option pool and investment performance (IRR) 3 scenarios941Discussadd_shopping_cart$39.00
by HEURTEBIZE
Simple Startup and SME Forecast Business Plan
A projection Model for startup and SME to forecast a complete P&L, Net Working Capital and Cash flow.491Discussadd_shopping_cart$49.00
by HEURTEBIZE
DSO - DPO - DIO computation and graph - Countback method (Includes countforward method!)
DSO (Days Sales Outstanding)/ DPO (Days Payable Outstanding)/ DIO (Days Inventory Outstanding) charts countback method.1,283Discussadd_shopping_cart$25.00
by HEURTEBIZE
P&L Due Diligence - Exhaustive Revenue Analysis model
Model for in depth understanding of high level P&L and Revenue Analysis. Big-4 like book of due diligence analyses.595Discussadd_shopping_cart$199.00
by HEURTEBIZE
Due Diligence Excel Best Practice - Balance Sheet starter pack
Starter Pack Best Practice for Financial Due Diligence - Balance Sheet1,080Discussadd_shopping_cart$40.00
by HEURTEBIZE
Scorecard - Scoring and Valuation Model
Scorecard / scoring model to help valuation, target assessment and visually see strengths and weaknesses of a business285Discussadd_shopping_cart$5.00
by HEURTEBIZE
Inventory Management and Analysis best practice with dynamic charts
Inventory Management and Analysis best practice. Useful to the Management team as well as to external financial analyst.1,2181add_shopping_cart$30.00
by HEURTEBIZE
Discounted Cash Flow (DCF) and Comparables Valuation Model
Discounted Cash Flow analysis of your business and compare it to a valuation comparables.623Discussadd_shopping_cart$49.00
by HEURTEBIZE
Advanced multiple rounds Cap Table Model including SAFE an Management pool with 4 different structures
Multiple rounds cap table including SAFE conversion, Management option pool and performance (IRR) with 3 deal structures287Discussadd_shopping_cart$70.00
by HEURTEBIZE
Due Diligence P&L - Exhaustive Revenue and Costs analysis template
Due Diligence exhaustive P&L template for Revenue & Costs Analysis. Big-4 like playbook of due diligence analyses.233Discussadd_shopping_cart$249.00
by HEURTEBIZE
Discussion feed for P&L (Profit & Loss) Constant Currency Analysis Excel Model
The user community and author are here to help. Go ahead!
- Hi B.
The "appropriate" way to do things really depends on the objective you are trying to achieve and the context in which your booking occur. Constant currency analysis is generally done to have a better idea of how the business has been operating historically assuming the fx rates were all constant. This is often an interesting analysis to do when you are trying to acquire a business, in which case you generally take the most recent FX rate to have a better understanding of expected margin % in the short term.
The "latest spot rate" is simply the latest known FX rate. If I look at the US / EUR rate today for instance it stands at 0.89. This is the latest spot rate.
Eloquens Member