Financial Due Diligence Template Workbook

Description
The file is a comprehensive Financial Due Diligence workbook built for transaction services professionals working on buy-side and sell-side engagements. This template provides a structured framework for analysing a target company's earnings quality, working capital position, net debt and commercial performance — the four pillars of any DD factbook.

The Quality of Earnings tab captures monthly reported revenue and EBITDA alongside seven adjustment categories, automatically rolling into annual totals with prior-year comparisons. The EBITDA Bridge tab presents the reported-to-adjusted walk with a waterfall chart and commentary fields for your narrative. Working Capital analysis tracks four asset and four liability line items monthly, calculating DSO, DIO, DPO and Cash Conversion Cycle to identify seasonality patterns and efficiency trends. Net Debt modelling covers six debt instruments and six debt-like adjustments including pensions, earn-outs and contingent liabilities.

Sales & Profitability breaks revenue across four segments with mix analysis and margin tracking. AR and AP Aging schedules highlight overdue balances automatically. The Dashboard pulls all headline KPIs with conditional formatting on leverage thresholds, and the Scenario Analysis tab produces bear, base and bull cases for implied Enterprise and Equity Value at an 8x multiple.

Includes a User Guide and 25-term Glossary. 418 formulas, zero errors, industry-standard colour coding throughout.