Transaction Services – FDD Sales & Profitability Analysis (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. Analyses sales and margins across divisions, products, regions and customers to identify growth and concentration drivers.
2. Visualises reported, adjusted and pro-forma sales/EBITDA through bridges, seasonality charts and segment overviews.
3. Breaks down profitability and EBITDA drivers (output, material, personnel, OOI/OOE) to explain margin development.

SALES EXCEL DESCRIPTION

Transaction Services – FDD Sales & Profitability Analysis is an Excel template (XLSX) with a supplemental Excel document available for immediate download upon purchase.

Purpose of the tool

This Excel-based Sales and Profitability Analysis Model provides a structured view of revenue and margin development across multiple dimensions such as divisions, products, regions and customers. It helps you understand how growth, mix and price/volume effects translate into profitability and where concentration risks, margin pressure or structural shifts may occur. The model can combine reported, adjusted and pro-forma figures, for example by linking inputs from your QoE work, and visualises sales and EBITDA performance through bridges, seasonality charts and segment overviews. This makes it straightforward to identify which segments drive growth, which customers are most relevant, and how total output, material, personnel and other operating items contribute to overall profitability. The tool is particularly useful for Transaction Services, financial and commercial due diligence and factbook preparation, but it is equally suited for recurring management reporting and performance 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

The model provides a sales overview including reported, adjusted and pro-forma sales with bridge views, complemented by a sales seasonality analysis showing monthly trends across fiscal years. It includes segment breakdowns and charts for sales by division or segment, by product or product group, and by region or country, and it also highlights customer concentration through top-customer views. On the profitability side, it delivers an overview covering total output, EBITDA, EBIT and net profit with margin analysis, supported by an EBITDA driver analysis that breaks down performance drivers such as total output, material, personnel and other operating income/expenses using bridge or waterfall-style views.

Key Inputs & Assumptions

The model is based on income statement and sales data, ideally monthly and with segment information such as division, product, region and customer. Where relevant, it can use QoE-related flags or linkages to differentiate between reported, adjusted and pro-forma figures. In addition, basic structural settings such as the number of segments (divisions, product groups, regions) and analysis periods are defined in the assumptions.

How to use

Start by setting the core parameters such as segments, time horizon and currency in the Assumptions sheet. Then load income statement and sales detail data into the relevant source / lead sheets and reconcile them to the financial statements. Where relevant, link or input adjusted and pro-forma figures and review the sales, concentration, seasonality and profitability tabs to analyse growth, mix and margin development.

Customization & support

The model is highly customisable and allows you to adapt segment structures, labels, KPIs and charts to your specific business model, industry or reporting standards. For more complex customisations or individual requirements—such as firm-specific versions, integration into broader workbooks or additional analysis modules—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. If you want to cover the full analysis scope—from Earnings/QoE and Working Capital to Net Debt plus sales and customer analytics—you may also want to have a look at the "Transaction Services All-in-One Financial Analysis Workbook."

Source: Best Practices in Sales, Due Diligence, Customer Profitability Excel: Transaction Services – FDD Sales & Profitability Analysis Excel (XLSX) Spreadsheet, Finance Model Hub