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.
