Transaction Services – FDD All-in-One Excel Workbook (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. Combines all core TS analyses in one integrated Excel workbook.
2. Delivers audit-friendly bridges, KPIs and dashboards ready for reports.
3. Easy to use and customise, with Clean and Example templates included.

SALES EXCEL DESCRIPTION

This product (Transaction Services – FDD All-in-One Excel Workbook) is an Excel template (XLSX) with a supplemental Excel document, which you can download immediately upon purchase.

This model combines and expands the following tools into one integrated workbook: Corporate Finance – Sales and Profitability Analysis Model, Corporate Finance – Quality of Earnings Model, Corporate Finance – Net Debt Analysis Model, and Corporate Finance – Working Capital Analysis Model.


Purpose of the tool

This Excel-based Transaction Services All-in-One Financial Analysis Workbook brings together all core TS workstreams in a single integrated file. It combines Quality of Earnings (QoE), multi-dimensional sales & profitability analysis, working capital (including aging), net debt & debt-like items, net asset / balance sheet analysis, as well as additional modules such as Current Year Trading (CYT) and business plan linkage.Starting from the trial balance and basic sales detail, the workbook guides you through mapping, classifications, adjustments and pro-forma entries and consolidates everything into decision-ready outputs: bridges, KPIs, dashboards and tables suitable for inclusion in factbooks, IC decks or due diligence reports. The structure is audit-friendly and designed to keep Earnings, Working Capital, Net Debt and commercial views fully consistent with each other. The tool is particularly useful for Transaction Services, financial & commercial due diligence and factbook preparation, but it can also serve as a robust integrated management reporting and analysis framework for recurring internal reviews. Each sheet includes a short "What to do / What to know" box with practical instructions, so you always know exactly what is expected on that tab and how it feeds into the overall model.

Key outputs

Within Earnings / QoE, the workbook provides reported, adjusted and pro-forma EBITDA and margins, supported by structured adjustment schedules (reclassifications, normalisations and pro-forma items) and clear, traceable bridges. For Sales & profitability, you get a sales overview including seasonality, analyses of sales by division, product, region and customer, and segment-level profitability views including EBITDA, EBIT, net profit and margin analysis. The Working capital & aging section shows net working capital by component with a clear OWC vs. Net Debt split, key metrics such as DIO, DSO, DPO, CCC and NWC as a percentage of sales / material expenses, as well as trade receivables and payables aging schedules and seasonality insights. In Net debt & debt-like items, the workbook covers net financial debt and other debt-like items (reported and pro-forma), delivers core leverage KPIs (Net Debt, Adjusted Net Debt / EBITDA, Net Debt / equity), and includes charts on net debt composition and development. Under Net assets & CYT / expense analysis / plan, it provides a consistent net asset structure with allocation to OWC, Net Debt and other categories, Current Year Trading (YTD/YTG) views with YoY comparisons, detailed breakdowns of Other operating income (OOI), Other operating expenses (OOE), personnel and material expenses, and a business plan module linking historic / LTM performance to forward-looking plan years.

Key inputs and assumptions

The model is built on trial balance / financial statements, ideally monthly and at account level. Where available, it also uses sales detail with segment information such as division, product, region and customer. In addition, you define mapping rules for net assets, working capital vs. net debt classification, and QoE categories. Optional business plan figures (sales, costs, EBITDA, etc.) can be added for the planning section.

How to use

First, set the core parameters (periods, segments, currency and plan horizon) in the Assumptions sheet. Then load your historical trial balance and sales detail into the relevant source / lead tabs and reconcile totals. Next, classify accounts for QoE, working capital vs. net debt and net asset categories, and enter the relevant adjustments (QoE, NWC, Net Debt and pro-forma items). Finally, navigate through the Earnings/QoE, Sales & Profitability, Working Capital, Net Debt, Net Assets, CYT and Plan tabs to review the integrated analyses, bridges and KPIs and use them in your reports and factbooks.

Customization and support

The workbook is highly customizable—you can easily adapt categories, segment structures, labels, KPIs and charts to your firm standards, sector specifics, or lender / investor reporting requirements. For more complex customizations or individual needs (for example firm-branded versions, additional modules, integration with existing templates, or client-specific setups), feel free to reach out and we can discuss a tailored solution. Each download includes both a fully blank "Clean Template" for working directly with your own data and a pre-populated Example Template that illustrates the model's logic and calculations using realistic sample data.

Source: Best Practices in Sales, M&A, Due Diligence, Integrated Financial Model Excel: Transaction Services – FDD All-in-One Excel Workbook Excel (XLSX) Spreadsheet, Finance Model Hub