Complex Excel Modeling

Models built right the first time, flexible, auditable, and built to last.

What We Do

Complex Excel Modeling

Our modeling team builds and maintains sophisticated financial models across transaction types, asset classes, and use cases. We work within your existing templates or build from scratch, always with clear structure, full auditability, and flexibility to accommodate evolving assumptions.

Our waterfall and distribution models are a particular area of depth, built to reflect the full complexity of LP/GP economics, including tiered promote structures, preferred return mechanics, and catch-up provisions that vary meaningfully across fund documents and deal structures. Where client compliance permits, optional AI-assisted data population and scenario testing is available as an efficiency layer.

Services

Services Covered

Multi-asset sensitivity frameworks built for complex portfolios with asset-level granularity, simultaneous sensitization across leverage, pricing, cost, and market assumptions at scale.
Property-level return analysis covering IRR, MOIC, NOI, yield on cost, and debt-related metrics across a range of revenue, expense, vacancy, and financing assumptions and deal structures.
Project-level FCF modeling with detailed revenue and cost inputs, debt service schedule, covenant headroom tracking, and liquidity analysis across base case and downside scenarios.
Accretion/dilution analysis across EPS and cash flow metrics, purchase price allocation with goodwill and intangible step-ups, synergy modeling with phasing, and pro forma balance sheet construction.
Fully structured leveraged buyout models with detailed debt schedule across tranches, sources and uses, returns waterfall, management equity rollover, and sensitivity analysis across entry multiple, leverage, and exit assumptions. Covers transaction fee modeling, debt capacity and coverage analysis, and returns attribution across sponsor, management, and co-invest structures.
Distribution waterfall models reflecting the full structure of private fund economics, return of capital, preferred return accrual, GP catch-up, and tiered carried interest across multiple promote thresholds. Handles American- and European-style conventions, multiple LP classes, clawback provisions, and escrow. Outputs IRR and MOIC by investor class with carried interest sensitivity across exit scenarios.

AI Capability — Available via Intelligence Layer

Data Population & Scenario Analysis (Optional AI Layer)

Where client compliance permits, automated market data inputs and sensitivity permutations can accelerate model builds and broaden assumption coverage, allowing analysts to focus on structure and judgement rather than data sourcing.

Engagement Snapshot

What depth looks like in practice.

Maritime Partners LLC, Multi-Hundred Vessel Portfolio

Concentric built a dynamic portfolio model covering several hundred vessels, each with unique asset features and lease structures, sensitizing pre- and post-tax returns across hundreds of assumptions including leverage, market lease rates, residual values, tax rates, and operating expenses.

Sub-Services

You May Also Be Interested In

Ad-hoc projects, recurring retainers, or fully embedded teams, we configure the engagement around your workflow.