Last version published: 30/11/2019 19:27
Publication number: ELQ-16910-2
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
Pierre-Alexandre HEURTEBIZE offers you this Best Practice for free!
download for free
Add to bookmarks
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.
Write a review
People using this Best Practice also downloaded
Multiple investing rounds Cap TableCap table for capital raise / buy in - by out and investor IRR and investment multiple forecast356add_shopping_cart
Productivity VBA tool - Automation of year on year movement computation for multiple periodsProductivity tool - VBA Macro for automatic year on year movements and automatic formatting50add_shopping_cart
DSO - DPO - DIO computation and graph - Countback methodDSO (Days Sales Outstanding)/ DPO (Days Payable Outstanding)/ DIO (Days Inventory Outstanding) charts countback method.198add_shopping_cart
Due Diligences Excel Template - P&L starter packStarter Pack Template for Financial Due Diligence - P&L220add_shopping_cart
Calculation of Depreciation & Amortization from Capex Excel ModelTool to calculate Depreciation and Amortization (D&A) from Capex using the straight line method100add_shopping_cart
Calculation of income tax with tax loss carry-forwardSimple tool to compute income tax, taking into account tax loss carry forward35add_shopping_cart
Due Diligence Excel Best Practice - Balance Sheet starter packStarter Pack Best Practice for Financial Due Diligence - Balance Sheet177add_shopping_cart
REITs investment model (SCPI in French)Investment model in REITs "Real Estate Investment Trusts" (SCPI in French) which allows to project IRR114add_shopping_cart
Investment Pitch Deck for Social Media Management companyThis is a template Pitch Deck giving an overview of a business and its financials.111add_shopping_cart
Inventory Management and Analysis best practice with dynamic chartsInventory Management and Analysis best practice. Useful to the Management team as well as to external financial analyst.80add_shopping_cart
Any questions on P&L (Profit & Loss) Constant Currency Analysis Excel Model?
The user community and author are here to help. Go ahead!