Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
  • Due Diligences Excel Template - P&L starter pack
Originally published: 01/09/2019 07:47
Last version published: 30/10/2019 14:40
Publication number: ELQ-89382-6
View all versions & Certificate
certified

Due Diligences Excel Template - P&L starter pack

Starter Pack Template for Financial Due Diligence - P&L

Description
This tool is a template that will get you started with your P&L financial due diligence. I have built all the template analyses in the tool based on several years of experience in M&A Transaction Services at PwC focusing on what I found were recurring, essential analyses to be conducted in any good FDD.
To give a better view of the model I have created a summary P&L with a few classic KPIs from the ground up that you can populate with your own numbers. All the other analyses are formula-linked, when possible, to this summary P&L. Here is an overview of the tool :
- Quality of Earnings => Generally the key point of your due diligence as adjusted EBITDA will serve as a basis for valuation and to assess forecast
- Revenue bridge by main products => Will allow to quickly see if a certain product category has been driving the growth
- Revenue seasonality => Will allow you to see if the business has a specific seasonality (eg. peak season in Christmas)
- Gross Profit Bridge by Volume / Margin effect => Will help you understand what drove the change in Gross Profit ( and to a larger extent, to EBITDA)
- EBITDA bridge => Will help you to focus on the main drivers of EBITDA, highlighting key movements year on year.
- Employee costs analysis => Allows to get an idea of the costs per FTE and repartition of bonuses
- Historical Budget Accuracy Analysis => Will allow you to assess the reliability of Management budgeting process. That's generally a key information to look at when trying to assess Management forecast
- Current Year Trading analysis and Outturn - Will allow you to compare current year trading with previous year and see how far or how close Management is to realise it's current year forecast
- Monthly forecast analysis => Flexible graph that allows you to compare the monthly forecast with monthly historical in $ value and as a of revenue

This Best Practice includes
1 Excel file

Acquire business license for $3.00

Add to cart

Add to bookmarks

Discuss

Further information

Provide a solid template of key analyses to perform when conducting financial due diligence on a Target

Financial due diligence . Understand the drivers of the business and assess feasibility of forecast.

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Pierre-Alexandre HEURTEBIZE

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Due Diligences Excel Template - P&L Starter Pack?

The user community and author are here to help. Go ahead!


4.8 / 5 (4 votes)

please wait...