Financial Models in Transaction Services
The types of financial models used in Transaction Services, how they are built, and the Excel skills FDD analysts need to develop.
Financial modelling in Transaction Services is different from the financial modelling taught in investment banking courses. TS models are analytical tools built to understand historical performance and present findings clearly — not to forecast cash flows for a DCF. Understanding the specific model types used in FDD is important for any TS candidate.
The Core TS Models
The Historical P&L Model
The foundation of every FDD engagement. This model:
- Reconstructs the P&L for the last 2–3 financial years plus the LTM period
- Is structured to allow easy EBITDA bridge construction
- Includes sub-schedules for revenue by segment, cost by category, headcount
- Reconciles to audited statutory accounts
Key features: monthly or quarterly breakdown, clear period labels, reconciliation row to statutory figures.
The EBITDA Bridge Model
Built on top of the historical P&L. This model:
- Lists every EBITDA adjustment with description, year and amount
- Calculates adjusted EBITDA for each period
- Includes a summary bridge (waterfall) from reported to adjusted EBITDA
- Tracks whether adjustments are accepted, challenged or partially accepted
The NWC Model
The NWC model:
- Builds monthly NWC for the last 24–36 months
- Decomposes NWC into its components (trade receivables, inventories, trade payables, other)
- Calculates DSO, DPO and inventory days for each period
- Identifies seasonal patterns and proposes the NWC target
- Quantifies the NWC target under different methodologies (LTM average, specific date)
The Net Debt Model
The net debt schedule:
- Lists all financial debt items with their balance at the reference date
- Lists all cash and cash equivalent items
- Includes debt-like items with their proposed classification
- Cross-references to the SPA net debt definition
Excel Skills Required in TS
FDD analysts need to be proficient in Excel, but not in a financial modelling competition sense. The key skills are:
- Efficient data organisation: Clean, labelled, structured worksheets
- Pivot tables: For customer revenue analysis, headcount analysis, cost breakdowns
- SUMIF, VLOOKUP, INDEX/MATCH: For linking data across worksheets and pulling in specific items
- Named ranges: For clear model referencing
- Conditional formatting: For quick identification of anomalies in large datasets
- Charts: For presenting trend data in the FDD report
Speed and accuracy are valued above complexity. A TS model is not impressive because it has hundreds of lines — it is impressive because it is clean, fast to navigate and free of errors.
Common Modelling Mistakes in TS
- Hardcoding numbers rather than linking to source data
- Not reconciling the model to statutory accounts
- Mixing periods (mixing monthly and annual data in the same calculation)
- No error checks or reconciliation rows
- Inconsistent formatting that makes the model hard to review
Conclusion
Financial modelling in TS is about clarity, accuracy and speed. The candidate who can build a clean, linked, reconciled EBITDA bridge and NWC model from a raw data pack is immediately productive on a deal team.
The Transaction Services Interview Programme (€119.99, one-time) includes Excel model templates and guided modelling exercises used in real FDD engagements. Start learning today.